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.
Add-ons in Google Docs and Sheets

Add-Ons

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 alicekeeler.com/rostertab
 RosterTab2  Same as the above RosterTab but adds additional functionality to email student the link to their tab. Use the Add-On menu. tinyurl.com/rostertab2
 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  alicekeeler.com/templatetab
 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 alicekeeler.com/rubrictab2
 MarkAsGraded  Change the document title of student Google Docs to include  Click Here tinyurl.com/markasgraded
 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 alicekeeler.com/filterroster
 DiscussionTab  Create a spreadsheet for collaborative discussions. Each discussion topic on its own tab.  Click Here alicekeeler.com/discussiontab
 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 alicekeeler.com/discussionboard
 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 alicekeeler.com/turnintab
 Make Copies – A LOT  Makes a LOT of copies of a Google Doc quickly.  Click Here  tinyurl.com/copydocscript
 ListRubrics  Create a list of a lot of rubrics quickly.  Click Here  alicekeeler.com/listrubrics
 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  alicekeeler.com/pdfmyfolder
 Teacher Newsletter  Create personalized weekly newsletters for students and parents  Click Here  tinyurl.com/keelernewsletter
 Bathroom Sign Out  Create a spreadsheet to use to have students sign out and into bathroom  Click Here  tinyurl.com/bathroomsignout
 Grade the Folder  Make a list of assignments in a Google Drive folder. Set their grading status and the document is renamed  Click Here  tinyurl.com/gradethefolder
 Google Docs: Make Copies  Make multiple copies quickly of a Google Doc  Click Here  tinyurl.com/copytextdoc
 Group Maker  Randomly assign your students to groups. Choose your group size  Click Here  alicekeeler.com/groupmaker
 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  alicekeeler.com/showdocs
 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  alicekeeler.com/listdocs
 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  alicekeeler.com/groupdocs
 Spelling Activity  Activity to practice spelling words  Click Here  tinyurl.com/kylespelling
 Make Folders  Create a Google Drive folder for each student on your roster. The folder is shared with the student explicitly.  Click Here  alicekeeler.com/makefolders
 List Scramble  Take a vocabulary (or other) list and create random subsets of the list.  Click Here  alicekeeler.com/listscramble
 Comment Maker Email each student a note quickly.  Click Here  alicekeeler.com/commentmaker
 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  alicekeeler.com/sendcomments
 Agenda Doc  Create a Google Form from a list of agenda items. Merge participant responses into agenda document.  Click Here  alicekeeler.com/agendadoc
 Create a Form  Quickly create a Google Form.  Click Here  alicekeeler.com/form
 Voice Type a Form  Use voice typing to create a Google Form.  Click Here  alicekeeler.com/docform
 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  alicekeeler.com/studentcritique
 Simple Quest  Get started with a quest game.  Click Here  alicekeeler.com/simplequest
 Start coding math  Have students get started learning to code. Edit the code to accomplish math challenges.  Click Here  alicekeeler.com/startmathscript
Let’s Play  Help students get on the same document faster to play a collaborative Google Apps game or assignment.  Click Here  alicekeeler.com/letsplay
Picker  If you’re already coding Google Apps Script and want an advanced template for having a Google Drive Picker.  Click Here  alicekeeler.com/picker
 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  alicekeeler.com/letsmakeaform
 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  alicekeeler.com/pulltheparagraph
 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  alicekeeler.com/notetaker
 Random Winner  Add-on for Google Forms to choose a random winner from submissions.  Click Here  alicekeeler.com/randomwinner
 Self Reflecting Reading  Have students reflect on their reading by filling out this Google Form.  Click Here  alicekeeler.com/selfreflectingreading
 Branching Form  Quickly create a template for a branching Form.  Click Here  alicekeeler.com/branchingform
 Periods for TemplateTab  Create your TemplateTab for multiple rosters all at once.  Click Here  alicekeeler.com/templatetabperiods
 Calendar Script  Extract event information between a date range from your Google Calendar.  Click Here  alicekeeler.com/calscript
 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  alicekeeler.com/copydocsstudents
 Copy Docs per class Create a copy of a template per class or group  Click Here  alicekeeler.com/copydocsclasses
 Lesson Plan Book  Collaborate on lesson plans. Create a copy of a template and share with collaborators.  Click Here  alicekeeler.com/createlessonplans
 Doc to Spreadsheet  Take a list of student Google Docs and list the content in a spreadsheet.  Click Here  alicekeeler.com/getdocs
 Pull the Paragraph 2  Leave feedback per paragraph without ever opening a student Google Doc.  Click Here  alicekeeler.com/pulltheparagraph2
 TemplateTab Plus  Evaluate each student on a rubric you design and email them the results.  Click Here  alicekeeler.com/templatetabplus
 Yohaku  Create a unique Yohaku puzzle for your students.  Click Here  alicekeeler.com/yohaku
 Word Search  For fun, design your own word searches  Click Here  alicekeeler.com/wordsearch
 Email Parents  Create an email and send it to each parent on your parent roster. Include a personal note about each student.  Click Here  alicekeeler.com/emailparent
 List of Newsletters  If you have a folder in Google Drive with newsletters, this will create a list of them.  Click Here  alicekeeler.com/listofnewsletters
 Worksheet Game  Make a game of your worksheet questions. Use the grader to make giving feedback easier.  Click Here  alicekeeler.com/worksheetgame and alicekeeler.com/worksheetgamegrader
 NumberDocs  Remove the previous assignment number from document title and append a new one.  Click Here  alicekeeler.com/numberdocs
 Delete Calendars  Quickly delete multiple Google Calendars (possibly created by Google Classroom).  Click Here  alicekeeler.com/deletecal
 Click Here
 Click Here

Want to learn to code? Check out my online coding workshop at alicekeeler.com/goslow

Apps Script Tutorials

Start Here: A Quick Google Apps Script Project

Code a List of Your Calendar Events

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

Kids Code: Create an Add-on Menu

Google Apps Script Picker Tutorial

Digiprove sealCopyright secured by Digiprove © 2015-2017