Coding

Coding Google Classroom

This is not for the faint of heart! You should already be proficient with coding Google Apps Script. This is just an intro to the fact that you CAN code Google Classroom.

Coding - Sending file links

Tuesday Google Meet starts 8/3/2021, 11:00:00 AM PST

You can create a document per student, but how do you send it to them??? Let's code it in Google Apps Script. - Alice Keeler

Part II: What to do with an array

Part 1: What is an array (it is a list. You use a variable to say what the list is and you use brackets to indicate which item in the list you want.).

In this follow up will will take the slides in Google Slides and a roster of names in Google Sheets and do something with them. Use the array elements.

Learn to code: dice

In this coding workshop we will look at how to create random values. One use for this is creating a random dice roll, but there are many uses for random in Google Apps Script!

Basics of Coding Google Apps Script

This workshop will be NINETY MINUTES. This will get you familiar with the basics of coding Google Apps Script. An idea of what you can code in Google Apps Script. We will look at unbounded scripts at http://script.google.com and bounded scripts by going to the Tools menu and choosing "Script editor" to code the particular Google Docs/Sheets/Slides

Coding an add-on!

Get started with coding Google Docs, Sheets, Slides, and Forms by thinking about creating an Add-on. In this webinar, we will build an add-on for the Add-on menu and intro how you can get it permanently added to the Add-on menu! This webinar WILL be recorded.

Make a Certificate: Code a Mail Merge

Coding your own mail merge is so satisfying. It would be helpful if you have tried some Google Apps Script before but not required. You will take Google Form responses and merge them into a Google Doc to create a certificate.

How to make a Google Apps Script add-on

In this webinar we will learn how to make an add-on (with a menu). We will build a add-on that copies the Spreadsheet (or Document, Presentation, etc). Note: This webinar WILL be recorded.

Workshop: Coding Boot Camp Part 1&2&3

Learn something new this holiday break!! We will do a daily coding lesson. Same link and time each day. This workshop is 3 parts, join in each day to work on coding Google Apps Script. This is for users who are new to Google Apps Script. (If you know some Apps Script Alice will drop you some challenges.) Join all three days as each day builds on the previous days!

Webinar: Coding with User Properties - Google Apps Script

This webinar is for those of you who have some experience with Google Apps Script. with UserProperties you can save values to the spreadsheet/document/slides and when you come back to the document later it will remember that value. For example... in http://alicekeeler.com/firstslide you select a folder in Google Drive. It remembers this folder and never asks you for the folder again no matter how many times you push and pull values from the spreadsheet. In this webinar we will practice coding Google Apps Script with the purpose of gathering variables and using them in later functions. Member suggested by Alice Keeler

CalendarApp: Scripting Office Hours

Want to talk coding? Let's go over some Google Apps Script or bring questions for coding in Google Apps Script.

Webinar: Coding to Create a Google Form

Google Meet starts 9/10/2020, 4:00:00 PM Pacific Daylight Time

This workshop does assume you have SOME experience with coding Google Apps Script. Try the Drip Workshop for coding. Recently I had a need to make 50 Google Forms!! One per student with their schedule for questions to inquire about how many minutes they spent on each subject. Let's try coding something like this together.