Have you ever wished to discover ways to code Google Docs, Sheets, Slides, and many others…? As a instructor you have got a singular must do duties repetitively. Code ought to aid you to do these duties extra effectively. Have you ever puzzled “Why can’t Google do this…?” This is what Google Apps Script can assist you with. Check out a few of my Add-ons I’ve created for Google Workspace Apps to see how I’ve created further performance. One of my favourite methods so as to add performance to Google Workspace Apps is to smash them collectively. My Doc to Slides Add-on will take your paragraphs in a Google Doc and magically flip it right into a Google Slides presentation. Would you prefer to discover ways to code however really feel that the educational curve to start out creating initiatives is just too excessive? This workshop with Google Developer Expert Alice Keeler is for you! Learn to code with ChatGPT. Join Alice for a 6 week interactive workshop to take you from zero to intermediate coder.
Register: Space is Limited
This workshop runs from April 2nd to May twentieth. (Note: there’s a break the week of May seventh). Space is restricted to twenty members.
Registration additionally consists of an AliceKeeler Membership for the 2023-2024 college yr (expires June 2024). A $249 worth.
Live Sessions 10am PST
In addition to asynchronous instruction and duties you’re invited to hitch Saturdays at 10am. In these classes we’ll strive coding initiatives utilizing ChatGPT and troubleshooting the output. If you’re unable to take part dwell you’ll have entry to the recording afterwards.
April eighth
April fifteenth
April twenty second
April twenty ninth
May sixth
NOTE NO LIVE CLASS MAY thirteenth (my son is graduating from highschool)
May twentieth
Debugging Google Apps Script & ChatGPT
Please remember that becoming a member of this workshop is about educating you about Google Apps through the use of the ability of ChatGPT that will help you leapfrog over newbie to intermediate coder in 6 quick weeks. ChatGPT will more than likely present code that doesn’t work. You might want to troubleshoot and debug the code to make it work. There will likely be instances that you’re not in a position to determine tips on how to adapt the ChatGPT code to perform your venture thought. It is beneficial to start out with primary coding venture purposes till your coding expertise are practiced sufficient to have the ability to deal with extra superior subjects.
This workshop does NOT Debug for you.
Unfortunately this workshop is unable to do any debugging for you. If your code will not be working this workshop is designed to present you expertise for having a primary understanding of Google Apps Script and JavaScript to assist you to have the ability to deal with your errors within the code. Alice is unable to individually evaluate your code to find out why your code will not be working. During the dwell classes you’ll study debugging methods that you may make the most of in your individual initiatives.
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 | Managing Arrays (lists) From Google Sheets |
| Week 4 | April 23, 2023 | Coding Google Slides for Teachers |
| Week 5 | April 30, 2023 | Coding Google Calendar for Teachers |
| BREAK | May 7, 2023 | BREAK |
| Week 6 | May 14, 2023 | Coding Google Forms for Teachers |
Course Outline
Week 1: Introduction to ChatGPT and Google Apps Script
- Introduction to the course, ChatGPT, and Google Workspace instruments (Docs, Sheets, Slides, Forms, and many others.)
- Basics of Google Apps Script: objective, performance, and advantages for lecturers
- Setting up the Google Apps Script growth setting
- Introduction to JavaScript: variables, knowledge varieties, primary syntax, management buildings (loops, conditional statements)
- Using ChatGPT for coding help: discovering code examples, fixing coding issues, and producing code snippets
- Homework: Explore Google Workspace instruments and brainstorm potential classroom purposes
Week 2: Creating a Sidebar and Menus for Your Coding Project
- Understanding the Google Apps Script UI and customized menus
- Creating a customized sidebar with HTML and CSS
- Integrating the sidebar with Google Docs, Sheets, and Slides
- Using ChatGPT to generate code snippets for UI parts
- Homework: Design a customized sidebar and menu for a classroom-related venture
Week 3: Managing Arrays (lists) From Google Sheets
- Introduction to arrays and their significance in managing knowledge
- Accessing and manipulating knowledge in Google Sheets utilizing arrays
- Common array operations: sorting, filtering, and looking
- Using ChatGPT to generate code snippets for array operations
- Homework: Create a script to handle classroom knowledge in Google Sheets utilizing arrays
Week 4: Coding Google Slides for Teachers
- Overview of Google Slides API and performance
- Creating, modifying, and formatting slides utilizing Apps Script
- Automating slide technology from Google Sheets knowledge
- Using ChatGPT to generate code snippets for Google Slides operations
- Homework: Develop a script to automate Google Slides displays for classroom use
Week 5: Coding Google Calendar for Teachers
- Introduction to Google Calendar API and providers
- Creating, updating, and managing occasions utilizing Apps Script
- Automating appointment scheduling and reminders
- Using ChatGPT to generate code snippets for Google Calendar operations
- Homework: Create a script to automate Google Calendar duties for classroom administration
Week 6: Coding Google Forms for Teachers
- Overview of Google Forms API and performance
- Creating, modifying, and managing kinds utilizing Apps Script
- Automating type technology, knowledge assortment, and evaluation
- Using ChatGPT to generate code snippets for Google Forms operations
- Homework: Develop a script to boost Google Forms utilization within the classroom
- Course wrap-up: tips on how to proceed utilizing ChatGPT for coding and studying assist
- Certificate of completion for members
Who is Alice Keeler
Alice Keeler is a famend Google Developer Expert for Google Workspace and a Google Certified Innovator with years of expertise in academic expertise. As the teacher of this workshop, Alice brings a wealth of information and a ardour for serving to lecturers improve their classroom expertise via revolutionary instruments and methods.
Alice has a robust background in educating and academic expertise, which has enabled her to know the distinctive challenges lecturers face in in the present day’s dynamic academic panorama. Her experience in Google Workspace, mixed together with her revolutionary and artistic strategy to instruction, has made her a sought-after guide, speaker, and coach within the area of academic expertise.
As an creator, Alice has written a number of books as regards to expertise integration within the classroom, sharing her insights and sensible ideas with educators across the globe. In addition to her written work, Alice is a prolific blogger and social media influencer, constantly sharing beneficial sources and thought management on finest practices in edtech.
In this workshop, Alice’s participating educating type and deep understanding of Google Apps Script and ChatGPT will present members with the information, expertise, and confidence they should unlock the total potential of Google Workspace for his or her lecture rooms. Participants can anticipate a hands-on, interactive expertise that may depart them impressed and outfitted to remodel their educating observe via the ability of expertise.
-
Quickly! Take benefit of ChatGPT to discover ways to code Google Workspace with Google Apps Script. Google Developer Expert Alice Keeler will educate you tips on how to go from zero to intermediate consumer in 6 weeks. Space is restricted. Register now.
-
Oh shoot! Google up to date their interface for Google Docs, Sheets, and Slides once more. This time the Explore instrument is the sufferer of the design replace. Can you continue to entry the Explore instrument? Where is it? Where Did the Explore Tool Go?
-
Navigating copyright legal guidelines may be difficult for educators, particularly when making an attempt to create participating and informative supplies for his or her college students. However, generally we’d unknowingly violate copyright legal guidelines when utilizing sources within the classroom. To keep away from any authorized hassle, it’s important to know widespread copyright pitfalls and tips on how to navigate them. One crucial facet of copyright legislation that lecturers ought to be aware of is “fair use.” Here are methods lecturers violate copyright:
-
Unlock the ability of environment friendly on-line analysis with our weblog publish on 5 important Google Search methods each instructor ought to strive in the present day. Learn tips on how to discover correct, related, and high-quality sources for lesson planning, pupil assist, {and professional} growth. Improve your search expertise and save time, making your educating expertise extra productive and enriching. Don’t miss these beneficial ideas for mastering the artwork of looking!
-
Google Jamboard, the interactive digital whiteboard from Google Workspace, has revolutionized collaboration each out and in of the classroom. Many customers are aware of its primary options, however there’s a lot extra to find. Explore 10 lesser-known options that may aid you unlock the total potential of Google Jamboard.
-
Choice has many advantages to college students in schooling to extend their motivation, efforts, and engagement. Gamified selection boards convey collectively the ability of selection and the ability of enjoyable. Join Alice Keeler as she explains some choices for making a gamified selection board.
