8 Google Forms Formative Assessment Tips
If you use Google Forms for formative assessment quizzes here are some tips for managing the resulting spreadsheet. When organizing data it is important that your data match. Trying to sort data by student name can be sketchy when students type in their own name. They might use “Robert” one day and “Bob” another. They may simply misspell their name. While I do not need the students ID number it is harder for students to get creative in how they fill it out. Rather than ask for “name” make 2 questions. From the edit screen of the Google Form you want to “View Responses” in the toolbar in order to open the spreadsheet of data. After creating your Google Form go to the live form and take the quiz. By default the first row of the spreadsheet is frozen. On the left hand side, between rows 1 and 2, hover over the freeze bar. Hovering over the column indicators will reveal a small drop down arrow. Sort each question. You probably want to sort by multiple columns. Like this: Like Loading...
• Formative assessment
• Formative Assessment with Technology
• Quiz Tools