Wednesday, March 15, 2017

Google Forms: Digital Assignment Tracking


You can use a Google Form to easily keep track of the turn-in rate of homework or other student assignments.  Make the first question the name of the assignment for easy sorting.  As the second question, use a multiple choice grid with each row being a student name and each column being a turn-in status.  You can even make it a required question so that you force yourself to never skip a student.

This type of form could also be used to take a quick snapshot of student mastery or progress on a particular skill.  The first question would be used to identify the skill or subject you are assessing.  For the second question, the multiple choice grid, you would use the rows again as student names, but make the columns be progress indicators - struggling, emergent, proficient, mastered, etc.

Make this even better by using the add-on for Sheets called Row Call.  This could put the responses for each unique topic or subject into their own tab in the spreadsheet for a more organized view of the responses.

I always mark the option to provide a link to submit another response, so after I submit, I’m ready for the next assignment or topic.

Thank you to Kyra Bowers (@KyraBowers) for sharing this idea with me!

What to ask?
  • Assignment name, Topic, or Skill
  • Multiple Choice Grid with student names as rows and assessment criteria as the columns. 
If you'd like to copy a sample form to make it your own - click here

Here is what this form could look like:



No comments:

Post a Comment

Thank you so much for taking the time to leave a comment!

Helping teachers incorporate technology, one tech tip at a time.