April 13, 2024

Have you ever ever wished to learn to code Google Docs, Sheets, Slides, and so on…? As a instructor you might have a singular must do duties repetitively. Code ought to assist you to 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 extra performance. Considered 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 learn to code however really feel that the training curve to begin creating tasks 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 Might twentieth. (Notice: there’s a break the week of Might seventh). House is restricted to twenty contributors.

Registration additionally contains an AliceKeeler Membership for the 2023-2024 college 12 months (expires June 2024). A $249 worth.

Stay Classes 10am PST

Along with asynchronous instruction and duties you might be invited to affix Saturdays at 10am. In these periods we’ll attempt coding tasks utilizing ChatGPT and troubleshooting the output. If you’re unable to take part stay you should have entry to the recording afterwards.

April eighth
April fifteenth
April twenty second
April twenty ninth
Might sixth
NOTE NO LIVE CLASS MAY thirteenth (my son is graduating from highschool)
Might twentieth

Debugging Google Apps Script & ChatGPT

Please remember that becoming a member of this workshop is about educating you about Google Apps by utilizing the facility of ChatGPT that can assist you leapfrog over newbie to intermediate coder in 6 quick weeks. ChatGPT will most probably present code that doesn’t work. You have to to troubleshoot and debug the code to make it work. There can be instances that you’re not in a position to determine easy methods to adapt the ChatGPT code to perform your venture thought. It is suggested to begin with primary coding venture purposes till your coding abilities are practiced sufficient to have the ability to deal with extra superior matters.

This workshop does NOT Debug for you.

Sadly this workshop is unable to do any debugging for you. In case your code is just not working this workshop is designed to provide you abilities for having a primary understanding of Google Apps Script and JavaScript to assist you to have the ability to handle your errors within the code. Alice is unable to individually overview your code to find out why your code is just not working. Through the stay periods you’ll be taught debugging methods you could make the most of in your personal tasks.

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 Might 7, 2023 BREAK
Week 6 Might 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: objective, performance, and advantages for lecturers
  • Organising the Google Apps Script improvement atmosphere
  • Introduction to JavaScript: variables, knowledge sorts, primary syntax, management constructions (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 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
  • Frequent 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, modifying, and formatting slides utilizing Apps Script
  • Automating slide technology from Google Sheets knowledge
  • Utilizing 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 Academics

  • Introduction to Google Calendar API and companies
  • 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, modifying, and managing varieties utilizing Apps Script
  • Automating kind technology, 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 instructional know-how. As the teacher of this workshop, Alice brings a wealth of data and a ardour for serving to lecturers improve their classroom expertise via revolutionary instruments and strategies.

Alice has a robust background in educating and academic know-how, which has enabled her to know the distinctive challenges lecturers face in as we speak’s dynamic instructional panorama. Her experience in Google Workspace, mixed together with her revolutionary and inventive method to instruction, has made her a sought-after advisor, speaker, and coach within the subject of instructional know-how.

As an writer, Alice has written a number of books with reference 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 assets and thought management on finest practices in edtech.

On this workshop, Alice’s partaking educating model and deep understanding of Google Apps Script and ChatGPT will present contributors with the information, abilities, and confidence they should unlock the total potential of Google Workspace for his or her lecture rooms. Members can count on a hands-on, interactive expertise that may go away them impressed and geared up to remodel their educating observe via the facility of know-how.

  • Workshop: Learn to Code with ChatGPT

    Shortly! Make the most 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 person 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 instrument is the sufferer of the design replace. Can you continue to entry the Discover instrument? The place is it? The place Did the Discover Instrument Go?

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

    Navigating copyright legal guidelines could be difficult for educators, particularly when making an attempt to create partaking and informative supplies for his or her college students. Nonetheless, typically we’d unknowingly violate copyright legal guidelines when utilizing assets within the classroom. To keep away from any authorized hassle, it’s important to know frequent copyright pitfalls and easy methods to navigate them. One essential side of copyright legislation that lecturers needs to be aware of is “truthful use.” Listed here are methods lecturers violate copyright:

  • 5 Google Search Techniques to Try Today

    Unlock the facility of environment friendly on-line analysis with our weblog submit on 5 important Google Search strategies each instructor ought to attempt as we speak. Learn to discover correct, related, and high-quality assets for lesson planning, scholar assist, {and professional} improvement. Enhance your search abilities and save time, making your educating 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 may assist you to unlock the total potential of Google Jamboard.

  • Gamified Choice Boards

    Selection has many advantages to college students in training to extend their motivation, efforts, and engagement. Gamified alternative boards convey collectively the facility of alternative and the facility of enjoyable. Be a part of Alice Keeler as she explains some choices for making a gamified alternative board.