Performance Conversation To-Do List: A Google Forms solution

In a previous post I explained how we used the Performance Conversation (affectionately referred to as the Green Sheet) for the bulk of our work submissions and assessments. One of the most significant benefits of this forum that focuses on an oft-times extended conversation with the student about the assignment is that it creates an elevated desire for students to revise their work.

And while this is precisely what we want for a multitude of reasons, it does create a not-so-insignificant issue: keeping track of who needs what re-assessed.

Mr. M's Student To-Do List

Yes, from your Google Drive page you can see which students have recently updated their Green Sheets, but it gives you no indication of what precisely they updated. This is where another Google product can help solve the problem and shift the burden of notification and organization to the student.

Students, of course, do not need to individually notify me if they are submitting an assignment that is submitted on-time since my expectation is that I will be able to open their green sheet and find it hyperlinked and self-assessed. But, if they have been absent, if they need their work reassessed because they've revised, if they need a letter of recommendation, to send an email home, etc., they fill out the questions on the Google form. The form then sends the results to a Google sheet (my Student To-Do List), which I check regularly.

I proceed (usually) in order of submission which is date-stamped on the sheet.

And because the form sends the data to a spreadsheet, I'm able to sort by student name to track frequency of revisions, late work, number of letters of rec., etc.

This has helped me rid my desk of all those maddening scraps of paper and sticky notes that were the bane of my existence. 

Thanks for reading,
Steve