Fast Food Research - Lab Report Template printable pdf download

Fast Food Research - Lab Report Template

NAME: ________________

Fast Food Research

Objective: Use the Internet and spreadsheets to find calories and fat in a typical fast food/restaurant

meal.

Open a new Excel worksheet and save it as Fast Food in your 3

Six Weeks folder.

Procedure:

Step One:

Decide which fast food restaurant you would like to visit. A few examples are listed below.

McDonald's:

Burger King:

Once there, plan three meals 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 fat.

Each meal should be included on a separate worksheet. The title tab should reflect the restaurant’s

name.

Step Two:

Enter your data in an Excel spreadsheet.

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)

To figure out the percentage of calories from fat, divide fat calories by calories. Format the cells in

column E for percentage. (HINT: =C2/B2)To figure out total calories, total fat calories, and total non-fat

calories, you can use the AutoSum button or write a formula. To figure out the total percentage of fat,

divide total calories by total fat calories.

Fast Food Research - Lab Report Template