Apps Script Archives - Teacher Tech

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

Google Sheets: Code Adding Content to Multiple Tabs

by admin | Oct 18, 2018 | Advanced, Apps Script, Google, Sheets

You Can Code Google Sheets Coding Google Apps Script is easier than you think it is. Learning to code can increase your productivity significantly. One thing I frequently code is adding the same piece of information to multiple tabs in a spreadsheet. I like to have...

Google Slides Essay

by admin | Sep 17, 2018 | Advanced, Apps Script, Google, Slides, templates

Google Slides Essay Template A little tongue in cheek I like to say “Don’t use Google Docs.” When we go digital we want to take advantage of what digital offers that paper did not. Oftentimes what we might use a Google Doc for we would really want a...

Teach Students How to Give Peer Feedback

by admin | Aug 26, 2018 | Advanced, Apps Script, Docs, Google, Sheets, templates

Teach Peer Feedback Peer feedback can be powerful for learning, but only if students do a good job at it. Analyze and critique can be higher critical thinking levels than doing the task in the first place. I guarantee if you ask students to give peer feedback the...