Monday, October 18, 2010

Analyzing Student Data in a Spreadsheet

For me, I was still getting used to the tools that Google docs has to offer, and the overall assignment was sort of frustrating to accomplish. It was seemingly tough to execute the tasks that were instructed solely because I was unfamiliar with the program and didn't know how to complete the graph. I realize I just need to play around with the tools and just experiment more and remember to publish my best work for the purposes of the class and the grade.

Student data spreadsheet:
https://spreadsheets.google.com/pub?key=0AtllIov43TQmdHowNUhld2dOaE82REFiakhjdzhad1E&hl=en&output=html












Overall, the statistics of the class looked very similar and the growth of the scores gradually increased over the duration of the tests. After looking at all of the scores from all of the students, it seems that Katherine had a great improvement from test 6 to test 7 and gradually performed better through the other tests. There are some assumptions I can make about why she may have performed the way she did. One, the material that was presented to the class may have influenced her on a more deeper level than the other students so she expressed more interest and wanted to perform better. Second, she may have not done well in the past, and wanted to perform better for the rest of the year and might have received some pep talks to do well.
When it comes to the teacher giving effective direction for the class, I believe he/she did a very good job and is well reflective on the test scores. I haven't obviously seen the lesson plans by the teacher, but whatever this individual was doing, he/she was very mindful of the students' progress and made necessary adjustments to keep those scores increasing!

1 comment:

  1. Looks like may have a nice start on spread sheeting, and are now ready to do the next steps:
    1. be sure to make your sheet PUBLIC, as I (or anyone) is not able to view it.
    2. be sure to carefully reread each instruction to ensure you've accomplished all of the criteria. This includes embedding, analyzing the results as if you were the teacher (trends, exceptions, how one might modify their instruction, etc.).

    Joe --- I've linked to other students results (or you can find tons of finished products by looking at the Class Data Sheet). Thanks, B

    ReplyDelete