Fast Food Fun



Fast Food Fun

Follow the steps below.

□ Enter your data in an Excel spreadsheet. Your spreadsheet will be set up as follows:

□ You will enter the calories in column B and fat calories in column C.

□ To figure out non-fat calories, write a formula to subtract the fat calories from the total calories.

□ To figure out the percentage of calories from fat, write a formula to divide fat calories by calories. Format the cells in column E for percentage.

□ Write formulas to figure out total calories, total fat calories, and total non-fat calories.

Formatting Your Spreadsheet

Once your data is entered, format your spreadsheet as follows:

□ Make your column headings bold and centered.

□ Center your menu items.

□ Format your “Total” row so that all of your totals are bold.

□ Make the Total row light blue (not the font, the row itself)

□ Add a header that reads: Fast Food Facts. To make a header, go to the menu bar and choose “Insert”. In the “Insert” menu, choose “Header and Footer”. Choose a different font, make it bold and make it size 16.

□ Go to the “Page Layout” tab on the menu bar.

□ In Page Setup, click on the “Sheet Options” arrow. A window should open.

□ Under “Print” on the Sheet tab, choose “Gridlines”

□ Click “OK”

□ Save your spreadsheet to your “H” drive in the Fast Food folder. Name it “Fast Food Spreadsheet”.

Creating Charts/Graphs

You will be creating two charts.

The first chart (graph) will be a bar or column chart that will illustrate calories and fat calories in your fast food meal.

The second chart (graph) will be a pie chart which will illustrate the percentage of non-fat and fat calories in one item of your meal.

Chart #1 (Column Chart)

Follow these steps:

□ Highlight cells A1 to C5. Remember to click and drag across these cells. You should see them highlighted in blue. (See below)

← Go to the “Insert” tab and click on the Column Chart arrow. Choose one of the column charts – don’t use the stacked chart.

← Move chart to its own sheet. Title it Calories and Fat Calories.

← Working with the chart – go to the “Layout” tab under “Chart Tools” above the menu bar.

← Insert a title as well as axis labels.

Your column chart should look something like the one below.

Chart #2 (Pie Chart)

Follow these steps:

□ Decide on an item to use for this chart – it can be your main item, your side item or your dessert.

□ If you do not choose your main dish for this graph, you will need to hold the control key down on your keyboard and click on the headings “Fat Calories” and “Non-Fat Calories” as well as the cells that correspond to that data for your menu item. (See example below).

I chose the french fries for my item for this chart and I highlighted the column headings and cells C3 and D3 for the data.

□ Go to the “Insert” menu and choose a Pie chart. You may use any of these charts except the one in the second row of choices.

□ Again, go to the “Chart Tools” and choose “Layout”. Add a title (title should state the name of your restaurant, the item and what the chart displays).

□ Under “Data Labels”, go to “More Data Label Options”. Under Label Options, check the boxes for Category Name, Value and Percentage.

Save (either press “ctrl S” on your keyboard, or go to “File” and choose “Save”, not “Save as”

Go back to your graphs and format them to give them a different look. Choose your own colors and add clip art that is appropriate to what your graph is showing.

Save again (same steps as above)

Using your spreadsheets and chart, answer the following questions:

1. Total calories for your meal.

2. Total fat calories for your meal.

3. Total non-fat calories for your meal.

4. Percentage of fat in meal.

5. Item with most calories. How many calories? (2 answers)

6. Item with least calories. How many calories? (2 answers)

7. Item with the highest percentage of fat.

8. Percentage of fat for the item in question #7 above.

9. Item, besides the beverage, with the lowest percentage of fat.

10. Percentage of fat for the item in question #9 above.

USDA Worksheet

On the next sheet you will see a worksheet with questions for you to answer about nutrition in general. Use the web sites provided as your primary source of information. If you are unable to find an answer in these web sites, then you may search elsewhere for the answer. You will be using these answers and your data in your summary.



USDA Dietary Guidelines for Americans

1. Click on “Introduction”. One of the primary reasons our bodies need food is for energy. How is energy measured?

2. How many calories are in a gram of protein? How about a gram of fat?

3. Now click on “Eat a Variety of Foods”. Give an example of what is considered a serving in each of the major food groups found below:

• Vegetables__________________________________________________________

• Fruits______________________________________________________________

• Grains_____________________________________________________________

• Milk______________________________________________________________

• Meat and Beans_____________________________________________________

Click on “Balance the food you eat with physical activity…”

4. How much exercise should you get daily?

5. What does sedentary mean?

Click on “Choose a diet low in fat…” to answer the following questions.

6. What percentage of your total calories should come from fat?

7. Why are monounsaturated and polyunsaturated fats better for a healthy diet than saturated fats?

Use this web site to answer the following questions.



Click on “My Pyramid Plan” under “Interactive Tools” on the left hand side of the window. Fill in the information to determine your own personal plan.

8. How many calories are you supposed to consume in a day?

9. What does it say about whole grains?

10. Tell how much you’re supposed to have for each category:

• Grains:____________________________________________

• Vegetables:_________________________________________

• Fruits______________________________________________

• Milk_______________________________________________

• Meats______________________________________________

11. How many calories are your allowed to have in the “Oils and Discretionary Calories” category (this is also known as junk food)?

Summary Paper

Using Microsoft Word, type a four paragraph report about your findings from this project. Use the format below.

Paragraph 1: Introduction – including which restaurant you chose and the items on your menu.

Paragraph 2: Summarize your findings about your meal including the number of calories, percentage of fat, etc. Copy and past one of your graphs (charts) onto your document as supporting evidence.

Paragraph 3: Compare and contrast your meal with another student. Use the information you recorded on your spreadsheet. Are there any major similarities or differences in your nutrition data? Why?

Paragraph 4: Use the information from the Department of Agriculture to evaluate your meal. How does your percentage of fat compare to the percentage recommended? What about other guidelines like eating fruits and vegetables? Have you planned a healthy meal? What changes might you make in your meal to make it healthier?

When you finish your paper, save it, print it. Staple the following papers together in the order written and turn them in:

Rubric

2 question sheets from the packet

Summary sheet

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download