Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Make Tabs FAST in Google Sheets

Make Tabs FAST in Google Sheets

YouTube video

Install Add-on


TemplateTab is a Google Sheets Add-on that allows you to duplicate a graphic organizer within a spreadsheet for every student on your roster.

Hack TemplateTab

Hack TemplateTab to simply create a lot of tabs quickly.

Add-on Menu

After installing TemplateTab you will find it permanently installed in the Add-on menu. Meaning it is available in any spreadsheet. Use the Add-on menu to choose “TemplateTab” and select “Setup Sheet.” This will add a sheet to the front of the workbook.

Instead of Roster

The template for the TemplateTab setup says “roster.” Instead of putting student names type any title you wish to use for the tab creation. For example if you were organizing the school musical you would need a tab for auditions, schedule, cast members, parent volunteers, budget, etc…

2nd Tab is the Template

The first sheet in your spreadsheet will act as the list of tab names to create. The second sheet is the template for what is copied. Leave this a blank sheet unless you want to pre-format the tabs you are creating with word wrap, freezing the first row or other.

TemplateTab operates on the first TWO sheets!

Run TemplateTab

Return back to the Add-on menu and choose “Run TemplateTab.” This will quickly create a new tab in your spreadsheet for each item on your list.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.