Due date october 19 2012
Download
1 / 14

SMART SHOPPERS PROJECT - PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on

Due Date October 19, 2012 . SMART SHOPPERS PROJECT . OBJECTIVES: . Ambassadors will RESEARCH the latest cell phones sold on the market. Ambassadors will organize their data on tables using Microsoft Excel.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' SMART SHOPPERS PROJECT ' - kana


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Due date october 19 2012

Due Date

October 19, 2012

SMART SHOPPERS PROJECT


Objectives
OBJECTIVES:

Ambassadors will RESEARCH the latest cell phones sold on the market.

Ambassadors will organize their data on tables using Microsoft Excel.

Ambassadors will create graphs (bar graphs, line graphs or pie charts) using Microsoft Excel to represent their findings.

Ambassadors will write a report to share their findings with the rest of the school.


Essential question
ESSENTIAL QUESTION

How can technology help us make Smart Consumer Decisions?


Vocabulary
VOCABULARY

  • Cell - The box where the numbers, the labels, or the formulas are entered.

  • Column - The collection of cells in a line from top to bottom.

  • Row - The collection of cells in a line from side to side.

  • Worksheet - The single page of rows and columns that is on the screen.

  • Workbook - The collection of pages (worksheets) that make up one file.

  • Range - A group of cells that are next to each other.

  • Mouse pointer - The arrow or other marker that indicates where the mouse is pointing.

  • Formula - A mathematical expression that gives instructions to the computer about what to do with the contents of specified cells.


Group tasks
GROUP TASKS

Groups 1,3 & 5:

Research and Present Two year Contracts

Group 2,4 & 6:

Research and Present No Contracts


Name date class subject
Name: Date: Class: Subject:

CHALLENGE 1:

Based on what you know about Cell Phones, name the latest three cell phones being sold today?


How to conduct research in your group
How to conduct research in your group?

Narrow down your search tasks.

Separate the tasks amongst group members.

Make sure that every member has a fair amount of work to complete.

Search only the keywords/terms you are assigned.

Do not get sidetracked.

Complete your part on the chart provided.

Keep an eye on the clock.


Day 1 group work 20 minutes
Day 1: Group Work20 minutes

Using Internet Explorer, as a group, research the following information:

Groups 1, 3 AND 5; TWO Year Contract

Groups 2, 4 & 6: Non Contract

PRICE OF EACH PHONE:


Day 2
DAY 2:

CHALLENGE:

Why is it important to be a Smart Shopper?

How is this project helping you become one Smart Shopper?


Day 2 introducing microsoft excel
Day 2: Introducing Microsoft Excel

Where is Microsoft Excel Located:

Click on the Start Menu

Select All Programs

Locate Microsoft Office

Click on Microsoft Office Excel


Day 2 introducing microsoft excel1
Day 2: Introducing Microsoft Excel

The Ribbon runs across the top of the window.

The Ribbon consists of 3 types of items.

o Tabs – This is the main level and includes Home, Insert, Page Layout, etc.

o Groups – Each tab has several groups that show related items together.

o Commands – A command is a button in a group or an item in a list.


Day 2 creating a spreadsheet
Day 2: Creating a Spreadsheet

  • What should the spreadsheet accomplish?

  • What should be on this spreadsheet?

  • Sketch out a picture of the spreadsheet. Where will things be?


Day 2 group work 10 minutes
DAY 2Group work: 10 minutes

ON THE PAPER PROVIDED ANSWER THESE QUESTIONS AS A GROUP:

  • What should your Spreadsheet accomplish?

  • What should be on YOUR Spreadsheet?

  • Sketch out a picture of your Spreadsheet.

    • Where would the title go?

    • Where were the numerical data go?

    • Where would the descriptors/words go?


Day 2 individual work 10 minutes
Day 2Individual Work: 10 Minutes

On Microsoft Excel, create a new Spreadsheet:

  • Create a Heading for the Spreadsheet

    Example: Iphone 5 NO Contract

  • Include the data for only one Cell Phone.

  • Round up the numerical data to nearest dollar.

  • Save your work on the Flash Drive

    • File name: SmartShopper_701_FIRSTLASTNAME


ad