Bring It All Together: Create Your Own Google Sheets Automation

Description

How would it feel to have a Google Sheet that automates your most time-consuming classroom tasks? With Google Apps Script and AI, you can build a spreadsheet tool tailored to your classroom's needs—whether it is an automated grade tracker, student feedback generator, or attendance manager. Join Lauren Boucher for this hands-on, interactive workshop where you will create a fully functional, time-saving automation that works for you, from start to finish, that will streamline your daily teaching tasks. Get ready to harness the power of Google Apps Script to build a custom AI-assisted spreadsheet tool tailored to your classroom! Lauren's expertise in digital teaching and learning will provide you with tools and resources to design and build a fully functional AI-powered automation tool in Google Sheets so you can focus more on teaching and less on managing data!

Objectives

1. Recall how Google Apps Script and AI can assist with automating classroom tasks.
2. Understand how to design and implement custom automation scripts using Google Apps Script.
3. Apply AI and Google Apps Script to create automation tools like grade trackers or attendance managers.
4. Analyze how automation can simplify and improve classroom management processes.
5. Evaluate the effectiveness and efficiency of AI-powered Google Sheets tools in the classroom.
6. Design and build a fully functional AI-powered automation tool in Google Sheets tailored to your classroom needs.

Key Take Aways

• Learn how to create an automated grade tracker that updates with ease.
• Discover how to build a student feedback generator that creates personalized comments.
• Understand how to automate attendance tracking to save time each day.
• Gain practical knowledge to write your first AI-powered Google Apps Script and implement it in your classroom.