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
Graphing Data by Spreadsheet Instructional VideoGraphing Data by Spreadsheet Instructional Video
Publisher
Bozeman Science
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 12th
Subjects
Math
3 more...
Resource Type
Instructional Videos
Media Length
4:49
Audiences
For Teacher Use
1 more...
Duration
10 mins
Instructional Strategy
Direct Instruction
Technology
Video
Database & Spreadsheet
Usage Permissions
Fine Print
Instructional Video

Graphing Data by Spreadsheet

Curated and Reviewed by Lesson Planet
This Graphing Data by Spreadsheet instructional video also includes:
  • Data
  • Join to access all included materials

Watch your pupils Excel at using spreadsheets to graph data by watching a video that covers how to graph data in a scatter plot using Microsoft Excel. The video also covers how to change titles, scales, and labels, as well as how to insert a best-fit curve.

11 Views 6 Downloads

Concepts

graphing data, scatter plots, line of best fit

Additional Tags

math

Instructional Ideas

  • Team up with a computer teacher to add a cross-curricular component to the resource
  • Provide learners with a data set to try on their own after viewing the video

Classroom Considerations

  • Note that depending on the version of Excel available in the classroom, it may look different than in the video
  • The third in a series of three related resources

Pros

  • Clear, step-by-step explanations make the material easy to digest
  • Resource includes a downloadable Microsoft Excel spreadsheet that contains the data in question

Cons

  • Pacing is a bit fast, so it may be difficult for some pupils to follow

See similar resources:

Lesson Plan

How Much Data is Enough?

Polar Trec
The next time you read a magazine or watch the news, make note of how many graphs you see because they are everywhere! Here, scholars collect, enter, and graph data using computers. The graphs are then analyzed to aid in discussion of...
6th - 12th Science
CCSS: Adaptable
Lesson Plan

Exploring Data

NASA
Bring the sun to your class! Young scholars analyze actual solar wind data in the second instructional activity of a five-part series. Their analysis includes speed, temperature, and density data.
9th - 12th Math
Lesson Plan

Organizing Topic: Data Analysis

Virginia Department of Education
Learners engage in six activities to lead them through the process of conducting a thorough analysis of data. Pupils work with calculating standard deviations and z-scores, finding the area under a normal curve, and sampling...
10th - 12th Math
CCSS: Adaptable
Instructional Video

Intro to Big Data: Crash Course Statistics #38

Crash Course
What makes data big? The 38th installment in the series Crash Course Statistics provides a definition of big data and its origins. It shows various methods and resources on how to collect big data and how companies use big data for a...
11 mins 9th - 12th Math
CCSS: Adaptable
Instructional Video

Fitting a Line to Data, Regression, Probability and Statistics

Khan Academy
Sal trades his tablet for an Excel spreadsheet in this video, which covers fitting data to a line. Using a word problem about median income, he not only solves the problem but also demonstrates how to use scatter plots and Excel tools in...
8 mins 7th - 11th Math
Lesson Plan

Using Data from Sensors

Curated OER
Beginning with a discussion about using technology to collect data, this resource includes a video about the next Mars rover as an example. Young scientists are taught that filtering is necessary before collected data can be analyzed....
6th - 12th Science
Lesson Plan

Interpreting Distance–Time Graphs

Mathematics Assessment Project
Pre-algebra protégés critique a graph depicting Tom's trip to the bus stop. They work together to match descriptive cards to distance-time graph cards and data table cards, all of which are provided for you so you can make copies for...
7th - 9th Math
CCSS: Designed
Instructional Video

Your Digital Footprint: Data and Energy Use

California Academy of Science
Understanding energy usage requires knowing more than how much energy it takes to charge your cell phone. Scholars learn each text sent uses energy as does each video, game, and phone call. They observe the larger grid of data transfers...
2 mins 6th - 10th Science
CCSS: Adaptable
Interactive

Graphs for Discrete and for Continuous Data: Discrete vs. Continuous Data

CK-12 Foundation
Not all data is the same. Using the interactive, pupils compare data represented in two different ways. The learners develop an understanding of the difference between discrete and continuous data and the different ways to represent each...
7th - 12th Math
Instructional Video

What is Numerical, or Quantitative, Data?

Curated OER
The teacher gives a very thorough explanation of numerical or quantitative data being anything where the answer to a question would be a number. Whereas any other answer might be considered categorical. She shows several different ways...
5 mins 6th - 12th Math
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