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
Young scholars 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. For 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
Learners 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
Students 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 real-world...
Lesson Plan
Curated OER

Scientific Inquiry: Periodic Motion

For Teachers 11th - 12th
Young scholars 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
Students 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
Young scholars 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...
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 instructional activity, which includes a data worksheet.
Lesson Plan
Curated OER

Wet Weather, Wet Climate

For Teachers 3rd - 5th
Students discover the differences between weather and climate in this long-term lesson introduction. They create rain gauges and practice reading rainfall measurements, view a website showing the cloud cover in their location and draw...
Lesson Plan
Curated OER

Lucky Number

For Teachers 6th - 9th
Young scholars use data from simulations to make theoretical generalizations. They discuss possible relationships between several given events and gain understanding about their own mathematical intuition about likelihood.
Lesson Plan
Curated OER

Picture a Nation

For Teachers 5th - 6th
Students research immigration data from a specific time period. They create a graphic organizer that depicts the information and share the information with the class.
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Alabama Learning Exchange

Can Plants Be Grown in Space?

For Teachers 3rd - 5th
Young scholars investigate finding a solution to growing plants in space. They define key vocabulary terms, conduct an experiment growing plants, explore various websites, and participate in a live video conference with NASA regarding...