Have you ever wanted to learn how to code Google Docs, Sheets, Slides, etc.? As a teacher, you have a unique need to do tasks repetitively. The code should help you do these tasks more efficiently. Have you ever wondered “Why can’t Google do this…?” This is what Google Apps Script can help you with. look at some of my Accessories I’ve created for Google Workspace apps to see how I’ve created additional features. One of my favorite ways to add features to Google Workspace apps is to combine them. My Document to Slides Add-in will take your paragraphs in a Google document and magically turn it into a Google Slides presentation. Would you like to learn programming but feel that the learning curve to start creating projects is too high? This workshop with Google development expert Alice Keeler is for you! Learn to code with ChatGPT. Join Alice for a 6-week interactive workshop that will take you from zero to intermediate programmer.
Register: Space is limited
This workshop will take place from April 2 to May 20. (Note: there is a break the week of May 7). Quota limited to 20 participants.
Registration also includes an AliceKeeler Membership for the 2023-2024 school year (expires June 2024). A value of $249.
Live sessions 10am PST
In addition to asynchronous instruction and assignments, you’re invited to join on Saturdays at 10 am. In these sessions we’ll try coding projects using ChatGPT and troubleshooting output. If you are unable to participate live, you will have access to the recording later.
April 8
April 15
April 22
April 29
May 6th
NOTE NO LIVE CLASSES MAY 13 (my son graduates from high school)
May 20th
Debugging Google Apps Script and ChatGPT
Please note that joining this workshop is all about teaching you about Google Apps by using the power of ChatGPT to help you go from beginner to intermediate programmer in 6 short weeks. ChatGPT will do it most likely provide code that doesn’t work. You will need to troubleshoot and debug the code for it to work. There will be times when you can’t figure out how to adapt the ChatGPT code to achieve the idea of your project. It is recommended to start with basic coding project apps until your coding skills are practiced enough to be able to tackle more advanced topics.
This workshop does NOT debug for you.
Unfortunately, this workshop cannot do any debugging for you. If your code doesn’t work, this workshop is designed to give you the skills to have a basic understanding of Google Apps Script and JavaScript to help you to be able to correct your errors in the code. Alice is unable to individually review your code to determine why your code is not working. During the live sessions, you’ll learn debugging strategies that you can use in your own projects.
Schedule
| Week 1 | April 2, 2023 | Introduction to ChatGPT and Google Apps Script |
| week 2 | April 9, 2023 | Creating a sidebar and menus for your coding project |
| week 3 | April 16, 2023 | Management of matrices (lists) from Google spreadsheets |
| week 4 | April 23, 2023 | Google Slides Coding for Teachers |
| week 5 | April 30, 2023 | Google Calendar Coding for Teachers |
| BREAK | May 7, 2023 | BREAK |
| week 6 | May 14, 2023 | Google Forms Coding for Teachers |
course outline
Week 1: Introduction to ChatGPT and Google Apps Script
- Introduction to the course, ChatGPT and Google Workspace tools (Docs, Sheets, Slides, Forms, etc.)
- Google Apps Script Basics: Purpose, Functionality, and Benefits for Teachers
- Setting up the Google Apps Script development environment
- Introduction to JavaScript: variables, data types, basic syntax, control structures (loops, conditional statements)
- Using ChatGPT for coding assistance: finding code samples, solving coding problems, and generating code snippets
- Homework: Explore Google Workspace tools and brainstorm potential classroom applications
Week 2: Creating a sidebar and menus for your coding project
- Understand the Google Apps Script user interface and custom menus
- Create a custom sidebar with HTML and CSS
- Sidebar integration with Google Docs, Sheets, and Slides
- Using ChatGPT to generate code snippets for UI elements
- Assignment: Design a custom sidebar and menu for a classroom related project
Week 3: Managing arrays (lists) from Google Sheets
- Introduction to arrays and their importance in data management
- Access and manipulate data in Google Sheets using arrays
- Common array operations: sort, filter, and search
- Using ChatGPT to generate code snippets for array operations
- Assignment: Create a script to manage classroom data in Google Sheets using arrays
Week 4: Coding Google Slides for Teachers
- Overview of the Google Slides API and functionality
- Creating, editing and formatting slides with Apps Script
- Automating slide generation from Google Sheets data
- Using ChatGPT to generate code snippets for Google Slides operations
- Assignment: Develop a script to automate Google Slides presentations for classroom use
Week 5: Google Calendar Coding for Teachers
- Introduction to the Google Calendar API and services
- Creating, updating and managing events using Apps Script
- Automation of appointment scheduling and reminders
- Using ChatGPT to generate code snippets for Google Calendar operations
- Assignment: Create a script to automate Google Calendar tasks for classroom management
Week 6: Coding Google Forms for Teachers
- Overview of the Google Forms API and functionality
- Creating, editing and managing forms with Apps Script
- Automation of form generation, data collection and analysis
- Using ChatGPT to generate code snippets for Google Forms operations
- Assignment: develop a script to improve the use of Google Forms in the classroom
- Course Summary: How to Continue Using ChatGPT for Coding and Learning Support
- Certificate of completion for participants.
Who is Alice Keeler?
Alice Keeler is a recognized Google Developer Expert for Google Workspace and a Google Certified Innovator with years of experience in educational technology. As the instructor for this workshop, Alice brings a wealth of knowledge and a passion for helping teachers enhance their classroom experience through innovative tools and techniques.
Alice has a strong background in teaching and educational technology, which has enabled her to understand the unique challenges teachers face in today’s dynamic educational landscape. Her experience at Google Workspace, combined with her innovative and creative approach to instruction, has made her a sought-after consultant, speaker, and trainer in the field of educational technology.
As an author, Alice has written several books on the topic of integrating technology in the classroom, sharing her knowledge and practical advice with educators around the world. In addition to her own written work, Alice is a prolific blogger and social media influencer, constantly sharing valuable resources and thought leadership on best practices in edtech.
In this workshop, Alice’s engaging teaching style and in-depth knowledge of Google Apps Script and ChatGPT will give participants the knowledge, skills, and confidence they need to unlock the full potential of Google Workspace for their classrooms. Participants can expect a hands-on, interactive experience that will leave them inspired and equipped to transform their teaching practice through the power of technology.
-
Quickly! Take advantage of ChatGPT to learn how to code Google Workspace with Google Apps Script. Google Development Expert Alice Keeler will teach you how to go from Zero User to Intermediate User in 6 weeks. Space is limited. Register now.
-
O shoot! Google updated its interface for Google Docs, Sheets, and Slides again. This time, the Explore tool falls victim to the design update. Can you still access the Explore tool? Where is? Where did the explore tool go?
-
Navigating copyright laws can be challenging for educators, especially when trying to create interesting and informative materials for their students. However, sometimes we may unknowingly violate copyright laws when we use resources in the classroom. To avoid any legal issues, it is essential to understand the common copyright pitfalls and how to get around them. A critical aspect of copyright law that teachers should be familiar with is “fair use”. Here are ways teachers violate copyright:
-
Unleash the power of efficient online research with our blog post on 5 Essential Google Search Techniques Every Teacher Should Try Today! Learn how to find high-quality, relevant, and accurate resources for lesson planning, student support, and professional development. Improve your research skills and save time, making your teaching experience more productive and enriching. Don’t miss these valuable tips to master the art of searching!
-
Google Jamboard, Google Workspace’s interactive whiteboard, has revolutionized collaboration both inside and outside of the classroom. Many users are familiar with its basic features, but there is much more to discover. Explore 10 lesser-known features that will help you unlock the full potential of Google Jamboard.
-
The choice has many benefits for students in education to increase their motivation, efforts and commitment. Gamified choice boards bring together the power of choice and the power of fun. Join Alice Keeler as she explains some options to create a gamified option board.
