My Spreadsheet Project

Above are the spreadsheets and chart I created for this project. The first spreadsheet shows the whole class date for Tests 6 through 10; average test score for each student, average score for each individual test, and the average overall score for the whole class on all tests.

Reflection:

Once I figured it out, I liked using Google Spreadsheets. There were some aspects that were easy for me, and others that challenged me. Eventually, everything made sense and I feel confident that I would be able to use Google Spreadsheets in the future for similar projects and have significantly fewer challenges. I was able to embed it in my blog without trouble though (as far as I can tell). This particular project seemed to have a very practical basis, and I might do something similar in the future.

Analysis of Data:

- With the exception of Katherine and Scott, all students test scores increased from Test 6 through Test 10

- Although some students individually did better on later tests than the class average, the students with averages below the over all class average never had a collective average on any one test that was equal to or higher than the overall class average.

- Some of Katherine's test scores appear to be flukes. Her score on Test 6 was significantly lower than any of her other scores. Her next score shot up, and then they fell again. After that, they leveled out some.

- As the test scores increased over time, we can assume that either something changed in the classroom, or that the design of the lesson allowed the students to build on what they had learned before to improve their scores. Chance are, with further testing, all students would continue to improve.

Here is the chart again, so you can analyze it for yourself . . .



What I Would Do In My Classroom:

If it were my classroom, I would hope that by using what students have already learned I would be able to continue to build on that so their test scores would continue to improve, which would in turn increase their their confidence levels allowing them to do better on future tests and be more receptive to new information. As the teacher I would analyze what students struggled with on earlier to test to determine what problems with understanding the whole class may be having that I need to review for everybody, and how students come to understand that information over time.

If you want to see my date in it's original home, you can go directly to my Google Spreadsheet by clicking here.