Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
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
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
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Curated OER
Favorite Food
Students are given three choices of food. They then decide on their favorite and predict what the class's favorite food will be. After the teacher enters the data into the computer, students gather around the computer to view the...
Curated OER
Excel Lesson
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Curated OER
Creating Circle Graphs with Microsoft Excel
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
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
Using Spreadsheets and Graphs
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Curated OER
Using Averages to Create Graphs Through Excel
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
The Candy Color Caper
Young scholars explore the concept of probability. They calculate the probability of an event happening and graph their results. Students determine the probability of winning a sweepstakes. They construct a bar graph to represent all the...
Curated OER
Do You Measure Up?
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. In this data analysis instructional activity, students search for statistics on the health effects of smoking and place the information into charts. Students create these...
Curated OER
Reading Graphs
Students read graphs and charts to interpret results. In this algebra lesson, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Curated OER
Using Fractions to Represent M&M Colors
Students investigate the concept of fraction and tangible application. In this algebra instructional activity, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the numerator...
Teach Engineering
Air Pollution in the Pacific Northwest
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
Curated OER
Our Favorite Season Lesson Plan
Fifth graders complete a survey about their favorite season of the year. Using Excel, they create a graph using the chart wizard and copy it into Microsoft Word. They explore the relationship between the survey and the bar graph.
Curated OER
Enhancing Writing Through Technology
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
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...
Curated OER
Scientific Method and Graphing
Seventh graders use the scientific method to determine how many seeds are in a watermelon.
Curated OER
Toy Dissection Graph
Students explore simple machines and how they are made. They examine the parts of the simple machine and collect information about its parts. Using Excel, students create circle and bar graphs from the collected data.
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.