SP Curr Advanced End User Computing 5 20

OCCUPATIONAL SKILLS PROGRAMME CURRICULUM
DOCUMENT
IN LINE WITH THE OQSF POLICY (2021) OCCUPATIONAL QUALIFICATION TYPE (NOMENCLATURE)
QUALIFICATION/PART-
SKILLS NQF
QUALIFICATION/SKILLS TITLE (DESCRIPTOR) CREDITS
PROGRAMME ID LEVEL
PROGRAMME
Skills Programme SP-240203 Advanced End User 5 20

Computing
CURRICULUM CODE 900240-000-00-00

PARTNER DETAILS ORGANISATION WEBSITE TELEPHONE LOGO
ADDRESS NUMBER
NAME
QUALITY PARTNER - https://www.

DEVELOPMENT mict.org.za +27 (11) 2072600
MICT SETA
QUALITY PARTNER –
ASSESSMENT N/A N/A N/A N/A
(NOT APPLICABLE FOR
SKILLS PROGRAMME)
DESIGNATION NAME AND SURNAME SIGNATURE DATE
SUBJECT MATTER Ben van As …

EXPERT (SME)
QUALITY PARTNER Natalie Nelson …

REPRESENTATIVE
SP Curr Doc Advanced End User Computing 5 20
©Copyright: QCTO Page 1 of 34

Contents
SECTION 1: CURRICULUM SUMMARY ....................................................................................... 3
1.1 Occupational Information: ......................................................................................................... 3
1.2 Curriculum Information: ............................................................................................................. 3
1.3 Curriculum Structure: ................................................................................................................ 5
1.4 Entry Requirements: ................................................................................................................. 5
1.5 Recognition of Prior Learning (RPL): ......................................................................................... 5
1.6 Quality Partner for Assessment: ................................................................................................ 6
SECTION 2: OCCUPATIONAL/SPECIALISATION/PART-QUALIFICATION/SKILLS
PROGRAMME PROFILE ................................................................................................................ 7
2.1. Occupational Title. ................................................................................................................... 7
2.2. Occupational Purpose. ............................................................................................................. 7
2.2 Occupational Tasks................................................................................................................... 7
2.3 Occupational Task Details:........................................................................................................ 7
SECTION 3: CURRICULUM COMPONENT SPECIFICATIONS ..................................................... 8
3.1. Knowledge Module Specifications: ........................................................................................... 8
3.2 PRACTICAL SKILL MODULE (PM) SPECIFICATIONS. ......................................................... 21
List of Practical Skills Modules. ..................................................................................................... 21
3.4 POSSIBLE SEQUENCING AND INTEGRATION .................................................................... 32
SECTION 4. STATEMENT OF WORK EXPERIENCE .................................................................. 33

SECTION 1: CURRICULUM SUMMARY
1.1 Occupational Information:
1.1.1 Associated, Organising Framework for Occupations (OFO) Occupational Code and
Title
351101 Computer Operator
1.1.2 Occupation/Specialisation/Part-Qualification/Skills Programme Type, Title, NQF Level,
Credits and Curriculum Code, addressed by this Curriculum.
TYPE TITLE NQF CREDITS CURRICULUM CODE
LEVEL
Skills Programme Advanced End User 5 20 900240-000-00-00

Computing
1.1.3 Alternative titles used by industry:

Computer Operator
1.2 Curriculum Information:

1.2.1 Articulation for Qualifications and Part- Qualifications
N/A
1.2.2 Articulation for Skills programmes
(a) Work Opportunities:
Having advanced skills in using word processing, spreadsheet and presentation software
applications can provide a person with various work opportunities in today's digital age. Here are a
few examples of the types of roles and industries where these skills are in high demand:
• Administrative Roles: Administrative assistants, executive assistants, and office managers often
need advanced skills in using word processing, spreadsheet, and presentation software
applications to create reports, presentations, and other types of documents.
• Accounting and Finance Roles: Accountants, financial analysts, and other professionals in the
finance industry use spreadsheet software extensively to create and analyse financial data,
including balance sheets, income statements, and cash flow statements.
• Sales and Marketing Roles: Sales and marketing professionals use presentation software to
create visually appealing and persuasive presentations that showcase products, services, and
marketing campaigns.
• Education and Training Roles: Teachers, trainers, and instructional designers use a range of
software applications to create educational materials, including word processing software to
create lesson plans, spreadsheet software to track student progress, and presentation software
to deliver lectures and training sessions.

• Technology Roles: Technical writers, software developers, and IT professionals often need
advanced skills in using word processing, spreadsheet, and presentation software applications
to document technical specifications, create project plans, and present technical information to
stakeholders.
Overall, advanced skills in using these software applications can provide individuals with a
competitive edge in a variety of industries and roles.
(b) Learning Opportunities:

If a person already has advanced skills in using word processing, spreadsheet, and presentation
software applications, there are many further learning opportunities available to them to enhance
their knowledge and expertise in these areas. Here are a few examples:
• Advanced Software Functionality: Many word processing, spreadsheet, and presentation

