You are going to approach the task of picking out a nutritious lunch analytically using the nutrition information available on the Internet and plugging it into Microsoft Excel.
There are seven fast food restaurants available in your area, but you have decided to only compare an average meal from three of them because you don't have time to compare all seven. You have decided that each meal you choose from a given restaurant is going to consist of a main course item, a side item, a beverage, and a dessert. The first thing you will do, then, is add up all the nutritional information for one meal at your chosen restaurants using Microsoft Excel. You are going to compare the following nutrition information for each meal at each restaurant:
- Calories
- Total Fat (grams)
- Total Carbohydrates (grams)
- Sodium (milligrams)
- Protein (grams)
Once you have the totals for a meal from three restaurants, you will graph all three meals and the Recommended Daily Allowances on a column chart. Using the graph, you will then write a letter to Jan telling her which meal you think would be the best to feed to the campers. You must explain why you chose the meal from a nutritional standpoint. Now that we have a general overview of what you're going to be doing, let's move on to the process you'll use to complete this task.