Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis lesson, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Young scholars practice creating graphs in Microsoft Excel. In this technology lesson plan, students conduct a random survey and collect data. Young scholars use the Microsoft Excel program to create a bar graph of the data.
Lesson Plan
Curated OER

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Lesson Plan
Curated OER

All in the Family

For Teachers 3rd - 4th
Students use data to make a tally chart and a line plot. They find the maximum, minimum, range, median, and mode of the data. Following the video portion of the lesson, students will visit a Web site to test their data collection skills...
Lesson Plan
Curated OER

What's Up With My Class

For Teachers 6th - 8th
Learners collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Statistics Education Web

How High Can You Jump?

For Students 9th - 12th Standards
How high can your pupils jump? Learners design an experiment to answer this question. After collecting the data, they create box plots and scatter plots to analyze the data. To finish the lesson, they use the data to draw conclusions.
Lesson Plan
1
1
Curated OER

Foliage Tracker

For Teachers 6th - 8th
Young scholars discuss the change of leaf colors and the role that climate and elevation play in those changes. They then track leaf changes, input data, and graph foliage changes with a free online tool.
Lesson Plan
Curated OER

Matchstick Math: Using Manipulatives to Model Linear, Quadratic, and Exponential Functions

For Teachers 9th - 10th
Playing with matches (unlit, of course) becomes an engaging learning experience in this fun instructional unit. Teach pupils how to apply properties of exponential functions to solve problems. They differentiate between quadratic and...
Lesson Plan
Statistics Education Web

Walk the Line

For Students 9th - 12th Standards
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Lesson Plan
NOAA

The Oceanographic Yo-yo

For Teachers 7th - 8th
How does chemistry help deep-sea explorers? Part four of a five-part series of lessons from aboard the Okeanos Explorer introduces middle school scientists to technologies used in ocean exploration. Groups work together to analyze data...
Lesson Plan
Curated OER

Little Auk Survival Challenge

For Teachers 3rd - 6th
A bird's life is one of danger and intrigue as it struggles for survival in sometimes harsh environments. To understand how difficult surviving in the wild can be, children play a simulation game where they act as little auks, birds from...
Lesson Plan
Curated OER

Identifying Ozone Variations over Different Locations

For Teachers 7th - 12th
Students analyze ozone data.  In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth.  Students will then create a graph for their data and answer related questions. 
Lesson Plan
1
1
Institute of Electrical and Electronics Engineers

Get Connected with Ohm's Law

For Teachers 5th - 12th Standards
Ideal for your electricity unit, especially with middle schoolers, this lesson plan gets engineers using multimeters in electrical circuits to explore the relationships among voltage, current, and resistance. Older learners may even plot...
Lesson Plan
Curated OER

Mystery Liquids: Linear Function

For Teachers 9th - 12th
High schoolers determine the linear equations of the density of water and oil by collecting data on the mass of various volumes of each liquid. They construct scatter plots from the data and use these to write the linear equations for...
Lesson Plan
Curated OER

Murder in the First Degree - The Death of Mr. Spud

For Teachers 9th - 12th Standards
Secondary learners investigate exponential functions in a real-world scenario. They collect data on the temperature of a cooling baked potato, enter the data into lists, and graph the data using a scatter plot before finding an...
Lesson Plan
Curated OER

Lesson 10: Graphs

For Teachers 10th - 11th
Students explore graph theory.  In this geometry lesson,  graphs are used to solve problems in a variety of domains.  In this lesson the term graph refers to a collection of vertices and edges used to depict...
Lesson Plan
Curated OER

Graphing Surveys

For Teachers 9th - 10th
Students collect data and graph it. In this algebra instructional activity, students create a survey for their classmates and teachers. They analyze the results from the survey and graph it. They draw conclusion from their data based on...
Lesson Plan
Curated OER

Graphing

For Teachers 9th - 10th
Students collect data and graph their results, then analyze the graphs. In this geometry lesson, students examine slopes and their graphs and discuss the relationship between the lines and the slopes.
Lesson Plan
Curated OER

Get the Picture with Graphs

For Teachers 5th
Fifth graders examine line, bar and circle graphs in the newspaper and on the Internet. They complete sketches of graphs with an emphasis on selecting the best model to depict the data collected.
Lesson Plan
Curated OER

Plotting Data on a Graph

For Teachers 4th - 5th
Students investigate graphing. In this graphing lesson, students survey the class and create graphs to reflect the data collected.
Lesson Plan
Curated OER

Data Collection and Presentation

For Teachers 9th - 12th
Students concentrate on discrete quantiative data. They are shown that the vertical line diagram as a more appropriate way to present discrete quantiative data then bar charts. Students work as a group to help with the interpretation...