software applications have advanced features and functionalities that can help users create even
more complex and sophisticated documents and presentations. Taking courses or tutorials that
cover advanced features and functionalities can help users become even more proficient and
efficient with these applications.
• Automation and Scripting: Many software applications support automation and scripting, which
can help users save time and effort by automating repetitive tasks and creating macros.
Advanced users can take courses or tutorials on automation and scripting to learn how to use
these features and streamline their workflows.
• Data Analysis and Visualization: While spreadsheet software applications are often used for data
analysis and visualization, there are many tools and techniques available to help users dive
deeper into their data and gain insights. Users can take courses or tutorials on data analysis and
visualization to learn how to use tools like pivot tables, data analysis tools, and data visualization
software.
• Project Management: Many users of word processing, spreadsheet, and presentation software
applications are also involved in project management. Courses and tutorials on project
management can help users learn how to use these applications to manage projects effectively,
including creating project plans, tracking progress, and managing project risks.
• Digital Communication: In today's digital age, effective communication skills are essential. Users
of word processing, spreadsheet, and presentation software applications can take courses or
tutorials on digital communication to learn how to write effective emails, create engaging social
media posts, and deliver persuasive presentations.
Overall, users with advanced skills in word processing, spreadsheet, and presentation software
applications have many further learning opportunities available to them to deepen their knowledge

and expertise in these areas, as well as related areas that can help them become even more effective
and efficient in their work.
1.3 Curriculum Structure:
1.3.1 Knowledge/Theory Modules:

900240-000-00-KM-01, Concepts and principles underpinning the Advanced use of core
computing applications (Word Processing, Spreadsheets, Presentations, Web and Electronic mail),
NQF Level 5, Credits 4.
Total number of credits for the knowledge modules: 4.
1.3.2 Practical Skills Modules:
900240-000-00-PM-01, Use Advanced Functionalities of Word Processing, Spreadsheets and
Presentation Applications, NQF Level 4, Credits 16.
Total number of credits for the practical skills module: 16

1.3.3 Work Experience Modules:
None
Total number of credits for work experience modules: 0
Total number of credits for the Skills Programme: 20
1.4 Entry Requirements:

NQF level 3 qualification with Intermediate EUC skills.
1.5 Recognition of Prior Learning (RPL):

1.5.1 RPL for Access:
NB: QCTO Standard Statement Provided
Learners may use the RPL process to gain access to training opportunities for a programme of
learning, qualification, part-qualification, or skills programme if they do not meet the formal, minimum
entry requirements for admission. RPL assessment provides an alternative access route into a
programme of learning, qualification, part-qualification, or skills programme.
Such an RPL assessment may be developed, moderated, and conducted by the accredited Skills
Development Provider which offers that specific qualification/part qualification/skills programme.
Such an assessment must ensure that the learner is able to display the equivalent level of
competencies required for access, based on the NQF level descriptors.
1.5.2 RPL for Exemption:

For exemption from modules through RPL, learners who have gained the stipulated competencies
of the modules of a programme of learning, qualification, part-qualification or skills programme

through any means of formal, informal or non-formal learning and/or work experience, may be
awarded credits towards relevant modules, and gaps identified for training, which is then concluded.
1.5.3 RPL for awarding credits:

Learners who have acquired competencies of the modules of a qualification or part qualification will
be credited for modules through RPL.
Learners who have gained the stipulated competencies of the modules of a programme of learning,
qualification, part-qualification, or skills programme through any means of formal, informal or non-
formal learning and/or work experience, may be awarded credits towards relevant modules, and
gaps identified for training, which is then concluded.
A valid Statement of Results is required for admission to the EISA in which confirmation of
achievement is provided that all internal assessment criteria for all modules in the related curriculum
document have been achieved.
For a Skills Programme, the accredited Skills Development Provider (SDP) must ensure all modular
competency requirements are met prior to the FISA and keep record of such evidence.
Upon successful completion of the EISA/FISA, RPL learners will be issued with the QCTO certificate
for the qualification, part-qualification, or skills programme. Quality Partners are responsible for
ensuring the RPL mechanism and process for qualifications and part-qualification is approved by the
QCTO.
1.6 Quality Partner for Assessment:

N/A

SECTION 2: OCCUPATIONAL/SPECIALISATION/PART-QUALIFICATION/SKILLS
PROGRAMME PROFILE
2.1. Occupational Title.
Title: End User Computer Operator
2.2. Occupational Purpose.
To enhance employability and workplace progression through comfortably and safely handling a
range of computing devices, effectively managing the interface between the devices and the end
user, and demonstrating proficiency in the selection, use and integration of a range of word
processing, spreadsheet, and presentation application software to execute basic to advanced level
workplace tasks and apply these skills within specialised workplace contexts.
2.2 Occupational Tasks.

TASK LINKS TO ELO
TASK01: Create advanced level word processing ELO 01: Apply informed understanding of essential
documents. operating procedures and techniques to create
advanced level word processing documents that meet
the integrated standards in terms of purpose, structure,
and quality of the documents.
TASK02: Create advanced level spreadsheets, ELO 02: Apply informed understanding of essential
input data, and use the spreadsheet to do basic operating procedures to create advanced level
reporting. spreadsheet documents that meet the integrated
standards in terms of purpose, structure, and quality of
the documents.
TASK03: Create advanced level presentations ELO 03: Apply informed understanding of essential
using a presentation application operating procedures to create advanced level
presentation documents that meet the integrated
standards in terms of purpose, structure, and quality of
the documents.
2.3 Occupational Task Details:

2.3.1 Task 1 Create advanced level word processing documents.
(a) Unique Product or Service:
• Advanced level documents available for use

(b) Responsibilities:
• Plan the creating of word processing documents.
• Use software application to created advanced level documents.
• Test the documents.
• Improve the documents.

(c) Contexts:

• Processes for creating advanced level word processing documents.
2.3.4. Task 2 Create advanced spreadsheets, input data, and use the spreadsheet to do
advanced reporting.
• Complex spreadsheets effectively utilised for specific contexts.

• Plan the creating of complex spreadsheets.
(c) Contexts:
• Processes for creating advanced level spreadsheets.

2.3.5. Task 3 Create advanced level presentations using a presentation application.
• Advanced level, interactive presentation available and effectively utilised

