My experience creating my Google Spreadsheet was mostly positive, probably because I use Excel almost daily. I had a couple of hiccups: 1. My computer wouldn't let me use the shortcut (ctrl+key) commands, because instead of going to the Google menu, it was going to the browser menu. 2. It took a few minutes for me to figure out how to get the labels on the graph axes, but the help file explained it. Unlike when using Excel, Google Spreadsheet didn't make me want to heave my computer out the window...easier & more intuitive.
Getting the raw data into my new spreadsheet was easy...
Getting the calculations & graph to work took a little longer since I had the issues, but they were also very easy to work around....
The analyzed data indicates that most students did better the more tests they took, with the exceptions of Katherine's dramatic spikes & Walter & Queen's nearly level scores. As an instructor, I would: 1. Think about whether I thought they knew the materials & were having trouble with test format or test anxiety. 2. Figure out more ways to assess all students' progress & understanding. 3. Give them extra help to manage the material and the assessment format(s).
Loved your quote of Excel vs G.Sheets :)
ReplyDeleteWill have to share that.
Looks terrific, and thanks for taking the time to analyze the results.