In a one on one session we brainstormed assigning your feedback a feedback ID. That students MUST respond to. For feedback to be effective, it has to be actionable (Hattie).
To get this ball rolling, we brainstormed this solution.
- Create a Google Form that students respond to feedback in
- The Form has a spot for “Feedback ID”
- The Form connects to a spreadsheet
- In THAT spreadsheet, create a template that allows you to input student feedback. Make sure it prints nice and has a column for feeback ID.
- When giving feedback, duplicate the feedback template and input
FEEDBACK ID,
student name (preferably from drop down),
assignment number or title,
Date (Control ;),
generic feedback from drop down,
Additional feedback,
Required Action
Checkbox - Fill out for each student.
- PRINT feedback from spreadsheet.
- Student use the feedback ID to fill out the Google Form to acknowledge the feedback.
Creating The Unique ID Numbers
In the video I show how I used some spreadsheet magic to generate a bunch of unique ID numbers.
PRINT OUT the unique ID numbers and cross them off as you use them.
3 letters + 3 numbers
Here are the steps
1) Make a list numbers from 1 to 26 in column A
2) In column B put the corresponding letter.
3) VLOOKUP will lookup a number in the table and return the letter.
RANDBETWEEN(1,26) will return a number between 1 and 26.
=VLOOKUP(A1, $A$1:$B, 2) will return the letter that goes along with the number in A1. BUT… we don’t want the number in A1… we want a random number, so we replace the A1 as the lookup, with looking up a random number.
=VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)
So this gives you one random letter. We want 3.
4) Use & to concatenate this same formula 3 times.
=VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)&VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)&VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)
This gives you the 3 random letters.
5) Need a 3 digit number.
Concatenate (&) with a 3 digit number
=VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)&VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)&VLOOKUP(RANDBETWEEN(1,26), $A$1:$B, 2)&RANDBETWEEN(111,999)
6) Drag this formula down a lot of rows… this gives you a lot of random ID numbers.
BUT… are they unique?
In a different column use
=UNIQUE(E2:E)
This ensures no duplicate values.
7) Optional: use WRAPROWS to turn into a table that is easier to print.
Print out the unique IDs and cross them off as you use them!