Self Grading Form

The act of creating a form in Google Drive is pretty cool as I demonstrated in a previous activity. The next step is to create a form (maybe a quiz or test or survey) and then grade the form using the Self Grading spreadsheet option within Google Drive. At first I thought this activity would be easy, but the hardest part was creating good questions that could be graded using a simple Self Grading form.

The first thing I did was create a quiz about rocks. There were 8 multiple-choice questions to answer.  Somehow on my summary spreadsheet there ended up being 9 questions with one column left blank. To fix this problem I put in N/A as the answer and filled in the answer for everyone so that all could get credit. Click here to see my Rock Quiz

After the quiz was sent out to my participants, I needed to create an answer key for the quiz. When I submitted the correct answers by taking the quiz myself, I could then put the formula together in order to mark the participant’s answers right or wrong. The formula part of the form was fairly easy after I watched the YouTube how-to video. I really like creating spreadsheets with short cuts and formulas because it makes things easier if they are automated from the start. Once the participants started answering the quiz questions, I was able to see if my formulas were done correctly. How cool to see the results of the quiz without having to manually grade anything. Click here to see the Grading Results Spreadsheet.

I think this Self Graded Form enables teachers to utilize digital media in a way that not only makes things straightforward, but easy to grade and record. When teachers can give quizzes like this one, students are able to quickly answer the questions and teachers are able to grade the form without spending a great deal of time outside of class. This particular activity complies with the ISTE.NETS.T standard number two, Design and Develop Digital-Age Learning Experiences and Assessments. The activity provides an example of how teachers can use digital media to assess learning through other measures than the traditional pencil and paper test.