Spreadsheet data analyzing

The purpose of this project was to identify trends in student test scores over a period of 5 tests.  Raw data for the entire class was given via spreadsheet.  The data represented individual student test scores on 10 tests.  For this assingment we were asked to only evaluate the student's scores on the second half of the semester or tests 6 through 10.  After deleting tests 1 through 5, I averaged each student's 5 remaining test score (tests 6-10).  I then caculated a class average by averaging scores on tests 6-10 for all students combined.  The class average was 192 points.  The assingment then asked us to only evaluate the information for those students who fell below the class average.  I then deleted the student's who were above the class average and analyzed the remaining information.  I found that most students improved on their test scores with each new test.  So, the majority of students did their best on test 10 and their worst on test 6 with a gradual successive increase in between.  I found one student, Katherine, who did not follow this pattern of improvement. She improved from test 6 to test 7, but then did poorly on test 8 followed by again improving on test 9 and 10.  This type of spreadsheet assingment would be a useful tool in the classroom for analyzing grades, test scores and trends in student acheivement.