Lesson Plan
Curated OER

Graphing Weights and Measures

For Teachers 4th - 6th
Learners practice gathering, averaging, and graphing data. They practice converting measurements to the metric system. Students graph their results and present them to the class.
Lesson Plan
Curated OER

Graphing and Demography: The Domestic Slave Trade

For Teachers 9th - 12th
Students create graphs or charts based on the data a narrative imbedded in this plan. They make them either by hand or by using Excel or a similar database program. This lesson plan utilizes technology in a meaningful way.
Lesson Plan
Curated OER

Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs

For Teachers 4th - 6th
Students use a spreadsheet program to graph and compare milage, gasoline costs and travel time for two travel routes in their virtual field trip in Michigan. They determine the most economical route based on the graphs and calculations.
Lesson Plan
Curated OER

The Box with the Greatest Volume

For Teachers 5th - 8th
Students use measurement tools to measure the nearest 16th of an inch. They connect fractions and their decimal equivalents and compare this with other decimals. Finally, the class uses algebraic concepts and formulas to solve problems.
Lesson Plan
Curated OER

Halloween Graphitti

For Teachers 5th - 7th
Students complete multi-curricular activities in a Halloween themed instructional activity. In this Halloween instructional activity, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf...
Lesson Plan
Cornell University

Mechanical Properties of Gummy Worms

For Students 9th - 12th
Learners won't have to squirm when asked the facts after completing an intriguing lab investigation! Hook young scholars on science by challenging them to verify Hooke's Law using a gummy worm. Measuring the length of the worm as they...
Lesson Plan
Curated OER

What's your favorite physical fitness activity?

For Teachers 4th
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Lesson Plan
Curated OER

Precipitation in Michigan Cities

For Teachers 3rd
Third graders investigate the rainfall amounts in four Michigan cities to observe how cities near lakes are affected differently by precipitation than those that are inland. They record the rainfall for the cities over an eight day...
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 5th - 7th
This hands-on resource has future trip planners analyze graphs of mileage, gasoline costs, and travel time on different routes. While this was originally designed for a problem-solving exercise using a Michigan map, it could be used as a...
Lesson Plan
Curated OER

Stress, Strain and Hooke's Law

For Teachers 10th - 12th
Students study Hooke's Law and stress-strain relationships.  In this spring lesson students create a strain graph in Microsoft Excel.
Lesson Plan
Curated OER

1, 2, 3, Read!

For Teachers K - 1st
Explain to your readers a variety of decoding strategies to improve their reading fluency. They observe the teacher modeling blending, then in pairs take turns reading the book Clifford the Big Red Dog. Learners then time each other...
Lesson Plan
Curated OER

Reading & Using a Nutrition Label

For Teachers 8th - 12th
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Predicting Temperature: An Internet/Excel Learning Experience

For Teachers 3rd
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Lesson Plan
Curated OER

One Plus One Makes New

For Teachers 5th - 8th
Students discover the properties of matter and how they change when composite materials are produced.  In this informative instructional activity students write up a question and procedure to an experiment then analyze and draw...
Lesson Plan
Curated OER

Math: Real Time and Live

For Teachers 6th - 9th
Get an interdisciplinary edge. Scholars study air contamination and slope. They record the time it takes for air fresheners to reach them at variable distances. They document their times, classify them by distance, and draw a scatter...
Lesson Plan
American Physiological Society

Feeling the Heat

For Teachers 9th - 12th
How do the changing seasons affect the homes where we live? This question is at the forefront of engineering and design projects. Challenge your physical science class to step into the role of an architect to build a model home...
Lesson Plan
Curated OER

Predicting Monthly Precipitation

For Teachers 8th - 12th
Students should log onto, and collect data from, a specific site on the Internet. They average and compare the data using the Excel spreadsheet program, make predictions from their data, and determine the percent error of their predictions.
Lesson Plan
Curated OER

Small Business

For Teachers 6th - 12th
Students simulate owning and running a small business by playing Lemonade Stands. They play the game for three weeks, then work with a partner to produce a Power Point presentation which would be given to a Board of Directors showing...
Lesson Plan
Curated OER

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz instructional activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced...
Lesson Plan
Curated OER

Bean Sprout

For Teachers 1st - 2nd
Student will track the growth of his/her bean sprout with sunlight and without sunlight over the course of 3 weeks. They will enter the results into an excel data base then graph the results of both variables to make the comparison.
Lesson Plan
Curated OER

HEART THROBS

For Teachers 6th - 8th
Middle schoolers predict what might happen to their pulse rates after physical exertion and then make conclusions about the effects of physical activity on pulse rates.
Lesson Plan
Curated OER

BRIDGING THE GENERATION GAP

For Teachers 9th - 12th
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Lesson Plan
Curated OER

Ready, Set, Go!

For Teachers 6th - 8th
Middle schoolers predict if the height of a ramp affect how far an object travels. They design and conduct an experiment to test their predictions. The results are recorded and a graph is created to show the relationship between ramp...