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 plan on line plots.
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
What's Up With My Class
Students collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
Curated OER
Farm Stories, Animal Webbing, Favorite Farm Animal Graph
Students brainstorm animals they would expect to see on a farm. They save these on a Kidspiration web. Students watch or read a farm story. They discuss the characters. Students vote for their favorite farm animal and crate a graph using...
Curated OER
Apple Graph
Students sample three types of apples. They choose their favorite apple. They create a graph, charting the favorite apples of their classmates. They answer a series of questions.
Illustrative Mathematics
Identifying Quadratic Functions
Put your high schoolers to the test and see how well they know their quadratic functions. With excellent thought-provoking questions, learners use what they know about creating quadratic equations based off different pieces of...
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...
Curated OER
Polar Bears in Peril - Climate Change Culprit?
High schoolers explore the changes in sea ice over several years. In this life science lesson plan, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
North Haven Middle School
Environmental Expert Presentation
Individuals or groups select an environmental issue, then spend time researching and creating a presentation to share in class. By allowing learners to choose the issue that matters most to them, you will motivate them to do excellent...
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
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. For 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
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Curated OER
Graphing Weather
Students make a graph. In this weather lesson, students fill in a KWL chart about different types of weather. Students watch a PowerPoint presentation about weather and natural disasters and where these types of weather are common....
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 instructional...
Curated OER
All Choked Up By Smoking Statistics
Scholars use the article "More College Students Are Smoking, Study Says" as a springboard for discussion on the reasons why people smoke cigarettes. They investigate different methods of graphing statistics by using the data provided in...
Curated OER
Curious Clouds
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Curated OER
Time Management
Learners record their daily activities and graph the results using the educational software program called Inspiration. This instructional activity is intended for the upper-elementary classroom and includes resource links and activity...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Curated OER
What Goes Up Must Come Down!!
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Curated OER
Microsoft Office Excel
Students use Microsoft Office Excel. For this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Curated OER
Balloon Graphing
Fourth graders explore data, charts and graphs. They create graphs using titles, labels, axes, intervals, and scale correctly. Students enter their data into Excel and create a graph.