NASA Logo - Web Link to NASA.gov Vertical Line

+ Text Only Site
+ Non-Flash Version
+ Contact Glenn

Go
ABOUT NASA NEWS AND EVENTS MULTIMEDIA MISSIONS MyNASA WORK FOR NASA

Lesson Plan: Graphing Data from a Spreadsheet


SUBJECT: Technology
TOPIC: Presenting Data
DESCRIPTION: A set of problems dealing with graphing data.
CONTRIBUTED BY: Carol Hodanbosi
EDITED BY: Jonathan G. Fairman - August 1996

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

Objective:
To illustrate a distance versus time graph using student data from running various distances.

Materials:

  • computer spreadsheet with data from previous lab activity
  • computer graphing utility

Procedure:

  1. Each student will be graphing the average of their classes running speed data, putting distance (from 0 meters to 20 meters on the vertical or Y axis, and time on the X axis ( in seconds), in 0.1 second intervals.
  2. Plot the values for your class, using the average time for the 5, 10, and 15 meter distances.
  3. Plot a fourth point using a zero distance, and estimating what the time would be for that distance.
  4. Draw a straight, best-fit line through the data points.
  5. Using the points for the 15 meter time and the zero point as endpoints, calculate the slope of the line segment.
  6. What does the slope represent?
  7. Can you predict the slope of the line if the distance were extended to a much greater value, such as 10,000 meters (10k), or 40,000 meters?
A blank graph of distance versus time


Related Pages:
Aeronautics Classroom Activities
Aerospace Activities
Aerodynamics Index
Average Velocity - Aircraft Application

 

     First Gov Image


+ Inspector General Hotline
+ Equal Employment Opportunity Data Posted Pursuant to the No Fear Act
+ Budgets, Strategic Plans and Accountability Reports
+ Freedom of Information Act
+ The President's Management Agenda
+ NASA Privacy Statement, Disclaimer,
and Accessibility Certification

 

NASA Logo   
Editor: Tom Benson
NASA Official: Tom Benson
Last Updated: May 13 2021

+ Contact Glenn