Analyzing Student Data in a Spreadsheet

I have used spreadsheets for school and business, yet I found this assignment to be educational.  I was not familiar with creating a spreadsheet with Google Docs.  All of my experience has been with Excel.  I admit that I enjoyed using Google Docs to create this spreadsheet and found it to be a little more user friendly than Excel.  I have included a link to my spreadsheet here.

I think this can be a very handy tool in analyzing student growth in the classroom.  It allows you to clearly see where progress is or is not occurring.  As a teacher I would be pleased overall with the results this spreadsheet shows.  Everyone passed the test and all but one student showed improvement from pre-test to post-test. The average test score improved from 46% to 91%.  However, I see room for improvement.  The student who did not show improvement dropped a grade level from A to B from pre-test to post-test.  I would probably examine why this occurred.  Also, initially I was concerned that there were two students that scored Cs on the post-test.  That concern quickly faded when I noticed their pre-test scores were two of the lowest and were not passing scores.  That is incredible progress.  I can clearly see how spreadsheets can be useful for analyzing data for a teacher.