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
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

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
Learners 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. Learners are introduced to terminology...
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 instructional activity, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius...
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
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 is intended for the upper-elementary classroom and includes resource links and activity extensions.
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 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

Forces and Graphing

For Teachers 6th - 8th
Students 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

Computer Graphing

For Teachers 7th - 8th
Students 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 central...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Learners research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Learners produce a spreadsheet and graph from the information collected.
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.  In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
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

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...
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

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.
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

And the Survey Says...

For Teachers 7th - 8th
Pupils use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
Lesson Plan
Curated OER

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
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
Young scholars use ClarisWorks to graph class' favorite candy bars on a bar graph.
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Learners create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.