Intro to Programming and Automation With AI Assistance – Digital Nova Scotia – Leading Digital Industry
Intro to Programming and Automation With AI Assistance

March 19 – April 4, 2024

tuesdays & thursdays from 1-3pm via zoom

Valued at $2,500 + HST, FREE for eligible DNS members (15 max)

Hosted by Michael MacMillan, MACMILLAN SEARCH

More CoursesApply Now

This 3-week course provides an introduction to scripting and Google Apps Script, emphasizing the use of ChatGPT as a learning tool. The course covers the basics of programming, the power of automation, and the setup of Google Apps Script.

Participants will progress from writing simple scripts to automating tasks in Google Sheets, Docs, and Slides. Advanced topics include automation of forms, Gmail, and calendar, troubleshooting with ChatGPT, API integration, and accessing external resources.

By the end of the course, participants will be able to automate daily tasks, debug scripts, and utilize advanced functionalities, connecting with communities for ongoing learning. The course is suitable for individuals with no prior programming experience, including professionals, educators, small business owners, administrative staff, curious learners, and consultants/freelancers looking to acquire new skills.

What will you learn? (More information in the FAQ section)
    • Week 1: Introduction to Scripting and ChatGPT (4 hours)
    • Week 2: Diving into Google Apps Script Basics with ChatGPT (4 hours)
    • Week 3: Advanced Automation and Sustained Learning (4 hours)
Who’s right for this course?

This course is designed for individuals who have no prior programming experience but want to harness the power of Google Apps Script for automation. This includes:

    • Professionals aiming to optimize their daily tasks
    • Educators seeking to introduce coding in a friendly, accessible manner
    • Small business owners looking to automate aspects of their operations
    • Administrative staff aiming to streamline repetitive tasks
    • Curious individuals ready to delve into the world of coding without prior background
    • Consultants or freelancers aiming to add a new skill set to their repertoire
    • Anyone interested in using innovative tools like ChatGPT to simplify the learning process

About the Instructor

Michael MacMillan

Michael MacMillan

Requirements

To apply your organization must

If your business is not yet generating revenue from commercial activity, you may be eligible for funding if you are in an LAE identified priority sector (See Section 4.2)

Digital Nova Scotia will facilitate the funding process based on the information provided in the application below. Employees must be receiving full-time compensation while in training to be eligible for WIPSI funding. This may include employees who are full-time seasonal.

Apply Now

Step 1: Fill Out Business Eligibility Form

Download and complete the following form to confirm your eligibility for funding. Please ensure all fields are filled correctly prior to submitting, organizations who participated in the program last year can contact us for their previous forms for reference if needed.

Download Form

Step 2: Submit Paperwork

Send in your completed form to be reviewed.

Step 3: Wait for Eligibility Confirmation

Please give us at least 3 – 5 business days to respond to your email with your eligibility. Should we require any additional information, we will follow up with you. Note, space is limited, and submitting a form does not guarantee you a spot within the program. We encourage all interested organizations to apply as soon as possible.

 

Have Questions?

Please contact Emily van den Hoogen at emily@digitalnovascotia.com

Course FAQ

[ click on a question to view the answer ]

What will the training cover?

Week 1: Introduction to Scripting and ChatGPT (4 hours) 

  • 1.1 Unveiling the Magic: What is Programming and Why Google Apps Script? 
  • 1.2 Understanding the Power of Automation in Daily Tasks 
  • 1.3 Introduction to ChatGPT: Your Personal Assistant in Learning to Code 
  • 1.4 Setting Up Google Apps Script: Your First Look at the Interface

Week 2: Diving into Google Apps Script Basics with ChatGPT (4 hours) 

  • 2.1 Writing Your First Script: Hello World and Basic Syntax
  • 2.2 Using ChatGPT to Understand and Solve Scripting Challenges 
  • 2.3 Automating Google Sheets: Reading, Writing, and Data Manipulation 
  • 2.4 Streamlining Google Docs and Slides with Basic Scripts

Week 3: Advanced Automation and Sustained Learning (4 hours) 

  • 3.1 Delving Deeper: Forms, Gmail, and Calendar Automation 
  • 3.2 Troubleshooting and Debugging: Using ChatGPT to Fix Common Errors 
  • 3.3 Beyond Basics: Introducing API Calls and External Integrations 
  • 3.4 Continual Learning: Resources, Communities, and Staying Updated

Program Outcomes

By the end of this 3-week course, participants will be able to:

  1. Understand the significance of programming in automating daily tasks;
  2. Set up, navigate, and start scripting with Google Apps Script;
  3. Utilize ChatGPT as a valuable tool in understanding coding concepts and overcoming challenges;
  4. Automate basic tasks in Google Sheets, Docs, Slides, and more;
  5. Debug scripts effectively with the assistance of ChatGPT;
  6. Explore advanced functionalities like API integration to further enhance automation capabilities and;
  7. Connect with resources and communities to foster continued learning and scripting proficiency.