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
Students 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
Students 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 different...
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
Learners 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
Students 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
Students 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
Students 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...
Worksheet
Curated OER

Double Digit Multiplication Practice

For Students 5th - 6th
In this math practice instructional activity, students complete 48 double digit multiplication problems in an Excel instructional activity. They find the products by multiplying in the spreadsheet.
Worksheet
Curated OER

Single Digit Multiplication Practice

For Students 2nd - 3rd
In this math practice worksheet, students solve 48 single digit multiplication problems. They work in an Excel spreadsheet to complete the work.
Lesson Plan
Curated OER

Excel Probability with Dice

For Teachers 4th - 6th
Students play a dice game to complete probability exercises. In this probability lesson, students collect data using a dice game and organize it into a spreadsheet format. Students 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
Students create a survey. In this survey lesson, students use www.walktoschool.org to help them come up with questions to ask other students. 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
Students 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

Evaluating an Olympic Sport

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

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.
Lesson Plan
Curated OER

Who Built It?

For Teachers 7th
Seventh graders study the difference between architectural detail from the Romanesque and Gothic eras. The class participates in discussion on are in different eras. They predict what picture belongs in what era.
Worksheet
Curated OER

Experiment-Using Formulas and Spreadsheets

For Students 9th
In this Algebra I worksheet, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data.  The one page worksheet contains the assignment and...

Other popular searches