Use red font to write your answers and explanations on this Word document. All final answers, charts, graphs should be in the Word document. However, you will submit this Word document and the Excel spreadsheet to the 5.5 Dropbox.
Pick your favorite restaurant, and do a web search for the nutrition facts for its menu items. Most restaurants have this information available. If you can’t find the nutrition facts, choose another restaurant.
(15 pts) Choose 10 entrees and record the following information. Then create an Excel spreadsheet to display these values and make sure to save it to your computer. Use an Excel formula to find the mean for each category.
Name of Restaurant: Burger King | |||||
Item Name | Calories | Total fat (g) | Sodium (mg) | Carbohydrate (g) | Protein (g) |
WHOPPER® Sandwich | 660 | 40 | 980 | 49 | 28 |
WHOPPER JR.® Sandwich | 310 | 18 | 390 | 27 | 13 |
Cheeseburger | 280 | 13 | 560 | 27 | 15 |
Double Cheeseburger | 390 | 21 | 590 | 27 | 23 |
Grilled Chicken Sandwich | 470 | 19 | 850 | 39 | 37 |
Chicken Nuggets- 4pc | 170 | 11 | 310 | 11 | 8 |
Original Chicken Sandwich | 660 | 40 | 1170 | 48 | 28 |
RODEO® Crispy Chicken Sandwich | 960 | 60 | 2230 | 72 | 33 |
French Fries – medium (Salted) | 380 | 17 | 570 | 53 | 5 |
Garden Side Salad – w/o dressing | 60 | 4 | 95 | 3 | 4 |
Mean | 434 | 24.3 | 774.5 | 35.6 | 19.4 |
(3 pts) Choose your favorite entrée and fill in the chart.
Favorite entrée | Calories | Total fat (g) | Carbohydrate (g) | Protein (g) |
Double Cheeseburger | 390 | 21 | 27 | 23 |
(3 pts) Assume that one serving of fat is approximately 5 g, one serving of protein is approximately 7 g, and one serving of carbohydrates is approximately 15 g. Then determine how many servings of fat, protein, and carbohydrates are in that entrée.
Show your work here:
(3 pts) Look up how many servings are recommended per day (remember to cite your source). Record this information along with the results from Question 3 in the table below.
Fat | Protein | Carb | |
Number of Servings in your Entrée | |||
Daily Recommended Servings | |||
Source: |
(3 pts) Use Excel to create a double (or “clusteredâ€) bar graph that compares the number of servings in your entrée to the number of recommended daily servings. Include labels.
Paste the double bar graph here:
(3 pts) Look up how many calories are in one gram of fat, protein, and carbohydrates (remember to cite your source). Write these values and the website you used here:
1 gram Fat | 1 gram Protein | 1 gram Carb |
Source: |
(3 pts) Determine how many calories in your chosen entrée come from fat, protein, carbohydrates, and other.
Show your work here:
(3 pts) Convert these to percentages of the total calories in the entrée and use Excel to create a pie chart. Include labels.
Paste your pie chart here:
(15 pts) Determine the total calories in the entrée. Assume you consumed a 300 calorie breakfast, a 600 calorie lunch, and this entrée for dinner. If you ate this meal every day for 1 year (365 days), how would this effect your life and body (weight, health, etc)?
Your response needs to be at least 300 words.
Base your answer on these assumptions
You should consume 2000 calories per day.
One pound of weight gain or loss is equivalent to 3500 calories.
You do not have any food allergies.
Explain and show any work needed for this calculation.
Describe the assumptions in making your judgments.
Provide compelling rationale for why each assumption is appropriate or inappropriate.
Explain whether and how your findings are valid.
Explain whether and how your findings are reasonable.
Provide deep and thoughtful judgments, drawing insightful, carefully qualified conclusions from the project.
(3 pts) Describe how this project fulfills the Gen Ed Outcomes (Interpretation, Representation, Calculation, Application/Analysis, Assumptions, Communication).
(3 pts) Describe how this MAT-118 course is essential for one’s professional education program as well as expanding other long-term career path options.