Spreadsheets

#1. I chose to view a 4th grade M&M Food for Thought spreadsheet showing relationships by Mr.Ron Huckins. In his project he separates his students into groups of five giving them each a different amount and variety of M&M's. With the M&M's you are to separate them according to color, then record the information each group got form their bag. The students did this on spreadsheets on the computer. They learned to record information according to the number and color of M&M's. Then the students learned how to make a bar/or column graph according to their information. Also with the graphs and information they learned how to make it creative by using colors associated to the colors from the M&M's. Once they recorded all their information they learned how to take the total, average, and percent using different formulas given from Sum, Average, and Percent. Then at the end of the project, he gave the students a chance to analyze there work and come up with a concluding statement.

#2. If i were to adapt this to a junior high level(7th grade), I would have each student do this exercise individually each with their own small pack of M&M's. After recording their inforamtion from the M&M's on an Excel Spreadsheet, i would challenge them to make their data unique and stand out from everyone elses. Such thing like adding graphic images, different font, colors, organization, ect.. Then once they were done with the creative side i would have them record information from two of their peers to place onto their spreadsheet, then find the total of each color, and the sum. After they recived all the information i would direct them to make a pie chart from their information of different colors total, and then a seperate graph of their choose from their information of averages.