I was already a big fan of spreadsheets and the tool that they can be. With a future in education, the Forms function of the spreadsheets becomes an even BETTER tool. It was cool to me to see that I could build the survey, send emails, and have people in 2 different states fill it out. It's very simple to use and easily repeatable. I liked that the atomic learning gave us a bit of a different formula for the self grading than the one we saw in class. It's nice knowing there are multiple ways to put the quiz together (especially if I forget).
With the CCSS, Forms is a great option. Throughout school I had to do a lot of research assignments in which I had to take polls and statistics from classmates and plot the data. It would have been so much easier to have something like Forms to share and obtain data for those projects. Students in school today and tomorrow should have a much easier time doing projects like the ones I had to do, especially as the CCSS are adopted.
Spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0AmOyKnkfSeGPdHRQbGtLanhLLVRyUkN3TEgtVkhxX1E#gid=0
Survey:
https://docs.google.com/forms/d/1TyiEK_VmmU3RL74ZvCuJ9YOiL88NAW2P8Vti48ckQCk/viewform
Yes, I use the formula I do because it was simple and easy for me. I started using the self grading form before the Atomic Learning screencasts were done for Forms. After checking out the Atomic Learning, I like the capability I have to do question analysis - but you are right that it is useful to have different approaches to the formulas. :-)
ReplyDeleteWell done!