Apps Script Archives - Teacher Tech

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...

Create an Infographics Report Card

by admin | Jan 21, 2019 | Advanced, Apps Script, Google, Sheets, Slides, templates

Design Your Own Infographics Report Card I saw on Twitter that @teachtech4kids was thinking about creating an Infographics report card. BRILLIANT! I got sucked into the idea immediately and started to create a template to help facilitate that. The problem with a...

Easy! Google Forms: Automatically Sort on Submit

by admin | Dec 13, 2018 | Advanced, Apps Script, Forms, Google, Sheets

Sort Your Google Forms Results Automatically Google Forms is amazing, however it can be challenging to read Google Forms submission in a spreadsheet sometimes. You may need to make the columns wider, set word wrap, hide some columns, etc… The problem is that...

Code a Google Calendar Event from Google Forms

by admin | Dec 8, 2018 | Advanced, Apps Script, Calendar, Forms, Google

Code a Google Calendar Event from Google Forms For my Coding Google Forms workshop I thought it would be super easy to make a tutorial on how to have people sign up for something on a Google Form with a Date and Time and then create a Google Calendar event. It is easy...

Use Macros in Google Sheets to Cheat Coding

by admin | Nov 13, 2018 | Advanced, Apps Script, Beginner, Google

Code Google Apps Script Coding Google Apps Script is not as scary as you think. It’s multiple choice and copy and paste. Starting Nov 19th, 2018 I have an online workshop for “Introduction to Coding with Google Apps Script.” If you are already...