Wednesday, May 29, 2013

Using Google Forms to Create Self-grading Test

This week we looked at how to use Google Forms to create self-grading tests. Plus how Google Forms can be used to help schools meet some of the Common Core State Standards (CCSS.)

I found it most helpful to have a sample to refer to help me with figuring out the formulas. Additionally, I really like the link to "Self-Grading Multiple Choice Tests with Google Docs." I found it very helpful to have a step-by-step guide with had a link to a video, plus had visuals embedded in the article. Once I figured out my test questions, which I think was the hardest part, it was easy to set up the test and just follow along with Google. The program will guide you along in setting up the test and the test response spreadsheet.

Here is a link to my test:
https://docs.google.com/forms/d/1uydH_Jv8QCxBQ0OYQvgTHOEw9sgWhYmIWyIs4n1wRXk/viewform

And a link to my response sheet:
https://docs.google.com/spreadsheet/ccc?key=0AmgfiCUYrsGfdDBjV3kxaWxjTG01UHd2bjE4ZE5aVVE#gid=0

I can see how a teacher can use Google Forms to collect student information at the beginning of the school year. As a parent it would be easier to fill out a form for the teacher and e-mail it in, and as a teacher it would be easier to collect information from parents in one e-mail plus easier to store an e-mail instead of a piece of paper.

The students could use Google Forms to conduct research and have an easy way to organize and analyze the data they collected. This could be used for science, psychology, or any type of class project. The students can then use the app to create graphs of the results. It was very user friendly. All of these activities will fulfill CCSS.

1 comment:

  1. Well done!

    You may want to number test questions for ease in discussion and analysis later. :-)

    ReplyDelete