***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.

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

Calculator, spreadsheet program with graphing capabilities

.

Computer with spreadsheet

**Procedures:**

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

Make a data table on a spreadsheet starting at 50 calories burned and ending at 500, in 50-calorie increments. Click here for a link to the spreadsheet.

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:

- If Susie burns 350 calories in a day, how many pounds will she lose in one week?
- If Raul loses 2 pounds, how many calories did he have to burn in one week?
- Susie wants to lose 5 pounds, how many calories does she need to burn?
- How many pounds would someone lose if they burned 100 calories?
- 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.