alice keeler add on templates

Add-Ons and Templates

alice keeler add on templates

Add-Ons using Google Apps Script

I learned a little JavaScript which is applicable for Google Apps Script. This allows me to code Google Docs and Sheets to create custom applications. Most of the templates below have an Add-On menu. These Add-ons are not available in the Add-on marketplace, but are instead tied to the template document. Usually the Add-on is the last Add-on in the list.  You can also learn Google Apps Script to create custom applications. Scroll to the bottom of this page for some blog posts on how to code along with tutorials.
Add-ons in Google Docs and Sheets


Script Description Link Quick Link
 RosterTab  Take a list of names of topics and create a named tab in a spreadsheet for each name in the list.  Click Here
 RosterTab2  Same as the above RosterTab but adds additional functionality to email student the link to their tab. Use the Add-On menu.
 TemplateTab  Create a graphic organizer or template and create a copy of the template on a different sheet for each name or topic in a list. Click Here
 RubricTab  Template of a Rubric to allow you to quickly assess each student against the rubric. This is a specific use case of the TemplateTab script.  Click Here and Click Here
 MarkAsGraded  Change the document title of student Google Docs to include  Click Here
 FilterRoster  Filter your Google Form for each student by creating a tab for each student and viewing their information on their own tab.  Click Here
 DiscussionTab  Create a spreadsheet for collaborative discussions. Each discussion topic on its own tab.  Click Here
 Discussion Board  If you have been wanting a solution for discussion boards within Google Docs, this spreadsheet allows you to create multiple discussion boards.  Click Here
 TurnInTab  Students do work on a spreadsheet and turn in their tab to teacher. Teacher has ONE spreadsheet with a tab from each student  Click Here
 Make Copies – A LOT  Makes a LOT of copies of a Google Doc quickly.  Click Here
 ListRubrics  Create a list of a lot of rubrics quickly.  Click Here
 PDF my Folder  Create a PDF of all the files in your folder. (Makes it easier to print all your files at once)  Click Here
 Teacher Newsletter  Create personalized weekly newsletters for students and parents  Click Here
 Bathroom Sign Out  Create a spreadsheet to use to have students sign out and into bathroom  Click Here
 Grade the Folder  Make a list of assignments in a Google Drive folder. Set their grading status and the document is renamed  Click Here
 Google Docs: Make Copies  Make multiple copies quickly of a Google Doc  Click Here
 Group Maker  Randomly assign your students to groups. Choose your group size  Click Here
 Google Classroom: List Docs  Create a list of all of the documents students have submitted through Google Classroom. Creates a list for each assignment.  Click Here
 Google Classroom: List Docs 2  Create a list of all of the documents students have submitted through Google Classroom. Creates a SINGLE list of all the documents for all the assignments.  Click Here
 Google Classroom: Create Group Docs  Copy a Google Doc template you create for each group. Shares the group doc with group members and adds group member names to the doc title.  Click Here
 Spelling Activity  Activity to practice spelling words  Click Here
 Make Folders  Create a Google Drive folder for each student on your roster. The folder is shared with the student explicitly.  Click Here
 List Scramble  Take a vocabulary (or other) list and create random subsets of the list.  Click Here
 Comment Maker Email each student a note quickly.  Click Here
 Send Comments  Create a spreadsheet for each student on your roster. Use this template to push comments to each students spreadsheet. Reuse to keep pushing comments to student spreadsheet. Great for students who do not have email.  Click Here
 Agenda Doc  Create a Google Form from a list of agenda items. Merge participant responses into agenda document.  Click Here
 Create a Form  Quickly create a Google Form.  Click Here
 Voice Type a Form  Use voice typing to create a Google Form.  Click Here
 Student Critique  Allow for peer evaluation of Google Docs. Change the sharing settings on a folder of student work to allow for commenting.  Click Here
 Simple Quest  Get started with a quest game.  Click Here
 Start coding math  Have students get started learning to code. Edit the code to accomplish math challenges.  Click Here
Let’s Play  Help students get on the same document faster to play a collaborative Google Apps game or assignment.  Click Here
Picker  If you’re already coding Google Apps Script and want an advanced template for having a Google Drive Picker.  Click Here
 Collaborative make Google Forms  Collaboratively create multiple choice questions on a spreadsheet and easily create a Google Form. Also, just a fast way to make a multiple choice Google Form.  Click Here
 Pull the Paragraph  Have students do a task on a Google text document. To evaluate it as if they had filled out a Google Form, this extracts all the paragraphs to a spreadsheet. Leave feedback and push it back to the Google Doc.  Click Here
 Note Taker  Automatically create a rough draft out of your notes. List sources and notes in spreadsheet and push to a Google Doc.  Click Here
 Random Winner  Add-on for Google Forms to choose a random winner from submissions.  Click Here
 Self Reflecting Reading  Have students reflect on their reading by filling out this Google Form.  Click Here
 Branching Form  Quickly create a template for a branching Form.  Click Here
 Periods for TemplateTab  Create your TemplateTab for multiple rosters all at once.  Click Here
 Calendar Script  Extract event information between a date range from your Google Calendar.  Click Here
 Copy Docs per student  If you are not a Google Classroom user and want to create copies of Google Docs for your students this simplifies the process.  Click Here
 Copy Docs per class Create a copy of a template per class  Click Here
 Click Here
 Click Here
 Click Here

Apps Script Tutorials

