Step 1
- Decide which fast food restaurant you would like to visit. Click on that restaurant's web site below. You may choose one that is not on the list, but please let me know which you decide.
http://www.bk.com/
http://www.wendys.com/the_menu/nut_frame.html
http://www.nutritiondata.com/(Other fast food restaurants).
- Once you are there, plan a meal with a sandwich, salad, or other main dish, a side dish (french fries, onion rings, etc.), drink, dessert, and five other items of your choosing.
- For each item on your menu, record the total calories and the calories from fat in a separate document.
- Create a header with your name, date, block, and step #.
- Enter your data into an OpenOffice Calc spreadsheet. (Sample provided)
- Put your page in landscape (Format > Page > Page tab).
- In cell A1, type the title Fast Food Fun. (You will merge the cells at the end of your project).
- Be sure to expand the width of your columns so that your information is not cut off.
- You may choose any font that you wish for this project. Be sure to include borders, shading, and a logo for the restaurant you chose in your spreadsheet.
- In cell A3 type your first menu item and continue entering your menu items until you reach cell A12.
- In cell B2 type Calories; in C2 type Fat Calories; in D2 type Non-fat calories; and in E2 type Percentage of Fat, in cell F2 type Total Calories.
- To figure out your non-fat calories, type a formula that subtracts the fat calories from the total calories =sum(b3-c3)
- To figure out the percentage of fat, divide calories by fat calories =sum(c3/b3). (Be sure to format this column as a percentage: Format > Cells > number tab > Percentage)
- To figure out total calories type a formula that calculates the sum of cells B3 through D3.
- In cell A14 type TOTAL. Then, in cell B14 type a formula that calculates the sum of the calories in your entire meal.
- In cell C14, type a formula that calculates the sum of the total fat calories in your entire meal.
- In cell D14, type a formula that calculates the sum of the total non fat calories in your entire meal.
- Make the spreadsheet colorful by adding borders, shading, and a nice looking font.
- Create a header with your name in the left, step # in the center, and date in the right.
- Create the charts according to the directions.
- Complete the handout provided.
- Compare your information with another student and determine who has the healthier meal.
- Be sure to record the data you collect from the other student (you will be called on to share the information)
Using OpenOffice Writer, write a three paragraph report on your findings. The following are the requirements:
- First paragraph: Introduction including which restaurant you chose and the items on your menu
- Second paragraph: Summarize your findings about your meal including the number of calories, percentage of fat, etc. Copy and paste one of your charts into your document as supporting evidence.
- Third paragraph: Compare and contrast your meal with another student. Use the information your recorded in step 2. Also conclude your report.
- Include a header with your name, date, block, and Step 4.
**Be sure to complete each step and to check your work often.
Lesson provided by: http://www.wmburgweb.com/Resources/Lesson/index.htm