Course Content
KM-01: Introduction to RPA and Digital Transformation
This module introduces learners to the fundamentals of Robotic Process Automation (RPA), digital transformation, and automation technologies used in modern business environments. Learners will explore how businesses use automation to improve efficiency, reduce repetitive tasks, and support digital innovation.
0/7
KM-01-KT01 — Robotic Process Automation (RPA) Basics – Part 1
Lesson 1 Part 1 Quiz.
KM-01-KT01 — Robotic Process Automation (RPA) Basics – Part 2
Lesson 1 Part 2 Quiz.
KM-01-KT02 — Background on RPA
Lesson 2 Quiz.
Summative Assessment — KM-01: Overview of Robotic Process Automation
KM-02: Basic Calculations and Logical Thinking
This module develops foundational mathematical, analytical, and logical thinking skills required in Robotic Process Automation (RPA) and digital problem-solving environments. Learners will strengthen their ability to perform calculations, analyse information, apply logical reasoning, and solve structured business and technology problems.
0/23
KM-02-KT01 — Mathematical Thinking Skills for Problem Solving
Lesson 1 Quiz.
KM-02-KT02 — Conversion Between Decimal and Binary Systems
Lesson 2 Quiz.
KM-02-KT03 — Expressing Size and Magnitude
Lesson 3 Quiz.
KM-02-KT04 — Error in Calculations
Lesson 4 Quiz.
KM-02-KT05 — Cartesian Coordinate System
Lesson 5 Quiz.
KM-02-KT06 — Pythagorean Theorem for Finding the Distance Between Two Points
Lesson 6 Quiz.
KM-02-KT07 — Operator Precedence
Lesson 7 Quiz.
KM-02-KT08 — Integer Division
Lesson 8 Quiz.
KM-02-KT09 — Modulus
Lesson 9 Quiz.
KM-02-KT10 — Increments
Lesson 10 Quiz.
KM-02-KT11 — Mixing Types
Lesson 11 Quiz.
KM-02: Basic Calculations and Logical Thinking: Revision
KM-03: Computing and Digital Concepts
This module introduces learners to foundational computing concepts, digital systems, and information technology principles used in modern automation and business environments. Learners will explore computer components, operating systems, networking, cybersecurity, software applications, and digital communication technologies relevant to Robotic Process Automation (RPA) and 4IR workplaces.
0/19
KM-03-KT01 — Problem Solving Skills for IT Professionals
Lesson 1 Quiz.
KM-03-KT02 — Cloud Computing
Lesson 2 Quiz.
KM-03-KT03 — Security Fundamentals
Lesson 3 Quiz.
KM-03-KT04 — Programming and Development
Lesson 4 Quiz.
KM-03-KT05 — Database Fundamentals
Lesson 5 Quiz.
KM-03-KT06 — Web Technologies and Internet Concepts
Lesson 6 Quiz.
KM-03-KT07 — Emerging Technologies and Digital Transformation
Lesson 7 Quiz.
KM-03-KT08 — Ethics, Privacy, and Digital Responsibility
Lesson 8 Quiz.
KM-03-KT09 — Careers and Professional Skills in Technology
Lesson 9 Quiz.
Summative Assessment — KM-03: Computing and Digital Concepts
KM-04: Computing Theory
This module introduces learners to the foundational principles of programming and computing theory used in software development and automation environments. Learners will explore programming languages, programming logic, algorithms, variables, operators, loops, functions, and software applications commonly used in modern computing systems. The module also introduces concepts related to web technologies, databases, artificial intelligence, and software development methodologies.
0/7
KM-04-KT01 — Introduction to Programming Languages
Lesson 1 Quiz.
KM-04-KT02 — Programming Basics
Lesson 2 Quiz.
KM-04-KT03 — Software Applications
Lesson 3 Quiz.
Summative Assessment — KM-04: Computing Theory
KM-05: Data, Databases and Data Scraping
This module introduces learners to the principles of data management, databases, and data scraping used in modern digital and automation environments. Learners will explore how organisations collect, store, analyse, secure, and visualise data to support business processes and decision-making. The module also introduces structured query language (SQL), relational databases, web scraping techniques, and software tools used for analysing and visualising data in automation and RPA environments.
0/13
KM-05-KT01 — Data and Data Processing
Lesson 1 Quiz.
KM-05-KT02 — Databases, Data Storage and Access to Data
Lesson 2 Quiz.
KM-05-KT03 — Structured Query Language (SQL)
Lesson 3 Quiz.
KM-05-KT04 — Data Scraping
Lesson 4 Quiz.
KM-05-KT05 — Software for Analysing and Visualising Data
Lesson 5 Quiz.
KM-05-KT06 — Data Security
Lesson 6 Quiz.
Summative Assessment — KM-05: Data, Databases and Data Scraping
KM-06: Introduction to RPA for Automation of Processes
This module introduces learners to the foundational concepts, technologies, and processes involved in Robotic Process Automation (RPA). Learners will explore automation principles, business process analysis, workflow automation, process mapping, bots, attended and unattended automation, and the role of RPA in improving operational efficiency. The module also examines how organisations identify processes suitable for automation and how RPA supports digital transformation initiatives.
0/7
KM-06-KT01 — Using a Toolkit/Platform
Lesson 1 Quiz.
KM-06-KT02 — Business Processes, Analysis and Process Modelling
Lesson 2 Quiz.
KM-06-KT03 — Workflow and Automation
Lesson 3 Quiz.
Summative Assessment — KM-06: Introduction to RPA for Automation of Processes
KM-07: Robotic Process Automation (RPA)
This module focuses on building an understanding of how to use a toolkit or platform, using a vendor-specific approach, for the creation and deployment of automated processes. Learners will explore variables, arguments, automation selectors, control flow, data manipulation, automation concepts, automation management, and methods used to secure the RPA ecosystem from security risks. The module develops practical knowledge required to build, manage, and support automation solutions within modern RPA environments.
0/15
KM-07-KT01 — Variables and Arguments
Lesson 1 Quiz.
KM-07-KT02 — Automation and Selectors
Lesson 2 Quiz.
KM-07-KT03 — Control Flow
Lesson 3 Quiz.
KM-07-KT04 — Data Manipulation
Lesson 4 Quiz.
KM-07-KT05 — Automation Concepts and Techniques
Lesson 5 Quiz.
KM-07-KT06 — Automation Management
Lesson 6 Quiz.
KM-07-KT07 — Securing the RPA Ecosystem from Security Risks
Lesson 7 Quiz.
Summative Assessment — KM-07: Robotic Process Automation (RPA)
KM-08: Introduction to RPA Governance, Legislation and Ethics
This module introduces learners to governance, legislation, compliance, ethics, and responsible practices within Robotic Process Automation (RPA) environments. Learners will explore legal requirements, organisational governance, ethical considerations, compliance frameworks, privacy protection, intellectual property, accountability, and professional conduct related to automation technologies. The module also examines how organisations manage risk, maintain compliance, and ensure ethical use of RPA systems within modern digital business environments.
0/19
KM-08-KT01 — Governance in RPA Environments
Lesson 1 Quiz.
KM-08-KT02 — Legislation in RPA Environments
Lesson 2 Quiz.
KM-08-KT03 — Introduction to Ethics and Security
Lesson 3 Quiz.
KM-08-KT04 — Ethics at Work
Lesson 4 Quiz.
KM-08-KT05 — Security
Lesson 5 Quiz.
KM-08-KT06 — Performance Management
Lesson 6 Quiz.
KM-08-KT07 — Business Planning
Lesson 7 Quiz.
KM-08-KT08 — Costing of Products
Lesson 8 Quiz.
KM-08-KT09 — Resources
Lesson 9 Quiz.
Summative Assessment — KM-08: Introduction to RPA Governance, Legislation and Ethics
KM-09: Fundamentals of Design Thinking and Innovation
This module introduces learners to the fundamentals of design thinking and innovation within modern business and technology environments. Learners will explore design thinking principles, human-centered design, creativity, innovation, design concepts, design thinking methodologies, and the practical application of design thinking in software development, cybersecurity, and business problem-solving. The module focuses on developing innovative thinking, problem-solving skills, and creative approaches used in modern workplaces and digital transformation environments.
0/15
KM-09-KT01 — Introduction to Design Thinking
Lesson 1 Quiz.
KM-09-KT02 — The Human Element
Lesson 2 Quiz.
KM-09-KT03 — Creativity
Lesson 3 Quiz.
KM-09-KT04 — Innovation
Lesson 4 Quiz.
KM-09-KT05 — Design
Lesson 5 Quiz.
KM-09-KT06 — Design Thinking Methodology
Lesson 6 Quiz.
KM-09-KT07 — Application of Design Thinking
Lesson 7 Quiz.
Summative Assessment — KM-09: Fundamentals of Design Thinking and Innovation
KM-10: 4IR and Future Skills
This module focuses on building an understanding of the impact of the Fourth Industrial Revolution (4IR) on communities, individuals, and businesses, as well as the future skills required in modern digital environments. Learners will explore emerging 4IR technologies, computing knowledge, future skills and competencies, business trends, interpersonal and intrapersonal skills, communication methods, workplace teamwork, customer service, and professional workplace practices required within modern organisations and Robotic Process Automation (RPA) environments.
0/29
KM-10-KT01 — 4IR Emerging Trends
Lesson 1 Quiz.
KM-10-KT02 — Computing Knowledge
Lesson 2 Quiz.
KM-10-KT03 — Future Skills and Competencies (4IR)
Lesson 3 Quiz.
KM-10-KT04 — 4IR Trends Affecting Businesses
Lesson 4 Quiz.
KM-10-KT05: Interpersonal Skills
Lesson 5 Quiz.
KM-10-KT06: Intrapersonal Skills
Lesson 6 Quiz.
KM-10-KT07: Communication Principles and Methods
Lesson 7 Quiz.
KM-10-KT08: Written Business Communication
Lesson 8 Quiz.
KM-10-KT09: Presentation Skills
Lesson 9 Quiz.
KM-10-KT10: Teamwork in the Workplace
Lesson 10 Quiz.
KM-10-KT11: Committees and Meetings
Lesson 11 Quiz.
KM-10-KT12: Job Descriptions and Profiles
Lesson 12 Quiz.
KM-10-KT13: Customers and Stakeholders
Lesson 13 Quiz.
KM-10-KT14: Customer Service
Lesson 14 Quiz.
Summative Assessment — KM-10: 4IR and Future Skills
PM-01: Basic Calculations for Programming
This practical module introduces learners to the mathematical and computational concepts required in programming and automation environments. Learners will develop practical skills in number systems, measurement conversions, mathematical operations, scientific notation, logical calculations, and computational problem solving. The module focuses on applying calculations and numerical reasoning in software development and Robotic Process Automation (RPA) environments. Learners will complete practical activities that strengthen analytical thinking, accuracy, and computational problem-solving skills required in modern digital workplaces.
0/16
PM-01-PS01: Number Bases and Measurement Units
Practical Assessment
PM-01-PS02: Basic Math
Practical Assessment
PM-01-PS03: Operator Precedence
Practical Assessment
PM-01-PS04: Integer Division
Practical Assessment
PM-01-PS05: Modulus
Practical Assessment
PM-01-PS06: Increments
Practical Assessment
PM-01-PS07: Mixing Types
Practical Assessment
PM-01-PS08: Casting (Timing and Contextualising)
Practical Assessment
PM-02: Basic Programming
This practical module introduces learners to fundamental programming concepts, software toolkits, coding environments, programming paradigms, data types, APIs, functions, logical operations, loops, SQL queries, error handling, and software development processes used in Robotic Process Automation (RPA) environments. Learners will develop practical programming skills by creating coding environments, writing and testing code, working with variables and functions, integrating APIs, handling errors, and developing simple automation solutions using industry-relevant software toolkits and platforms.
0/15
PM-02-PS01: Source and Compare at Least Three Software Toolkits/Platforms/Languages Used in Your Field of Studies
PM-02-PS02: Create a Development Environment
PM-02-PS03: Write and Execute Basic Program Code
PM-02-PS04: Use Variables and Constants
PM-02-PS05: Select and Use Correct Data Types (Tailored to a Specific Tool or Platform)
PM-02-PS06: Use Complex Types to Organise Data (Tailored to a Specific Tool or Platform)
PM-02-PS07: Add API’s (Application Programming Interface) to an Application (Tailored to a Specific Tool or Platform)
PM-02-PS08: Define a Function (Tailored to a Specific Tool or Platform)
PM-02-PS09: Use Logical Branch Statements and Comparison Operators (Tailored to a Specific Tool or Platform)
PM-02-PS10: Code Loops (Tailored to a Specific Tool or Platform)
PM-02-PS11: Use and Apply Variable Scopes (Tailored to a Specific Tool or Platform)
PM-02-PS12: Create Queries to Pull Desired Data Using a Structured Query Language (SQL) (Applicable to Database) (Tailored to a Specific Tool or Platform)
PM-02-PS13: Handle Errors (Tailored to a Specific Tool or Platform)
PM-02-PS14: Apply the General Steps for Writing Code (Tailored to a Specific Tool or Platform)
Practical Module: PM-02 — Basic Programming
PM-03: Access, Analyse and Visualise Structured Data Using Spreadsheets and Scraping Tools
This practical module focuses on developing the skills required to access, analyse, organise, transform, visualise, and report structured data using spreadsheets, dashboards, pivot tables, databases, and web scraping tools within a Robotic Process Automation (RPA) environment. Learners will work with spreadsheet reporting, dashboards, pivot tables, SQL imports, data models, charts, and web scraping techniques to process and visualise data for business decision-making.
0/12
PM-03-PS01: Report Data Using Spreadsheets
PM-03-PS02: Summarise and Format Data Using Spreadsheet Tables
PM-03-PS03: Create, Use and Edit Pivot Tables and Pivot Charts
PM-03-PS04: Create, Use and Edit Dashboards
PM-03-PS05: Create and Configure Hierarchies and Time Data
PM-03-PS06: Apply a Spreadsheet Data Model
PM-03-PS07: Import Data from Files
PM-03-PS08: Import Data from Databases
PM-03-PS09: Import Data from Reports
PM-03-PS10: Visualize Data
PM-03-PS11: Scrape Data from the Web Using an Appropriate Tool
PM-03 Summative Practical Assessment - Access, Analyse and Visualise Structured Data Using Spreadsheets and Scraping Tools
PM-04: Model and Develop Robotic Automated Process (RPA) Solutions
This practical module focuses on developing the practical skills required to model, design, build, organise, document, and maintain Robotic Process Automation (RPA) solutions within business environments. Learners will work with Process Design Documents (PDDs), software robot workflows, automation tools, data analysis, algorithms, reusable components, documentation standards, and industry best practices to develop resilient RPA solutions that emulate human actions.
0/9
PM-04-PS01: Identify the Process and Objects from the Process Design Document (PDD) Pertaining to the Software RPA Solution
PM-04-PS02: Formulate Scripted Actions and a Feedback Response Based on the Analysis
PM-04-PS03: Build the Software Code or Workflows for Software Robots for Each Component of RPA Solution as per the SDD
PM-04-PS04: Perform Data Analysis to Understand and Identify the Types of Variables, Arrays and Dictionaries
PM-04-PS05: Program Basic Algorithms and Evaluate Program Correctness
PM-04-PS06: Organize Projects for Efficiency and Easy Maintenance
PM-04-PS07: Adhere to Industry Best Practices
PM-04-PS08: Ensure Documentation is Updated According to Required Standards
PM-04 Summative Practical Assessment - Model and Develop Robotic Automated Process (RPA) Solutions
PM-05: Execute Test Procedures for Evaluating the RPA Solution Performance
This practical module focuses on developing the practical skills required to prepare, execute, evaluate, and improve test procedures for Robotic Process Automation (RPA) solutions. Learners will work with test cases, testing methodologies, simulation tools, workflow evaluations, exception handling, and remedial actions to determine whether an RPA solution passes or fails according to business and technical requirements. Learners will also develop the ability to analyse automation outcomes, identify application and workflow issues, document test evidence, and apply corrective actions to improve automation reliability and performance.
0/4
PM-05-PS01: Assist with the Preparation of Test Procedures for a New RPA Solution
PM-05-PS02: Test the New RPA Solution, Evaluate the Robot’s Performance Through Test Cases and Decide Whether the Robot Passes or Fails
PM-05-PS03: Take Remedial Action to Address Any Exception to Desired Outcomes
PM-05 Summative Practical Assessment - Execute Test Procedures for Evaluating the RPA Solution Performance
PM-06: Deploy RPA Solutions Which Emulate Actions of a Human Interacting Within Digital Systems
This practical module focuses on developing the practical skills required to deploy, schedule, monitor, manage, and maintain Robotic Process Automation (RPA) solutions within production environments. Learners will work with unattended and attended robots, deployment procedures, process documentation, auditing dashboards, scheduling systems, and RPA environment management tools. Learners will also develop the ability to schedule automated workflows, deploy bots into production environments, update process documentation, train end-users, monitor runtime activities, and import or export automation solutions between environments.
0/7
PM-06-PS01: Schedule Times that the RPA Solutions Must Run as per Design Specifications (Coding) for Unattended Robots
PM-06-PS02: Deploy the RPA Solution into the Production Environment (Go Live)
PM-06-PS03: Update Process Documentation
PM-06-PS04: Enable RPA Users (if Necessary), to Understand How the Automation Works and How They Should Interact with the Robots (Attended Robots – Human Triggers) on Business Need Basis
PM-06-PS05: Monitor the RPA Solution Status Through Auditing Logs and Dashboards
PM-06-PS06: Import and Export RPA Solutions
PM-06 Summative Practical Assessment - Deploy RPA Solutions Which Emulate Actions of a Human Interacting Within Digital Systems
PM-07: Modify and Improve Existing RPA Solutions
This practical module focuses on developing the practical skills required to troubleshoot, improve, maintain, and optimise existing Robotic Process Automation (RPA) solutions within operational environments. Learners will work with debugging tools, workflow optimisation techniques, infrastructure changes, software upgrades, regulatory requirements, and process improvement strategies to ensure that automation workflows continue to operate efficiently and reliably. Learners will also develop the ability to investigate alternative solutions, apply continuous improvement techniques, manage changes in technical environments, explore workflow scalability, and update robotic workflows when organisations upgrade RPA software versions.
0/6
PM-07-PS01: Troubleshoot Problems and Performance
PM-07-PS02: Investigate and Document Better Practices and Alternative Solutions that Could Be Used in Future Development (New Requirements)
PM-07-PS03: Update and Maintain Developer Standards (Best Practice) Around RPA Best Practices to Adapt Due to Regulatory and Market Pressures
PM-07-PS04: Explore Process Improvements
PM-07-PS05: Update Robotic Workflows Should the Company (Client) Update its RPA Software Version
PM-07 Summative Practical Assessment - Modify and Improve Existing RPA Solutions
PM-08: Function Ethically and Effectively as a Member of a Multidisciplinary Team
This practical module focuses on developing the practical skills required to function ethically, professionally, and collaboratively within multidisciplinary Robotic Process Automation (RPA) environments. Learners will work with business analysts, solution architects, DevOps teams, infrastructure engineers, project managers, business users, and stakeholders throughout the automation life cycle. Learners will also develop the ability to communicate effectively, collaborate across departments, support business process automation initiatives, engage with stakeholders ethically, adapt to organisational policies and infrastructure changes, and contribute to teamwork and business optimisation activities.
0/7
PM-08-PS01: Function Ethically and Effectively in the Analysis/Discovery Stage in the Automation Life Cycle
PM-08-PS02: Function Ethically and Effectively in the Design and Build Stage in the Automation Life Cycle
PM-08-PS03: Function Ethically and Effectively in the Management Stage in the Automation Life Cycle
PM-08-PS04: Function Ethically and Effectively in the Run Stage in the Automation Life Cycle
PM-08-PS05: Function Ethically and Effectively in the Engage Stage in the Automation Life Cycle
PM-08-PS06: Collaborate with Colleagues in Other Departments to Automatize Business Processes in Domains Such as Risk Management, Business Optimization, Finance and Customer Intelligence
PM-08 Summative Practical Assessment - Practical Module: PM-08 — Function Ethically and Effectively as a Member of a Multidisciplinary Team
PM-09: Apply Design Thinking Methodologies
This practical module focuses on developing the practical skills required to apply Design Thinking methodologies within problem-solving and innovation environments. Learners will collaborate with multidisciplinary teams to investigate problems, generate innovative ideas, develop prototypes, and test solutions using the Design Thinking process. Learners will also develop the ability to engage in collaborative discussions, participate in innovation workshops, analyse user needs, challenge assumptions, generate creative solutions, and apply the five Design Thinking phases: Empathize, Define, Ideate, Prototype, and Test.
0/3
PM-09-PS01: Collaborate with Team Members to Apply Innovative and Problem Solving Strategies
PM-09-PS02: Apply Design Thinking Process to Solve a Problem Creatively and Innovatively
PM-09 Summative Practical Assessment - Apply Design Thinking Methodologies
Occupational Certificate: Robotic Process Automation (RPA) Developer

