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
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
Creating Circle Graphs with Microsoft Excel
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
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
Pet Count Excel Graphing
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Curated OER
Is the Rainbow Fair?
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Curated OER
Speed + Graphing = Winners!
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Curated OER
Data Handling
In this data handling instructional activity, students interpret data found in table, graphs and charts. They organize data and draw bar charts. This two-page instructional activity contains 2 multi-step problems.
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
Organizing Data
In this organizing data worksheet, 7th graders solve seven different types of problems related to data. They first identify the type of data as categorical, discrete or continuous from the information given. Then, students use Excel 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
Bunny Cakes and Graphing
Third graders graph and analyze data relating to the book "Bunny Cakes" by Rosemary Wells. They listen to and discuss the book, vote on their favorite cake using Excel computer software, and discuss the results.
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.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
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
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
Students 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
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Curated OER
Valentine Heart Candy
Each student gets a box of candy Valentine hearts. The students open the box and count how many of each colored heart they have in their box. The students use this information to make a bar graph and answer follow-up questions.
Curated OER
Data Analysis Challenge
In this data analysis worksheet, young scholars work with a partner to collect information for a survey. The information is then compiled into a graph. Learners must indicate their survey question, the target audience, predict the...
Curated OER
Polar Bears in Peril - Climate Change Culprit?
Students 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.