Curated OER
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Curated OER
Survey Says...
Young learners create and implement a school-wide survey about student body favorites! Learners record and analyze the data on a bar graph, picture graph, and line graph, and then display the data. Then, wrap it all up with a celebration...
Curated OER
Temperature High and Lows
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Curated OER
M & Ms in a Bag
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Curated OER
Venn Diagram and UK Basketball
Students analyze data and make inferences. In this algebra lesson, students collect and analyze data as they apply it to the real world.
Curated OER
Time Management
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
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
Halloween Graphitti
Students complete multi-curricular activities in a Halloween themed instructional activity. In this Halloween instructional activity, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf...
Curated OER
Jellybean Graphs
Second graders predict and graph data based on the color of jelly beans they think are in a handful. In this prediction lesson plan, 2nd graders will predict how many of each color jellybean are in a handful. Then they graph these...
Curated OER
Math: Football Fever Fun
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
Curated OER
Graphing Your Favorite Pizza Topping
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Curated OER
Which Graph is best?
Students use commercial software to organize and visually display data to draw conclusions; students use graphing software to create several types of graphs illustrating the number of each color of M&M's in one bag.
Willow Tree
Linear Relationships
There's just something special about lines in algebra. Introduce your classes to linear equations by analyzing the linear relationship. Young mathematicians use input/output pairs to determine the slope and the slope-intercept formula to...
Curated OER
Counting Coins
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Curated OER
Graphs Abound
Students create a survey for their classmates to collect data on their favorite foods, eye color, pets or other categorical data. They compile the data from the survey in a table and then make a bar graph of each category using a web tool.
Curated OER
Elementary Statistics in Life
Students examine newspapers for graphs. They collect and sort data that is of interest to them. They enter data into a database and make comparisons using the information.
Curated OER
Graphic Favorite Breakfast Foods
Second graders graph data based on a class survey of their favorite breakfast foods. In this graphing lesson plan, 2nd graders take a class survey of their favorite breakfast foods. Then they take that data and put it into a computer...
Curated OER
Gummy Bear Math
First graders predict, collect data, and create a graph based on gummy bear colors they are given. In this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Curated OER
M & M Madness
Students work with the mathematics unit of collection, organization, and presentation of data. In this math and technology lesson plan, students use Valentine M & M’s and The Graph Club to sort and graph the various colored M & M’s.
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...
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
Fly Away With Averages
Students discover the process of finding the mean, median, and mode. Through guided practice and problem solving activities, they use a computer program to input data and create a graph. Graph data is used to calculate the mean,...
Curated OER
Fast Food Survey Using Bar Graphs
Second graders conduct survey and sort data according to categories, construct bar graph with intervals of 1, and write a few sentences about their graphs.