Using autoCrat to Pull Free Responses from a Google Form
One of the best features of autoCrat for Google Sheets is that it works on the spreadsheets generated by a Google Form.
Many teachers use Google Forms to create quizzes and tests. It is a fantastic way to give an online quiz or test. But, one problem with Forms is the way that long free responses are handled. Since all Form responses go into a spreadsheet, a free response answer is crammed into a tiny spreadsheet cell, even if it is a page worth of text! This makes it almost impossible to grade free response questions from a Form.
Luckily, autoCrat comes to the rescue. You can use autoCrat to pull the free responses into separate Google Docs labeled by student name and then print or grade them electronically.
1. Create and administer your Google Form to students.
2. Create a Doc template with the tags <<student_name>> and <<free_response_1>> (you can add a free_response_2, 3, 4, etc. based on the number of free response questions you have)
3. After all responses have been collected, navigate to the Response spreadsheet.
4. Start up autoCrat. If you haven't installed autoCrat, access the Add-ons market and add it. Tutorial below if you need it:
5. Start a new merge job and choose the Doc template you made.
6. Map the <<student_name>> and <<free_response_1>> to the appropriate Google Form question.
8. Run the merge job!
Now you will find a folder in your Drive with a separate Google Doc for each student with his name and free responses!
To follow this up, use Flubaroo to grade the closed response questions.
Many teachers use Google Forms to create quizzes and tests. It is a fantastic way to give an online quiz or test. But, one problem with Forms is the way that long free responses are handled. Since all Form responses go into a spreadsheet, a free response answer is crammed into a tiny spreadsheet cell, even if it is a page worth of text! This makes it almost impossible to grade free response questions from a Form.
Luckily, autoCrat comes to the rescue. You can use autoCrat to pull the free responses into separate Google Docs labeled by student name and then print or grade them electronically.
Here's how:
1. Create and administer your Google Form to students.
2. Create a Doc template with the tags <<student_name>> and <<free_response_1>> (you can add a free_response_2, 3, 4, etc. based on the number of free response questions you have)
3. After all responses have been collected, navigate to the Response spreadsheet.
4. Start up autoCrat. If you haven't installed autoCrat, access the Add-ons market and add it. Tutorial below if you need it:
5. Start a new merge job and choose the Doc template you made.
6. Map the <<student_name>> and <<free_response_1>> to the appropriate Google Form question.
7. Choose the correct file naming convention as shown.
Now you will find a folder in your Drive with a separate Google Doc for each student with his name and free responses!
To follow this up, use Flubaroo to grade the closed response questions.
Comments
Post a Comment