AI + Google Apps Script: Let AI Build Your Teaching Tools

Description

Are you ready to automate your classroom tasks without needing any coding expertise? Google Apps Script can take your spreadsheets to the next level by enabling simple automations like auto-filling forms, sending email reminders, and customizing Google Sheets—all without writing a single line of code. Join Lauren Boucher for this hands-on, interactive workshop where you will discover how to use AI (like ChatGPT) to write and refine Google Apps Script code, making it easier than ever to automate time-consuming tasks. Discover how AI can become your personal coding assistant to help you automate and streamline classroom tasks using Google Apps Script! Lauren's expertise in digital teaching and learning will provide you with tools and resources to work more efficiently, leaving you with more time to focus on what truly matters—teaching and connecting with your students.

Objectives

1. Recall the basic concepts of Google Apps Script and its features.
2. Understand how Google Apps Script can automate and streamline classroom tasks.
3. Apply Google Apps Script to create automation and customize Google Sheets for classroom needs.
4. Analyze how automating tasks with Google Apps Script can improve classroom efficiency and productivity.
5. Evaluate the effectiveness of different Google Apps Script tools and integrations to enhance classroom management.
6. Design custom automations and scripts to optimize daily classroom tasks and data management.

Key Take Aways

• Learn how to set up simple automations in Google Sheets, like auto-filling forms and sending email reminders.
• Discover how to customize Google Sheets to fit your classroom's unique needs.
• Understand how Google Apps Script can reduce time spent on repetitive administrative tasks.
• Explore how to integrate Google Apps Script with other Google Workspace tools for seamless classroom management.