Lesson Plan Guide

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

.

 

 

Technology Connection:

Computer with spreadsheet

 

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

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:

  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.