Lesson Outcomes

After completing this practical lesson, learners will be able to:

  • Connect to database environments
  • Import data from database systems
  • Retrieve database records using queries
  • Validate imported database information
  • Analyse imported database data
  • Refresh and maintain imported database connections

Overview

Businesses and Robotic Process Automation (RPA) environments commonly store operational data in database systems. Spreadsheet and business intelligence tools are used to connect to databases, retrieve information, and generate reports for analysis and decision-making.

This practical lesson introduces learners to database connectivity, data retrieval, query execution, imported data analysis, and refresh procedures within spreadsheet and reporting environments. Learners will complete practical activities involving business sales and customer databases.

Scenario: Central Business Database Reporting

A company stores customer transactions, sales records, and inventory information in a central database system.

Management requires the data to be imported into a reporting environment for analysis, summaries, and visual reporting.

Learners are required to connect to the database environment, retrieve records, and analyse imported information.

PA0801 — Connect to a Database Environment

Tools/Resources

  • PC or laptop
  • Spreadsheet or BI software
  • Database connection credentials

Activity Instructions

  1. Open the spreadsheet or reporting environment.
  2. Select the database connection option.
  3. Enter the required database connection details.
  4. Connect to the database server.
  5. Verify successful connection.

Expected Outcome

The database environment is accessed successfully.

