Fast Food Project 1 -
This project contains several parts: You will first read about food and nutrition and then answer some questions. You will then design a menu from a fast food store and then look up the nutritional information from various sites. You will then enter the information into EXCEL and make some calculations.
Visit the following website and answer the questions below. Once that is completed, you will proceed to the next part of the project.
Step 1: Go to this web site
http://www.nal.usda.gov/fnic/dga/dga95/cover.html
Click on Introduction and answer these questions:
What are the four essential nutrients ?
How many calories does a gram of carbohydrate have?
How many calories does a gram of fat have?
Click on Eat A Variety of Foods:
Find the food guide pyramid. How many servings of each of the following does it recommend?
Fats, Oils, and Sweets
Milk, Yogurt, and Cheese
Meat, Poultry, Fish, Dry Beans, Eggs, and Nuts
Vegetable
Fruit
Bread, Cereal, Rice, and Pasta
Click on Balance the Food You Eat with Physical Activity:
How much moderate physical activity should you have per day?
Is there a problem with being too thin ?
What does sedentary mean?
Click on Choose a Diet Low in Fat:
What percentage of fat should you have in your diet?
Fast Food Project 1 - Part B
|
Decide which fast food restaurant you would like to visit. Click on that restaurant's web site below.McDonald's: http://www.mcdonalds.com/app_controller.nutrition.index1.html Burger King: http://www.bk.com/ Wendy's: http://www.wendys.com Other Restaurants: http://www.nutritiondata.com/ (This site allows you to search many fast food restaurant sites.) Once there, plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc), a drink, and a dessert. For each item on your menu, record the total calories and the calories from fat. Step Two:Enter your data in an Excel spreadsheet; |
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.