Apps Script Archives - Teacher Tech

Create a Choice Board from Bingo Add-on

by admin | May 12, 2020 | Apps Script, Gamification, Google, Sheets

I have an Add-on (not available in the marketplace) to quickly create a unique bingo board for each student. Use the Bingo template to create a unique choice board per student. Tell students to choose 5 in a row from the choice board to make Bingo! The Add-on...

Google Drive: Create a Table of Contents for a Folder

by admin | May 5, 2020 | Apps Script, Coding, Drive, Google, Sheets

List the Files in a Google Drive Folder I’ve been on a coding binge 🙂 I saw that an AP Biology group were sharing lesson plans and resources in a Google Drive folder with a lot of subfolders to organize by topics. I thought it might be helpful to share the...

script.new TRY IT

by admin | Feb 28, 2020 | Advanced, Apps Script, Google

Try Coding Google Apps Script You can code Google Apps. Google Docs, Sheets, Slides, Forms, etc… (Currently Google new Google Sites you can not). script.new Like the other Google Apps products you can use dot new to quickly make a new file of the product. Once...

Copy a Folder in Google Drive

by admin | Jan 20, 2020 | Advanced, Apps Script, Drive, Google

Copy Files from One Account to Another If you want to copy your Google Drive files from one account to another the trick is to put the files in account A into a folder. Share the folder with account B. In account B go to “Shared with Me” and start copying...

PDF my Folder – Add-on

by admin | Jan 5, 2020 | Advanced, Apps Script, Drive, Google, Sheets

Turn Google Drive Folder Files to PDF If you would like to print student work to post on the wall you will need to Control P print one document at a time. Alternatively, you can use PDF my Folder Add-on by me (Alice Keeler) to turn a folder of Google Apps Documents...

APPROVED!! TEMPLATETAB

by admin | Dec 23, 2019 | Advanced, Apps Script, Google, Sheets

TemplateTab Copies a Graphic Organizer Per Student TemplateTab is one of the first things I ever coded, and I think one of the best things I’ve coded. Special thanks to Alicia Williams and John McGowan for helping me get this published to the G Suite...