Lesson Plan
Curated OER

Scale Basketball

For Teachers 9th - 12th
Students understand that a spreadsheet can be used to find the best scale to use in a model. They place the distances of the planets of the solar system to the Sun in one column of the spreadsheet. Students try different scales so that...
Lesson Plan
Curated OER

What is for Sale and at What Price?

For Teachers 7th
Seventh graders will research information on products carried by a store (such as sporting goods, department, clothing, etc.) They will create purchase prices for the products they wish to carry. They also will decide what percentage...
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Lesson Plan
Curated OER

Survey Says...

For Teachers 3rd - 7th
Students practice taking surveys to answer different questions about radio.  In this communications lesson, students brainstorm to create questions they can ask strangers about how often they listen to their radio.  Students...
Lesson Plan
Curated OER

Box Folding: Predict, Analyze and Measure

For Teachers 10th - 11th
Students predict the shape of a geometric figure in 3D. In this geometry instructional activity, students construct 3D shapes to perfect their knowledge of measuring and predicting. This assignment is also available as an online...
Lesson Plan
Curated OER

Graphing Fun In Third Grade

For Teachers 3rd
Third graders display information in a graph, table, and chart. In this data lesson plan, 3rd graders look at graphs, tables, and charts, discuss their importance, and make their own.
Lesson Plan
Curated OER

Iterating the Function over Real Numbers

For Teachers 8th - 10th
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.
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

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.