Monday, September 13, 2010

Analyzing Student Data in a Spreadsheet

At first I had a difficult time with this activity. After playing around with it for a while I finally became efficient using Google Spreadsheet. Once I got going with it the activity was pretty easy. I did have a difficult time embedding it at first but I watched Tony's video and after that it was pretty easy. I found Google Spreadsheet way easier to use than Excel. I always had a really difficult time getting anything completed with Excel, but Spreadsheet was easy to pick up and once I did, worked really well for me.

As far as my data is concerned, I analyzed a couple of different things. First, I determined each student's test average, and the average for each different test for the class as a whole. All of the analysis is within the sheets. I also analyzed the mean, median, and mode of the below class average students, as well as for the entire class. I also graphed the below average students which is another way to effectively analyze the data. The data is present in a visual representation that is very easy to compare numbers with others. One feature that I really like about Google Spreadsheet is that when you click on one of the bars in the graph it also gives the numerical value.

Here is the link to my graph and it is embedded below.


1 comment:

  1. Thorough reflection. Everything looks great, except the bar chart is quite noisy and difficult to interpret. Might want to consider a line chart to study the trends ...

    ReplyDelete