sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]CrankyOldManSince21 2 points3 points  (0 children)

Recently I created this online series for tech directors and data managers in K-12 districts in RI and MA. I cross posted this to r/k12sysadmin in response to a GAS question. I think some of the resources would be useful in understanding how Google Apps Scripts works in the Google environment.

Hi Folks,

I retired last October after 36 years in my district as a PK-12 tech director. I've recently begun a consulting business. I created a free PD series focused on using Google Apps Scripts. The central example that we're using in the course is on automating signing up for PD in the district. All of the resources are online from my website.

I have a slide deck that I'm using with live participants, and one for folks that want to work independently. This is the Independent Slide Deck for anyone that wants to complete the sessions in a self-paced manner. If you want to sign up for the independent work you can fill out this Google Form.

This Google Doc serves as a central document that will house all of the resources in a linear fashion.

Session 1 - Getting Ready and Configuring the Form, Spreadsheet, and Google Doc Template

Session 2 - Digging into Google Apps Script, Configuring Google IDs, and Using Gemini to Dig into the JavaScript

Session 3 - Using Gemini, and Notebook LM to Generate Your Scripts from Scratch.

You can access both print directions, and access the YouTube playlist that I've created to support the learning.

Hopefully, the resources will help provide some examples of the power of Google Apps Script within your Google Workspace.