• Plan the creating of advanced level, interactive presentations using a software

application.

(c) Contexts:
• Processes for creating intermediate level presentations using a software application.
SECTION 3: CURRICULUM COMPONENT SPECIFICATIONS

3.1. Knowledge Module Specifications:
Blended learning using face-to-face/contact, online, e-learning, mobile training unit, and
distance learning.
MODULE CODE MODULE TITLE NQF CREDITS MODE OF
LEVEL DELIVERY
• 900240-000-00- KM-01 Concepts and 5 4 Blended

principles
underpinning the

Advanced use of core
computing
applications (Word
Processing,
Spreadsheets,
Presentations, Web
and electronic mail)
3.1.1 Detailing Knowledge Module (KM) content.

Knowledge Module (KM) - 01
LEVEL DELIVERY
• 900240-000-00- KM-01 Concepts and 5 4 Blended

principles
underpinning the
Advanced use of core
computing
applications (Word
Processing,
Spreadsheets,
Presentations, Web
and electronic mail)
Purpose of Knowledge Module.

The focus of the learning in this module is on building on the broad principles of a core set of
applications that the learner will encounter in most organisations. The purpose is to build a sound
basis of the advanced level operating principles of a word processing application, a spreadsheet
application a presentation application and an electronic mail application. This knowledge will form
the basis for developing the application skills for creating and using advanced level documents using
these applications.
List of Knowledge Topics in the module.

TOPIC TOPIC TITLE % OF TIME
CODE TO BE
SPENT
KM-01-KT01 Advanced features of Word Processing Applications. 25%
KM-01-KT02 Advanced features of Spreadsheet Applications. 25%
KM-01-KT03 Advanced features of Presentation Applications. 25%
KM-01-KT04 Advanced Features of digital communications. 25%

Detailing each topic listed above into topic elements.
KM0101: Advanced features of Word Processing Applications. (25%)
TOPIC TOPIC ELEMENT TITLE % OF TIME
ELEMENT TO BE
CODE SPENT
KT0101 Advanced formatting: advanced formatting options, such as 12,5%

custom styles, section breaks, and advanced page numbering. This
can also include an exploration of advanced formatting tools, such as
table of contents, indexes, and footnotes/endnotes.
KT0102 Collaboration and Reviewing: Advanced techniques for 12,5%

collaborating with others on a document, such as using track
changes, comments, and co-authoring. This can also include
strategies for sharing and distributing documents, such as PDF
conversion, password protection, and digital signatures.
KT0103 Document automation: Techniques for automating repetitive tasks 12,5%

in a document, such as mail merging, macros, and custom
templates. This can also include an exploration of add-ins and third-
party tools that can help automate document creation and
management.
KT0104 Advanced graphics and media: advanced graphics options, such 12,5%
as adding and formatting images, charts, and diagrams, and
incorporating multimedia elements, such as videos and sound files.
This can also include an exploration of graphic design principles and
best practices for creating visually appealing and professional
documents.
KT0105 Customization and automation: Strategies for customizing and 12,5%

automating the user interface, such as customizing the ribbon and
quick access toolbar, and creating keyboard shortcuts. This can also
include an exploration of advanced settings and options, such as
changing default fonts and styles and creating and managing custom
dictionaries.
KT0106 Accessibility and internationalization: Techniques for creating 12,5%

documents that are accessible to all users, including those with
disabilities, and that can be localized for different languages and

cultures. This can include an exploration of accessibility tools and
features, such as alt-text and captions, as well as internationalization
tools, such as language translation and localization.
KT0107 Advanced formulas and functions: An in-depth look at advanced 12,5%

formulas and functions in word processing applications, such as
conditional formatting, IF statements, and nested formulas. This can
also include an exploration of advanced spreadsheet integration,
such as importing and exporting data and linking data to external
sources.
KT0108 Future of word processing: word processing software is evolving, 12,5%

including trends such as artificial intelligence, natural language
processing, and machine learning. This can also include an
exploration of emerging document management technologies and
the impact they will have on the future of word processing.
Internal Assessment Criteria (IAC) and Weight.

IAC CODE IAC DESCRIPTION % OF TIME
TO BE
SPENT
IAC0101 Indicate and explain where to access and how to use the functions 12,5%
for Advanced formatting.
for Collaboration and Reviewing.
for Document automation.
for Advanced graphics and media.
for Customization and automation.
for Accessibility and internationalization.

for Advanced formulas and functions.
for Future of word processing.
KM0102: Advanced features of Spreadsheet Applications. (25%)

ELEMENT TO BE
CODE SPENT
KT0201 Advanced functions and formulas: advanced functions and 12,5%

formulas in spreadsheet applications, such as array formulas,
conditional statements, and nested formulas. This can also include
an exploration of advanced data analysis tools, such as pivot tables,
and how they can be used to summarize and visualize complex data
sets.
KT0202 Macros and automation: Techniques for automating repetitive 12,5%

tasks in a spreadsheet, such as recording and editing macros, and
creating custom functions. This can also include an exploration of
scripting languages, such as VBA, and how they can be used to
automate more complex tasks and create custom add-ins.
KT0203 Data visualization and dashboards: data visualization techniques, 12,5%

such as conditional formatting, charts, and graphs, and how they can
be used to present data in a more engaging and informative way.
This can also include an exploration of dashboards and how they
can be used to summarize and present key performance indicators
(KPIs) in a single view.
KT0204 Collaborating and sharing: Advanced techniques for collaborating 12,5%

with others on a spreadsheet, such as using shared workbooks and
co-authoring. This can also include strategies for sharing and
distributing spreadsheets, such as password protection, PDF
conversion, and digital signatures.

