Lesson Plan
Curated OER

Assessing Water Quality in a Local Creek by Sampling Aquatic Macroinvertabrets

For Teachers 9th - 12th
High schoolers experiment collecting macroinvertebrates from a stream and identify the specimens collected and then log in the information into a data table. From the data, they make qualitative and quantitative interpretations of water...
Lesson Plan
Curated OER

Rock Identification Lab

For Teachers 8th
Eighth graders compare and contrast the three different types of rock. In this earth science instructional activity, 8th graders classify rock samples according to their correct rock type. They design their own data collection table.
Lesson Plan
Curated OER

Temperature Comparisons

For Teachers 9th - 11th
Students practice plotting temperature data points on a line graph in groups and examine the temperature differences at the same time of year. They graph the temperatures in Lannon, WI, and Mitchell's Plain, SA. After the data has been...
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

Different Perspectives of Oregon's Forest Economic Geography

For Teachers 6th - 8th
Learners locate the many forests located in Oregon. In groups, they use the internet to research employment data on wood products made in the state. They discuss how looking at information presented in a different way can change their...
Lesson Plan
Curated OER

M&M Exponential Activity

For Teachers 10th - 12th
Young scholars create a scatter plot of their experimental data. In this algebra lesson, students use M&M's to determine an algebraic model. They discuss results in class.
Lesson Plan
Curated OER

Lesson 3: Lobster Roll!

For Teachers 4th - 6th
Students play a game that illustrates the delicate ecological balance between fishing, fishing regulations and fish populations. They collect data and analyze the results.
Lesson Plan
Curated OER

CEENBot Soccer

For Teachers 7th - 8th
Students research the history and uses of the different elements in the periodic table. In this chemistry lesson, students explain the significance of an element's valence electrons. They create a multimedia presentation of an element...
Lesson Plan
Curated OER

Hermit Crab Races

For Teachers 1st - 5th
Students predict the speeds of humans and hermit crabs and investigate their predictions using ratios and formulas. AppleWorks is used for this lesson, which includes a data worksheet.
Lesson Plan
Curated OER

Body Length Experiment

For Teachers 3rd - 5th
Students measure the lengths of their bodies and various body parts to determine the relationship (or lack of one) between body part length and the length of the entire body. A spreadsheet program is suggested for data collection.
Lesson Plan
Curated OER

What's Your Favorite Stuffed Animal?

For Teachers 2nd
Second graders gather information in a survey and interpret the results using a tally chart, a table, and a bar graph. They' present their results of the during the final group discussion. The subject of the survey is favorite stuffed...
Lesson Plan
Curated OER

Cinderbank

For Teachers 4th
Fourth graders identify major components of a "Cinderella" story in order to create a database.
Lesson Plan
Curated OER

Save Me: Mother Earth

For Teachers 1st - 3rd
Learners read stories and articles about protecting the Earth. They collect data for a computer generated graph, and provide a key to show what the symbols represent.
Lesson Plan
Curated OER

Penguin Heights

For Teachers 1st - 2nd
Young scholars use the worksheet from the first website listed below to collect data on the penguin heights on the Penguin Page.
Lesson Plan
Curated OER

Our Favorite Season Lesson Plan

For Teachers 5th
Fifth graders complete a survey about their favorite season of the year. Using Excel, they create a graph using the chart wizard and copy it into Microsoft Word. They explore the relationship between the survey and the bar graph.
Lesson Plan
Curated OER

Eight Basic Elements of the Earth

For Teachers 10th - 11th
Students identify the concept of an element and work with an idea that all of the millions of substances on the earth are various combinations of only 8 elements. They work with the Periodic Table of the Elements and symbols of the...
Lesson Plan
Curated OER

Do You See What I See?

For Teachers 2nd - 7th
Students hypothesize the role of rocks, soil, and water by observing a terrarium and create a model to explore the water cycle. This is part of a five station set up.
Lesson Plan
Curated OER

Up, Up, and Away

For Teachers 2nd - 5th
Learners create a model to explore the water cycle. Students also perform different experiments to witness water changing from a liquid to a gas. Learners are asked to if they can find ways for water to go away without pouring the...
Lesson Plan
Curated OER

Graphing the Daily Revenue of Miami Seaquarium

For Teachers 7th
Seventh graders compile a table of the revenues of the 8 eateries (a combined total), Main Gate admissions, and the Gift Shop.
Lesson Plan
Curated OER

Mapping a Stream

For Teachers 7th - 8th
Students map an actual local waterway. They create full color scale drawings that include windfalls, plant cover, streambed composition, and landmarks such as trees, boulders, and slumps. This is a long-term project that involves...
Lesson Plan
Curated OER

Asthma "Outbreak" Exercise

For Teachers 8th - 12th
Students investigate numerical data on a possible asthma epidemic. Using statistical information, students graph and figure ratios of the epidemic. They evaluate the mortality rate from severe smog in the 1950's in London.
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Locating the Salt Front

For Teachers 4th - 5th
Young scholars use Hudson River salinity data to create a line graph that shows the location of the salt front, and use math skills to explore how this location varies over time. They use the graph to estimate the location of the salt...
Lesson Plan
Curated OER

A Real Difference

For Teachers 5th
Fifth graders use the Celsius and Fahrenheit thermometers to compare temperature readings. They use the Internet to find the temperatures of selected cities. After data is collected for five days, 5th graders graph the temperatures.