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, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
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. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Learners 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 lesson.
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
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson is intended for the upper-elementary classroom and includes resource links and activity extensions.
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...
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
Learners use Microsoft Office Excel. In 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.
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
Curated OER
Graphing
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Curated OER
Bias in Statistics
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Curated OER
How Big Is Your Head?
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Curated OER
Student Costs Data Table
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Curated OER
Rockin' Data
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
Precipitation in Michigan Cities
Third graders investigate the rainfall amounts in four Michigan cities to observe how cities near lakes are affected differently by precipitation than those that are inland. They record the rainfall for the cities over an eight day...
Curated OER
What Can I Afford?
Students explore the concept of cell phone plans. In this cell phone plan instructional activity, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
Teach Engineering
The Energy Problem
Think you can solve the energy problem? You'll first need to know about current energy use. Analyzing a set of circle graphs lets scholars see where energy consumption is the greatest, both by sector and by household use. They develop a...
West Contra Costa Unified School District
Correlation and Line of Best Fit
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation...