## Georgia Learning Connections

*TITLE:

How many calories must you burn to equal weight loss?

*Annotation

This lesson focuses on calculating weigh loss given calories burned during one week then constructing a graph.

## *Primary Learning Outcome:

Student should be able to see a direct correlation of weigh loss to calories burned during exercise by constructing a spreadsheet and graph.

*Assessed QCC:

Standard 35: The learner will be able to use formulas to solve problems.

Standard 11: The learner will be able to communicate complex ideas effectively by creating graphical forms of data from a variety of sources. The learner will be able to create tables and charts to display data.

Standard 12: The learner will be able to organize data using table, chart and graphs, spreadsheets and/or databases.

*Total Duration:

55 minutes

## *Materials and Equipment:

Calculator, spreadsheet program with graphing capabilities

.

Procedures:

## Step One

Susie wants to lose weigh. She wants to know how many calories she has to burn in a week to lose a pound.

Calculate weight loss per week using the following formula:

W = 0.002 C

Where W = weight loss and C = calories burned

 Calories Weigh loss 50 0.1 100 0.2 150 0.3 200 0.4 250 0.5 300 0.6 350 0.7 400 0.8 450 0.9 500 1

Estimated Time:

½ hour

Step 2:

Graph the data using the graphing function and answer the questions.

Estimated Time:

½ hour

Questions:

1. If Susie burns 350 calories in a day, how many pounds will she lose in one week?
2. If Raul loses 2 pounds, how many calories did he have to burn in one week?
3. Susie wants to lose 5 pounds, how many calories does she need to burn?
4. How many pounds would someone lose if they burned 100 calories?
5. If someone wants to lose 5 pounds in 10 weeks, how many calories do they need to burn?

*Assessment:

The students are assessed based on the spreadsheet data table and graph and the questions.

Extension:

Students who already know can be asked specifically about the equation of the line or the slope of the line.