Evidence Required

  • Screenshot of database connection settings
  • Screenshot of successful database connection
  • Screenshot of available database tables

PA0802 — Import Data from Database Tables

Tools/Resources

  • Spreadsheet software
  • Database tables
  • Import tools

Activity Instructions

  1. Select the required database tables.
  2. Import records into the reporting environment.
  3. Configure import settings correctly.
  4. Load imported records into worksheets or tables.
  5. Verify imported outputs.

Expected Outcome

Database records are imported successfully into the reporting environment.

Evidence Required

  • Screenshot of selected database tables
  • Screenshot of imported records
  • Screenshot of loaded datasets

PA0803 — Retrieve Data Using Queries

Tools/Resources

  • SQL editor or query tools
  • Database system
  • Reporting environment

Activity Instructions

  1. Create queries to retrieve required records.
  2. Apply filtering conditions where necessary.
  3. Execute the queries.
  4. Verify returned outputs.

Expected Outcome

Database records are retrieved successfully using queries.

Evidence Required

  • Screenshot of database queries
  • Screenshot of query outputs
  • Screenshot of filtered records

PA0804 — Analyse Imported Database Data

Tools/Resources

  • Spreadsheet software
  • Pivot tables or dashboards
  • Imported datasets

Activity Instructions

  1. Create summaries from imported data.
  2. Analyse trends or patterns.
  3. Generate reports or visualisations.
  4. Verify analysed outputs.

Expected Outcome

Imported database data is analysed successfully.

Evidence Required

  • Screenshot of summary reports
  • Screenshot of charts or dashboards
  • Screenshot of analysed outputs

PA0805 — Refresh and Verify Database Data

Tools/Resources

  • Spreadsheet software
  • Database updates
  • Validation tools

Activity Instructions

  1. Refresh imported database data after updates.
  2. Verify data consistency and accuracy.
  3. Correct identified issues.
  4. Save the completed workbook.

Expected Outcome

Database imports are refreshed and verified successfully.

Evidence Required

  • Screenshot of refreshed datasets
  • Screenshot of verified outputs
  • Screenshot of corrected data issues

Key Notes

  • Database systems store structured business information.
  • Database imports support business reporting and analysis.
  • Queries retrieve selected records from database tables.
  • Refreshing updates imported records automatically.
  • Validation improves data accuracy and reliability.
  • Visual reporting improves business decision-making.
Previous
Next
Scroll to Top