Module 1. Google Form Services

• Form Services
• Create Google Form Using Script

Module 2. Custom User Interface

• HTML Services
• Build Custom HTML User Interface

Module 3. Saving and Storing Data

• Properties Servies
• Saving Data
• Reading Data

Module 4. Custom Menu 

• Create Custom Menu
• Create Custom Sidebar
• Create Custom Dialgo

Module 5. Advanced Google Script Services

• Enable Advanced Google Apps Services
• Calendar
• Drivce
• Sheets

Module 6. Advanced Triggers

• Simple Triggers
• Installable Triggers

• IT administrators
• IT developers

Prerequisite

The following prerequisite is assumed:

• Basic Google G Suite knowledge
• Basic Javascript knowledge;

Software Requirement

• Download and install Visual Studio Code https://code.visualstudio.com/

• IT administrators
• IT developers

Dr. Sarita Singh received her Ph.D. degree for her work done in the area of Information Security. She is the recipient of the prestigious Infosys fellowship for pursuing her Ph.D. Programme. She has more than twenty-five years of teaching and research experience in Singapore, Malaysia and India in the field of Programming, Information Security, Web-application Development, Computer Networks and Engineering related modules.

She has presented papers at several National and International Conferences and has written articles for magazines. She has authored text-books for Engineering courses as well.

Carey is an undergraduate at the Singapore University of Technology and Design (SUTD). He has previously interned at DSO National Laboratories, where he co-wrote a research paper on differential cryptanalysis on block ciphers. As an avid game developer, he has clinched 1st-runner twice consecutively at the Singapore Games Creation Competition.

Besides having a vested interest in machines, he tries in his capacity to make a difference in society. In 2014, he co-wrote a research paper pinpointing the location of various civil unrests in Singapore, and advocated for the importance of civil unrest commemorative markers at the Anatomy of a Riot conference organised by the Singapore Heritage Society. Thereafter, he was invited to intern at the Ministry of Home Affairs to finetune the research. If one pays attention when crossing the junction of Alexandra Road and Tanglin Road, one can spot a blue rectangular marker commemorating the 1955 Hock Lee Bus Riots. The commemorative marker was established by the National Heritage Board after consultations with his team and the Ministry of Home Affairs.

When he is not trying to meet the demands of being an undergraduate in Singapore, he might be taking solitary walks in parks, or working on his pet projects involving Arduino or Raspberry Pi microprocessors.

Dr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 1997 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.