Workshop: Study to Code with ChatGPT

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.

  • Feature: Create Gamified Choice Board by Category

    A characteristic added to an Add-on for Google Sheets permits you to flip it right into a Google Slides alternative board. Use the Roster Extras for Schoolytics Add-on in Google Sheets to shortly create a gamified alternative board. Function: Create Gamified Alternative Board by Class

  • Workshop: Learn to Code with ChatGPT

    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.

  • Google Explore, What Happened to It?

    Oh shoot! Google up to date their interface for Google Docs, Sheets, and Slides once more. This time the Discover software is the sufferer of the design replace. Can you continue to entry the Discover software? The place is it? The place Did the Discover Device Go?

  • 10 Ways Teachers Violate Copyright (and How to Avoid It)

    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:

  • 5 Google Search Techniques to Try Today

    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!

  • 10 Hidden Google Jamboard Gems

    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.