Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Curated OER
M&M Graphing
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
Curated OER
Sweet Data
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Curated OER
Graphs! Graphs! Graphs!
Young scholars 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
Fruit Loop Graphing
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
Curated OER
Graphing My Path to Success
Seventh graders examine their school performance through self-assessment of strengths and weaknesses. They construct a line graph, plotting all courses and achievements. Students use graph paper and colored pencils for each activity. If...
Space Awareness
The Climate in Numbers and Graphs
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
Curated OER
Graphing Favorite Fruit
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
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
Level III: Technology Integration
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create the graph are...
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.
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson plan, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Apple Adjectives
Study different apple varieties and use appropriate adjectives to describe them. Learners alphabetize both the apple names and the adjectives before creating spreadsheet, bar, and pie graphs. A mix of language arts, technology, and math!
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
Using Computers to Produce Spreadsheets and Bar Graphs
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Curated OER
Line Graphs and Commercial Costs
Students investigate line graphs. In this middle school mathematics lesson, students compare and contrast different types of graphs and create line graphs based on the data provided.
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...
Museum of Tolerance
Why is This True?
Are wages based on race? On gender? Class members research wages for workers according to race and gender, create graphs and charts of their data, and compute differences by percentages. They then share their findings with adults and...
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
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
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
Graphing Data on Ellis Island
Third graders use data to make a bar graph. In this graphing and social studies lesson plan, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.