Analyzing Student Data in a Spreadsheet

I didn't have a lot of experience with spreadsheets and needless to say that I was a bit intimidated when this task was presented. The tutorials were very helpful. I admit that I had to walk away from my computer a couple of times and come back later with a less frustrated attitude.  My frustrations mainly came from the computer not cooperating.  I had some browser issues on one computer, as I was working on this task from 3 different computers; one mac and two windows based PC's.  I do feel comfortable working on google spreadsheets and creating charts/graphs now.

Overall considering the data from the pre and post test, each student increased their scores except for 1; Joel.  Joel experienced a lower score in his post test.  Considering the other data available Joel also has the least attendance with 8 days compared to all the other students whose attendance were at 9 and 10 days.  Joel is also the oldest student.  He is the only student in 12th grade in this class.  Joel aloso had the highest pretest score.  Considering Joel's attendance, he would have the least exposure to the teachers lessons and class experience, this could be the reason for the lower score, being the only senior in the class could also negatively impact Joel's attitude and possibly his test scores.  Perhaps he feels he should not be in this class.
Considering the formative assessments (1,2 and 3) each student did better on assessment 2 and 3, with the exception of Rut and Lauren.  They did better on assessment 1.
As the classroom instructor I would take Joel aside and see if there were perhaps some other things going on that are impacting his attendance and possibly his feelings about the class and the other students.