Lesson Plan
Curated OER

Iterating Linear Functions

For Teachers 7th - 9th
Young scholars use a spreadsheet to investigate data. In this algebra lesson, students collect and graph data on a coordinate plane. They explain properties of a linear equation both algebraically and orally.
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Students use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
Lesson Plan
Curated OER

Wildlife Sampling

For Teachers 7th
Seventh graders use paper bags and crackers to simulate a wildlife sampling of salmon. They record data on spreadsheets and determine a formula to estimate salmon populations.
Lesson Plan
Curated OER

Meet The Graphs

For Teachers 3rd - 4th
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
Lesson Plan
Curated OER

Water-our Precious Resource

For Teachers 6th - 8th
Students complete a unit of lessons on water as a limited resource. They conduct Internet research, record information in electronic journals, utilize spreadsheets, conserve water and record the results, and conduct water safety tests on...
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.
Lesson Plan
Curated OER

Paper Tower Challenge

For Teachers 2nd - 5th
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Young scholars collect and record the heights of other towers and use that data to create a spreadsheet.
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

Home on the Biome

For Teachers 5th
Fifth graders study six major biomes, graph temperature and rainfall, and present their findings to the class.
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Students spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.
Lesson Plan
Curated OER

Bubble Gum Chemistry

For Teachers 8th - 10th
Students explore the concept of graphing data. In this graphing data instructional activity, students determine the percentage of sugar in bubble gum. Students graph type of gum vs. sugar percentage. Students create a table of their data.
Lesson Plan
Curated OER

ABC's of Banking

For Teachers 9th - 10th
Young scholars explore the concept of managing money. In this managing money lesson plan, students discuss how to write checks and keep an accurate check registry. Young scholars discuss the importance and uses of debit cards and deposit...
Lesson Plan
Curated OER

Probability Using M & M's

For Teachers 6th - 8th
Middle schoolers develop an understanding of probability by sorting bags of M & M's by color and recording the results in percents. The data is entered onto a spreasdsheet and graphed.
Lesson Plan
Curated OER

Understanding Cloud Formation

For Teachers 4th - 5th
Students explore air and clouds by watching demonstration. They perform an experiment to measure air pressure changes.
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders conduct survey and sort data according to categories, construct bar graph with intervals of 1, and write a few sentences about their graphs.
Lesson Plan
Curated OER

Data Days

For Teachers 6th
Sixth graders practice collecting, organizing and displaying data. They create circle, bar, line and picto graphs. They analyze data in small and large sample groups.
Lesson Plan
Curated OER

Understanding Cloud Formation

For Teachers 3rd - 5th
Students read and relate the poem, "Clouds" by Aileen Fisher to a demonstration on cloud formation. They create clouds in jars using ice water and matches then discuss the ways clouds can be used to predict weather.
Lesson Plan
Curated OER

Escape The Hangman

For Teachers 7th
Seventh graders investigate the concept of probability. They use the game of hangman to create engagement and context for conducting the lesson. They create a spreadsheet with data that is given. Students make predictions based on data.
Lesson Plan
Curated OER

Around and Around

For Teachers 6th - 8th
Students create a spreadsheet to record information about circular objects. They measure and record information from a variety of objects. Students calculate the ratio of the circumference to the diameter of each object. They find the...
Lesson Plan
Curated OER

Collisions Lesson

For Teachers 10th
Tenth graders explore the role that collisions and near collisions of galaxies play in determining the shape of galaxies. They model the collision of disk shaped and spherically shaped galaxies.
Lesson Plan
Curated OER

Polygons

For Teachers 4th
Fourth graders identify and describe lines, shapes, and solids using formal geometric language. They use Inspiration to create a graphic organizer and outline of polygons.
Lesson Plan
Curated OER

Which Color Will You Pick?

For Teachers 5th - 6th
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

Graphing Heart Rates

For Teachers 4th - 5th
Students explore heart rates. They record pulse rates, predict which exercises cause a faster heart rate, make a chart, and graph the results. Students write an essay using the data to support their predictions. They write a hypothesis...
Lesson Plan
Curated OER

Graphing Grazy Crayons

For Teachers 2nd
Children create crazy crayons they made to sort and construct a floor bar graph. Then, using technology resources, they make a simple bar graph to compare the top four colors produced. Students will then interpret the printed graph by...