Have you ever needed to assess your students quickly to see if they are understanding concepts or skills? Today, while my students were reading an online article, I created a mini, four question assessment on Body Organization in Google Docs. I created a Google Form with two multiple choice questions, two fill in the blank questions, and a place for the
Making the Google Form was easy. Even easier was having the responses from a quiz graded in the spreadsheet. I had the student responses appear as a summary in a spreadsheet. To create questions, just right-click on the column heading (where the question appears) and a drop-down will appear like the one to the right. Click on Conditional formatting and another window will pop-up like the one below.
Type your answer in the block next to Text contains. In this case, you can see in the Conditional formatting box, I typed in the answer, cell. I checked the box beside background and this caused any student's response of cell to be highlighted in green. The green helped me to identify the number of correct responses per student.
As you can see to the left, I have an Excel document that is easy to read and score. I made the quiz as a Google Form and formatted the response sheet in less than 10 minutes, and I was able to pull small groups for remediation before the class period was over. With the mounting stacks of work I have to grade, having an assessment graded as soon as the form was submitted allows me more time to plan for my students and relieves me of the task of grading papers.