Analyzing Student Data in a Spreadsheet

Well, hopefully I did this right, lol. If I did, it wasn't too difficult...after all is said and done that is. I of course had anxiety while doing it. I don't know why I let technology give me anxiety because once I learn something its not so hard the next time. I guess I always go into it thinking its going to take a long time, which sometimes it does, and that I "can't" do it. Well...I have proven to myself that i can:} Feels good!

My analysis of the information, from a teachers perspective is that, even though these students were under the overall average their scores consistently went up with the exception of Katherine. Initially, her score soared from test 6 to test 7. Does this mean that for her test 7 was too easy? Was the test set up differently so that her understand was easier? Although in test 8 her score plummeted again, so does this mean that test 7 was a fluke? Or, was test 8 too easy? Was there some sort of environmental issues going on her life such as family problems or was she ill or distracted? Or maybe this would be a clue that she misunderstood or even didn't get a concept that was taught. These would be good questions the teacher would need to find out, in order to better help this student. My initial thought would be that its probably an environmental issue since all of the other students' scores consistently went up and also after test 8 Katherine's did as well.This would be excellent to use to for not only evaluating the students trend in achievement but also this could help evaluate the effectiveness of the teacher.