Creative Constructor
Lab Virtual
Leadership Exchange
at ISTELive 21
Edtech Advocacy &
Policy Summit

Getting Started With Google Apps Script

Times and dates are displayed based on your device's time zone setting.

Explore and create : Creation lab

Dr. Wanda Terral  
Ever wonder how Google Docs/Sheets/Slides/Forms add-ons work? This session is a beginner’s look at just that. Leave being familiar with the basics of Google Apps Script and how it allows interactions with G Suite applications. Even write your first simple add-on before you go!

Audience: Chief technology officers/superintendents/school board members, Technology coordinators/facilitators
Skill level: Beginner
Attendee devices: Devices required
Attendee device specification: Laptop: Chromebook, Mac, PC
Participant accounts, software and other materials: In order to write and run the scripts they create, attendees will need a computer (not a tablet) and access to a Google account with access to script.google.com. Additionally, they would need access to other Google services (Docs, Sheets, Slides, Mail) in order to run some of the sample scripts. Managed G Suite accounts may not have the needed access so attendees are encouraged to use a consumer Google account.
Topic: Online tools, apps & resources
ISTE Standards: For Educators:
Leader
  • Model for colleagues the identification, exploration, evaluation, curation and adoption of new digital resources and tools for learning.
Facilitator
  • Model and nurture creativity and creative expression to communicate ideas, knowledge or connections.
For Coaches:
Content Knowledge and Professional Growth
  • Regularly evaluate and reflect on their professional practice and dispositions to improve and strengthen their ability to effectively model and facilitate technology-enhanced learning experiences.

Proposal summary

Purpose & objective

Participants will learn how Google Apps Script works by writing their own scripts, running them, and seeing how they can be used to interact with various Google services. Most of the session is spent with participants in the Script Editor. While participants will be encouraged to actually type the sample scripts, templates of script snippets will be provided which could be copied/pasted/edited. Success will be immediately visible through the successful running of their code. Additionally, participants will brainstorm ideas for leveraging Google Apps Script to solve problems in their districts/schools.

Outline

- Google Apps Script: What is it & why use it?
- Google Sheet Macros
- Using the Script Editor
- Create, save, & run some scripts - This is where the bulk of the session is spent
- Developer Reference Guides
- Additional resources
- Closing Info

Supporting research

Google Apps Script - https://developers.google.com/apps-script

Apps Script Tutorials - https://developers.google.com/apps-script/articles/tutorials

Apps Script Blastoff course - https://www.benlcollins.com/apps-script-course/

More [+]

Presenters

Photo
Dr. Wanda Terral, Lakeland School System

People also viewed

Collaboration in the Classroom Is Possible!
Global Collaboration — Seeing Yourself in Others Around the World
Go Team! Your Hybrid Classroom Made Easy With Microsoft Teams