Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Fresh TemplateTab: Reuse Template

Create a fresh TemplateTab by using the new menu option "Create New." Use TemplateTab to have one spreadsheet for all students.
Create a new fresh TemplateTab
Fresh TemplateTab: Reuse Template

My most popular Add-on is TemplateTab. Collects no user data! TemplateTab will duplicate a graphic organizer within the spreadsheet for each student in the class, within the same spreadsheet. You can now create a fresh TemplateTab to export your graphic organizer to a new spreadsheet to use with a new group of students. 

How to Use TemplateTab

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. This is a classroom staple for me. 

Start by installing the free Add-on from the Google Marketplace. Open a new spreadsheet. Using the Extensions menu, select “TemplateTab” and choose “Setup.” The first sheet is your list of student names, or tab names you want to create. The 2nd sheet is your template, graphic organizer, that will be duplicated for each item in the list on the 1st sheet. 

screenshot of two tabs in a google sheets spreadsheet. first one says "Put Roster Here" and the second one says "Put Template Here"

Back in the Extensions menu, select TemplateTab->Run TemplateTab.

Reuse Your TemplateTab Template

A feature added to TemplateTab is to be able to create a fresh TemplateTab. After using ONE spreadsheet with your entire class you will want to reuse the template, but not the student names, with another class.

Show Advanced Features

The “Show Advanced Features” option displays a sidebar with additional options. Click on the “Create New” button in the sidebar. 

This will create a fresh spreadsheet and copy your graphic organizer over to that spreadsheet. The spreadsheet is created in Google Drive. If you have pop-ups enabled, the new spreadsheet will appear in a new tab.

Screenshot of the extensions menu for advanced features in TemplateTab

Fresh TemplateTab

If you’ve used TemplateTab in the past. Use the advanced features to make reusing the template a snap!! 

Advanced Options Sidebar

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.

Books by Alice Keeler

Available on Amazon or in bulk order.

Learn More about Google Sheets from Teacher Tech

© 2024 All Rights Reserved.