Lesson Plan
Curated OER

Testing Battery Combinations

For Teachers 4th
Fourth graders examine the required combinations of plates and predict which combination will generate the most and least current and voltage. They use an ammeter and experiment with combinations of their own testing and record each...
Lesson Plan
Curated OER

Impact Craters and Water on Mars

For Teachers Higher Ed
Students explore for water on Mars using impact crater morphology. During this lab, students: investigate how to use the equation writing and graphing capabilities in Microsoft Excel, then develop and apply an impact crater...
Lesson Plan
Curated OER

Virtual Field Trip: Lodging and Meals

For Teachers 5th - 7th
Students calculate the costs for lodging and meals for a virtual field trip. They calculate the number of nights lodging needed for road and city travel and the number of meals needed, the costs for each, and input the data using...
Lesson Plan
Curated OER

Finding Caterpillars

For Teachers 4th - 6th
Learners examine how animals protect themselves from predators and camouflage themselves. They participate in a simulation in which they locate red and green yarn "caterpillars," organize their data, and generate a bar graph using...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Learners use NASA satellite data to compare water vapor over the United States.  In this data analysis activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Curated OER

Terrific Tessellations

For Teachers 6th - 10th
Students create to pieces of artwork using two primary colors and tessellation techniques. This is an excellent lesson plan that can be accomplished using standard art techniques or educational software such as Adobe Photoshop or...
Lesson Plan
Novelinks

Oedipus the King: Anticipation Guide

For Teachers 9th - 12th
Is it possible to escape fate? Are all types of pride evil? Are family secrets best kept secret? Before reading Oedipus the King, class members respond to a series of statements on an anticipation guide that introduces some of the basic...
Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 7th - 9th
Students experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.
Lesson Plan
Curated OER

Calculating Profits from Selling Virtual Lemonade

For Teachers 5th - 7th
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider weather...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson plan, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint...
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
High schoolers demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
PHET

Where to See an Aurora

For Teachers 6th - 8th Standards
Where can you see an aurora in North America? After completing an astronomy activity, scholars can locate the exact coordinates. Pupils plot points of the inner and outer ring of the auroral oval and answer questions based on...
Lesson Plan
Curated OER

Allele and Phenotype Frequencies in Rock Pocket Mouse Populations

For Teachers 9th - 12th Standards
In the deserts of Arizona and New Mexico, some tiny creatures show just how quickly natural selection can turn a mutation into an advantageous adaptation. Watch a video about rock pocket mice, who show that one small change can make all...
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Dietary Guidelines 2000

For Teachers 6th - 12th
Students research dietary guidelines and create a Microsoft Powerpoint presentation that reviews the dietary guidelines to present to their class or an elementary class.
Lesson Plan
Curated OER

May The Force Be With You

For Teachers 8th
Eighth graders investigate Newton's Laws of Motion. They use the example of a roller coaster for illustration purposes. A force associated with a roller coaster is tested, data graphed, and a conclusion is drawn. They use excel in order...
Lesson Plan
Curated OER

Geometry Shapes Playground Safety

For Teachers 9th - 12th
High schoolers create a new playground design to present to elementary students during Playground safety week. They review basic geometry to use in observing and recording the equipment on a local playground. They research playground...
Lesson Plan
Curated OER

Once Upon A Math Story

For Teachers 2nd - 4th
Students write a math story.  In this math operations and writing lesson plan, students work in small groups to brainstorm ideas for a math story, write a rough draft, revise their story, edit their story and add clip art. ...
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Curated OER

Weights and Measures

For Teachers 6th - 8th
Students master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.
Lesson Plan
Curated OER

Nutrition Track

For Teachers 7th - 9th
Students examine the importance of a healthy diet based on the USDA food pyramid. They log their daily food intake in a journal. They create charts to analyze and compare their diets to the USDA recommended allowances.
Lesson Plan
Curated OER

The Universe

For Teachers 6th - 8th
Learners describe what scientists mean by an "expanding universe" in their own words. They explain how scientists comprehend the universie is expanding. Students comprehend the vast scale of the universe. They comprehend how theory...
Lesson Plan
Curated OER

Buy Low, Sell High

For Teachers 7th - 10th
Learners investigate the stock market and investing in corporate stocks by creating an investment portfolio. They develop database worksheets that track their stock's performance over a specified period of time. Students use their...