
Yes Spreadsheets really are remarkable. I say that because the project I reviewed could not have been done without the concept of spreadsheets and certainly the advent of spreadsheets for personal computers lends unimaginable power and numerous options to their use. The project was named “Graphing Our Throw Away Materials” and it is directed at 6th grade science classes who are studying conservation by looking at the amount of trash generated on a daily basis. The teacher had her classes do a “Throw Away Journal,” collecting data on the type and number of pieces of various materials that were being thrown away in their own homes. Once data was collected the students entered the data in spreadsheets and did an analysis of it using basic charts and statistical analysis. Finally they attempted to judge the accuracy of their conclusions relative to other classes and outside sources. The “main message was that there is a great deal we throw away.”
This 6th grade science project is a brilliant start on an 8th grade data analysis project in mathematics. The lesson would only need to be adapted in two ways. The first adjustment to be made is the actual measurement data that is being gathered. I would want to collect the data using a volume (cubic ft.) or weight measurement. Weight is probably more practical but in either case you are able to draw a broader set of statistical conclusions. By piece, as done in this project, compares equally a one pint plastic bottle with a two gallon plastic bleach bottle. Volume takes away much of that relativity (but not all).
The second change is not really a change but takes the project to another level. I would then ask the question, how can the students impact the results? We would then design an action plan for our homes and once implemented, students would go back and collect the data again. Now students can really contemplate the influence individual families can have on the big picture. From the mathematics point of view we now have volume data before and after implementation of an action plan and we can do an analysis using high level statistics such as confidence intervals, correlations, quartiles, trends and from that draw more in-depth conclusions.
Integrating math and science in this way is terrific and I applaud Ms. Wiedenfeld’s efforts. It was a job well done.
This 6th grade science project is a brilliant start on an 8th grade data analysis project in mathematics. The lesson would only need to be adapted in two ways. The first adjustment to be made is the actual measurement data that is being gathered. I would want to collect the data using a volume (cubic ft.) or weight measurement. Weight is probably more practical but in either case you are able to draw a broader set of statistical conclusions. By piece, as done in this project, compares equally a one pint plastic bottle with a two gallon plastic bleach bottle. Volume takes away much of that relativity (but not all).
The second change is not really a change but takes the project to another level. I would then ask the question, how can the students impact the results? We would then design an action plan for our homes and once implemented, students would go back and collect the data again. Now students can really contemplate the influence individual families can have on the big picture. From the mathematics point of view we now have volume data before and after implementation of an action plan and we can do an analysis using high level statistics such as confidence intervals, correlations, quartiles, trends and from that draw more in-depth conclusions.
Integrating math and science in this way is terrific and I applaud Ms. Wiedenfeld’s efforts. It was a job well done.
