Lesson Plan
Curated OER

Does One Tree a Forest Make?

For Teachers 2nd - 4th
Students take a walk around the schoolyard looking at and identifying the trees. One leaf for each tree is collected. A chart is developed that represents the population of trees on the school ground. They keep journals and write an essay.
Lesson Plan
Curated OER

The Big Bang Theory

For Teachers 10th - 12th
Students will use scientific reasoning to formulate ideas about the formation of the universe using the Big Bang Theory. The use of critical thinking skills is part of the activity and the foundation of the scientific method will serve...
Lesson Plan
Curated OER

What did I find?

For Teachers 4th - 6th
Students excavate an artifact. In this archaeology instructional activity, students get a bucket filled with dirt and a broken up artifact. They work in groups to take it out and to find what its purpose was. 
Lesson Plan
Curated OER

T-Shirt Lettering

For Teachers 3rd - 8th
Students determine the cost of a t-shirt using a variety of mathematical operations to solve problems. Then they use a spreadsheet to calculate the cost of lettering a t-shirt and display this information in a graph.
Lesson Plan
Curated OER

Water-The Liquid Gold

For Teachers 4th - 6th
Young scholars investigate the necessity of water for the survival of plants, animals, and people. They explore the affect that water has on human and natural environments through literature, field trips, and discussions.
Lesson Plan
Curated OER

Our Favorite Pet

For Teachers K
Students each have a turn, telling the class his or her favorite pet. The choices are cat, dog, fish or bird. Using the computer, the information from the tally be recorded on a spreadsheet and bar graph.
Lesson Plan
Curated OER

Put Your Heart Into It

For Teachers 1st
First graders sort Valentine candies according to kind. Data is inserted into a spreadsheet and displayed in various graphic formats.
Lesson Plan
Curated OER

The Great Chile Challenge

For Teachers 5th
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
Lesson Plan
Curated OER

Thank You... Thomas Edison!

For Teachers 2nd - 3rd
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.
Lesson Plan
Curated OER

Ratios

For Teachers 4th
Fourth graders complete a taste test of different sandwiches, rate them, and then put them in a ratio graph. In this ratio lesson plan, 4th graders write what they learned about ratios after this activity.
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

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

You Gotta Have Heart

For Teachers 9th
Ninth graders investigate the concept of relations and interpret graphs and tables. They analyze given data and look for a pattern to determine if the numbers represent a function. Students practice solving scientific word problems that...
Lesson Plan
Curated OER

What is a Tropical Rainforest?

For Teachers 3rd - 5th
Students investigate amounts of rainfall in selected world rainforests by creating a bar graph showing rainfall in inches for each. They convert inches to millimeters, and solve word problems having to do with rainfall in selected world...
Lesson Plan
Curated OER

Ratios Through Social Studies

For Teachers 9th - 12th
High schoolers analyze and integrate mathematical concepts within the context of social studies. They gather, present and analyze information on a bar graph, pie chart, etc. Students compute ratios. They demonstrate that ratios have...
Lesson Plan
Curated OER

Scientific Inquiry: Periodic Motion

For Teachers 11th - 12th
Students construct their own pendulum. In this physics lesson, students design an experiment to find the factors affecting its period. They formulate a conclusion based on experimental data.
Lesson Plan
Curated OER

Streamflow

For Teachers 9th - 12th
High schoolers discuss the topic of streamflow and how it occurs. They take measurements and analyze them. They interpret data and create their own charts and graphs.
Lesson Plan
Curated OER

Rolling Dice

For Teachers 4th
Fourth graders investigate the mathematical concept of probability. They determine the given mean of a data set found when rolling dice. The results of the experiment are displayed using a bar graph. The teacher does an example before...
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

Body Part Measurements

For Teachers 2nd
Second graders participate in a review of how to use rulers and yard sticks while collecting measurement information. They measure assigned body parts and chart the data on collection sheets. They make a spreadsheet with the information...
Lesson Plan
Curated OER

Fire Fighting Crew

For Teachers 9th - 12th
Students use the concepts in statistics to make decisions. They calculate the mean, median and mode. They compare one firefighter against another and analyze the data. They share their information with the class.
Lesson Plan
Curated OER

Effect of Daylight Hours on Human Activity

For Teachers 6th - 8th
Students determine the average hours of daily sunlight for each month of the year by constructing a bar graph. They develop a understanding of how the amount of daylight hours varies by month and how that affects both temperature and...
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.