Apps Script Archives - Teacher Tech

First Slide: Push a Slide to Students

by admin | Nov 5, 2019 | Advanced, Apps Script, Google, Slides, templates

Update Student Slides with First Slide When you make a copy of a document for every student it is slow to open and give feedback. It just takes time for digital documents to load, especially if the internet is not super fast. First Slide allows you to give feedback...

Google Slides – Badge Maker

by admin | Nov 3, 2019 | Apps Script, Google, Slides

Create Badges in Google Slides I definitely have a coding addiction. For fun I created an Add-on for Google Slides that will make gamification badges for you. Template alicekeeler.com/makebadges This makes is fast and easy to add digital stickers or badges to student...

Push a Prompt to Slides

by admin | Oct 31, 2019 | Apps Script, Google, Slides, templates

Push to Slides If you would like to assign each student a different prompt or question I have coded an Add-on for Google Slides that will allow you to take a list of prompts, randomize them, and push them to an individual Google Slides per student. Template...

Fast: Create a Branching Google Form

by admin | Oct 21, 2019 | Advanced, Apps Script, Forms, Google, Sheets, templates

Create a Branching Google Form Design your Google Forms to provide immediate feedback by utilizing branching options. Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the...

Bulk Removing Users From G Suite Admin

by admin | Oct 10, 2019 | Admin, Advanced, Apps Script, Google

G Suite Admin – Bulk User Removal I am the apps admin on my G Suite EDU domain. For a training I had created 100 temporary accounts and then wanted to delete them after the training. Doing a Google Search the results show me how to tediously remove one user at a...

Linking Data Sets in Different Google Sheets

by admin | Oct 10, 2019 | Advanced, Apps Script, Google, Sheets

Updating One Google Sheets Spreadsheet From Another You have more than one spreadsheet of data. You need the information from one spreadsheet to interact with the data in another spreadsheet. There are 2 ways to do this in Google Sheets. Copying and pasting from one...