Lesson Plan
Curated OER

Evaluating an Olympic Sport

For Teachers 6th - 7th
Learners research the political context of the Winter Olympics in general and within certain countries in particular. They read authentic, published articles on the topic from the Internet and add this information to the spreadsheet as...
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Students explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Students complete a data sheet to record ozone readings over a...
Lesson Plan
Curated OER

Sampling Variation in a Natural Population

For Teachers 9th - Higher Ed
Students examine the phenotypic variation within a natural population of a single species. They collect data on the species and analyze the data using statistical/spreadsheet software. Students interpret their results and present their...
Lesson Plan
Curated OER

Stock Market Math

For Teachers 7th - 9th
Students select a company that they like and using technology, in teams, they prepare a class presentation about their company. The class have the option to buy stock or choose a competitor. Each team research a company and buy...
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

How's the Weather

For Teachers 4th - 8th
Students explore weather patterns. They collect and record all aspects of the weather from various sites. Students investigate regional weather and use a spreadsheet to record and chart data. Students chart temperature, humidity,...
Lesson Plan
Curated OER

Animals In Your Neighborhood

For Teachers 3rd - 5th
Learners make list of all animals they have seen in their backyards, neighborhoods, and around school in past week, graph animals using computer spreadsheet program, and compare graphs through email with students in another class.
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Students explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Students use the chart wizard to create a graph.
Lesson Plan
Curated OER

Statistics and Graphing with Accelerated Math

For Teachers 3rd - 7th
Young scholars create charts and graphs, using a spreadsheet program, of their results from their accelerated math lessons. Students discover how graphs can be used to interpret data in our everyday lives as well as how several...
Lesson Plan
Curated OER

Body Part Measurements

For Teachers 2nd
Second graders participate in a review of how to use rulers and yard sticks while collecting measurement information. They measure assigned body parts and chart the data on collection sheets. They make a spreadsheet with the information...
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Students create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family budget.
Lesson Plan
Curated OER

A RealSim Surface Look at Descriptive Statistics

For Teachers 5th - 12th
Students explore the concepts of mean and variance. They observe properties of materials to their basic atomic or molecular structure. Students use spreadsheet software to record, tabulate and analyze collected information.
Lesson Plan
Curated OER

Weight in Water

For Teachers 3rd - 4th
Young scholars investigate why some materials are able to float while others sink. They carry out a scientific investigation, predict and test their predictions. They record their results in a spreadsheet, and use a forcemeter in another...
Lesson Plan
Curated OER

Demographic Changes in 19th Century England and Wales

For Teachers 7th - 12th
Students examine population in England and Wales during the period of 1801-1911. They calculate the percentage of population and how it changed from one census to the next in various towns. They record data on a spreadsheet and create...
Lesson Plan
Curated OER

Job Distribution After 1945

For Teachers 7th - 10th
Learners research job distribution in the U.S. after 1945. They study a spreadsheet of employment data and identify changes in the distribution of jobs in America since World War II. They create pie charts reflecting the data of jobs...
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

Sea Surface Temperature Trends of the Gulf Stream

For Teachers 6th - 12th
Students explore the importance of the Gulf Stream. Using a NASA satellite images, they examine the sea surface temperature. Students collect the temperature at various locations and times. Using spreadsheet technology, they graph the...
Lesson Plan
Curated OER

Computer Science: Temperature

For Teachers 9th - 10th
Students conduct an experiment on heat transfer and how it works. They record the temperature in whatever environment is surrounding the container and run experiments that use at least two different ambient temperatures. Students...
Lesson Plan
Curated OER

Fly Away With Averages

For Teachers 3rd - 5th
Learners study mean, median, and mode. They construct paper airplanes and test them to see how far they fly. They measure the distance and then find the averages of their throws. They use spreadsheet software to record the data in a...
Lesson Plan
Curated OER

Excel Probability with Dice

For Teachers 4th - 6th
Learners play a dice game to complete probability exercises. For this probability lesson, students collect data using a dice game and organize it into a spreadsheet format. Learners also write a lab report for an experiment on probability.
Lesson Plan
Curated OER

Pedestrian Safety for Students Lesson 4: A Walkable Survey

For Teachers 4th - 5th
Pupils create a survey. In this survey lesson, students use www.walktoschool.org to help them come up with questions to ask other pupils. They put the information in spreadsheet format. 
Lesson Plan
Curated OER

Wind Effects on Model Building: Lab for Deflection and Moment of Inertia

For Teachers 11th - 12th
Pupils investigate the relationship between shape of object and moment of inertia. In this physics lesson, students collect data from the experiment and use spreadsheet to graph them. They discuss how load affects deflection.
Lesson Plan
Curated OER

Buying My First Car

For Teachers 5th - 12th
Students pretend they are about to buy their first new car. They must do all the calculations necessary to estimate the cost of purchasing the car. They see that the math they learn in school really does have real-life applications.

Other popular searches