Tech Lesson 04-5: I Ate What?? Using a Spreadsheet program

Standards:
Demonstrates understanding of basic technology and telecommunication tools
Operates Basic technology tools and applications
CSTA Level I Standard 4: (3rd to 5th) Use general purpose productivity tools and peripherals to support personal productivity, remediate skill deficits, and facilitate learning throughout the curriculum.
CSTA Level I Standard 5: (3rd to 5th) Use technology tools for individual and collaborative writing, communication, and publishing activities to create presentations, and publishing activities to create presentations for audiences inside and outside the classroom.
CSTA Level I Standard 9: (3rd to 5th) Determine which technology is useful and select the appropriate tools and technology resources to address a variety of tasks and problems.


Basic Skills:

Objectives:
Students will create a spreadsheet that uses sum to add values.
Students will format cells in spreadsheet using borders and number values.
Students will create graphs from data in spreadsheet.

Process:  (Student Directions)
1. Students will make a list in their Idea Books of what they would eat at Breakfast or Dinner at McDonalds.
2. Students use McDonald's website to look up the calorie content of their food.  Students write down values in their Idea Books.
3. Students key in their meal and calorie value in a spreadsheet program.
4. Students use auto sum to calculate their total calorie intake.
5. Students use google to research what a 11 year old should eat in terms of calories for one day.
6. Students make a graph showing the calorie content of their food intake.
7. Students save their spreadsheet in their file area.

Assessment:
Meets the Standard: Students will have created a spreadsheet file that contains the names and calorie values for food items consumed in one meal.  Their will be a total calorie count and a graph representing calorie values.