Getting students high-quality feedback can be tricky. There are many methods for getting students back information from a rubric, here is one more way.
TemplateTab Plus Template
- Paste roster of students into the first column.
- Design a rubric or other graphic organizer on the 2nd tab.
- Use the TemplateTab menu to run TemplateTab.
- A copy of the rubric or graphic organizer is created per student within the same spreadsheet. (In other words ONE document to manage.)
- Locate each student’s name along the bottom and provide feedback.
- Go back to the TemplateTab menu and run “Create spreadsheets.”
- A new spreadsheet per student is created and linked to on the roster tab.
- Copy and paste those links into the private comments of Google Classroom or wherever students see feedback.
- Optional to use the TemplateTab menu to send the individual spreadsheets to students.
Old school way of doing rubrics is to use the copy machine. Make a stack of the rubrics and circle or mark for each student on the paper and leave comments. Hand the kid the piece of paper. Of course, when you give the kid the paper you no longer have it yourself. If the kid is absent when you spend class time to pass things out, later you have to remember where you put it (for me, ugh my desk is a mess).
If you have your rubric on a spreadsheet that can potentially be better than paper because of all the spreadsheet awesomeness you can do with conditional formatting and formulas. Check out my formulas on my EpicRubric. I’m not a really big fan of this style of rubric, I know people use it so I coded it so it does the math for you. It’s not so uncommon that people ask me for modifications to the rubric. Sorry, I’m unable to make customized variations. Makes perfect sense that you have your own way of displaying the criteria and how to mark it.
In the TemplateTab Plus the 2nd tab allows you to design your rubric any way you want. You start with a blank sheet. Make columns wider, set word wrap, fill with color where it would emphasize information, etc… If you’re adding up points let the spreadsheet do the math for you!
TemplateTab was originally designed to create collaborative documents with your students. In this case, it is just for you. Use the TemplateTab menu to duplicate your rubric for each student.
Notice in the animated GIF that the spreadsheet starts putting the student names along the bottom.
Assess Each Student
A tab was created for each student. Locate the students name along the bottom. You can also use the 4 lines icon in the bottom left hand corner, the “Big Mac.” Using the Big Mac you can easily locate a students name and jump to their tab. Fill out your rubric for each student.
Make a Spreadsheet Per Student
Normally you would do this backwards. Have a document per student and fill them out. This is of course slow because you have to open each one separately. Doing it all in one spreadsheet in the first place is much faster. You also have the added bonus of being able to easily get back to each students rubric. Use the TemplateTab menu to generate a new spreadsheet per student. The rubric you edited for each student will be copied to the individual spreadsheet.
The sharing settings of the individual spreadsheets that were created were set to “anyone with the link can view.” This allows you to share the spreadsheet without knowing the student’s email address. Simply copy (Control C) the link next to each students name and paste it somewhere the student can find it.
The students have view only access to the spreadsheet. If they have questions or comments, the students can reply in the private comments in Google Classroom.
Optionally, you can share the spreadsheet directly with the student. In Column B of the roster paste the students email addresses. Use the TemplateTab menu to choose “Share Spreadsheets.” If a valid Google account (students school G Suite accounts for example) is listed in column B the spreadsheet will be shared with view access to the students Google Drive. If the student is able to receive email, an email notification alerting the student to the rubric will be sent.