Objective: Use the Internet and Microsoft Excel to create spreadsheets to find calories and fat in a typical fast food meal.
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.
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.
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.
Once you finish all three charts, arrange them on the spreadsheet so that each one is clearly visible.
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.
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.