Objective: Use the Internet and Microsoft Excel to create spreadsheets to find calories and fat in a typical fast food meal. Procedure: Step One: Decide which fast food restaurant you would like to visit. Click on that restaurant's web site below. If the link doesn't work, right click the link and select "Save Target As", then "Save", and "Open". The pdf file should then open. Once there, plan a meal with a sandwich, a side dish, a drink, and a dessert. For each item on your menu, record the total calories and the calories from fat. You can write this information on a scratch sheet of paper. McDonald's: http://nutrition.mcdonalds.com/getnutrition/nutritionfacts.pdf Burger King: http://www.bk.com/cms/en/us/cms_out/digital_assets/files/pages/MenuNutritionInformation.pdf Whataburger: http://www.whataburger.com/browse_nutritional_info.php Arby’s: http://www.arbysrva.com/uploads/nutrition.pdf Sonic: http://www.sonicdrivein.com/pdfs/menu/SonicNutritionGuide.pdf Don't forget to plan a meal with a sandwich, a side dish, a drink, and a dessert. For each item on your menu, record the total calories and the calories from fat. You can write this information on a scratch sheet of paper. Enter your data in an Excel spreadsheet. Click here for the Excel template AND SAVE IT TO YOUR H: DRIVE. Follow all the directions on the Excel spreadsheet for entering your data. BE SURE TO SAVE YOUR PROJECT TO YOUR H: DRIVE. Once you have entered all your data, return here and move onto Step Three. Step Three: Create three types of charts to go along with the information on your spreadsheet. Raise your hand if you need help completing any of the below graphs. Make sure that when you finish, all three charts are clearly visible. 
| Create this column chart by selecting the data in columns A, B, C and
D. Once you’ve highlighted columns A-D, click on “Insert” and then “Column” and select a graph. Don't forget to give it a title and to label your axes. | 
| Create this chart by selecting the calories from fat and non-fat calories for one of the items on your menu. You'll need to select the labels in cells C1 and D1 and then the calories. Don't forget to hold down the Control key to select data that isn't right beside each other. Then click on “Insert” and then “Pie” and chose a pie graph. Be sure to label your data and include the percentages. Don't forget a title! | 
| Create this chart by selecting your total fat and non-fat calories for the meal found in cells C6 and D6. You'll need to select the labels in cells C1 and D1 and then the calories. Don't forget to hold down the Control key to select data that isn't right beside each other. Then click on “Insert” and then “Pie” and chose a pie graph. Be sure to label your data and include the percentages. Don't forget a title! |
Once you finish all three charts, arrange them on the spreadsheet so that each one is clearly visible. Step Four: Visit the following website to find out more about healthy eating guidelines: http://www.livestrong.com/article/224234-what-is-the-recommended-caloric-intake-for-children/ Find out how many calories are recommended for an average person your age. Does the meal you’ve researched exceed that expectation or not? On your Excel spreadsheet, click on “Insert” and then “text box” and then click and drag the mouse to create a text box. Write a short paragraph describing the calories in your meal and if it is a healthy option according to the information you read on the above website. Step Five: Decorate your spreadsheet to make it look neat and professional. You can change colors, backgrounds, fonts, and add pictures. Suppose you were reporting this information to a group of people. How would you want the information to look? Once you finish personalizing your spreadsheet, compare your findings to another student. Discuss the similarities and differences between your meals, and the appearance of the spreadsheets. | 
