Spreadsheets That Work for You: The Power of Google Apps Script

Lauren Boucher
Presenter
60
mins
Course length
Multi Device
Access from mobile or laptop
4.98
Course rating
An adult and a child sitting at a table, working together on homework with notebooks and a smartphone nearby.
A sequence of black and white geometric shapes alternating between quarter circles and half circles arranged in a horizontal line.

Description

Are you looking for ways to automate your classroom tasks and save time? By harnessing the magic of Google Apps Script, you can automate everyday teaching tasks and make your classroom data work for you, boosting productivity and efficiency. Join Lauren Boucher for this hands-on, interactive workshop where you will discover how to create simple automations in Google Sheets, including auto-filling forms, sending email reminders, and more—without any coding knowledge required. Get ready to unlock the power of Google Apps Script to make your spreadsheets work harder for you! Lauren's expertise in digital teaching and learning will provide you with tools and resources to streamline repetitive tasks and give you more time to focus on what really matters: teaching and supporting your students.

Objectives

Recall the basic concepts of Google Apps Script and its features. Understand how Google Apps Script can automate and streamline classroom tasks. Apply Google Apps Script to create automation and customize Google Sheets for classroom needs. Analyze how automating tasks with Google Apps Script can improve classroom efficiency and productivity. Evaluate the effectiveness of different Google Apps Script tools and integrations to enhance classroom management. 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.

Start your 7-day free trial today and explore this course at no cost.

Continue your learning with full access to our library of 1000+ courses, learning pathways and microcredentials to support your growth.

Meet

Lauren Boucher

Lauren Boucher has 18+ years in public education, teaching 3rd grade, gifted K-8, and working as a Digital Teaching and Learning Coach. Now a Southeast Regional Consultant for the NC Department of Public Instruction, she shares innovative ed tech practices nationwide.
Specializes In:
Digital Teaching & Learning Consultant

Over 1,000 courses. 40+ topics. Unlimited potential.

The most comprehensive professional learning library available — designed to grow with you.
Arrow-icon-left
Arrow-icon-right

Ready to grow?

Unlock new strategies and skills—wherever you are in your teaching journey.

A teacher with curly hair and glasses shows a glowing light bulb to a group of smiling children gathered around a table.