Spread Sheet Assignment #4

On the master spread sheet you can see the chart displays the last 5 test scores for a class.  The chart breaks down the scores in 3 different ways: Vertically you can see the average test score per test for the entire classroom and also see the average of the 5 tests.  Horizontally you can see the average of each individual students test scores and the average over the last 5 tests, Lastly, you can see the mean, median, mode of the entire class.  These results could be helpful when conducting a review of the progress the class is making as a whole and allow the teacher to analyze which students are having a more difficult time compared the the class average.

The next chart is the students that are below the class average.  I have made 3 separate analysis to compare the class data: Students below average, students above average, and whole class average.  By breaking down the class even more, it allows me to analyze their results in more depth.  For example, if each test were out of 250 points, I could conclude that as a whole class my students were only averaging 76% which means I am not doing something right as a teacher.  However, if you look at the next slide titled "chart", you could see that the kids that are below the class average are all progressively doing better as the year went on implying that they are starting to understand the material better and/or my teaching style is congruent to their needs.

This type of spreadsheet is limited to only what your data will allow you to do, thus, the more data you have, the more analyzing you can do.  The graphs are a great way to visually see the trends in the classroom, where as the raw numbers and averages speak for them selves and allow you to get at the heart of the matter.