I thought the exercise with Google Spreadsheets was a great way to compare and familiarize myself with a program similar to Excel. Analyzing student data from a slightly different angle forced me to reevaluate my perspective on their results. For example, by isolating and comparing the test results from students who fell below the class average (for tests 6 through 10), I was able to clearly determine the test scores showed a general increase in their trends. I could also observe in the classroom how and why these students were able to accomplish this success, and focus on the teaching style that had allowed them to improve. It also might help to boost their confidence by acknowledging their success shown in these trends. They might even learn to appreciate how graphs are used to extrapolate useful information, especially as it pertains to them.
I took the analysis a step further and compared only tests 6 and 10 for each student in this group. This graph illustrates two pieces of information, 1) it shows improvement by comparison of the two tests for each student and, 2) the area between the lines representing the two tests visually proves that every student was able to achieve better test scores on their last test. Although these students tested below average for the class, it is more important to see that they are learning and improving their skills.
To see student data click on the link below.
spectacular!
ReplyDeleteYou really pushed this project to the next level.
Since the theme/style of your blog is somewhat narrow, it is difficult to modify the frame size of the data and graph. You may be able to Edit the HTML and modify the 'width' in there --- but that's all I can think of.