Self-grading forms

Wow. That took some doing! As I have stated before, I struggle with the concepts of spreadsheets and formulas, even though I do work with them from time to time. For some reason, my spatial reasoning just does not click with this format. However, I think I was successful at making a self graded form.
Here is a link to the form.
Here is a link to my spreadsheet.
I found this video to be extremely helpful too!


Whew! Now, all that said and done, I think this is extremely helpful.  Google forms makes it easy, user friendly and all-accessible to create, share and take many different kinds of assessments. Would I use it in a regular classroom setting? I'm not sure. First of all, while I got the hang of the formulas after a while, it is something that I would have to practice often to keep in good form. I also worry about the accessibility of students to one another and the web.  The instructor in the video I watched had a good solution to make students open the assessment in a new window to discourage the chat option in email. This is a good idea, but you still run the risk of web searching. But, I guess with online courses, that is the risk you take. (In my opinion, online tests are much more difficult than face to face ones-even with an open book!) I am interested in using this tool as perhaps a daily or weekly checkup or quiz. Something casual to remind students to stay on top of work and what they need to work on. I would also be in favor of students creating their own assessment and either swapping grading or self-grading. This is a good way to learn more about the program, how formulas work, how to formulate better test questions, how to share and update documents, etc. There are a lot of good things going on here, they may just take a little while to figure out!

NETS T standards associated with this are:
2) Design and develop digital age learning experiences and assessments
3) Model digital age work and learning
4) Promote and model digital citizenship and responsibility

In the paragraph above, I gave several reasons why using self-graded forms are a useful tool for both instructors and students. Instructors have a fast and easy way to assess students from home, paper free. Students learn about creating assessments, taking assessments, implementing formulas, mathematics, document sharing, self-assessment and have a fast and easy way to take quizzes at home in their own time.