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
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs Lesson PlanBasic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs Lesson Plan
Publisher
Curated OER
Curator Rating
Educator Rating
Not yet Rated
Lesson Plan

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

Curated and Reviewed by Lesson Planet

Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.

86 Views 172 Downloads
Concepts

microsoft excel, charts, graphs, line graphs

Additional Tags

charts, excel, line graphs, Spreadsheets, math
Show More Show Less

Resource Details

Grade
5th - 12th
Subjects
Math
3 more...
Resource Type
Lesson Plans
Audience
For Teacher Use
Duration
45 mins
Instructional Strategy
Inquiry-Based Learning

See similar resources:

Lesson Plan

Point-Slope Form of a Line

Curated OER
This activity helps young mathematicians connect the graph and the point-slope form of a line, by first solving a real-world problem and then using that example to motivate the understanding of the equation. By manipulating the gizmo,...
8th - 9th Math
Lesson Plan

Graph It!

Curated OER
There is more than one way to represent data! Learners explore ways to represent data. They examine stacked graphs, histograms, and line plots. They conduct surveys and use stacked graphs, histograms, or line plots to chart the data they...
6th - 9th Math
Instructional Video

Example of Plotting a Simple Inequality on a Number Line, Pre-Algebra

Khan Academy
Graphs are excellent tools for visualizing data. Use this video to demonstrate what inequalities look like on a number line. Sal draws a number line and shows the inequality. He effectively employs differentiated colors to express the...
2 mins 5th - 8th Math
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

I Know What You Did Last Summer: A Data Graphing Project

Alabama Learning Exchange
Young scholars participate in graphing data.  In this graphing data lesson, students make a stem and leaf plot of their summer activities.  Young scholars create numerous graphs on poster boards.  Students discuss the...
7th - 11th Math
CCSS: Designed
Interactive

Derivate

Shodor Education Foundation
Derive tangent lines through derivatives. Scholars use an app to graph functions and investigate derivatives and tangent lines. The interactive automatically graphs a tangent line at a specified point and can also produce tables of values.
11th - Higher Ed Math
Interactive

Vertical Line Test

Shodor Education Foundation
Connect the points to create a function. Using points given by the applet, pupils try to connect them to create a line that would pass the vertical line test. The resource keeps track of the number of sets the learner is able to identify...
9th - 12th Math
CCSS: Designed
Lesson Plan

Conversation Heart Graphing

Curated OER
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
6th Math
Lesson Plan

What's in a Graph?

Curated OER
How many yellow Skittles® come in a fun-size package? Use candy color data to construct a bar graph and a pie chart. Pupils analyze bar graphs of real-life data on the Texas and Massachusetts populations. As an assessment at the end...
4th - 8th Math
Instructional Video

Drawing Cumulative Frequency Graphs

Corbett Maths
What's the difference between frequency and cumulative frequency? Young scholars consider the question as they create a cumulative frequency graph. They watch as the frequency totals grow to create a new shape of the graph.
5 mins 6th - 10th Math
CCSS: Adaptable
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