Lesson Plan: Collecting Data on Running Speeds

Purpose:
To collect real data to input into a computer spreadsheet

Objective:
To collect data on running speeds of various individuals in your class to determine the average running speed for a distance of 20 meters.

Materials:

Procedure:

  1. Using a meter stick, mark off a linear distance of 5 meters, 10 meters, and 15 meters on a flat surface, such as a playground, parking lot or track.
  2. Have each student predict how long it will take to run each of these distances. Have each student give reasons for their predictions, explaining the difference between a hypothesis and a guess.
  3. Have one student be the time-keeper at the finish line and another student record each individual's time.
  4. Each student should run the distance at least 3 times for accurate results.
  5. Fill in Chart A.
  6. Choosing the fastest speed for each distance, convert to miles per hour.
  7. Record the times, speeds, and names of all the other classmates and enter into a spreadsheet.
  8. Use the information in chart B to label the data headings.
  9. Use formulas within the spreadsheet to calculate average times (rounded to the nearest 0.01 second) and average speed ( in both meters/second and miles per hour)
  10. In the last line of the spreadsheet , include calculations to average the entire class data.

     


Return to Aerospace Activities Page
Average Velocity - Aircraft Application

Created by Carol Hodanbosi
WWW pages edited by Jonathan G. Fairman - August 1996

Please send any comments to:
Curator:
Tom.Benson@grc.nasa.gov
Responsible Official: Kathy.Zona@grc.nasa.gov