Curated OER
Reality Bites
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.
Curated OER
Cloud Databases
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.
Curated OER
Weather Systems
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...
Curated OER
A Teeny Tiny Book: My Friends
In this mini book worksheet, students cut apart and complete a teeny tiny book with names of friends and their phone numbers.
Curated OER
Visit My Class Wikis
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.
Curated OER
Math: The Bone connection
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...
American Institutes for Research
Digital Smiles
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...
Curated OER
Discovering Pi
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.
Curated OER
The Birds of a Feather Flock Together
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...
Howard Hughes Medical Institute
Tracking Genetically Modified Mosquitoes
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,...
Texas Instruments
Is It or Isn't It Proportional
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...
Curated OER
Investigating Fables
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...
Curated OER
Properties of Logarithms
Learners investigate properties of logarithmic function as they add, subtract and multiply logarithms. They graph and analyze the graph for exponential equivalency.
Curated OER
Solar System Lesson Plans
Solar system lesson plans provide teachers with a multitude of ways to interest even the most reluctant learners.
Science Education Resource Center at Carleton College
Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore
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...
National Council of Teachers of Mathematics
The Math Forum: Algebraic Problem Solving Using Spreadsheets
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.
Science Education Resource Center at Carleton College
Serc: Yellowstone! A National Park on a Hot Spot
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...
Science Education Resource Center at Carleton College
Serc: The Digital Divide: A Data Analysis Activity Using Subtotals
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...
Department of Defense
Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen
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.
Department of Defense
Do Dea: Spreadsheets: M4: L2: What Are the Conditions? Calculate With Functions
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.
Department of Defense
Do Dea: Spreadsheets: M5: L2:loans and Investments: Calculate With Functions
In Module 5 Lesson 2 of this course on spreadsheets, students will learn how to use the advanced Financial, Logical and Date & Time functions to analyze spreadsheet data. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M6: L1: Designing Spaces: Using Templates
In Module 6 Lesson 1 of this course on spreadsheets, students learn how to use the templates in Excel to save time when making new spreadsheets. Includes slideshow tutorials.
REMC Association of Michigan
Remc Association of Michigan: 21 Things4 Students: 13. Dig the Data
This tutorial contains ten quests. You will learn to create spreadsheets and charts, use formulas, and make decisions based on data. The first five quests has students plan a party and in the last five, they collect and analyze data for...
Department of Defense
Do Dea: Spreadsheet Software Applications: M6: L2: Clean Up: Using Data Tools
In Module 6 Lesson 2 of this course on spreadsheets, students learn how to use data validation tools in Excel to minimize errors in manual data entry. Includes slideshow tutorials.