WSQ - IT Automation with Google Apps Script

Topic 1: Getting Started with Google Apps Script 

• Overview of Google Apps Script and its capabilities
• Navigating and utilizing the Google Apps Script Editor
• Creating and running basic scripts
• Understanding Mail Service and basic automation scripts

Topic 2: Automating Google Sheets with Script 

• Introduction to Spreadsheet Service
• Utilizing Sheet and Range Methods for automation
• Manipulating cell values and applying formulas programmatically

Topic 3: Scripting for Google Docs and Google Slides

• Utilizing Document and Slide Services for automation
• Scripting methods for text manipulation and slide modification
• Integrating Google Docs and Slides with other Google services

Topic 4: Google Calendar and Google Drive Scripting 

• Automating tasks with Calendar Service, including event creation
• Leveraging Drive Service for file and folder management
• Implementing API-level integrations with Google Drive and Google Calendar

Topic 5: Working with Triggers and Data Management 

• Setting up Time-Driven Triggers and auto-email alerts
• Managing data across Google Apps Script services
• Automating file duplication and folder sharing

Topic 6: HTML Services and Web App Development 

• Utilizing HTML Services for web app creation
• Communicating with server functions and deploying web apps
• Integrating Google Sheets data into HTML web apps

Topic 7: Custom Menu, Dialogs, and Sidebars 

• Developing Bound Scripts and Custom Menus in Google Workspace
• Utilizing Dialogs and Sidebars for user interaction
• Implementing OnOpen Triggers for automation

Topic 8: Creating and Utilizing Custom Functions 

• Designing custom functions for specific tasks
• Troubleshooting and optimizing custom scripts for performance
• Addressing compatibility and technical issues in script integration

Final Assessment 

• Written Assessment (Short Answers Questions)
• Practical Performance

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.

Target Age Group: 21 to 65 years old

Minimum Software/Hardware Requirement

Software:

You can download and install the following software:

• Google Apps Script
• Google Colab

Sign up for free Google account

Hardware: Windows and Mac Laptops

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity. 

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Steps to Apply Skills Future Claim

• The staff will send you an invoice with the fee breakdown.
• Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
• Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
• Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The  SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

• Log in to your U Portal account to submit your UTAP application upon completion of the course.

Note

• SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
• All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
• An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
• UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
• UTAP support amount will be paid to training provider first and claimed after end of class by learner.

• Google Apps Script Developer
• Automation Engineer
• Workflow Specialist
• IT Project Manager
• Technical Support Engineer
• Data Analyst
• Application Developer
• Systems Analyst
• Business Intelligence Analyst
• Web Developer
• Software Engineer
• Cloud Solutions Architect
• IT Consultant
• Operations Analyst
• Business Systems Analyst
• Integration Specialist
• Quality Assurance Tester
• User Experience Designer
• Database Administrator
• Digital Transformation Specialist

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc.  Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.  An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Truman Ng: Truman Ng is a ACTA certified trainer that graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project.

Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States.

Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philippines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc.

Leon Ye Jin Hong: Leon Ye Jin Hong is a ACTA certified trainer.  He have exprience in RPA Architect, Test Automation lead, Coach and Trainer, Cloud Engineer(Azure) and Data Analysis. The Automation solutions have benefited Land Transport Authority, MINDEF Singapore, Ministry of Education(MOE), Ministry of Development(MND) Singapore Press Holdings(sph),ST Engineering, Accenture, Defence Science & Technology Agency(DSTA) and Singapore Exchange. Some Robotic Process Automation that he experience in: Automated Booking System(Customer Service), Finance Invoice Processing, HR Recruitment, HR onboarding & Offboarding and Automated Data Exchange & Reporting Generation.