Lesson Plan
Curated OER

Chart the Weather for Cities Around the World

For Teachers 11th - Higher Ed
Learners orally describe Northern and Southern hemispheres, identify 7 continents, and point out specific countries and cities. They locate and record weather information.
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Reality Bites

For Teachers 5th - 8th
Students 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

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

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

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.
Worksheet
Curated OER

A Teeny Tiny Book: My Friends

For Students 1st - 2nd
For this mini book worksheet, students cut apart and complete a teeny tiny book with names of friends and their phone numbers.
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 instructional activity, students visit the links to view class wikis.
Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Young scholars 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...
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 activity effectively...
Activity
Howard Hughes Medical Institute

Tracking Genetically Modified Mosquitoes

For Teachers 9th - 12th Standards
What's that buzzing in your ear? An insightful lesson about genetically modified mosquitoes! Partnered pupils explore the creation, release, and monitoring of mosquitoes designed to reduce the mosquito population. After watching a video,...
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 Planet Article
Curated OER

Solar System Lesson Plans

For Teachers 4th - 8th
Solar system lesson plans provide teachers with a multitude of ways to interest even the most reluctant learners.
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 students 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...
Activity
National Council of Teachers of Mathematics

The Math Forum: Algebraic Problem Solving Using Spreadsheets

For Students 9th - 10th Standards
A unit is presented on instructing students how to build and use spreadsheets for algebraic problem solving. Easy-to-follow steps are provided along with problems for students to practice.
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 plan 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...
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen

For Students 9th - 10th
In Module 1 Lesson 3 of this course on spreadsheets, students begin learning how to use Microsoft Excel to create spreadsheets. Slideshows walk them through how to navigate the menus and tools of Excel.
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M4: L2: What Are the Conditions? Calculate With Functions

For Students 9th - 10th
In Module 4 Lesson 2 of this course on spreadsheets, students learn how to use conditional formatting to more easily analyze data. Includes slideshow tutorials.