Apps Script

By Anonymous

I've been working on creating some resources for teachers in my district and trying my hand at Google apps script. Below are some samples of what I've tried and some templates to use them, if you wish. Some of them will be coded as Add-ons while others are just Google Apps Scripts created to do some custom processing. Much of what I've used I have found on Google's App Script Developer's Guide and by looking/asking on Stack Overflow.

I will add more to this page as I develop more applications and scripts.


Apps Script Slide Deck



Script Name Task Link
Mass Docs Create a desired number of copies of a template document.
Form On/Off Use time based triggers to automagically turn form response collecting on and off.

 bit.ly/FormOnOff
TimeStamp A Google Apps Script that runs with a formula in a google sheet and will input the date when the corresponding cell has been edited or meets a specific condition. bit.ly/EditTimeStamp
DupTab Sample A Google Apps Script Sample that will duplicate tabs for a roster list. Based on Alice Keeler's RosterTab tutorials. bit.ly/DupTab

Comments

Post a Comment

Popular posts from this blog

Private Comments in Google Classroom

By Anonymous
Image
One of my most favorite ways to give feedback to students is using the Private Comments feature in Google Classroom. Much of my love for them has come from what I've learned from Alice Keeler, both on her blog and from her session at our Tech Kickoff this past August. I like this so much because it allows for personal, instant, and constant feedback to students on an individual level from anywhere, anytime. I know many teachers in my district don't like the fact that they are getting notifications from students at all times of the day, but I think it's great to see that my students are interested in their work for me when they have the time to do it. Plus, it gives me a great way to talk to students about time management, commitments, and prioritizing the things in your life (even if it ends up that my class works isn't the priority, it still opens up that window!). One quick note: I've found that many people don't see the difference between the Private Com...
Read more

Leverage Data Validation in Google Forms

By Anonymous
Image
Although it sounds very dry, data validation in Google Forms is actually a great help to anyone wanting to collect information or give assessments. Plus, it's only a couple of clicks away from making your forms work better for you and your target audience. What is data validation? To begin, we need to know what we are talking about. Data validation is basically a way for the person who is creating the form to "force" those that are filling it out to follow their directions, or they can't submit their answers. That's right! Forms won't allow them to submit until those criteria have been met. This creates predictable answers from your students so that using the information in the spreadsheet is simplified (numbers where you need numbers, text that is the correct length, the right number of answers in a specific question, etc.). How to make it happen: To begin, create a from in Google Forms and create a question in that form (data validation works in sho...
Read more

Using Slides "Right"

By Anonymous
Image
We all know that we shouldn't put a lot of text on slideshow slides and the last thing we want to do is watch someone read their slides to us during a lesson or presentation. However, many people don't know just how flexible Google Slides are and how to "hack" the use of them to make presenting information more pleasing to an audience. Recently, I went to the IETA conference in Boise, ID, the annual conference for the Idaho Educational Technology Association (IETA). While there, I attended a session by the illustrious Sarah Windisch ( @slwindisch on twitter) about using Google Slides. While I have always tried to keep my slides more focused on images than text, I learned some new hacks from her and other presenters at the conference. Here are my top 3 additions to slide decks that we should all try at least once: Use topical images that draw interest Your slideshow should support what you are talking about, not be the centerpiece. Use images that relate t...
Read more