Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson plan, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Young scholars prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

Don't Trash the Earth

For Teachers 6th - 8th
Pupils experience a hands-on environmental science project. They access about recycling as they collect data on their own family's trash production. Students analyze the data with worksheets, chart the data, and present their findings.
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Lesson Plan
Curated OER

Positive Future Fair Project

For Teachers 9th
Ninth graders view the film "Pay It Forward" and discuss what kind of public campaign is needed to move people to positive action. They consider different ways of presenting information (graphs, visual displays, etc.) as tools for...
Lesson Plan
Curated OER

Watt's Up with the Electricity Bill?

For Teachers 7th - 8th
Students study of how much electricity is used in their home and the actual cost for the electricity. They create a realistic conservation plan for their home focusing on the areas that tend to use a great deal of electricity....
Lesson Plan
Curated OER

Time Management

For Teachers 3rd - 6th
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson is intended for the upper-elementary classroom and includes resource links and activity extensions.
Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Students explore the concept of cell phone plans. In this cell phone plan lesson, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
Lesson Plan
Curated OER

The Effects of Weather on People

For Teachers Pre-K - 2nd
Students discover the causes of different types of weather and it's effect on society.  In this environmental lesson, students utilize the Internet to examine cloud types, normal weather conditions and the type of weather considered...
Lesson Plan
Curated OER

How Do Plants Grow?

For Teachers 3rd - 5th
Young scholars investigate plant growth. In this plant growth lesson plan, students investigate what would happen to plants if they did not have water and sunlight. Young scholars conduct experiments to determine what plants need....
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
Lesson Plan
Curated OER

Food Label Fun

For Teachers 3rd
Third graders demonstrate how to read and analyze food labels. In this nutrition lesson, 3rd graders watch a food label video and investigate labels from various canned foods. Students create a chart showing the percentage of vitamins...
Lesson Plan
Curated OER

The Universe

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

Bias in Statistics

For Teachers 7th - 8th
Young scholars work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Lesson Plan
Curated OER

"One Day in the Prairie" by Jean Craighead George

For Teachers 4th - 6th
Students collect "prairie insects" for data collection and analysis.
Lesson Plan
Curated OER

Enhancing Writing Through Technology

For Teachers 1st - 3rd
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
Lesson Plan
Curated OER

Using SWMP Data

For Teachers 9th - 12th
High schoolers are introduced to the SWMP system which tracks short-and long-term changes in water. Using this data, they plot and interpret the data on a graph to determine how human activities are lowering the water quality. They also...
Lesson Plan
Curated OER

Weather Or Not

For Teachers 3rd - 5th
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Lesson Plan
Curated OER

To Drink or not to Drink

For Teachers 7th
Seventh graders discuss water quality, water availability and water resources and how water is used in the world around them. They view a video on water quality then test for pH, temperature and dissolved oxygen to indicate water quality.
Lesson Plan
Curated OER

Student Experiment Flies On NASA Space Shuttle!

For Teachers 7th - 12th
Students design and construct an experiment that will be launched into space aboard a NASA research shuttle. How better to gain and appreciation for (and, hopefully, a love of) scientific investigation than to do real science and be...
Lesson Plan
Curated OER

"So Tell Me About Your Trip..."

For Teachers 6th - 8th
Students research destinations and the factors involved in taking a trip and explore how averages play a part in making decisions. They explore how to find the average speed and the distance to a particular destination, they estimate...
Lesson Plan
Curated OER

Graphing Speed

For Teachers 9th - 12th
Students use LOGAL motion detector probe and observe a generated graph as a student performs various standard motions, and make measurements of time and distance. They suggest various time and distance measurements which a student can...