Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free

Hi, what do you want to do?

Create a lesson plan
Create a lesson plan
Generate resources with 80+ AI teacher tools
Generate resources with 80+ AI teacher tools
Search 200,000 instructional videos
Search 200,000 instructional videos
Find a teaching resource
Find a teaching resource
Calculating & Graphing Using a Spreadsheet Lesson PlanCalculating & Graphing Using a Spreadsheet Lesson Plan
Publisher
Curated OER
Curator Rating
Educator Rating
Not yet Rated
Lesson Plan

Calculating & Graphing Using a Spreadsheet

Curated and Reviewed by Lesson Planet
This Calculating & Graphing Using a Spreadsheet lesson plan also includes:
  • Worksheet
  • Join to access all included materials

Pupils use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.

3 Views 3 Downloads
Concepts

acceleration, velocity, time

Additional Tags

acceleration, Spreadsheets, time, velocity, science
Show More Show Less

Resource Details

Grade
11th - 12th
Subjects
Science
2 more...
Resource Type
Lesson Plans
Audience
For Teacher Use
Instructional Strategy
Inquiry-Based Learning
Technology
Database & Spreadsheet
Usage Permissions
Fine Print

See similar resources:

Assessment

Regents High School Examination: Physics 2010

New York State Education Department
Give every type of learner in your physics class an opportunity to demonstrate what they have learned throughout the year. From analyzing tables and graphs to evaluating diagrams and solving problems, there is an outstanding variety of...
9th - 12th Science
Instructional Video

Distance-Time and Velocity-Time Graphs

DoodleScience
It's story time! Show your class how to use a distance-time graph to tell a story. They learn to draw and analyze a graph using distance and time data. The story then continues to compare velocity and time. 
2 mins 9th - 12th Science
Worksheet

Unit II: Worksheet 1 - Velocity

Curated OER
Beginning physics scholars interpret two graphs depicting position versus time. For each graph, there is a series of questions to answer. The exercise is basic, but beneficial. Consider using it as an assessment of understanding after...
9th - 12th Science
Worksheet

Unit II: Worksheet 2 - Velocity vs. Time Graphs

Curated OER
On the first of two pages, physics aces graph velocity versus time on sets of axes. On the second page, they look at graphs of position versus time and then draw velocity versus time on graphs right next to them. This is good practice in...
9th - 12th Science
Worksheet

Unit II Worksheet 4 - Constant Velocity/Motion Maps

Curated OER
This is a smart approach to displacement concepts. Physics learners analyze a motion map and then draw qualitative graphs for time versus displacement and time versus velocity. Get your class thinking critically through the use of a very...
9th - 12th Science
Worksheet

Unit II: Worksheet 3 - Velocity

Curated OER
Future engineers analyze the motion of Robin, the roller skater, as he moves along a sidewalk. They graph the position versus time for three different occurrences. Questions are asked about the resulting graphs, reinforcing the concepts...
9th - 12th Science
Worksheet

Unit II: Worksheet 5 - Velocity and Motion Maps

Curated OER
A chart with eight rows makes up this handout. The columns are labeled with two graphs ("x vs. t" and "v vs. t"), a written description, and a motion map. One cell in each row is filled in, leaving the rest for your class to complete....
9th - 12th Science
Lesson Plan

Time That Period

Curated OER
Physical science starters play with a pendulum in order to experience periodicity. Detailed procedures and a worksheet are included for day one. For day two, learners will use a graphing calculator to help them plot orbit data from a...
7th - 12th Math
Activity

Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

Howard Hughes Medical Institute
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
9th - 12th Math
Instructional Video

Position vs Time Graph - Part 2

Bozeman Science
The narrator os this video explains how to create a velocity-time graph from the position-time graph. He works through several examples after explaining the shapes of the position-time graphs. 
13 mins 9th - 12th Science
Try It Free
© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use