TemplateTab Plus by Alice Keeler

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

alicekeeler.com/templatetabplus

  • 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.

Managing Rubrics

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).

Digital Files

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.

Design It

bret Gosselin rubric

Screenshot tweeted to me by Bret Gosselin. He has his own graphical way to assess an infographic.

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!
design your rubric

Roster

The first tab of TemplateTab plus allows you to paste a list of your students’ names into column A.
Roster of student names

TemplateTab

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.
Run TemplateTab

create tabs

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.
locate each students name along the bottom

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.

Create Spreadsheets

Use the TemplateTab menu and choose “Create Spreadsheets.” With no effort, a spreadsheet for each student is created with their rubric.
Create Spreadsheets

automatically a spreadsheet for every student was created on the roster

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.
copy and paste link

Google Classroom

If you are a Google Classroom user, paste the link into the private comments for each student.
paste link into Google Classroom Private Comments

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.

Share Spreadsheets

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.
Share Spreadsheets

Digiprove sealCopyright secured by Digiprove © 2017