Data & Automation for Ops & Automation Specialist in Wholesale Trade

Short Course / 6-9 months

Note: Application for this course is not open, please register your interest to receive an email notification for the next run.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Entry Requirements
Course Fees

Course Information

This is a basic/intermediate course for learners to pursue an entry-level career in operations, procurement and sourcing within the Wholesale Trade sector.

Understand how data is stored, retrieved, analyzed, visualized and interpreted.

In addition, the bridging course provides foundational skills in literacy, numeracy and digital literacy to navigate the demands of this course and the future workplace.

Learning Outcomes

You will learn how work processes can be automated and streamlined. The skills gained can be applied in practically any discipline to increase productivity and effectiveness.

You will also gain exposure to functions such as technology integration.



All courses are designed to have a blend of online and in-person learning on campus. The detailed learning plan shall be shared with you by the instructors.

Application Period (without Bridging Course): 10 Nov 2020 to 7 Feb 2021

Application Period (with Bridging course): 10 Nov to 14 Dec 2020

Course Duration: 3 months (bridging course if required) + 6 months (core course)

Bridging Course

4 Jan to 7 Jan 2021 – Digital Learning Beginner Workshop (16 hours)

11 Jan to 14 Jan 2021 – SkillsFuture for Digital Workplace (14 hours)

15 Jan to 22 Jan 2021 – Workplace Numeracy (Intermediate) (30 hours)

25 Jan to 15 Feb 2021 – Workplace Literacy Comprehensive (Beginner/Intermediate) (90 hours)

16 Feb to 19 Feb 2021 – Financial Literacy (Optional) (16 hours)

Core Course
Duration: Mar 2021
Schedule: Weekdays, either 9am to 1pm or 2pm to 6pm

Lesson Plan

This course consists of 5 modules:

Bridging Course

The bridging course is meant for individuals who are unable to meet the entry requirements of the core course. Individuals will be required to complete the 3-month bridging course and attain the relevant level of numeracy and literacy before proceeding to read the core course.

The bridging course comprises a package of courses which build foundational skills in literacy, numeracy and digital literacy:

  1. Workplace Literacy Comprehensive (Beginner/Intermediate) – 90 hours
  2. Workplace Numeracy (Intermediate) – 30 hours
  3. SkillsFuture for Digital Workplace – 14 hours
  4. Digital Learning Beginner Workshop – 16 hours
  5. Financial Literacy (Optional) – 16 hours
Workflow Automation

This module provides participants with an understanding of the essential aspects of both Power Apps and Power Automate tools, without the need to write code. The module teaches foundational skills to build, publish, and share simple mobile friendly apps to access data using Power Apps; create automated workflows using Power Automate; and how to integrate these two tools together.


Data Analytics & Visualization

This module discusses the techniques and algorithms for creating effective visualizations based on principles and techniques from graphic design, visual art, to perceptual psychology and cognitive science.



Corporate databases are set up to hold the voluminous business transactions generated by various information systems. This module introduces the underlying concepts of database systems and how to model and design database systems that reflect business requirements. Participants will be taught how to analyze data needs, model the relationships amongst the data entities, apply normalization processes to relations, create the physical database and SQL (Structured Query Language).


Spreadsheet Engineering

The spreadsheet is an indispensable tool for professionals to solve business problems and make better informed decisions. This module will introduce the use of spreadsheets as a reporting and modelling tool. Using a commercial spreadsheet system such as Microsoft Excel, participants will explore various spreadsheet functions and simple macros used for analyzing, formatting and presenting data.



Certificate will be awarded to participants who achieve at least 75% attendance and pass assessments.

Entry Requirements

Applicants with any of the following qualifications are invited to apply for the course:

GCE ‘O’ Level grades:
– English Language (1-6)
– Mathematics (Elementary/Additional) (1-6)

OR have been assessed and attained proficiency level 6 of the Workplace Literacy (WPL) and Workplace Numeracy (WPN) series. To assess your level of proficiency, you should take a pre-training test with British Council here. If the level of proficiency is at one level below Level 6, you will be required to complete our 3-month bridging course. Upon attainment of level 6, we will proceed to enroll you into the core course.

Applicants should have basic digital literacy and be willing to acquire new technical skills.

Must have working knowledge of Microsoft Office e.g. Word, Excel and Powerpoint

Students enrolled into the course are expected to bring along their personal laptop with the Windows 10 operating system installed.

Course Fees

Full Fees (incl GST):
$10,165 (including bridging course)
$6,420 (excluding bridging course)

Singaporeans & Permanent Residents (incl GST):
$750 (including bridging course),
$500 (excluding bridging course)

Trainees must fulfil minimum attendance requirements and pass assessments to qualify for course fee subsidies. Trainees who are unable to meet these requirements may be asked to return the course fee subsidies that they have received.

Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.

Applicants / Eligibility Fees
Full Fees (including bridging course)$10165.00
Full Fees (excluding bridging course)$6420.00
Singaporeans & Permanent Residents (including bridging course)$750.00
Singaporeans & Permanent Residents (excluding bridging course)$500.00