Lesson Plan
Curated OER

Irish Eyes: Taking a Look at Local Landscape

For Teachers 9th - 11th
Students create landscape flyers of local landscapes using digital photography, educational software, and examples of Irish landscapes. This creative-project lesson lasts two weeks, including class time spent collecting photographs...
Lesson Plan
Curated OER

Tell Me a Story

For Teachers 10th
Tenth graders read short story, "The Storyteller" by Saki, and expand on concept of stories for students by reading and evaluating several popular students's stories as well as writing their own original students's stories.
Lesson Plan
Curated OER

Graphing Heart Rates

For Teachers 4th - 5th
Students explore heart rates. They record pulse rates, predict which exercises cause a faster heart rate, make a chart, and graph the results. Students write an essay using the data to support their predictions. They write a hypothesis...
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Get Your Butt off the Beach!

For Teachers 11th - 12th
Students participate in a Beach Field Study in which the analyze the affect pollution is having on beaches and the animals that live there. Students focus specifically on the damage cigarette butts are causing on the environment.
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

Research a State in the United States

For Teachers 6th - 8th
Learners research one state of the United States of their choice. Using the internet, they gather as much information about the state as possible along with appropriate images. They present their findings to the class in the form of a...
Lesson Plan
Curated OER

Water-our Precious Resource

For Teachers 6th - 8th
Students complete a unit of lessons on water as a limited resource. They conduct Internet research, record information in electronic journals, utilize spreadsheets, conserve water and record the results, and conduct water safety tests on...
Lesson Plan
Curated OER

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.
Lesson Plan
Curated OER

Reality Bites

For Teachers 5th - 8th
Young scholars select a career or occupation to study. Students research their career preferences and annual living expenses compared to the estimations they may before conducting research.
Lesson Plan
Curated OER

Cloud Databases

For Teachers 7th - 9th
Students complete a unit on clouds and a report about one type of cloud. They collect data through observation about different types of cloud cover and then create a spreadsheet to reflect their observations over a 2 week period.
Lesson Plan
Curated OER

Weather Systems

For Teachers 4th
Fourth graders research weather phenomenon in groups on the Internet and create a slide for the class power point presentation. They include 5 key points (temperature, air pressure, and fronts and descriptions for each type of cloud or...
Lesson Plan
Curated OER

Visit My Class Wikis

For Teachers 4th - 7th
Students visit the links on the blog site to learn about class wikis. In this technology integration lesson, students visit the links to view class wikis.
Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Students examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating and...
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

The Birds of a Feather Flock Together

For Teachers 5th
Fifth graders identify all parts of an egg, and explore their importance to the life cycle of a chicken. Learners compare all sorts of birds and place them in categories based on what they look like. This five-day lesson effectively...
Lesson Plan
1
1
Texas Instruments

Is It or Isn't It Proportional

For Teachers 6th - 12th Standards
How can you tell if number relationships are proportional? Mathematicians investigate proportional relationships. They compare and contrast functions and graphs to determine the characteristics of proportional relationships, as well as...
Lesson Plan
Curated OER

Investigating Fables

For Teachers 7th - 8th
Time for a story! Learners of all ages enjoy listening to stories, so read them some common fables and have them work cooperatively to create a fable.  Differentiate for varying ability levels by providing sentence frames, graphic...
Lesson Plan
1
1
Curated OER

Properties of Logarithms

For Teachers 9th - 12th Standards
Learners investigate properties of logarithmic function as they add, subtract and multiply logarithms. They graph and analyze the graph for exponential equivalency.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore

For Teachers 9th - 10th
A lesson plan with an accompanying PowerPoint learning module for learners where they learn about coho salmon and a repair done to a culvert in Point Reyes National Seashore. The repair was intended to help the salmon make their journey...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Yellowstone! A National Park on a Hot Spot

For Teachers 9th - 10th
A lesson plan with an accompanying PowerPoint learning module for students where they learn about the volcanic features of Yellowstone National Park. They use spreadsheets to make various calculations, such as the volume of material...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Digital Divide: A Data Analysis Activity Using Subtotals

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the accessibility...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...