KT0205 Data modelling and analysis: Techniques for modelling and 12,5%
analysing complex data sets, such as using scenario analysis, goal
seeking, and optimization. This can also include an exploration of
advanced statistical and financial analysis tools, such as regression
analysis and Monte Carlo simulations.
KT0206 Database integration: integrating spreadsheet applications with 12,5%

external data sources, such as databases and web services. This
can include an exploration of techniques for importing and exporting
data, as well as for connecting to external data sources and updating
data in real-time.
KT0207 Advanced customization and formatting: Strategies for 12,5%

customizing and automating the user interface, such as creating
custom ribbons and toolbars, and using keyboard shortcuts. This can
also include an exploration of advanced formatting options, such as
custom styles and templates, and how they can be used to create
professional and visually appealing spreadsheets.
KT0208 Future of spreadsheet software: how spreadsheet software is 12,5%

evolving, including trends such as cloud computing, artificial
intelligence, and machine learning. This can also include an
exploration of emerging data visualization and analysis technologies
and their potential impact on the future of spreadsheet applications.

TO BE
SPENT
IAC0201 Indicate and explain where to access and how to use the advanced 14%
functions and formulas when building complex spreadsheets.
IAC0202 Indicate and explain where to access and how to use the functions 14%
for Macros and automation.
for Data visualization and dashboards.

for Collaborating and sharing.
for Data modelling and analysis.
for Database integration.
for Advanced customization and formatting.
KM0103: Advanced features of Presentation Applications. (25%)

ELEMENT TO BE
CODE SPENT
KT0301 Advanced multimedia: advanced multimedia options, such as 12,5%

embedding video and audio files, adding animations, and using
special effects. This can also include an exploration of advanced
graphic design principles and techniques for creating visually
appealing and engaging presentations.
KT0302 Collaboration and sharing: Advanced techniques for collaborating 12,5%

with others on a presentation, such as using shared presentations and
co-authoring. This can also include strategies for sharing and
distributing presentations, such as using password protection, digital
signatures, and PDF conversion.
KT0303 Customization and automation: Strategies for customizing and 12,5%

automating the user interface, such as creating custom themes,
templates, and slide layouts. This can also include an exploration of
advanced settings and options, such as custom fonts, styles, and
transitions.
KT0304 Interactivity and audience engagement: Techniques for adding 12,5%

interactivity to a presentation, such as using hyperlinks, custom
animations, and interactive quizzes. This can also include an
exploration of audience engagement tools, such as real-time polling
and live Q&A.

KT0305 Advanced presentation delivery: advanced techniques for 12,5%
delivering a presentation, such as using remote presentation tools,
customizing presenter views, and recording and sharing presentations
online. This can also include an exploration of strategies for managing
and delivering presentations to large audiences, such as using
webinars and virtual conferences.
KT0306 Accessibility and internationalization: Techniques for creating 12,5%

presentations that are accessible to all users, including those with
disabilities, and that can be localized for different languages and
cultures. This can include an exploration of accessibility tools and
features, such as alt-text and captions, as well as internationalization
tools, such as language translation and localization.
KT0307 Analytics and metrics: analytics and metrics for presentations, such 12,5%
as tracking audience engagement and measuring presentation
effectiveness. This can also include an exploration of advanced
analytics tools, such as A/B testing and heat mapping.
KT0308 Future of presentation software: How presentation software is 12,5%

evolving, including trends such as cloud computing, artificial
intelligence, and virtual and augmented reality. This can also include
an exploration of emerging presentation technologies and their
potential impact on the future of presentation applications.

TO BE
SPENT
for Advanced multimedia in presentation.
for Collaboration and sharing when building complex presentations.

for Customization and automation when building advanced level
presentations.
for Advanced presentation delivery.
for Accessibility and internationalization when building complex
presentations.
for Analytics and metrics when building complex presentations.
IAC0307 Discuss the Future of presentation software indicating how it will 12,5%
impact on the end user.
KM0104: Advanced Features of digital communications.

ELEMENT TO BE
CODE SPENT
KT0401 Advanced messaging features: Advanced messaging features, such 20%

as group messaging, message reactions, and message threading. This
can also include an exploration of advanced search and filtering options,
as well as techniques for managing and organizing large numbers of
messages.
KT0402 Collaboration and productivity tools: Advanced techniques for 20%

collaborating with others on a project, such as using shared documents,
co-authoring, and screen sharing. This can also include an exploration
of productivity tools, such as task management and calendar integration,
and how they can be used to increase efficiency and effectiveness.
KT0403 Video and audio communication: Video and audio communication 20%
options, such as video conferencing, screen sharing, and virtual
backgrounds. This can also include an exploration of techniques for
optimizing video and audio quality, as well as strategies for managing
and troubleshooting video and audio issues.

KT0404 Security and privacy: Techniques for securing digital communication 20%
applications and protecting personal information, such as using two-
factor authentication, encryption, and secure communication protocols.
This can also include an exploration of privacy settings and options, as
well as strategies for managing data retention and deletion.
KT0405 Mobile and remote work: Mobile and remote work options, such as 10%
using mobile devices, virtual private networks (VPNs), and cloud
storage. This can also include an exploration of strategies for managing
and securing remote devices and data, as well as techniques for
maintaining productivity while working remotely.
KT0406 Emerging digital communication technologies: Emerging digital 10%

communication technologies and their potential impact on the future of
digital communication applications, such as artificial intelligence,
machine learning, and virtual and augmented reality. This can also
include an exploration of emerging trends in digital communication, such
as social networking and mobile messaging, and their potential impact
on the future of digital communication applications.

