A Healthier You: Modeling a Healthier Weight from Dietary Improvement and Exercise

Loretta Sharma, Delta College
Author Profile
This material was originally developed by Spreadsheets Across the Curriculum as part of its collaboration with the SERC Pedagogic Service.


In this Spreadsheets Across the Curriculum module, students develop an Excel spreadsheet to calculate how many days it would take for an overweight person to come down to a healthy weight. The context is a community weight-loss program, and the presumption is that the student is designing a weight loss plan for the participants in the program. The weight-loss plan incorporates the effect of both dietary changes and increases in activity. The student's spreadsheet takes into account information relating to age, sex, height, weight, body mass index, resting energy expenditure, caloric content of food, and metabolic equivalents.

Learning Goals

Students will:
  • Rearrange an equation to calculate each participant's ideal weight from the ideal body mass index (BMI) and the participant's height.
  • Convert between inches and meters and between pounds and kilograms to use the definition of BMI.
  • Apply a multivariable equation to evaluate each participant's resting metabolic rate (RMR) given the participant's height (m), weight (kg) and age (years).
  • Apply the concept that there is a quantitative relationship between pounds of fat and accumulated net caloric intake.
  • Apply the concept that different foods result in different quantities of caloric intake.
  • Learn in context that "calories" on food labels are kilocalories in a physics class.(/li>
  • Apply the concept of Metabolic Equivalent Units (MET) to calculate the increase in caloric expenditure from sitting at rest to various activities such as walking at 4 mph.
  • Rearrange the rate equation to find the time that it takes for a decrease in caloric intake or increase in caloric expenditure to produce a desired reduction in total accumulated calories (and pounds of fat).
  • Develop a spreadsheet to do the calculations.
  • Construct participant-specific bar graphs to compare the amount of time to reach the goal weight from (a) a given dietary change, (b) a given exercise schedule, (c) a combination of the two.
In the process the students will:
  • Model the effects of dietary change and exercise on the time to achieve a target weight reduction.
  • See by example that school algebra (rearranging a linear equation) is useful.
  • Be impressed with the effectiveness of spreadsheets to carry out repeated calculations (each participant is in a row).
  • Understand through problem solving the meaning of BMI, RMR, MET, and calories, and the distinction between pounds vs. kilograms and inches vs. meters.
  • Learn of Websites that provide METs for various activities and calories of various foods.
  • Learn that one can calculate a desired weight and, if relevant, various options to achieve it.

Context for Use

This module is designed for students who plan to enter careers in the health professions, and who have minimal (or no) skills using Excel spreadsheets. Students should have access individually to computers that are linked to the Internet. Students may perform this activity as a lab exercise under instructor supervision, but may also have this module assigned as homework. Students may also work in groups to master this module and answer end-of-module questions.
While it would be helpful for students to have some familiarity with concepts relating to the health benefits of exercise, the composition of a healthy diet, Body Mass Index, or Resting Metabolic Rate, it is not absolutely necessary.

Description and Teaching Materials

PowerPoint SSAC2006.QP301.LS1.2-student version (PowerPoint 416kB May27 10)

The module is a PowerPoint presentation with embedded spreadsheets. If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.

This PowerPoint file is the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher (vacher@usf.edu) by filling out and submitting the Instructor Module Request Form.

Teaching Notes and Tips

Ideally, each student should have a computer. An alternative is to have students work in pairs. Assistance by one or more instructors would be very helpful.


The end-of-module questions can be used for assessment.

The instructor version contains a pre-test.

References and Resources

The module cites and draws information from the following resources: