Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Lesson Plan
Curated OER

Graphing with the Five Senses

For Teachers 1st - 2nd
Pupils collect data and record it on a bar graph. For this data graphing lesson, each small group of students is assigned to collect data on one of the five senses. They then practice a song that helps them remember the purpose of each...
Lesson Plan
Pennsylvania Department of Education

Eye to Eye

For Teachers Pre-K - 2nd
Students practice the concept of posing mathematical questions regarding themselves and their surroundings. In this eye to eye lesson, students gather data about eye color from their classmates. Students organize their data in order to...
Lesson Plan
Curated OER

Cloudy vs. Clear

For Teachers K - 2nd
Learners analyze line plots. In this weather lesson using real NASA data, students discuss how weather affects the way the Earth is heated by comparing different line plots.
Lesson Plan
Curated OER

Graphing My Path to Success

For Teachers 7th
Seventh graders examine their school performance through self-assessment of strengths and weaknesses. They construct a line graph, plotting all courses and achievements. Students use graph paper and colored pencils for each activity. If...
Lesson Plan
Curated OER

Slavery: Population Growth in Arkansas

For Teachers 8th
Eighth graders examine the number of slaves in Arkansas in each census period from 1820 to 1860. They graph the data using the proper labeling and write a paragraph summarizing the data from each period making comparisons between slave...
Lesson Plan
Curated OER

Re-Presenting Race in the Digital Age

For Teachers 8th - 10th
Teen-aged scientists analyze a graphic organizer of how trash is removed from New York City and then answer standard questions about a graph and a diagram. Resources are mentioned, but there are no links to these resources, so you will...
Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Middle schoolers explore the concept of cell phone plans. In this cell phone plan lesson, students research the cost of cell phones. Middle schoolers compare various cell phone plans and decide on which phone plan is best for them.
Lesson Plan
Curated OER

Graphing Your Favorite Pizza Topping

For Teachers 5th
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Lesson Plan
Curated OER

Froot Loops to the Max - 2

For Teachers 6th - 8th
In this Froot Loops to the max worksheet, students complete and solve 5 problems related to a box of Froot Loops cereal. First, they determine how many of each color is represented in the box of Froot Loops. Then, students determine...
Lesson Plan
Michigan Sea Grant

What's in This Water?

For Teachers 5th - 8th
Pupils investigate the biological and chemical characteristics of water to determine where purple loosestrife occurs. They create data sheets to record water quality tests in several locations and work in groups to conduct the water...
Lesson Plan
Curated OER

Back In The "Old Days"

For Teachers 5th
Fifth graders collect data during their worker interviews while in groups to compile job changes. They analyze the data to determine the categories of changes, patterns/trends of change and future projections. Each group then develops a...
Lesson Plan
Curated OER

Graphing Data

For Teachers 1st
First graders learn how to display data using a bar graph. In this bar graph lesson, 1st graders use data from a t-shirt color survey to make a bar graph. They also make an animal bar graph before interpreting the information.
Lesson Plan
Curated OER

Histograms and Bar Graphs

For Teachers 6th - 8th
Students are introduced to histograms, bar graphs, and the concept of class interval. They use an activity and three discussions with supplemental exercises to help students explore how data can be graphically represented (and...
Lesson Plan
Curated OER

Creating Circle Graphs using Excel

For Teachers 5th
Fifth graders evaluate data from a circle graph that compares time spent on various activities. They use the computer to manipulate their own data as they compare, examine, create and evaluate data using circle graphs.
Lesson Plan
Curated OER

Epidemiology: Graphing and Analyzing Health Data

For Teachers 9th - 12th
Students graph data on fetal and infant mortality rates collected by the Centers for Disease Control and Prevention. They identify trends in the data and propose potential causes for the trends.
Lesson Plan
Curated OER

Line Graphs and Commercial Costs

For Teachers 6th - 8th
Students investigate line graphs.   In this middle school mathematics lesson, students compare and contrast different types of graphs and create line graphs based on the data provided.
Lesson Plan
Curated OER

Interpreting Oceans of Data

For Teachers 6th
Sixth graders analyze the data from a scientific experiment. For this statistics lesson, 6th graders answer questions about some data to show their understanding of the data. They apply the result to future decisions when using data.
Lesson Plan
Curated OER

Graphing Data

For Teachers 1st
First graders explore the concept of graphing. In this data lesson, 1st graders gather information from a class survey and display their findings on a picture graph. Students also practice solving problems that their instructor models.
Lesson Plan
Curated OER

Getting There

For Teachers K - 4th
Pupils practice reading a pictograph. In this data analysis lesson, students collect data and create their own pictograph. A pupils worksheet is included.
Lesson Plan
Curated OER

Growing Plants

For Teachers K - 7th
Students grow plants and track their growth over time. In this growing plants lesson, students plant seedlings and chart their growth in a data analysis activity.
Lesson Plan
Curated OER

Census Statistics and Graphing

For Teachers 7th - 8th
Pupils graphically represent data from the Census.  In this middle school mathematics instructional activity, students investigate the housing characteristics of different tribes of Native Americans and compare them to the average...
Lesson Plan
Curated OER

Which Bag is Which?

For Teachers 7th - 9th
Students explore number sense by completing a statistical analysis game in class. In this data graphing lesson, students utilize visual references such as colored cubes and tiles to map out the results of an experiment outcome such as a...
Lesson Plan
Curated OER

Effects of chemical use in Agriculture

For Teachers 5th - 9th
Students research environmental data to create a bar graph. In this agricultural ecology lesson plan, students research the pros and cons of chemical use in farming. Students debate on passing a law to reduce chemical use.