TO BE
SPENT
IAC0401 Indicate and explain where to access and how to use the functions for 20%
Collaboration and productivity tools.
Video and audio communication.
Security and privacy.
Mobile and remote work.
IAC0405 Debate Emerging digital communication technologies. 20%

3.1.2 Criteria for accreditation
Requirements, against which Skills Development Providers (SDP) and Assessment Centres, will
be accredited, as listed below.
Physical Requirements:
SKILLS DEVELOPMENT PROVIDER (SDP)
EQUIPMENT & TOOLS • Computers.

• Applicable Software applications: This may include word processing
software, spreadsheet software, presentation software, and digital
communication software.
• Internet access: Access to the internet is important for
demonstrating online software and tools, accessing resources and
research, and for digital communication software training.
• Projector and screen.
• Printers and scanners.
• Headsets and microphones.
• Classroom or training space: equipped with tables, chairs, and
adequate lighting.
CONSUMABLES • Curriculum aligned learning material.
• Quality Management System.
• Pens, pencils, and highlighters.
• Notepads and notebooks.
• USB drives.
• Printer paper and ink.
• Sticky notes.
• Whiteboard markers and erasers.
ASSESSMENT CENTRE
N/A
N/A
Human Resource Requirements:

QUALIFICATIONS & • Facilitators must have Minimum of NQF Level 6 qualification in

EXPERIENCE Computer Application / Information and Communication
Technology.
• Proven minimum of three (3) years practical experience in computer
applications.
FACILITATOR/LEARNER 1:35
RATIO

ASSESSMENT CENTRE
QUALIFICATIONS & N/A

EXPERIENCE
FACILITATOR/LEARNER N/A
RATIO
Legal Requirements:
• Registered Legal entity
• Protection of Personal Information:

o The Protection of Personal Information Act, 2013 (Act No. 4 of 2013):
Compliant to protecting the privacy and personal information of individuals,
including training participants.
• Copyright and Intellectual Property:

o Compliance to Copyright Act, 1978 (Act No. 98 of 1978): Compliant use and
reproduction of copyrighted materials, including training materials, ensuring
compliance with copyright laws.
• Consumer Protection:
o Consumer Protection Act, 2008 (Act No. 68 of 2008): Protects the rights of
consumers, including those participating in training programs, by regulating
fair and ethical business practices.
• Occupational Health and Safety:

o Buildings, equipment and tools compliant to Occupational Health and Safety
Act, 1993 (Act No. 85 of 1993): Requires ensuring a safe and healthy
training environment, including compliance with safety standards and
regulations.
• Display of Labour Laws in the buildings:
• Taxation:
o Compliance with South African Revenue Service (SARS) regulations:
Including registration for tax purposes and adherence to tax laws and
regulations relevant to the business.
Additional Requirements:

ASSESSMENT CENTRE
None
3.1.3 Exemptions
No exemptions identified.

3.2 PRACTICAL SKILL MODULE (PM) SPECIFICATIONS.
List of Practical Skills Modules.
LEVEL DELIVERY
900240-000-00-PM-01 Use Advanced Functionalities 5 16 Blended

of Word Processing,
Spreadsheets and
Presentation Applications
3.2.1 Detailing Practical Module (PM).

Practical Module (PM) - 01
LEVEL DELIVERY
900240-000-00-PM-01 Use Advanced Functionalities 5 16 Blended

of Word Processing,
Spreadsheets and
Presentation Applications
Purpose of the Practical Skills Module.

List of Practical Skills contained in the module.
PRACTICAL SKILL CODE. PRACTICAL SKILL.
PM-01-PS01 Create and use Advanced level Word Processing documents.
PM-01-PS02 Create and use Advanced level Spreadsheets.
PM-01-PS03 Design, develop and use Advanced level Presentations.
SCOPE OF EACH PRACTICAL SKILL:

PM-01-PS01 Create and use Advanced level Word Processing documents.
Condition for Performance

Given a simulated or controlled work environment where employees are required to create
documents using the advanced functionalities of presentation software applications as well as
access to working computing devices with the required software and specific presentation creation
tasks. Learners will be able to:
Required Performance
Code Skills activities that must be mastered.

PA0101 • Define document style: Before you start writing, define document's style,
including the font, line spacing, margins, and other formatting details. Create a
custom style sheet to ensure consistency throughout the document.
PA0102 • Use advanced formatting features: Most word processing software has
advanced formatting features such as columns, drop caps, and text boxes. Use
these features to create a visually appealing document that captures reader's
attention.
PA0103 • Insert and format multimedia: Multimedia elements such as videos, audio clips,
and animations can make your document more engaging and interactive.
Embed multimedia elements and format them appropriately.
PA0104 • Use advanced tables and charts: Advanced tables and charts can help present
complex data in a visually appealing and understandable way. Use features
such as pivot tables and charts to create sophisticated data visualizations.
PA0105 • Incorporate macros and automation: Macros and automation can help you
automate repetitive tasks such as formatting, inserting elements, and updating
the document. Use macros and automation to save time and increase
efficiency.
PA0106 • Use advanced referencing tools: If you are creating a research-based
document, advanced referencing tools such as endnotes, footnotes, and cross-
referencing can help you manage your references and citations more
effectively.
PA0107 • Incorporate interactive features: Interactive features such as hyperlinks,
bookmarks, and table of contents can help your readers navigate your
document easily. Use these features to create an interactive reading
experience.
PA0108 • Review and edit your document: Once you have completed your document,
review and edit it for accuracy, consistency, and overall quality. Use advanced
editing tools such as thesaurus, spell check, and readability analysis to ensure
your document meets the highest standards.
Applied Knowledge that underpins the required performance.

