PBL Pathways
Students and Teachers 2
Examine trends in student-to-teacher ratios over time. Building from the first task in the two-part series, classes now explore the pattern of student-to-teacher ratios using a non-linear function. After trying to connect the pattern to...
Howard Hughes Medical Institute
Gorongosa: Scientific Inquiry and Data Analysis
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Curated OER
Exploring Graphs
Learners are introduced to connecting graphing in a coordinate plane to making scatterplots on a graphing calculator. Working in pairs, they connect points plotted to make a sailboat and complete questions on a worksheet as well as plot...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
Graphing With Paper and Computers
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Curated OER
Get the Picture with Graphs
Fifth graders examine line, bar and circle graphs in the newspaper and on the Internet. They complete sketches of graphs with an emphasis on selecting the best model to depict the data collected.
Curated OER
Hygiene Potato Graphs
Fifth graders discuss the importance of proper hygiene. After watching their teacher peel potatoes, they discuss why she was wearing rubber gloves. They demonstrate how to wash their hands properly and why one should never touch...
Curated OER
Students Favorites
Students complete activities using a frequency table and construct a pie graph for the data. In this frequency table lesson, students complete a survey to find data for a frequency table. Students use the given link to make a pie graph...
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Curated OER
Beginning Graphs in MS Excel
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Curated OER
The Viewing Tube
Looking for an excellent lesson plan that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a...
Curated OER
Historical Pollution in the Hudson: Part 2
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Utah Education Network (UEN)
The Human Line Plot
Learners collect data and use charts and line plots to graph the data. Some excellent worksheets and activities are embedded in this fine lesson on line plots.
Benjamin Franklin High School
Saxon Math: Algebra 2 (Section 4)
This fourth of twelve units in a series continues the investigation of functions through equations and inequalities. However, the modular nature of the lessons in the section make this an excellent resource for any curriculum covering...
Curated OER
Graphing Surveys and Analyzing Data
Students analyze data and graph the results of their surveys. In this statistics lesson, students create graphs using excel to make graphs to be able to better observe their data. They conclude how great we as unique individuals.
Curated OER
Relations and Graphs
Here is a simple, yet clever lesson on how to teach the important concepts of greater than, less than, and equal to. Pupils write their names down on grid paper - one letter per box. They compare their names and find a name that is...
Curated OER
This is the Way We Go To School
Second graders create and utilize a graph using the Excel computer program. They gather data regarding how the students get to school, tally the numbers for the class, and create a bar graph on paper and using Excel.
Curated OER
Graphs! Graphs! Graphs!
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson plan.
Granite School District
7th Grade CCSS Math Vocabulary Word List
Address key vocabulary in the seventh grade Common Core Math Standards with this comprehensive list. A series of word cards is also provided that supports each term with images and examples, making this an excellent tool for teaching the...
Curated OER
Determining the Density of a Liquid
Students find the density of diet soda and regular soda. In this density lesson plan, students measure the mass of a graduated cylinder with 10 different volumes of each soda. They find the mass of the liquid alone and use the volume to...
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. In this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
Curated OER
Data Lesson Vital Information
Young scholars prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.