Analyzing Student Data in a Spreadsheet

Here is the link to my Spread sheet. 

I liked working with the google docs version of Excel. It runs very much the same was as the excel except that some of the menu's are easier to locate and access. For example the sorting function is located conveniently at the top of the column and automatically expands the selection to the rest of the data so that the data stays together. I also liked how the formulas popped up as you started typing, which allowed you to choose which one you wanted conveniently. Overall this was a great introduction to using the google version of spreadsheets and has me even more convinced that this line of software is the way to go. 

The Chart shows that the students continued to improve from test 6 through test 10.  For the most part the students improved from test to test with a couple students scoring higher on an earlier test. It was also intersting to see that the students who outperformed other students in their class continued to do so throughout the tests. 

What I can conclude is that the teacher isn't spending more time with the lower level students. I don't see much increase in performance the lower the scores, which tells me that the students who need more attention aren't getting it.