Apps Script Archives - Teacher Tech

Play Yahtzee with Google Sheets

by admin | May 23, 2019 | Apps Script, Google, Sheets, templates

Google Sheets Yahtzee In the book Math Recess, Sunil Singh and Chris Brownell give a list of regular board games that are good for playing with math. Yahtzee was on the list! Of course!! When I rolled a 4 6 6 6 4 I was adding up my points and I said I had four sixes...

Google Classroom: A Guide to Reusing Old Assignments

by admin | May 21, 2019 | Advanced, Apps Script, Classroom, Google, Sheets, templates

Create a List of Your Assignments in Google Classroom Every year is a new opportunity to be better than you were last year. This is one of the advantages to teaching, unlike any other profession we get a fresh start every year. The kids from last year are not the same...

Save Hours: Pull The Tables

by admin | May 6, 2019 | Apps Script, Docs, Google, Sheets, templates

Pull Student Responses From a Google Doc I’ve said many times, I would rather hit myself in the head with a brick than open 30 Google Docs (or Slides, or Sheets…). My rule of thumb is to only assign individual student work that I have to open 20% of the...

5 Basics to Know for Coding

by admin | Mar 26, 2019 | Apps Script, Google

Coding with Google Apps Script As a G Suite user you may find yourself wishing… “Why can’t I …. in Google Docs/Sheets/Forms/Slides?” You can if you know how to code! Go to script.google.com to get started with standalone coding or in...

1st Graders Making a Spreadsheet

by admin | Feb 1, 2019 | Advanced, Apps Script, Google, Sheets, templates

Have Students Respond in a Spreadsheet This morning I woke up to see this tweet “What about first graders responding to a question in graph format through Google classroom?” There are many ways to accomplish this but here is a suggestion for how first...

Google Sheets: What is On My Google Calendar

by admin | Jan 29, 2019 | Apps Script, Calendar, Google, Sheets, templates

Create a List of Your Google Calendar Events Have you ever wanted a simple list of every event on your Google Calendar? Use this Google Sheets template to extract a list of your events. Template alicekeeler.com/listcalendar Calendar ID When you create a copy of the...