K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel - Fast Food Nutrition Facts

Students Chart Fast Food Calories

Students search for fast food nutrition and calorie information on the internet. Students choose several items from the fast food restaurant menu to create a typical meal and then create a spreadsheet with a calorie and fat calories chart.

 

The Assignment: You are going to plan a meal with a burger, sandwich or salad, along with a side order of french fries or other item. You also want to add a drink and a dessert to your meal. For each item you choose, you will enter the calories and the amount of fat calories into your spreadsheet.

 

You can choose any restaurant you would like to eat at for your planned meal (McDonalds, Burger King, Jack in the Box, Wendy's, Subway, Taco Bell, Carl's Jr. etc). Search the internet for your chosen restaurant's nutrition information.

Grades 4+

 

Requirements:

1) Students create a spreadsheet similar to the finished example below.

2) Students enter their meal choices in column A.

3) Students enter calories in column B.

4) Students enter fat calories in column C.

5) Students use a simple subtraction formula (column B minus column C) to calculate the non-fat calories for column D.

6) Students use a simple division formula to calculate percentage of fat calories in column E. (column C divided by column B).

7) Students create a chart comparing calories and fat calories.

8) Students add a chart illustrating the top 3 items percentage of fat calories.

 

Students may format their spreadsheet with a title, different fonts, colors, sizes for improved clarity and appearance. Students save and or print their completed spreadsheet.

 

Fast Food Calorie Chart Finished Example:

Download: fast-food-calorie-chart-finished-example.xlsx

 

Fast Food Calories Spreadsheet

 

 

 

Fast Food Nutrition Spreadsheet Instructions:

Download: fast-food-nutrition-spreadsheet-instructions.pdf

 

Fast Food Nutrition Spreadsheet Instructions

 

 

Excel Spreadsheet Rubric for Grading Assignments:

Download: rubric-for-spreadsheet-with-chart.pdf

 

Spreadsheet Rubric

 

Popular for iPads - iWork

For PC's and Microsoft Office

  • Excel Bar Chart

  • Excel Bar Chart
  • Thanksgiving
    Copy and Paste
  • Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing
  • Green Screen Photo Editing
  • Computer Lab
    Rules
  • Computer Lab Rules Essentials
  • California Regions
    Brochure
  • California Regions Brochure
  • Amazing Animals
    PowerPoint
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
    Animation
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M&M
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template