Unit 1 Group Project Names of Group Members: (Print Please)

Unit 1 Group Project Names of Group Members: (Print Please)

Unit 1 Group Project
Names of group members: (print please)

Part 1: Exam Scores

You will be given a spreadsheet showing the results for 13 students on a 20 question multiple choice exam. Your assignment is to use some of what you have learned in this unit to analyze the results of the exam.

  1. Use Excel to calculate the percentage of correct answers for each student. DO NOT compute these by hand and enter them into the spreadsheet.
  2. Based on these percentages, determine the number of students who earned an A, B, C, D, and F on the exam. Assume a 90%, 80%, 70%, 60% scale. Use this information to make a pie chart showing the percentage of students who earned each grade. Make sure the percentages are labeled on your pie chart.
  3. Use Excel to calculate the number of correct responses for each question. In other words, determine how many students got question #1 correct? How many got question #2 correct? And so on.
  1. Create a bar graph showing the number of students who answered each question correctly.

Part 2: Favorite Restaurant Meal Analysis

  1. Select a breakfast, lunch, and dinner meal from a restaurant. Write the name of the restaurants in the top box of each column. Then list the items in each meal in the larger box on the bottom of each column.

Breakfast / Lunch / Dinner
  1. Do a web search for the nutrition facts for every item on this meal and record the following information. Most restaurants have this information available. If you can’t find yours, pick something else.

Item Name / Calories / Total fat (g) / Sodium (mg) / Carbohydrate (g) / Protein (g)
  1. Record the above table in a spreadsheet and determine the totals for each category. Turn in this spreadsheet
  2. How do your totals compare to the recommended daily intake table on the next page? ( This is intentionally open ended. Can you describe how your totals compare to the values in the table by using the same units as used in the table? Can you describe how your totals compare to the values in the table by using percentages?

Nutrient / Unit of Measure / Daily Values
Total Fat / grams (g) / 65
Saturated fatty acids / grams (g) / 20
Cholesterol / milligrams (mg) / 300
Sodium / milligrams (mg) / 2400
Potassium / milligrams (mg) / 3500
Total carbohydrate / grams (g) / 300
Fiber / grams (g) / 25
Protein / grams (g) / 50
  1. If you ate this meal every day for 1 year (365 days), how much weight would you gain or lose? Base your answer on the assumption that you should consume 2000 calories per day and that one pound of weight gain or loss is equivalent to 3500 calories more or less than you need. Show any work needed for this calculation.