APPLIED APPLIED KNOWLEDGE
KNOWLDEGE
CODE

AK0101 Techniques for Formatting: This technique involves adjusting the appearance of
text to suit the purpose of the document. Advanced users can apply different
formatting styles such as headings, subheadings, font styles, font sizes, and
colours to highlight important information.
AK0102 Techniques for creating Styles: Styles are pre-defined formatting options that
can be applied to text to maintain consistency throughout the document.
Advanced users can create custom styles, modify existing ones, and apply them
to different sections of the document.
AK0103 Techniques for using Macros: Macros are automated sets of commands that can
be used to perform repetitive tasks. Advanced users can create custom macros
to automate frequently performed tasks such as formatting, inserting tables and
graphics, and applying styles.
AK0104 Techniques for creating and using Templates: Templates are pre-designed
document layouts that can be customized to suit the user's needs. Advanced
users can create custom templates, modify existing ones, and use them to save
time and ensure consistency across different documents.
AK0105 Techniques for Collaboration: Collaboration features allow multiple users to work
on the same document simultaneously. Advanced users can utilize tools such as
comments, track changes, and version control to manage document revisions,
provide feedback, and ensure accuracy.
Internal Assessment Criteria (IAC).

IAC CODE IAC DESCRIPTION
IAC0101 Formatting techniques, including styles, templates, and advanced formatting

options are consistently applied, to create visually appealing and well-structured
documents
IAC0102 Advanced features like macros, mail merge, and document automation tools are
utilised to streamline document creation and improve efficiency.
IAC0103 Text manipulation tasks, such as tracking changes, collaborating on documents,

and managing complex document versions are expertly performed, ensuring
accuracy and clarity.
IAC0104 Multimedia elements, including images, charts, tables, and videos are skilfully
included, into documents, enhancing content presentation and engagement.
IAC0105 Document security and protection protocols are effectively used ensuring the
protection of sensitive information, and effective collaboration n with others on

document editing and review processes are applied, ensuring document integrity
and confidentiality.
PM-01-PS02 Create and use Advanced level Spreadsheets.

documents using the advanced functionalities of spreadsheet development software applications
as well as access to working computing devices with the required software and specific
presentation creation tasks. Learners will be able to:
PA0201 Determine the purpose and audience: Before creating the spreadsheet, determine
the purpose and audience of the spreadsheet. This will help you choose
appropriate content, formulas, and design.
PA0202 Create a plan and structure: Create a plan and structure for the spreadsheet,
including the main headings, subtopics, and formulas. This will help you organize
the content and ensure that it is easy to read and use.
PA0203 Use advanced formatting: Use advanced formatting features such as conditional
formatting, data bars, and colour scales to highlight important information and
make the spreadsheet visually appealing.
PA0204 Use advanced formulas and functions: Use advanced formulas and functions to
automate calculations, analyse data, and make predictions. Use functions such
as IF, VLOOKUP, and SUMIF to manipulate data and create more complex
calculations.
PA0205 Use advanced chart and graph features: Use advanced chart and graph features
to visually represent complex data and provide insights. Use features such as
data labels, trend lines, and custom chart types to create a clear and compelling
visualization of the data.
PA0206 Use advanced data analysis tools: Use advanced data analysis tools such as
pivot tables, scenario analysis, and regression analysis to analyse data and make
informed decisions.

PA0207 Use advanced collaboration tools: Use advanced collaboration tools such as
sharing and co-authoring to collaborate with others and work on the spreadsheet
simultaneously.
PA0208 Protect and secure the spreadsheet: Protect and secure the spreadsheet by using
features such as password protection and user permissions to prevent
unauthorized access and protect sensitive information.
PA0209 Test and revise: Test and revise the spreadsheet to ensure that it is accurate,
reliable, and meets the needs of the audience. Get feedback from others and
revise the spreadsheet based on their feedback.

KNOWLDEGE
CODE
AK0201 Techniques for Data Validation: This technique helps ensure that data entered
into a spreadsheet is accurate and consistent. Advanced users can use data
validation rules to restrict data entry to a specific range, data type, or list of options.
AK0202 Techniques for building and using advanced PivotTables: PivotTables are
powerful tools for summarizing and analysing large data sets. Advanced users
can create PivotTables to extract insights quickly and easily from data and
visualize the results in various formats.
AK0203 Techniques for building and using advanced Macros: Macros are sets of
commands that automate repetitive tasks. Advanced users can use macros to
automate complex calculations, data cleaning, and other time-consuming tasks.
AK0204 Techniques for building and using advanced Conditional Formatting: This
technique allows advanced users to apply formatting to cells based on certain
criteria, such as cell values or formulas. Advanced users can use conditional
formatting to highlight important data, visualize trends, and identify outliers.
AK0205 Techniques for building and using advanced Formulas and Functions: Formulas
and functions are the building blocks of advanced spreadsheets. Advanced users
can use formulas and functions to perform complex calculations, manipulate data,
and automate tasks. Examples include SUMIF, COUNTIF, VLOOKUP, and
IFERROR.


IAC0201 Advanced data analysis techniques, including pivot tables, complex formulas, and
data visualization tools are applied, to extract meaningful insights from
spreadsheet data.
IAC0202 Advanced functions and formulas, utilising functions like VLOOKUP, INDEX-
MATCH, and array formulas are competently applied to perform complex
calculations and data manipulations.
IAC0203 Intricate spreadsheet models, such as financial models, forecasting models, and
scenario analyses are effectively created, to support decision-making processes
with accuracy and reliability.
IAC0204 Data validation rules, error-checking mechanisms, and conditional formatting are
consistently implemented to ensure data accuracy, consistency, and error
detection within spreadsheets.
IAC0205 Advanced charts, graphs, and dashboards are designed to present data in a
visually compelling and informative manner, enabling stakeholders to grasp key
insights at a glance.
PM-01-PS03 Design, develop create and implement advanced level

