Lesson Plan
Curated OER

The Transformer

For Teachers 4th
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length...
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.
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
Curated OER

Energy Efficient Home Design

For Teachers 9th - 12th
Students investigate the applications of energy efficient homes. They conduct Internet research, complete a worksheet, evaluate the energy efficiency of a home design, and complete a research report on energy efficient homes.
Lesson Plan
Curated OER

Day And Night: Interdisciplinary Study of Cyclic Change

For Teachers 8th
Eighth graders conduct a "Length of Day Symposium." They complete a variety of activities and explorations regarding the earth's rotation, its revolution around the sun and the cyclic changes in climate and energy distribution on the...
Lesson Plan
Curated OER

All About Me: Measuring Height and Weight

For Teachers 2nd - 4th
Students take personal fitness inventories. In this personal health lesson, students take measurements of their heights and weights. Students record the data, calculate their BMI, and then chart their physical activity.
Lesson Plan
Curated OER

Visiting the Medical Fields

For Teachers 9th - 12th
Students act as medical pioneers to establish a clinic in an under served area.t They work in teams of two to complete a portfolio about their clinic and examine new treatments in various area of medicine.
Lesson Plan
Curated OER

How Quickly Disease Spreads

For Teachers 9th - 12th
Students demonstrate how quickly disease spreads and the importance of protective measures with communicable diseases. They examine past epidemics such as the Bubonic Plague and make predictions about future epidemics.They compare and...
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This activity is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Giving Them the Business

For Teachers 1st - 2nd
Students work in small groups of 4-5 students to form a business, create, market and sell their product, and track their expenses and profits. They experience the roles of the producer, distributor, and consumer of goods.
Lesson Plan
Curated OER

The Seasonal Round and The Cycle of Life

For Teachers 4th
Fourth graders are introduced to the concept of the seasonal round and how folklife traditions vary from season to season. They begin charting dates of personal interest on seasonal round calendars by starting with birthdays. Students...
Lesson Plan
Curated OER

Great Online Art Sites

For Teachers K - 8th
Students complete an online study of art websites. In this art and technology lesson, students explore the links and try the activities to learn about art online.
Lesson Plan
Curated OER

Bringing Young Architects to Surface

For Teachers 7th - 9th
Students work in pairs to design a building. In this architecture lesson plan, students take on the role of head architect to design and construct a 3-D scale model a building for a client. Students' goal is to meet...
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.
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
Other

Nearpod: Spreadsheets: Using Formulas

For Teachers 9th - 10th
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
Activity
University of Waterloo (Canada)

Wired Math: Organizing Data Grade 7 [Pdf]

For Students 6th - 8th
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
Lesson Plan
PBS

Pbs Teachers: Sports and Math: Batting Averages and More

For Teachers 9th - 10th Standards
Set up a spreadsheet using a computer or graphing calculator, and perform calculations using columns. Calculate percentages and solve a system of equations regarding baseball statistics.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: Seventh Grade Mathematics: Data Sense

For Teachers 6th - 8th
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...
Activity
National Council of Teachers of Mathematics

The Math Forum: How to Make a Bar Graph

For Students 9th - 10th
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
Lesson Plan
Utah Education Network

Uen: Design Your Own Bedroom

For Teachers 6th - 8th
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Lesson Plan
Microsoft

Microsoft Education Lesson Plan: Candy Is Dandy

For Teachers 3rd - 8th
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
Interactive
American Association of Physics Teachers

Com Padre Digital Library: Open Source Physics: Data Tool Program

For Students 9th - 10th
Use this online data analysis tool to build graphs and display results from scientific investigations. Data can be entered directly with the keyboard or imported from, and exported to spreadsheets.