Start Here: A Quick Google Apps Script Project

Google Apps Script: Code Insert a Sheet

Start Here: A Quick Google Apps Script Project

Google Apps Script: Getting Started Part 2

Google Apps Script: You Can Code (part 3)

Google Apps Script: Format a Sheet

Google Apps Script: Create an Add-On

Google Apps Script: Create an Alert

Google Apps Script: Create Your Own Mail Merge

Kids Start Coding Their Vocab

Google Apps Script Picker Tutorial

Digiprove sealCopyright secured by Digiprove © 2015

31 thoughts on “Add-Ons and Templates

  1. Google Slides doesn’t have an option to make an object clone infinitely. Making copies can be annoying for algebra tiles. How about a script that makes a specified number of copies of an object that all all aligned over each other?

    1. That would be easy… but not that exciting for me. I encourage you to learn Google Apps Script. I have some tutorials to get you started!!!! You’ll feel awesome about it.

  2. You had done a presentation at Montclair State University last spring. Your ideas on how to use google were so helpful. I’m using your rubric script for sheets and it is LIFE CHANGING! I am sending a letter to the coodridnator of the event to let them know of how much your hard work has helped us here in carlstadt, new jersey.

  3. Alice – we are trying to use your Rubric Template to Email – RubricTab sheet. We LOVE this tool but are experiencing a few issues. Everything goes well until we sent the email. Stops populating data in the ‘roster’ sheet after the first student (only does row 2) and the copy of the spreadsheet that gets copied for the student looks like your original template and lacks the modifications we made to the sheet (even though it looks perfect when it makes the student copy inside my master sheet). Thoughts on what we might be doing wrong?

    1. This is an issue on some GAFE domains that have a setting in the admin panel set to not allow it. Works fine for some schools, not for others. I don’t know what the setting is. Need to track it down in the apps dashboard

  4. Hi Alice – I just ran your “Show me all the docs” script, and it’s great. Is there a way to run a spreadsheet by student instead of assignment? To show all the writing of just one selected student; maybe each tab could be each student’s name? I think this would be extremely helpful for submitting data and work samples to special education teachers.

  5. Interested in using one of your rubric scripts. Is there one that will put the rubric automatically in the student’s Drive folder? Looking for one that automatically returns the rubric to the student.

    1. Yes, if you run rubricTab it emails the student their rubric and puts it in Drive. If you know how to code, you can adjust the code to go to a particular folder.

  6. Pingback: | 5 super useful Chrome extensions & add-ons for educators

  7. Is there a script or add-on that will read to my students what they have written in a Google Doc? Or if not, possibly a website they can copy-paste their essay into that will read it back to them? I want my students to hear what they have written as they are editing and revising their essays.

  8. LOVE your site! I used rubric tab recently to grade science projects and it worked beautifully, until I tried to email the tabs back to the students. Only the first row on the roster page (first student) was automatically filled with points and comments, and that student did not receive an email. Just wondering what I might be doing wrong because I’d love to use it again! Thanks!

  9. Pingback: : un blog de référence. | Le blog de Thierry VANOFFE : Coach Google Apps

  10. Alice,
    Do you have a script to directly/instantly populate a Google Calendar from a Google Form? I’d like to allow parents to schedule their own conferences but want them to see the times that are open/taken immediately and have more flexibility than Google Appointment Slots. Any other ideas?
    Thank you so much!

  11. Alice,

    I have a Forms script question. I would like to build an observation Form. I teach in a juvenile justice school, so we have students coming and going. what I would like to do is write a script that creates a new tab in the sheet for each student(probably adding to and subtracting from this list with a dropdown question). Would it be possible to write a script to send the observation to their tab every time their name is selected? I realize that I could filter and do it that way, but I thought it would be a little cleaner for the end user to click on the tab for that student to see all of their observations. Is that as clear as mud?


    Jordan O’Donnell

  12. Hi Alice, can use suggest an add-on / method which will allow me to add scanned documents of students’ work to their Classroom assignment, rather than have young students scan and attach their own documents?

  13. Hi Alice, I would like to scan some student work, for example illustrations, handwriting samples, hand drawn maps, hand written work etc and be able to use the Google Classroom filing system to keep track of them, by putting them in appropriate student folders, and then use add-ons to assess and comment on the work. That is collect student work, feed it into the copier to scan, and use the help of an add-on (?) to place them in appropriate student folders – and then deal with them as any other work sample. Ideas?

  14. Pingback: Google Apps Script: Create New Tabs - Teacher Tech

  15. Pingback: Great Finds Lead to Great Shares | The Incidental Techie

  16. Pingback: Google Classroom: Pull Student Paragraphs and Give Feedback - Teacher Tech

  17. Hi Alice

    I have been using RosterTab for the past few years and I love it. I use it in conjunction with a Google Form to collect data on the students in my program. What I can not figure out is how to add a student mid-year. I have tried to add a new student to the list and then rerun the add-on but that creates dozens of tabs and I have to delete all but the one I needed. Is there a simpler way to add a new student part way into a course?


    1. It is not intended to add additional students. I usually use each time I need something. If you have a kid show up later to an ongoing document easiest thing is to just add a tab manually.

  18. Hello:) I am seeking a solution for at quick way to automatically give all assignments in a Classroom-folder the same feedback-respons placed directly in their assignment-doc or in a comment. Would that be possible? Or what would be the best solution?
    Many regards JytteP

Leave a Reply