MS FORM AND MICROSOFT POWER AUTOMATE (SF)

Course Overview

The course is designed to equipped students with the basic skills needed to create a Microsoft Form integrated with Power Automate workflows. Upon course completion, learners will be able to create an automated task that streamlines business processes embedded with an electronic method of storing and managing data.

Course Objectives

Upon course completion, learners will be able to:

• Know the basic foundation of MS Form.
• Create a MS Form.
• Manage a form solution.
• Understand when to use Flow.
• Describe the components of Flow and their correct use.
• Create and edit Flows.
• Know the benefits of Flow.
• Integrate Flow with other solutions

Pre-requisites

Required Prerequisites:

• Basic knowledge of Microsoft Office Application
• Basic knowledge of Windows OS and web browsers

• Hardware & Software

This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must own a zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download

System Requirement

Must Have: Please ensure that your computer or laptop meets the following requirements. Operating system: Windows 10 or MacOS (64 bit or above) Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher Minimum 20 GB hard disk space. Minimum 8 Gb RAM Webcam (The camera must be turned on for the duration of the class) Microphone Internet Connection: Wired or Wireless broadband Latest version of Zoom software to be installed on computer or laptop prior to the class.

Course Outline

Module 1: What is Microsoft Form

• Some Use Cases for Microsoft Form

Module 2: Getting Started with Creating a Form

• Creating and Enabling an account

Module 3: Choosing the Appropriate Field Types

• Basic Input Fields
• Fields with Input Validations
• Layout Types for Content Organization

Module 4: Forms Management and Publishing

• Form Management
• Form Publishing

Module 5: An Introduction to Microsoft Form and Power Automate

• What are business processes?
• Life before Power Automate
• Migration
• Power Automate Overview
• Power Automate licensing
• Power Automate actions

Module 6: Getting Started

• Using Power Automate templates
• Navigating in Power Automate
• Editing a Flow
• Publish and trigger a Flow
• Turn off or delete a Flow

 

Module 7: Automation logic

• Adding conditions
• Designing switches
• Using apply to each
• Configuring do until logic
• Adding a scope

Module 8: Integration

• Standard and premium connectors
• Connecting to web services
• Using Flow with on-premises data

Module 9: The Power Automate Mobile App

• Downloading the mobile app
• Signing in and account management
• Building and managing Flows
• Creating buttons
• Feeds and approvals

Module 10: Administration and maintenance

• Maintaining a Flow
• View history and analytics
• Sharing a Flow
• Export and import Flows
• Office 365 administration for Flow
• Environments
• Data policies
• Data integration

Certificate Obtained and Conferred by

• Certificate of completion from NTUC LearningHub

Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.

Additional Details

Medium of Instruction: English

Trainer:Trainee Ratio is 1:20

Mode of Delivery: Virtual Live Class (VLC) via Zoom

As this is a government subsidised programme, the entire training programme will be video recorded for audit purposes by the relevant funding agency. To ascertain their presence, Trainees / Participants are required to

• Turn on web camera to show real-time video, as opposed to using a profile picture / video (jpg/jpeg, gif or png image file) for the entirety of the training and assessment session.
• Ensure that their faces are fully visible (not just the forehead / eyebrows)
• Use their full name as per NRIC / Passport as their Screen Name on Zoo

Price

Course Fee and Government Subsidies
	Individual Sponsored		Company Sponsored
			Non-SME		SME
	Before GST	After GST	Before GST	After GST	Before GST	After GST
Full Course Fee (For Foreigners and those not eligible for subsidies)	$1,000.00	$1,090.00	$1,000.00	$1,090.00	$1,000.00	$1,090.00
For Singapore Citizens aged 39 years and below and For all Singapore Permanent Residents (The minimum age for individual sponsored trainees is 21 years)	$300.00	$327.00	$300.00	$327.00	$100.00	$127.00
For Singapore Citizens aged 40 years and above	$100.00	$127.00	$100.00	$127.00	$100.00	$127.00

Funding Eligibility Criteria:

Individual Sponsored Trainee

Company Sponsored Trainee

Singapore Citizens or Singapore Permanent Residents From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses Trainee must pass all prescribed tests / assessments, and attain 100% competency NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria

Singapore Citizens or Singapore Permanent Residents From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses Trainee must pass all prescribed tests / assessments, and attain 100% competency NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria

Remarks:

Individual Sponsored Trainee	Company Sponsored Trainee
SkillsFuture Credit: Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding UTAP: NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP)	Absentee Payroll (AP) Funding: $4.50 per hour, capped at $100,000 per enterprise per calendar year AP funding will be computed based on the actual number of training hours attended by the trainee Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim.

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.