Spreadsheets – Fast Food Facts
Excel Lesson – Fast Food Facts
lesson Modified from: http://www.bcsberlin.org/lessons/excelff.htm
Objectives
In this lesson you will:
- Study and analyze nutritional information about FAST FOOD
Question????How healthy are Fries? Cheeseburgers? Pizza? Happy Meals?
- Use (spreadsheet software) to calculate, analyze and compare nutritional facts such as Calories, Fat Calories, Sodium, Protein or Cholesterol.
Directions
Part 1 – Research
Visit the following Web sites and fill out the Fast Food Worksheet:
GOOGLE DOCS WORKSHEET to Download & Make a Copy
- Site 1. http://www.ars.usda.gov/is/kids/nutrition/story10/fastfoodmain.htm
- Site 2. https://www.choosemyplate.gov/saturated-unsaturated-and-trans-fats
- Site 3. http://sustainablekodiak.blogspot.com/2008/01/what-is-eaten-in-one-week.html
When you are done read interesting facts on this page:
http://www.turnoffyourtv.com/healtheducation/fastfoodfacts.html
Part 2 – Gather Information
Explore some Fast Food Sites and plan your project. You must decide what fast food menu items and what nutritional facts you will compare using Spreadsheet software. Fries? Cheeseburgers? Pizza? Happy Meals? Select four menu items and four nutritional facts to compare. Calories? Protein? Sugars?
Fast Food Websites:
- McDonalds http://www.mcdonalds.com/us/en/food/full_menu/full_menu_explorer.html
- Burger King http://www.bk.com/pdfs/nutrition.pdf
- Wendy’s http://www.wendys.com/food/NutritionLanding.jsp
- Arby’s http://www.arbys.com/nutrition/
- Taco Bell http://www.tacobell.com/nutrition
- KFC http://www.kfc.com/
- Subway http://www.subway.com/nutrition/nutritionlist.aspx
Part 3 – Excel Spreadsheet
You will be graded on the following:
| 100 Pts | Worksheet – Internet Research – On-task classwork |
| 15 Pts | Font Formatting —-CAPS All Words, Labels, Titles — Title and Labels Larger Font —- Font Size 12 |
| 20 Pts | Content ——–Menu items and Nutritional Facts ——-Spell & Grammar |
| 5 Pts | Format Cell Color, Font & Borders —— Format text Boxes |
| 10 Pts | Formulas –—– Sum, Least, Most |
| 15 Pts | Graph(s) ——using Chart Wizard that makes Math Sense – labeled and easy to read |
| 5 Pts | Pictures ——-Clipart One or More —-Insert Picture or Copy |
| 15 Pts | Textbox Conclusion Critical Thinking Statement Math Sentences explain graph. Think, compare, Analyze state conclusion. Use words like More, Less, most, and Than. 3 Sentences or More. Must state healthiest choice. |
| 5 Pts | WordArt Title |
| 5 Pts | Footer – Your Name & date |
| 5 Pts | Preview Document –Print on one page — adjust Margins, Page Layout Portrait or Landscape, Resize graphs & pictures |