Ed Tech-Spread Sheet Assignment

By looking at the average test scores of both the overall group and below average group, scores progressively went up by test. Because we were only looking at the later half of the tests administered (Test 6-Test 10), it could help to explain why students would have possibly gotten better or shown more distinct improvements. As a teacher, I think this is a trend we would hope to see in test scores from our students-improvements as the year/lesson/unit goes along.
We were asked to "filter out" those students who scored above the average of 191.92, and that meant that out of the 26 students, 14 students were filtered out (only 12 students scored below the average). Of those in the below average groups, there were only 3 students (Katherine Hepburn, Jason Lee, and Walter Scott) whose scores fluctuated between test. The rest of the students had scores that progressively increased over the course of the last have of tests administered.
Student averages fluctuated and there was a range of averages across the board, however, as a teacher, if these were the results I got, I think that I would be pleased that there are students (despite scoring below the average) that are making steady improvements with each lesson/test. By looking at averages we are able to see (quantitatively) which of our students may be struggling, in what areas they are struggling, and get a feel for what the overall average of our class is understanding, learning, and achieving based on tests that are being administered. Also, as I mentioned before, by looking at trends and seeing improvements is a great way for we as teachers to see if our students are making improvements and if not, it's a great tool for us to take a step back and see how we can help our students.