+
Lesson Plan
Curated OER

World Population Activity II: Excel

For Teachers 11th - Higher Ed
Students import UNEP World population data/projections from either the World Population Prospects: The 2002 Revision Population Database - UN Population Division or a text file. They graph this data by itself, and then along with...
+
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 3rd
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
+
Lesson Plan
Curated OER

Rainforest Deforestation and the Water Cycle

For Teachers 1st - 5th
Students create terrariums (mini rainforests). They observe and discuss the life processes that occur in their terrariums and how changes in these processes affect the plants and organisms inside. They collect and graph data and present...
+
Lesson Plan
Curated OER

Spreadsheet Budget Project

For Teachers 8th
Eighth graders record all the food they eat for one week, compute the costs for all of this food, and display the different categories on a spreadsheet and then convert to a chart.
+
Lesson Plan
Curated OER

Landfill Project

For Teachers 8th - 10th
Students explore impact of garbage on environment, examine waste management operations and how they can directly impact environment, implement ways to lower household garbage, and make STELLA Model about garbage flow and use model to...
+
Lesson Plan
Curated OER

E3 Project Instructional Plan

For Teachers 10th - 11th
Students will build a solar panel. In this physics lesson plan, students will begin with a lecture on energy and proceed into research for their solar panel. The solar panels will be field tested and problems and solutions will be shared...
+
Lesson Plan
Curated OER

Community and Ecosystems

For Teachers 4th - 5th
Students complete a unit of lessons on ecosystems. They participate in online activities, create a diorama, write journal entries, and develop a Hyperstudio multimedia project on a selected ecosystem.
+
Lesson Plan
Curated OER

Animal Research Project

For Teachers 3rd
Third graders prepare an oral report using Appleworks to present information on their animal. They write a short narrative comparing and contrasting their animal to another students and, after watching other presentations, discuss what...
+
Lesson Plan
Curated OER

Wsshington Monuments Projects

For Teachers 8th
Eighth graders choose a landmark or monument to investigate (individually or with a partner). After agreeing on items to study they research the landmark/monument and prepare a presentation.
+
Lesson Plan
American Statistical Association

How Random Is the iPod’s Shuffle?

For Teachers 6th - 8th Standards
Shuffle the resource into your instructional activity repertoire. Scholars use randomly-generated iPod Shuffle playlists to develop ideas about randomness. They use a new set of playlists to confirm their ideas, and then decide whether...
+
Lesson Plan
Teach Engineering

Fun with Air-Powered Pneumatics

For Teachers 7th - 12th Standards
How high did the ball go? Engineering teams build a working pneumatic system that launches a ball into the air. The teams vary the amount of pressure and determine the accompanying height of the ball. An extension of building a device to...
+
Lesson Plan
Minnesota Literacy Council

Scientific Method

For Teachers 4th - 6th Standards
Here is a resource with a descriptive approach to explaining the scientific method. It's simple, but effective for both introduction and reinforcement of this concept. 
+
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 5th - 7th
Are we there yet?  Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
+
Lesson Plan
WK Kellogg Biological Station

N2O: It’s No Laughing Matter!

For Teachers 7th - 12th
While the layout of the lesson plan is not very detailed and the link to the PowerPoint is no longer valid, there are some great exercises to examine the role of nitrous oxide in the environment. For middle level learners, the resource...
+
Lesson Plan
Curated OER

Plot! Analyze! Draw your Conclusions!

For Teachers 3rd - 8th
Students download data reported from the Global Sun Temperature Project website. They graph and analyze the data looking for trends and patterns. They prepare a class report with their observations and post it to the website.
+
Lesson Plan
Curated OER

What Can Scatterplots Tell Us?

For Teachers 8th
Eighth graders use data from surveys conducted with parents, peers and themselves to create computer-generated scatterplots. They make inferences from their scatterplots.
+
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

Highs and Lows

For Teachers 3rd - 4th
Students use email to chart weather patterns and then graph their findings. In this weather patterns lesson, students chart their weather for a week at the school. Students then use email to find temperatures at a variety of locations....
+
Lesson Plan
Curated OER

Ladybugs in the Garden

For Teachers 5th
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a lesson where they observed, examine, and record data...
+
Lesson Plan
Curated OER

How is Your Driver Doing?

For Teachers 6th
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.
+
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Learners construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Learners familiarize themselves with entering and presenting data in a spreadsheet.
+
Lesson Plan
Curated OER

How Texas is Planning To Manage Its Water

For Teachers 9th - 12th
Students research water management strategies in Texas. They analyze projected demand for water in the year 2050, interpret graphs and tables and then discuss the data as part of a written report. They research and map the locations of...
+
Lesson Plan
Curated OER

Lemonade for Sale

For Teachers 3rd
Third graders engage in a read-aloud of the book, "Lemonade for Sale." They collect data from the story and turn the data into a mathematical graph. This lesson has a rubric for you and the students to follow-very creative lesson.
+
Lesson Plan
Curated OER

Differences between Climate and Weather

For Teachers 4th - 7th
Students collect weather data over weeks, graph temperature data and compare the temperature data collected with averaged climate data where they live.