Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Lesson Plan
Curated OER

Mythology Spreadsheet

For Teachers 4th - 8th
Students read a large variety of myths and discuss the characters and their attributes found in mythology. Then they identify and learn to set up an appropriate spreadsheet program. Students also enter the data to the class spreadsheet...
Lesson Plan
Curated OER

Quick Questions: Open-Ended

For Teachers 2nd - 6th
Students conduct an open ended survey and analyze the data they found. For this open-ended survey lesson plan, students ask others their open ended questions and then organize their results based on the most common, least common, and...
Lesson Plan
Curated OER

Combinations and Permutations

For Teachers 5th
Fifth graders investigate the concepts of combinations and permutations using probability. They practice calculations using probability to measure the outcomes. Students demonstrate how to organize and categorize the data.
Lesson Plan
Curated OER

Acid-Base Titration

For Teachers 9th - 12th
Students determine the concentration of an unknown solution. This task assesses students' abilities to state hypothesis, develop procedures for investigation, plan for recording and organizing observations and data, collect data, create...
Lesson Plan
Curated OER

Gee, It's Crowded in Here

For Teachers 4th - 6th
Students interpret raw data about population statistics. In this raw data lesson plan, students plug the data into graphic organizers and draw conclusions based on their findings.
Lesson Plan
Curated OER

Misleading Graphs

For Teachers 3rd - 5th
Young scholars explore number relationships by participating in a data collection activity. In this statistics lesson, students participate in a role-play activitiy in which they own a scrap material storefront that must replenish...
Lesson Plan
Curated OER

Mapping River Statistics

For Teachers 9th - 12th
Students research different statistics to do with the Mississippi River. They answer questions about finding data and collect it by conducting research. The research is used to construct a data table. Then students use the table to...
Lesson Plan
Curated OER

Stemmin'-n-Leafin'

For Teachers 6th - 7th
Students make stem and leaf charts to determine the measures of central tendency using test score data. They analyze the data to draw inferences which they share with the class. They complete the associated worksheets.
Lesson Plan
Curated OER

Getting A Grip On Graphs

For Teachers 4th
Fourth graders investigate the concept of graphing and comparing different types of data using pictographs, line graphs, scatter plots, etc... They gather data and make interpretations while examining the medium of how it is displayed.
Lesson Plan
Curated OER

Probability Lesson Plan

For Teachers 3rd - 8th
Your learners will examine probability through experiments and dice games. Using a computer, your class will perform simple experiments to collect and analyze data to determine the probability of different experimental results. Students...
Lesson Plan
Curated OER

What is a Box and Whisker Plot?

For Teachers 8th
Eighth graders explore the correct use of box and whisker plors. The times when they are appropriate to use to compare data is covered. They plot data according to statistical analysis including mean, median, and mode.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 7th - 8th
Learners develop a formula that describes the functional relationship of the circumference of a circle to its diameter. Working with a partner, they measure the diameter and circumference of circular objects in order to discover the...
Lesson Plan
Curated OER

Student Heights

For Teachers 5th - 7th
Students measure the heights of their fellow classmates and create a box and whisker plot to display the data. In this measurement lesson plan, students analyze the data and record results.
Lesson Plan
Curated OER

Calculating Buttons

For Teachers 2nd - 4th
Learners, after reading "The Button Box" by Margarette S. Reid, analyze real-world data by surveying a sample space. They predict the generalization onto a larger population utilizing calculators and computers. Students total categories,...
Worksheet
Curated OER

Family Size

For Students 8th - 9th
In this family size worksheet, students complete a tally chart to determine data from a family size line plot. They organize the data in the chart to determine the mean, median, mode, and range of the data. There are six problems in...
Lesson Plan
Curated OER

Significant Science: Statistics for Planet Earth

For Teachers 9th
Ninth graders discover how statistics are used to interpret results of scientific experiments. Students write hypotheses and test the hypotheses by collecting data and organizing the data. Students graph their data to produce a visual....
Lesson Plan
Curated OER

Graph It

For Teachers 1st - 2nd
Students create a spreadsheet and graph using Open House attendance data.
Lesson Plan
Curated OER

Mathematics Witing: Algebraic Processes and Its Connections to Geometry

For Teachers 4th - 5th
Students, using manipulatives, determine how many different ways there are to arrange 3 and 4 objects. They organize and record their arrangements. Students investigate the pattern generated by 3 and 4 objects, they predict how many ways...
Lesson Plan
Curated OER

Histograms and Bar Graphs

For Teachers 5th - 6th
Students examine the use of bar graphs and histograms. In this data representation lesson, students investigate the proper use of bar graphs and histograms to represent data. They learn the proper geometric definitions, experience direct...
Lesson Plan
Curated OER

Survey and Tally

For Teachers 2nd
Second graders view a model of a survey and tally.   In this survey and tally lesson, 2nd graders decide on questions for a survey.  Students conduct the survey and tally their results. Students create a tally chart....
Lesson Plan
Curated OER

Estimation and Your TV Diet

For Teachers 3rd - 4th
Students develop estimation skills by using real life situations. In this estimation instructional activity students collect data about their television watching habits. They make hypothesis about the number of hours they...
Lesson Plan
Curated OER

Pancakes, Anyone?

For Teachers 1st
First graders explore data collecting and graphing. In this data collecting and graping lesson, 1st graders watch a video about monster who sells pancakes. Students make a graph to record the most popular pancake. Students also play...
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...