### Spreadsheet Assignment:  Nutrition Analysis of Fast Food:  Which is the Healthiest?

Plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc), a drink, and a dessert from four different restaurants. For each item on your menu, record the total calories and the calories from fat.

http://www.dietfacts.com/fastfood.asp   (This site allows you to search many fast food restaurant sites.)

Entering Data and Formulas:  Set up your Excel spreadsheet like the one above.  You will enter the calories in column B and fat calories in column C.

To figure out non-fat calories, write a formula to subtract the fat calories from the total calories. (HINT: =B2-C2)

To figure out the percentage of calories from fat, divide fat calories by calories. Format the cells in column E for percentage. (HINT: =C2/B2)

To figure out total calories, total fat calories, and total non-fat calories,  you can use the AutoSum button or write a formula.  To figure out the total percentage of fat, divide total calories by total fat calories.

Making Pie Chart: Create a pie chart for fat from calories for each menu. Highlight Food items-> hold down ctrl-.highlight food items->then highlight numbers in Fat Calories column (just the numbers- not titles)-> then choose Pie Graph. Use Text Boxes to create titles of Restaurants and Label each Fat Calories.

http://www.fda.gov/Food/LabelingNutrition/ConsumerInformation/UCM078889.htm

After creating the spreadsheet and pie graphs, read (analyze) the data.  Write a letter to Dolores School stating which restarant is the healthiest, and why it would be best for activity busses to stop at these/this fast food restaurant(s).  Be sure to explain in detail why. Give specific numbers referring to your spreadsheets.

• Paragraph 1-Introduce yourself and why you are writing the letter. You can be a concerned student, athlete, etc.
• Parargraph 2- Body of the letter give specific reasons why activity busses should stop at the restaurant you suggest. Be sure to refer to specific information on your spreadsheet. Such as, "Sample menuse can be seen on the attached menus. The McDonald's sample menu has 42% percent total fat, where Applebees had only 34% total fat for their sample menu," for example.
• Paragraph 3- Call for an action. Thank the reader for their time in considering this matter.

Hints: Eating too much fat, may increase the risk of e heart disease, some cancers, and/or high blood pressure. Therefore, menus with lower fat and higher non fat calories is better.

Label the letter Fast food .  Use the block style form (Example:  Fast food-).

Print Pie Charts on 1 page by itself. Print spreadsheets with and without formulas.( Formulas-Show formula iconc.)  Staple to the back of your letter.