Transform the way teachers plan lessons. Transform the way you read. Tell us what you think about improving LessonPlansPage.com by simply answering our poll and enter to win one of 10 Amazon Kindles!

This one involves creating M&M; Graphs and Spreadsheets on a computer

Rate This:
3944 1
Thanks!
An error occurred!

Subject(s): Multi-Disciplinary, Math Grades(s): Grades 6-7, Grades 2-3, Grades 4-5

Title – M & M GRAPHS

By – Judy Leathers

Subject – Math, Computers

Grade Level – 3-6

INTRODUCTION:

I used this as an introductory lesson on creating spreadsheets and graphs with 4th graders as a collaborative project with the classroom teachers for a math unit. The lesson was done in the Technology/Computer Lab and students were allowed 2 (35 min.) class periods to complete the project. Printed graphs were displayed on the math teacher’s hallway bulletin board.

THE PROCESS:

Students are given a handful of plain M & M’s in a sealed plastic bag and asked to estimate (guess) how many of each color they have. Estimates are recorded on a sheet, noting how many of each color. To make it easier for students to transfer information to a spreadsheet/graph, have them record guesses in colored markers which correspond to the colors of the M & M’s.

Students set up a spreadsheet with columns/row labeled “Estimate” and “Actual”. Then they record their guesses in the “Estimate” column, count the actual number of that particular color M & M, and record the number in the “Actual” column. As each color is counted and recorded, have the students change the text color to correspond to the color of the M & M’s. It makes for a colorful and easy-to-understand graph.

The students then convert the spreadsheet into a bar graph, give it a title, transfer the graph to a new word processing document, and write about the steps in creating the graph.

EVALUATION:

Students are evaluated on the accuracy of the graph and the written report they give on the steps used to create the graph.

E-Mail

Judy

!

Print Friendly
Rate:
3944 1
Thanks!
An error occurred!

Leave a Comment

Your email address will not be published. Required fields are marked *

To comment, click below to log in.

*