Lesson Plan
Curated OER

Graphing Pendulum Results

For Teachers 6th
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

Excel Lesson Plan Coin Statistics

For Teachers 2nd
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Lesson Plan
Curated OER

Graph It

For Teachers 5th - 8th
Elementary and middle schoolers engage in a lesson of graphing in quadrant I of the coordinate plain. They use the graph to create shapes and symbols. While using a graphing calculator, they locate the points on the coordinate plane. In...
Lesson Plan
Curated OER

Scatter-Brained

For Teachers 7th
Seventh graders graph ordered pairs on a coordinate plane. They create a scatterplot. Additionally, they determine the line of best fit and investigate the slope of the line. Multiple resources are provided. An excellent resource!
Lesson Plan
Curated OER

Pet Count Excel Graphing

For Teachers 3rd - 5th
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
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 plan, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees...
Lesson Plan
Curated OER

Math Lesson: What Do You Want to Know? - Country Statistics

For Teachers 9th - 12th
High schoolers are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing...
Lesson Plan
Curated OER

Data Analysis Challenge

For Teachers 5th - 6th
In this data analysis worksheet, young scholars work with a partner to collect information for a survey. The information is then compiled into a graph. Learners must indicate their survey question, the target audience, predict the...
Lesson Plan
Curated OER

I Can Build It.....Yes I Can!

For Teachers K
Kindergartners listen to a story read by their teacher, then use magnetic shape pieces to construct simple designes. They "build" their own house using pre-cut paper shapes. This age-appropriate lesson would be an excellent choice for...
Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Young scholars calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Lesson Plan
Curated OER

Reading Graphs

For Teachers 6th - 9th
Students read graphs and charts to interpret results. In this algebra lesson, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

World Population Activity II: Excel

For Teachers 11th - Higher Ed
Students import UNEP World population data/projections from either the World Population Prospects: The 2002 Revision Population Database - UN Population Division or a text file. They graph this data by itself, and then along with...
Lesson Plan
Curated OER

What's My Pattern?

For Teachers 7th - 8th
Students recognize, describe and extend patterns in three activities. They organize data, find patterns and describe the rule for the pattern as well as use the graphing calculator to graph the data to make and test predictions. In the...
Lesson Plan
Curated OER

The "U's" Have IT!

For Teachers 10th - 12th
Young scholars explore the maximum and minimum values of parabola. In this exponential equations lesson, students use graphing calculators or TI Interactive Software to calculate values of parabola and graph x-intercepts of parabola.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend...
Lesson Plan
Curated OER

Graphing Weather

For Teachers 2nd - 3rd
Students make a graph. In this weather lesson, students fill in a KWL chart about different types of weather. Students watch a PowerPoint presentation about weather and natural disasters and where these types of weather are common....
Lesson Plan
Curated OER

Graphing Pockets

For Teachers 2nd
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Lesson Plan
Curated OER

Line Graphs

For Teachers 7th
Seventh graders create a line graph and identify when to use line graphs. In this line graphs instructional activity, 7th graders analyze the average temperatures of various cities. Students graph the data they collected.
Lesson Plan
Curated OER

Name Count and Graph

For Teachers 6th - 8th
Students find the frequency of a name in selected states by using the Internet. They input data into a spread sheet. They create a graph that illustrates the gathered information.
Lesson Plan
Virginia Department of Education

Algebra Tiles and Solving Equations

For Teachers 6th - 9th Standards
Young mathematicians solve linear equations by drawing models of algebra tiles using colored pencils. To finish, they solve the same equations algebraically and check their answers using a graphing calculator.
Lesson Plan
Curated OER

The Race of Baseball All-Stars

For Teachers 7th - 9th
Collect and analyze data. Pupils graph their data and model with it to solve real life problems. They use logic and deductive reasoning to draw conclusions.
Lesson Plan
Curated OER

BUS: Farming: It's A Fact (Ag)

For Teachers 9th - 12th
Students create two different types of graphs from the information in the "Farm Facts" booklet (i.e., bar graph, pie chart, etc.). They calculate where your food dollars are spent (on and off farm).