Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
Lesson Plan
Curated OER

Rockin' Data

For Teachers 5th
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
Lesson Plan
Curated OER

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Lesson Plan
Curated OER

M & M Madness

For Teachers 1st
M&M's are always a great manipulative to use when teaching math. In this graphing lesson plan, learners predict how many of each color of M & M's there are. They count up each color and plug the data into a graph using the...
Lesson Plan
1
1
Teach Engineering

The Challenge Question

For Teachers 7th - 9th Standards
A research position becomes a modeling job. The introductory lesson in a series of nine presents the challenge of analyzing a set of bivariate data. The class brainstorms what the data may represent. Pupils must decide what is needed to...
Lesson Plan
Curated OER

Computer Graphing

For Teachers 7th - 8th
Young scholars research the Internet or create surveys to find graphable data. They collect, organize, analyze and interpret the data. Finally, they choose the appropriate type of graph to display the data and find the measures of...
Lesson Plan
Curated OER

Exploring Careers

For Teachers 9th - 12th
The world is full of possibilities for your ELLs. Help them explore their career options with a lesson that incorporates Internet research and expository writing. Not only will they learn more about their careers of choice, but both...
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

Speed + Graphing = Winners!

For Teachers 5th
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  For this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Time Management

For Teachers 3rd - 6th
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson plan is intended for the upper-elementary classroom and includes resource links and activity extensions.
Lesson Plan
Curated OER

Timed Multiplication Test Graphs

For Teachers 8th - 10th
Students use the tools of data analysis for managing information. They solve problems by generating, collecting, organizing, displaying histograms on bar graphs, circle graphs, line graphs, pictographs and charts. Students determine...
Activity
Teach Engineering

Making Moon Craters

For Teachers 5th - 6th Standards
Create an egg-citing study of energy. Pupils investigate the effect of height and mass on the overall amount of energy of a falling object. The fourth segment in a six-part series on energy uses a weighted egg falling from different...
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Lesson Plan
Curated OER

Gummy Bear Math

For Teachers 1st
First graders predict, collect data, and create a graph based on gummy bear colors they are given. In this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Learners research the solar cycle. In this Science lesson plan, students use the internet to investigate the solar cycle. Learners produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Forces and Graphing

For Teachers 6th - 8th
Middle schoolers analyze graphs to determine relationships between variables and rates of change. They determine the basic concepts about static reaction forces. They determine the slope and equation of a line.
Lesson Plan
Curated OER

What's Your Line?

For Teachers 5th
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Students create spreadsheets and bar graphs based on results of survey of favorite holidays.
Lesson Plan
Curated OER

Graphing Our Favorite Candy Bars

For Teachers K - 2nd
Students use ClarisWorks to graph class' favorite candy bars on a bar graph.
Lesson Plan
Curated OER

Fun With Graphs

For Teachers 1st
First graders read about making graphs and lean how to make graphs using "The Graph Club" software.
Lesson Plan
Curated OER

A Day at the Beach

For Teachers 1st
Student read Sheryl Wilson's story, "A Day at the Beach" while classifying items they find. They design a chart of the items before using educational graphing software to create a graph.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.