Have you ever ever wished to learn to code Google Docs, Sheets, Slides, and so on…? As a instructor you’ve gotten a novel have to do duties repetitively. Code ought to aid you to do these duties extra effectively. Have you ever ever questioned “Why can’t Google do that…?” That is what Google Apps Script will help you with. Try a few of my Add-ons I’ve created for Google Workspace Apps to see how I’ve created further performance. Certainly 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 wish to learn to code however really feel that the educational curve to begin creating initiatives is just too excessive? This workshop with Google Developer Knowledgeable Alice Keeler is for you! Study to code with ChatGPT. Be a part of Alice for a 6 week interactive workshop to take you from zero to intermediate coder.
Register: House is Restricted
This workshop runs from April 2nd to Could twentieth. (Word: there’s a break the week of Could seventh). House is restricted to twenty contributors.
Registration additionally contains an AliceKeeler Membership for the 2023-2024 faculty yr (expires June 2024). A $249 worth.
Stay Classes 10am PST
Along with asynchronous instruction and duties you’re invited to affix Saturdays at 10am. In these classes we’ll attempt coding initiatives utilizing ChatGPT and troubleshooting the output. In case you are unable to take part reside you should have entry to the recording afterwards.
April eighth
April fifteenth
April twenty second
April twenty ninth
Could sixth
NOTE NO LIVE CLASS MAY thirteenth (my son is graduating from highschool)
Could twentieth
Debugging Google Apps Script & ChatGPT
Please bear in mind that becoming a member of this workshop is about instructing you about Google Apps by utilizing the ability of ChatGPT that can assist you leapfrog over newbie to intermediate coder in 6 quick weeks. ChatGPT will more than likely present code that doesn’t work. You’ll need to troubleshoot and debug the code to make it work. There can be occasions that you’re not in a position to determine easy methods to adapt the ChatGPT code to perform your venture thought. It is strongly recommended to begin 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.
Sadly this workshop is unable to do any debugging for you. In case your code isn’t working this workshop is designed to provide you expertise for having a primary understanding of Google Apps Script and JavaScript to assist you to have the ability to tackle your errors within the code. Alice is unable to individually overview your code to find out why your code isn’t working. In the course of the reside classes you’ll be taught debugging methods you can 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 | Making a Sidebar and Menus for Your Coding Mission |
Week 3 | April 16, 2023 | Managing Arrays (lists) From Google Sheets |
Week 4 | April 23, 2023 | Coding Google Slides for Academics |
Week 5 | April 30, 2023 | Coding Google Calendar for Academics |
BREAK | Could 7, 2023 | BREAK |
Week 6 | Could 14, 2023 | Coding Google Kinds for Academics |
Course Define
Week 1: Introduction to ChatGPT and Google Apps Script
- Introduction to the course, ChatGPT, and Google Workspace instruments (Docs, Sheets, Slides, Kinds, and so on.)
- Fundamentals of Google Apps Script: goal, performance, and advantages for academics
- Establishing the Google Apps Script growth setting
- Introduction to JavaScript: variables, knowledge varieties, primary syntax, management buildings (loops, conditional statements)
- Utilizing ChatGPT for coding help: discovering code examples, fixing coding issues, and producing code snippets
- Homework: Discover Google Workspace instruments and brainstorm potential classroom purposes
Week 2: Making a Sidebar and Menus for Your Coding Mission
- Understanding the Google Apps Script UI and customized menus
- Making a customized sidebar with HTML and CSS
- Integrating the sidebar with Google Docs, Sheets, and Slides
- Utilizing ChatGPT to generate code snippets for UI components
- 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
- Widespread array operations: sorting, filtering, and looking
- Utilizing 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 Academics
- Overview of Google Slides API and performance
- Creating, enhancing, and formatting slides utilizing Apps Script
- Automating slide era from Google Sheets knowledge
- Utilizing ChatGPT to generate code snippets for Google Slides operations
- Homework: Develop a script to automate Google Slides shows for classroom use
Week 5: Coding Google Calendar for Academics
- Introduction to Google Calendar API and providers
- Creating, updating, and managing occasions utilizing Apps Script
- Automating appointment scheduling and reminders
- Utilizing 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 Kinds for Academics
- Overview of Google Kinds API and performance
- Creating, enhancing, and managing varieties utilizing Apps Script
- Automating type era, knowledge assortment, and evaluation
- Utilizing ChatGPT to generate code snippets for Google Kinds operations
- Homework: Develop a script to boost Google Kinds utilization within the classroom
- Course wrap-up: easy methods to proceed utilizing ChatGPT for coding and studying assist
- Certificates of completion for contributors
Who’s Alice Keeler
Alice Keeler is a famend Google Developer Knowledgeable for Google Workspace and a Google Licensed Innovator with years of expertise in academic know-how. As the trainer of this workshop, Alice brings a wealth of data and a ardour for serving to academics improve their classroom expertise by way of modern instruments and methods.
Alice has a robust background in instructing and academic know-how, which has enabled her to know the distinctive challenges academics face in at this time’s dynamic academic panorama. Her experience in Google Workspace, mixed along with her modern and inventive strategy to instruction, has made her a sought-after advisor, speaker, and coach within the area of academic know-how.
As an writer, Alice has written a number of books with regards to know-how integration within the classroom, sharing her insights and sensible ideas with educators across the globe. Along with her written work, Alice is a prolific blogger and social media influencer, persistently sharing useful sources and thought management on greatest practices in edtech.
On this workshop, Alice’s participating instructing fashion and deep understanding of Google Apps Script and ChatGPT will present contributors with the information, expertise, and confidence they should unlock the total potential of Google Workspace for his or her lecture rooms. Individuals can anticipate a hands-on, interactive expertise that can depart them impressed and outfitted to rework their instructing observe by way of the ability of know-how.
-
Shortly! Reap the benefits of ChatGPT to learn to code Google Workspace with Google Apps Script. Google Developer Knowledgeable Alice Keeler will train you easy methods to go from zero to intermediate consumer in 6 weeks. House is restricted. Register now.
-
Navigating copyright legal guidelines could be difficult for educators, particularly when attempting to create participating and informative supplies for his or her college students. Nevertheless, generally we’d unknowingly violate copyright legal guidelines when utilizing sources within the classroom. To keep away from any authorized bother, it’s important to know frequent copyright pitfalls and easy methods to navigate them. One crucial facet of copyright legislation that academics ought to be aware of is “truthful use.” Listed below are methods academics 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 attempt at this time. Discover ways to discover correct, related, and high-quality sources for lesson planning, scholar assist, {and professional} growth. Enhance your search expertise and save time, making your instructing expertise extra productive and enriching. Don’t miss these useful 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. Discover 10 lesser-known options that can aid you unlock the total potential of Google Jamboard.