Lesson Plan
Curated OER

The Effects of Environment on Plant Growth: Selecting Seeds for Survival on a New Planet

For Teachers 5th
Fifth graders conduct experiments to compare seed germination and plant growth rates. They construct a hydroponic plant unit and a lighthouse. They care for the plants for a month and collect data for graphs. They write a report.
Lesson Plan
Curated OER

State Lottery Numbers

For Teachers 7th - Higher Ed
Students sort and graph numerical data using a spreadsheet.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Lesson Plan
Curated OER

The Transformer

For Teachers 4th
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length...
Lesson Plan
Curated OER

Our Animal Friends

For Teachers 4th - 8th
Students use the internet to find information pertaining to the benefits of pets. They list their results on a database. They find and record data on the percent of households that own pets as well as the top six species of pets. Once...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Young scholars 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

Space Trading Cards

For Teachers 4th - 6th
Young scholars use the Internet and other reference sources to gather information on a space topic. They create a trading card displaying the information learned and import pictures from libraries and the Internet.
Lesson Plan
Curated OER

SRDES-Webquest Project

For Teachers 9th - 12th
Young scholars create a webquest on any topic that they would like. Before students begin their webquest project they visit a webquest and select the Social Studies; they then choose "Blmorhea-Oasis in the Desert." They work through the...
Lesson Plan
Curated OER

It's In the Numbers

For Teachers 9th - 12th
Students explore the careers available in the field of oceanography. They discover the difference between a job and a career and the need for a good education. They work together to create a presentation about oceanography.
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
Curated OER

Where the Buffalo Roam

For Teachers 7th - Higher Ed
Students lear about energy, energy efficiency and consumption. They measure energy use, graph the date, write a letter then design and present a PowerPoint on the topic.
Lesson Plan
Curated OER

Comparing Amount of Rainfall in Different Geographical Areas

For Teachers 3rd
Third graders create rain gauges and take them home. Individually, they record the rainfall amounts at all of their homes over a 2-week period and then bring the data back to class so they can compare the different amounts of rainfall...
Lesson Plan
Curated OER

Amphibian Spawns

For Teachers K
Students observe tadpoles as they gradually change into adults.  For this amphibian biology lesson, students watch tadpoles in a tank in the classroom, keep a daily record of what they observe, and chart the growth development of...
Lesson Plan
Curated OER

Identification of Different Compounds and Substances

For Teachers 9th - 12th
High schoolers conduct a series of tests to identify unknown compounds. In this chemistry activity, students compare the physical and chemical properties of substances. They collect data and formulate a conclusion.
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Lesson Plan
Curated OER

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. For this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Lesson Plan
Curated OER

The Hot Dog Stand

For Teachers 6th - 8th
Pupils run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Lesson Plan
Curated OER

Investigating Properties of Water: Temperature

For Teachers 6th - 8th
Investigate how temperature affects the density of water and stratification that occurs in bodies of water when temperatures vary. Water of differing temperatures is given different colors to see the layers that form. The lesson is meant...
Lesson Plan
Curated OER

The Hot Dog Stand - An Annual Report

For Teachers 6th - 8th
Students run a computer simulation and collect data as they work and use the data to create an annual report for their business. It is desirable for students to do this project individually, but it could be done as a class using a large...
Lesson Plan
Curated OER

Influence of Beauty, The Beauty of Influence

For Teachers 10th
Tenth graders explore the influence of art on modern societies. Through the internet, they assess paintings of advertisements for commercial products and social-political beliefs. Using spreadsheet software, the class compares and...
Lesson Plan
Curated OER

Get a Life Project

For Teachers 8th
Eighth graders participate in interdisciplinary career unit in which they explore alternate lives. Students assume roles, manage budgets, make decisions, and solve problems, Students then research challenges, develop solutions, and...
Lesson Plan
Curated OER

Comparing Temperatures in Different Cities

For Teachers 6th - 12th
Students generate a spreadsheet to calculate average daily temperature. They create graphs from spreadsheet data and comprehend the components of the a spreadsheet.
Lesson Plan
Curated OER

Graphing With Second Graders

For Teachers 2nd
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.
Lesson Plan
Curated OER

Twelve Days of Christmas

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