Lesson Plan
Curated OER

Student Census

For Teachers 7th - 9th
Students collect data from their peers and store the information in a database. As students manage the information they realize the usefulness of a database as a tool to manage large amounts of information in an efficient and accurate...
Lesson Plan
Curated OER

Data Displays with Excel

For Teachers 8th - 10th
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Lesson Plan
Curated OER

"Data Dabble"

For Teachers 7th - 8th
Students engage in a lesson which facilitates their use of web sites to find data, graph it, and interpret it, thus scaffolding graphing skills to prepare students for their 8th grade I-search exit project.
Lesson Plan
Curated OER

Appalachia: Physical Fitness

For Teachers 6th - 8th
Students plan a family fitness outing. In this physical education lesson, students will research possible physical activities which might be completed by a family during a daily-long outing in the Appalachian area. Students will...
Lesson Plan
Curated OER

Create your own plane.

For Teachers 3rd - 5th
Students create and or modify a plane to have the longest duration and/or flight distance, then record the flight and distance and repeat the activity for three flights Using calculators, students find the average of their three flights.
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...