Reuse Your TemplateTab Template

I am always tweaking my TemplateTab Add-on. TemplateTab allows you to use ONE spreadsheet with your entire class. Instead of 30 documents to open, you have one. Students can crowdsource and learn from each other. I use it a lot. I have added the ability to more easily reuse your TemplateTab template.

Template

alicekeeler.com/templatetab

The Template Tab

After making a copy of the template you will notice there are 2 tabs. “Put Roster Here” and “Put Template Here.” Design your graphic organizer on the “Put Template Here” tab.

The Menu

After pasting your roster on the “Put Roster Here” tab, use the TemplateTab menu to “Run TemplateTab.”

This will create a copy of the graphic organizer on the “Put Template Here” tab for each student, within the same spreadsheet. Share the spreadsheet with students, giving them edit access.

Make Copies

I updated “Make Copies” in the menu to now create a copy of the TemplateTab template and to add the graphic organizer template you already have. This minor update allows you to have your roster pasted onto the roster tab, or even to have run TemplateTab, and still be able to make fresh copies for another class.

Delete Unedited Tabs

Sometimes not all students participate in the TemplateTab. One use for TemplateTab is peer evaluation where each student has their own copy of the TemplateTab that has a rubric to peer evaluate each peer. In both cases, not all of the sheets are filled out. Delete Unedited Tabs will count how many cells are edited on each sheet. If the count matches the graphic organizer, the sheet will be deleted.

Email Tab

If your roster you pasted contains the email addresses for each student in column C, you can email each student the link to their specific tab. Remember the point of TemplateTab is collaboration and crowdsourcing so all students can see each other’s sheets.

Note if you are sharing TemplateTab through Google Classroom you must ASSIGN the spreadsheet first before using Email Tab. Google Classroom does not give permissions to the document until it has been assigned. If you save the assignment as a draft or schedule the assignment the document is not shared until the assignment actually appears in the Stream.

Move to Front

For peer evaluation purposes it can be frustrating for students to look at the spreadsheet and not realize who has and who has not edited their sheet. The menu option to “Move to Front” moves the sheets that have been edited to the front of the tab list. In other words, slackers are at the end.

Create New

New school year and you want to reuse the TemplateTab templates you used last year, choose “Create New” from the menu. This will create a new TemplateTab and import the template.

Old TemplateTab

The “Create New” is a new feature in TemplateTab. If you previously used TemplateTab those spreadsheets do not have this menu option. In that case try these steps:

• Create a fresh TemplateTab at alicekeeler.com/templatetab
• Delete the “Put Template Here” tab.
  Whatever is the 2nd sheet is considered the graphic organizer.
• On the outdated TemplateTab use the View menu and choose “Hidden Sheets.” This will reveal the graphic organizer template.
• On the “template” tab, click on the tiny triangle and choose “Copy to.” Choose the new TemplateTab you created as the destination.
• On your new spreadsheet your graphic organizer should now be the 2nd tab and you are all set to “Run TemplateTab.”