Presentations.

documents using the advanced functionalities of presentation software applications as well as
access to working computing devices with the required software and specific presentation creation
tasks. Learners will be able to:
PA0301 Determine the purpose and audience: Before creating the presentation, determine
the purpose and audience of the presentation. This will help you choose
appropriate content, design, and multimedia elements.
PA0302 Create a storyboard: Create a storyboard or outline of the presentation, including

the main points, subtopics, and transitions. This will help you organize the content
and ensure that it flows smoothly.
PA0303 Use multimedia elements strategically: Use multimedia elements such as audio,
video, and animations strategically to enhance the presentation and engage the

audience. Use multimedia elements to illustrate complex concepts or to add visual
interest.
PA0304 Use advanced design tools: Use advanced design tools to create a visually
appealing and cohesive presentation. Choose appropriate fonts, colours, and
styles, and use design elements such as images, shapes, and graphics to enhance
the presentation.
PA0305 Use advanced animation and transition features: Use advanced animation and
transition features to add visual interest and make the presentation dynamic. Use
motion paths, slide transitions, and object animations to create a visually engaging
presentation.
PA0306 Use advanced chart and graph features: Use advanced chart and graph features
to visually represent complex data and provide insights. Use features such as data
labels, trend lines, and custom chart types to create a clear and compelling
visualization of the data.
PA0307 Use advanced presenter tools: Use advanced presenter tools such as custom slide
shows, audience response systems, and presenter view to deliver the presentation
effectively and engage the audience.
PA0308 Practice and rehearse: Practice and rehearse the presentation multiple times to
ensure that it flows smoothly, and you feel confident presenting it.
PA0309 Get feedback and revise: Get feedback from others and revise the presentation
based on their feedback. This will help you refine the content, design, and
multimedia elements to create a more effective and engaging presentation.

KNOWLDEGE
CODE
AK0301 Techniques for Visual Design: This technique involves selecting and arranging
visual elements such as images, videos, and diagrams to create an engaging
and professional-looking presentation. Advanced users can use design
principles such as contrast, alignment, and proximity to create a visually
appealing presentation.

AK0302 Techniques for Multimedia Integration: Advanced users can integrate multimedia
elements such as audio, video, and animation to enhance the presentation and
engage the audience.
AK0303 Techniques for utilising the Slide Master: This technique involves creating a
Slide Master, which is a template that contains formatting and design elements
that are applied to all slides in the presentation. Advanced users can use the
Slide Master to maintain consistency throughout the presentation.
AK0304 Techniques for utilising advanced Animation and Transitions: Advanced users
can use animation and transition effects to add interest and visual appeal to the
presentation. They can also use these effects to control the flow of information
and guide the audience's attention.
AK0305 Techniques for creating Interactivity: Advanced users can make their
presentations more interactive by adding hyperlinks, navigation buttons, and
interactive quizzes. This technique can increase audience engagement and
improve retention of the presentation content.

IAC0301 Presentation content with a clear and logical structure is consistently organised,
ensuring a cohesive flow that engages the audience and conveys complex ideas
effectively.
IAC0302 Advanced visual design techniques, including the use of multimedia elements,
custom graphics, animations, and slide transitions are applied, enhancing the
visual appeal and engagement of the presentation.
IAC0303 Storytelling principles and concise messaging are skilfully incorporated to create a
narrative that resonates with the audience, conveying complex concepts
understandably and compellingly.
IAC0304 Audience is effectively engaged through interactive elements, such as quizzes,

polls, and audience participation activities, fostering active involvement and
retention of key information.
IAC0305 Advanced presentation software is applied, adapting to different platforms and

technologies, and troubleshooting technical issues, ensuring seamless delivery
and interactivity during presentations.
3.1.2 Criteria for accreditation

Requirements, against which Skills Development Providers (SDP) and Assessment Centres, will
be accredited, as listed below.
Physical Requirements:
EQUIPMENT & TOOLS • Computers.

• Applicable Software applications: This may include word processing
software, spreadsheet software, presentation software, and digital
communication software.
• Internet access: Access to the internet is important for
demonstrating online software and tools, accessing resources and
research, and for digital communication software training.
• Projector and screen.
• Printers and scanners.
• Headsets and microphones.
• Classroom or training space: equipped with tables, chairs, and
adequate lighting.
CONSUMABLES • Curriculum aligned learning material.
• Quality Management System.
• Pens, pencils, and highlighters.
• Notepads and notebooks.
• USB drives.
• Printer paper and ink.
• Sticky notes.
• Whiteboard markers and erasers.
ASSESSMENT CENTRE
N/A
N/A
Human Resource Requirements:

QUALIFICATIONS & • Facilitators must have Minimum of NQF Level 6 qualification in

EXPERIENCE Computer Application / Information and Communication
Technology.
• Proven minimum of three (3) years practical experience in computer
applications.
FACILITATOR/LEARNER 1:35
RATIO
ASSESSMENT CENTRE

QUALIFICATIONS & N/A
EXPERIENCE
FACILITATOR/LEARNER N/A
RATIO
Legal Requirements:
• Registered Legal entity
• Protection of Personal Information:

o The Protection of Personal Information Act, 2013 (Act No. 4 of 2013):
Compliant to protecting the privacy and personal information of individuals,
including training participants.
• Copyright and Intellectual Property:

