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
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
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
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
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
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
Graphing Surveys and Analyzing Data
Students analyze data and graph the results of their surveys. In this statistics lesson plan, 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
Data Lesson Vital Information
Students 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.
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
Class Birthday Graph
Young scholars analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
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...
American Statistical Association
Scatter It! (Using Census Results to Help Predict Melissa’s Height)
Pupils use the provided census data to guess the future height of a child. They organize and plot the data, solve for the line of best fit, and determine the likely height and range for a specific age.
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
Water Chestnut Graphing Activity
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
Does cloud type affect rainfall?
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Students compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
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
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
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
Time Management
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson plan is intended for the upper-elementary classroom and includes resource links and activity extensions.
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
Making Logic Out of Madness
Tenth graders organize and interpret data from a student health program. In this physical education lesson, 10th graders use a body composition analyzer over 8 weeks to determine the validity of a student health program. ...
Curated OER
Graph Related Linear Inequalities
Students explore the concept of linear inequalities. In this linear inequality lesson plan, students graph linear inequalities using Microsoft Excel.