Using Google Docs spreadsheet was fairly easy for me as I have used excel a lot over the years. What I found to be difficult was when trying to filter out the above average students to graph, the graph would include all students if the above average students were hid. I then made a new sheet and deleted the other students so my chart would work. It did not take me very long to do the assignment so that was nice.
As for an analysis of the data, almost every student who was below average did better on their last test than they did on test 6. Many of the students also did better on every test than they did the test before from test 6 to 10. This is what you would expect as the students have a better idea as to what the test format will look like and they could have a better grasp about what information the teacher may place on the tests. As an instructor I would be pleased that the students improved, but I would ask these students what they did differently to gain a better idea as to why they improved. This will help me know what student habits help them so I can try to help them not be below average in the class in test scores. I would really concentrate on the students who had a small improvement from test to test because their improvement was smaller than their fellow classmates. These students would be Walter and Queen. I would talk to Katherine as well to see why her test scores very so much from test to test. Once I understood how the students learned best I would try to teach my classes towards those students a little more to try and help them in the everyday class topics, which will help them prepare for future tests.
http://spreadsheets.google.com/ccc?key=0ArCsEZq1EAp4dENpVVNXeXQ5czdjVWViSVpaVHNNRXc&hl=en
Yes, the concept of filtering is a little weak! But, there are some simple ways around that, thank goodness. Nice job of embedding and analyzing.
ReplyDelete