Fast Food Webquest – Food Inc., continued…
Decide which fast food restaurant you would like to visit. Click on that restaurant's web site
Burger King: http://www.bk.com/
Other Restaurants: http://www.nutritiondata.com/ (This site allows you to search many fast food
restaurant sites. You will want to look under the “all food categories” pull down menu.
Other foods: http://www.myfitnesspal.com/food/search
Once there, plan a meal with a sandwich, salad or other main dish, a side dish (french fries, etc),
a drink, and a dessert. For each item on your menu, record the total calories and the calories from
Enter your data in an Excel spreadsheet. See Sample Spreadsheet below.
When you have finished your spreadsheet, you will create charts to visually show your data. See
example and directions below.
Entering Data and Formulas:
Set up your Excel spreadsheet like the one above. 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.
(HINT: =B2-C2) Put the formula in the line above all of the cells
To figure out the percentage of calories from fat, divide fat calories by calories. (HINT:
=C2/B2). Right click on the E column and select format cells. Choose Percentage
To figure out total calories, total fat calories, and total non-fat calories, you can use a formula
like this: =SUM(B2:B5) To figure out the total percentage of fat, divide total fat calories by total
Create this column chart by
selecting the data in columns A, B,
and C. Click Insert Chart. Series
will be selected. Click Next. Give
your chart a title. Label X and Y
Axis with their values.
Click Next. Click Finish.
You may play around with the types
and layouts of the charts. Continue
with the next chart in the same way.
Create this chart by selecting the
fat/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. Click Insert
Chart, select pie chart. Click Next.
Click Data labels and select category
name and percentage. 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. Be sure
to label your data and include the
percentages. Follow the italics in the
previous box. Don't forget a title!
SAVE YOUR EXCEL FILE IN YOUR FOLDER!!!