o Compliance to Copyright Act, 1978 (Act No. 98 of 1978): Compliant use and
reproduction of copyrighted materials, including training materials, ensuring
compliance with copyright laws.
• Consumer Protection:
o Consumer Protection Act, 2008 (Act No. 68 of 2008): Protects the rights of
consumers, including those participating in training programs, by regulating
fair and ethical business practices.
• Occupational Health and Safety:

o Buildings, equipment and tools compliant to Occupational Health and Safety
Act, 1993 (Act No. 85 of 1993): Requires ensuring a safe and healthy
training environment, including compliance with safety standards and
regulations.
• Display of Labour Laws in the buildings:
• Taxation:
o Compliance with South African Revenue Service (SARS) regulations:
Including registration for tax purposes and adherence to tax laws and
regulations relevant to the business.
Additional Requirements:

ASSESSMENT CENTRE
None
3.1.3 Exemptions
No exemptions identified.

3.4 POSSIBLE SEQUENCING AND INTEGRATION
Listing and order of modules in the sequence in which these modules will follow each other during
delivery/implementation. This allows for integration of KM, AM (PM/ WM) as work logically flows.
ORDER MODULE TITLE MODULE CODE LEVEL CREDITS
1.
2.

SECTION 4. STATEMENT OF WORK EXPERIENCE
QUALIFICATION/PART- QUALIFICATION/PART-QUALIFICATION/SKILLS NQF CREDITS

QUALIFICATIONS/SKILLS PROGRAMME TITLE/DESCRIPTOR LEVEL
PROGRAMME TYPE
CURRICULUM CODE _ _ _ _ _ _ -_ __ -_ _ -_ _
LEARNER DETAILS
NAME:
ID NUMBER:
EMPLOYER DETAILS
COMPANY NAME:
ADDRESS:
SUPERVISOR NAME:
WORK TELEPHONE:
E-MAIL:

LEVEL DELIVERY
_ _ _ _ _ _-_ _ _-_ _-WM-01
WORK EXPERIENCE MODULE DETAILS
WM-01-WE01 SCOPE WORK EXPERIENCE DATE SIGNATURE
WA0101
WA0102
SUPPORTING EVIDENCE DATE SIGNATURE
SE0101
SE0102
WM-01-WE02 SCOPE WORK EXPERIENCE DATE SIGNATURE
WA0201
WA0202
SUPPORTING EVIDENCE DATE SIGNATURE
SE0201
SE0202
NUMBER CONTEXTUALISED WORKPLACE DATE SIGNATURE

KNOWLEDGE
1.
NUMBER ADDITIONAL ASSIGNMENTS TO BE DATE SIGNATURE

ASSESSED EXTERNALLY
1.

SP Curr Advanced End User Computing 5 20

Uploaded by

Copyright:

Available Formats

SP Curr Advanced End User Computing 5 20

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SP Curr Advanced End User Computing 5 20

Uploaded by

Copyright:

Available Formats

OCCUPATIONAL SKILLS PROGRAMME CURRICULUM

Skills Programme SP-240203 Advanced End User 5 20

CURRICULUM CODE 900240-000-00-00

QUALITY PARTNER - https://www.

DESIGNATION NAME AND SURNAME SIGNATURE DATE

SUBJECT MATTER Ben van As …

QUALITY PARTNER Natalie Nelson …

SP Curr Doc Advanced End User Computing 5 20

©Copyright: QCTO Page 1 of 34

SP Curr Doc Advanced End User Computing 5 20

©Copyright: QCTO Page 2 of 34

Skills Programme Advanced End User 5 20 900240-000-00-00

1.1.3 Alternative titles used by industry:

1.2 Curriculum Information:

©Copyright: QCTO Page 3 of 34

(b) Learning Opportunities:

• Advanced Software Functionality: Many word processing, spreadsheet, and presentation

SP Curr Doc Advanced End User Computing 5 20

©Copyright: QCTO Page 4 of 34

1.3 Curriculum Structure:

1.3.1 Knowledge/Theory Modules:

Total number of credits for the practical skills module: 16

1.4 Entry Requirements:

1.5 Recognition of Prior Learning (RPL):

1.5.2 RPL for Exemption:

©Copyright: QCTO Page 5 of 34

1.5.3 RPL for awarding credits:

1.6 Quality Partner for Assessment:

SP Curr Doc Advanced End User Computing 5 20

©Copyright: QCTO Page 6 of 34

2.2 Occupational Tasks.

2.3 Occupational Task Details:

• Advanced level documents available for use

• Plan the creating of word processing documents.

• Use software application to created advanced level documents.

• Test the documents.

• Improve the documents.

©Copyright: QCTO Page 7 of 34

• Complex spreadsheets effectively utilised for specific contexts.

• Plan the creating of complex spreadsheets.

• Use software application to created advanced level documents.

• Test the documents.

• Improve the documents.

• Processes for creating advanced level spreadsheets.

• Advanced level, interactive presentation available and effectively utilised

• Plan the creating of advanced level, interactive presentations using a software

• Use software application to created advanced level documents.

• Test the documents.

• Improve the documents.

• Processes for creating intermediate level presentations using a software application.

SECTION 3: CURRICULUM COMPONENT SPECIFICATIONS

• 900240-000-00- KM-01 Concepts and 5 4 Blended

©Copyright: QCTO Page 8 of 34

3.1.1 Detailing Knowledge Module (KM) content.

• 900240-000-00- KM-01 Concepts and 5 4 Blended

Purpose of Knowledge Module.

List of Knowledge Topics in the module.

KM-01-KT01 Advanced features of Word Processing Applications. 25%

KM-01-KT02 Advanced features of Spreadsheet Applications. 25%

KM-01-KT03 Advanced features of Presentation Applications. 25%