Lesson Plan
Curated OER

Spreadsheet Budget Project

For Teachers 8th
Eighth graders record all the food they eat for one week, compute the costs for all of this food, and display the different categories on a spreadsheet and then convert to a chart.
Lesson Plan
Curated OER

Christmas Tree

For Teachers 9th
Ask the students for ideas on sorting the decorations so that they could tell someone what was in the box. Students share idea for sorting a box of Christmas decorations so that they could tell someone what was in the box. They share...
Lesson Plan
Curated OER

Fractions and Fact Families: Jump Kangaroo Jump!

For Teachers 2nd
Second graders practice with fractions and fact families. In this fractions and fact families lesson, 2nd graders participate in a series of activities to assist them with understanding fractions.  Activities include graphing,...
Lesson Plan
Curated OER

Ecosystems

For Teachers 2nd - 6th
Students create plots of land in three different ecosystems and use AppleWorks to collect data for research. This lesson includes a downloadable worksheet and can be accomplished in four days.
Lesson Plan
Curated OER

Introducing Temperature Measurement

For Teachers K - 2nd
Students explore temperature and use Celcius thermometers to measure and graph the temperature in the classroom daily. They estimate what they think the temperature might be and then find the actual temperature in the room.
Lesson Plan
Curated OER

Slopey Math

For Teachers 8th - 10th
Students identify the slope of a line and use it to solve real life problems. In this algebra lesson, students write linear equations in slope intercept form and make a correlation to its relation to the real world. They use the slope an...
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

Leap Into Exponential Functions

For Teachers 8th - 10th
Young scholars use properties of exponents to solve equations. In this algebra lesson, students add, subtract, multiply and divide exponential functions. They graph and differentiate between exponential growth and decay.
Lesson Plan
Curated OER

How Effective is Perspiration at Cooling?

For Teachers 9th - 12th
Students collect data on the cooling of water in two different test tubes, one that is wrapped in wet newspaper and one in dry newspaper. They then relate this cooling effect to the body's perspiration.
Lesson Plan
Curated OER

M & M Lab

For Teachers 4th
Fourth graders explore several different types of graphs using M & Ms.
Lesson Plan
Curated OER

Did Somebody Say...? Where to Work?

For Teachers 6th - 8th
Middle schoolers conduct research on four fast food restaurants to determine where they might apply for a job. They conduct research on hourly rate, working conditions, and benefits, construct a spreadsheet with a graph, and present...
Lesson Plan
Curated OER

Light Plants and Dark Plants, Wet Plants and Dry Ones

For Teachers 1st - 3rd
Young scholars plant sunflower seeds in plastic cups, and once germinated, these are exposed to different conditions of light levels and/or soil moisture contents. Students measure growth of the seedlings every few days using...
Lesson Plan
Curated OER

Using a spreadsheet and the Internet to learn about stock market performance

For Teachers 9th - 12th
Students record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.
Lesson Plan
Curated OER

Natural Resources

For Teachers 5th
Fifth graders begin the lesson plan by identifying the different types of natural resources. As a class, they discuss how environments are destructed and how the loss of one natural resource can affect the economy. Using a map, they...
Lesson Plan
Curated OER

Ants in Your Pants

For Teachers 1st
First graders read "One Hundred Angry Ants" by Elinor Pinczes. They identify various sums that equal ten and display them on a chart.
Lesson Plan
Curated OER

Fossils: The Eras of the Earth's History

For Teachers 2nd - 3rd
Students research the four geologic eras of Earth's history. In this extension on a fossils lesson, students research the different eras of Earth's history. Students use AppleWorks to create a bar graph containing information of the four...
Lesson Plan
Curated OER

Math: Party Time!

For Teachers 12th
Twelfth graders discover how to calculate the total costs for a party. They determine the unit prices of food and supplies, the quantities needed, and complete a chart displaying their findings. Students calculate the costs per serving...
Lesson Plan
Curated OER

Graph Both Crusts

For Teachers 4th
Fourth graders calculate the angles and construct a pie graph of the percentages of the elements in the continental and oceanic crusts. Then they analyze the results. They can be assigned the task of researching the percentages.
Lesson Plan
Curated OER

Heart Smart in a Heart Beat

For Teachers 5th - 7th
As an introductory activity, young statisticians measure their heart rate at rest and after exercise and compute the mean and median, and create a box & whisker plot.  This is followed by watching a video (that no longer seems...
Lesson Plan
Curated OER

Sampling Snoops

For Teachers 7th - 8th
Students practice formulating a hypothesis and designing an experiment to test the hypothesis. They identify several sampling techniques they can use to test their hypotheses.
Lesson Plan
Curated OER

Rubber Band

For Teachers 8th
Eighth graders investigate what would happen to the length of a rubber band as more and more rings were hung on it. They base their explanation on what they observed, and as they develop cognitive skills, they should be able to...
Lesson Plan
Curated OER

Weather "Whys" : Introduction to Weather

For Teachers K
Students discuss weather forecasts and different types of weather. In this weather lesson, students observe the weather and learn a weather song. They listen to a story and see weather measurement tools. 
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 3rd
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
Lesson Plan
Curated OER

Inventors Unit Survey

For Teachers 3rd - 5th
Students develop and conduct a survey for their inventors unit. They create a five question survey and tally the survey results, and create a graph using Microsoft Word and Graph Club 2.0.