Wednesday, October 21, 2009

Spready McSpreadsheet

http://spreadsheets.google.com/ccc?key=0AvFKBwQM7xNqdGhScnlXSXo1ZWZManB1akdlSXlkTlE&hl=en#

For this assignment I averaged the scores of the student on tests 6-10. I then found the standard deviation for each test. After that I found the average for the students who scored above the class average and created a graph representing the growth from test 6-10. The graph showed that for every test the scores of those who were scoring above the class average where growing. The growth was fairly constant with a little bit of a spike in the end. This graph shows that the teacher was doing a good job at reaching the students who were already high achievers. Those students continued to increase their scores over each of the last 5 tests. This graph doesn't show us who those individual students are, just that the average score of students scoring above the average continually grew over the course of the last 5 tests.

No comments:

Post a Comment