Aligned with/to QCTO SP-240203 Advanced End User Computing, NQF L5

SKILLS PROGRAMME: ADVANCED END USER COMPUTING

SKILLS PROGRAMME ID: SP-240203 NQF LEVEL 5, 20 CREDITS


SKILLS PROGRAMME Details:

Registration start date:           29-02-2024

Registration end date:            29-02-2029

Last date for enrolment:         29-02-2030

Last date for achievement:     29-02-2033

Entry LEVEL Requirements:

Skills Programme: Intermediate End User Computing, NQF Level 3

RELATED REGISTERED QUALIFICATIONS:

N/A

PURPOSE AND RATIONALE OF THE QUALIFICATION

Advanced End User Computing skills programme focuses on high level word processing, spreadsheets, and presentations for high scarce and critical skills requirements for supporting the national development initiatives in the country.

As technology continues to evolve, there is a growing demand for individuals with advanced digital literacy and problem-solving skills in various occupations and industries.

There has been an increased reliance on digital technologies for communication, collaboration, and information management to grow and develop the economy. It is essential to equip learners with the necessary skills to navigate and use digital technologies effectively.

Improving digital skills is crucial for driving economic growth and competitiveness, as it enables individuals and businesses to be more productive, innovative, and efficient.

By developing Advanced End User Computing skills this promotes lifelong learning and enhances skills development, which is critical for addressing unemployment and promoting social mobility.

The programme will produce a pool of skilled and knowledgeable end-users, who operate with increased efficiency, accuracy, and productivity. This results in reduced support requirements and enable ICT professionals to focus on more technical tasks. The programme will create a pipeline of ICT skilled workers for addressing skills shortages and promoting career advancement.

The programme will empower individuals with advanced digital literacy skills, enabling them to navigate and use digital technologies effectively, which is essential for participation in the modern economy and society. Improved digital skills will increase social inclusion, promote lifelong learning, and enhance overall quality of life.

The programme will increase productivity, innovation, and efficiency, which are essential for promoting economic growth and competitiveness. With improved digital skills, individuals and businesses will be better equipped to meet the demands of the modern economy, adapt to new technologies, and compete in the global marketplace. It will address the skills gap, promote job creation, and support economic development.

Creating an advanced level skills programme for end user computing focusing on word processing, spreadsheets, and using software to create presentations will have far-reaching benefits for the ICT sector, society, and the economy.

An Advanced End User Computing skills programme provides learners with specific benefits, including the ability to improve productivity, accuracy, and efficiency in handling complex tasks in various industries digitally. It enables learners to develop analytical and problem-solving skills, enhance communication and collaboration abilities, and effectively manage projects. Advanced End-User Computing skills also provide learners with a competitive edge in the job market, making them more marketable and attractive to employers who are looking for individuals with advanced technology skills.

The purpose of the skills programme is to prepare a leaner to function as Advanced End-User Computing. Advanced End User Computing handles complex computing tasks such as word documents, spreadsheet, and presentation.

SKILLS PROGRAMME Outcomes:

A qualified learner should be able to:

  1. Create and edit complex documents, spreadsheets, presentations, and databases.
  2. Apply various software tools to automate tasks, manage and analyse data and collaborate with others.
  3. Improve productivity, efficiency, and effectiveness.
  4. Solve complex end user computing problems, communicate ideas, and manage projects.
Skills Development Provider Accreditation Requirements:

Knowledge Modules & Practical Modules

Equipment, Tools & Consumables

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.

Providers are required to ensure that requirements for all equipment & tools are met.

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.

 

Masterskill provides access to the following curriculum aligned learning material: Student & Instructor Programme Guidelines; Student & Instructor Learning Materials [eBooks and/or videos (where applicable)]; Additional Resources [website links and/or articles (where applicable)]; Assessment Guidelines; Portfolio of Evidence (including formative, summative and FISA assessments); Assessment Guide for Assessors; Programme Strategy (alignment matrix documentation).

Providers are required to ensure that the rest of the consumable requirements are met.

Human Resource Requirements:

  1. Lecturer/learner ratio of 1:35 (Maximum)
  2. Qualification of lecturer (SME):
    • Facilitators must have Minimum of NQF Level 5 qualification in Computer Application / Information and Communication Technology.
    • Proven minimum of three (3) years practical experience in computer applications.
    • Assessors and moderators: accredited by the MICT SETA.

Providers are required to appoint own instructors, assessors and moderators.

Legal Requirements:

  1. Registered Legal entity
  2. Protection of Personal Information: 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
  3. Copyright and Intellectual Property: 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
  4. Consumer Protection: 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
  5. Occupational Health and Safety: 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.
  6. Display of Labour Laws in the buildings.
  7. Taxation: Compliance with South African Revenue Service (SARS) regulations: Including registration for tax purposes and adherence to tax laws and regulations relevant to the business.

Providers are required to ensure that all legal compliance requirements are met.

Work Opportunities

Many professionals, such as administrators, finance professionals, marketers, and human resource personnel, require intermediate level skills in word processing, spreadsheets, and presentations to perform duties effectively. Small business owners who are responsible for managing business's finances and documents can benefit from an intermediate level programme to create professional-looking spreadsheets and documents, manage data, and present ideas more effectively. Intermediate level skills in word processing, spreadsheets, and presentations can be helpful for students who need to prepare reports, presentations, and other assignments for studies. Job seekers who want to improve employability can benefit from an intermediate level programme to improve ICT skills and demonstrate their proficiency in essential software tools. Individuals who want to improve digital literacy and personal productivity can also benefit from an intermediate level skills programme to better manage personal documents, finances, and presentations.

Further Learning

Further learning opportunities include:

  1. OC: Computer Technician (CompTIA) SAQA ID: 101408 NQF Level 5, 282 credits
  2. OC: Data Science Practitioner SAQA ID: 118708 NQF Level 5, 185 credits
  3. OC: Project Manager SAQA ID: 101869 NQF Level 5, 240 credits
  4. OC: Office Administrator SAQA ID: 102161 NQF Level 5, 445 credits
  5. Any associated NQF Level 6 qualification based on learner’s field of specialisation

Learners may also enroll for international certifications such as:

  1. Certiport: IC3 Digital Literacy Certification
Curriculum Information

Learning Unit 1a: word ADVANCED

31 hrs 5 min / 3,8 days

  1. ELO1: Apply the essential 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.

Resources Required for this learning unit:

  • Access to equipment (computers), applicable software applications, internet connectivity, classroom facilities or training space.
  • Material is based on Microsoft® Office 365 & 2019 Series

Book: NQF94-045SG: MS Word Advanced (7537-1) - Student Edition

Learners will be required to cover all the lessons:

  • Lesson 1: Distributing Documents
  • Lesson 2: Working with Illustrations
  • Lesson 3: Reference Creation and Document Collaboration
  • Lesson 4: Intermediate Document Features
  • Lesson 5: Managing Documents
  • Lesson 6: Using Productivity Tools
  • Lesson 7: Working with Advanced References
  • Appendix

These lessons will cover the following knowledge and practical modules / topics:

  • 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.
  • 900240-000-00-PM-01, Use Advanced Functionalities of Word Processing, Spreadsheets and Presentation Applications, NQF Level 4, Credits 16.

Facilitation Suggested Duration: 14 hrs.

Associated Assessment Activities:

  • Formative Assessment 1 (FA1) = 1 hour, 18 marks
  • Formative Assessment 2 (FA2) = 30 minutes, 12 marks
  • Formative Assessment 3 (FA3) = 1 hour 30 minutes, 32 marks
  • Formative Assessment 4 (FA4) = 20 minutes, 13 marks
  • Formative Assessment 5 (FA5) = 3 hours, 21 marks
  • Formative Assessment 6 (FA6) = 30 minutes, 13 marks
  • Formative Assessment 7 (FA7) = 15 minutes, 5 marks
  • Formative Assessment 8 (FA8) = 4 hours, 40 marks
  • Summative Assessment (SA) = 6 hours, 100 marks

Assessment Duration: 17 hrs. 5 min.

Content: All the above content will be covered by eBook via Masterskill LMS platform.

Content is grouped into a student and instructor edition:

  • SP-240203-LU1aSG_rev1.0: LU1a-Word Advanced, Student Edition
  • SP-240203-LU1aIG_rev1.0: LU1a-Word Advanced, Instructor Edition [There is no additional instructor guide, instructors need to receive a copy of the Student Edition. Instructors should also refer to the Instructor Programme Guidelines document].

Each edition consists of:

  • Student / Instructor Programme Guidelines
  • Book: NQF94-045SG: MS Word Advanced (7537-1) (Learning Material). Print option is available.
  • Note there is no additional instructor guide available instructors will need to consult the learner guide. Supporting overhead files are available and answers to the questions found in the learner guide has been placed at the back of the instructor guideline document.
  • Assessment Guidelines

Learning Unit 1b: EXCEL ADVANCED

26 hrs 40 min / 3 days

  1. ELO2: Apply essential operating procedures to create intermediate level spreadsheet documents that meet the integrated standards in terms of purpose, structure, and quality of the documents.

Resources Required for this learning unit:

  • Access to equipment (computers), applicable software applications, internet connectivity, classroom facilities or training space.

Book: NQF94-041SG: MS Excel Intermediate (7532-1) - Student Edition

Learners will only be required to cover the following lessons:

  • Lesson 1: Data Input and Cell Manipulation
  • Lesson 2: Using Formulas
  • Lesson 3: Formatting the Worksheet
  • Lesson 4: Working with Charts
  • Lesson 5: Organizing Data
  • Lesson 6: Data Analysis Using Pivot Tables and Pivot Charts
  • Lesson 7: Workbook Management Features

These lessons will cover the following knowledge and practical modules / topics:

  • 900239-000-00-KM-01, Concepts and principles underpinning the Intermediate use of core computing applications (Word Processing, Spreadsheets, Presentations, and electronic mail. NQF Level 4, 4 credits
  • 900239-000-00-PM-01, Use Intermediate level Functionalities of Word processing, Spreadsheets and Presentation Applications. NQF Level 4, 16 credits

Facilitation Suggested Duration: 18 hrs.

Associated Assessment Activities:

  • Formative Assessment 1 (FA1) = 1 hour, 12 marks
  • Formative Assessment 2 (FA2) = 1 hour, 11 marks
  • Formative Assessment 3 (FA3) = 20 minutes, 6 marks
  • Formative Assessment 4 (FA4) = 20 minutes, 6 marks
  • Formative Assessment 5 (FA5) = 30 minutes, 6 marks
  • Formative Assessment 6 (FA6) = 1 hour 30 minutes, 10 marks
  • Summative Assessment 1 (SA1) = 4 hours, 66 marks

Assessment Duration: 8 hrs. 40 min.

Content: All the above content will be covered by eBook via Masterskill LMS platform.

Content is grouped into a student and instructor edition:

  • SP-240202-LU1bSG_rev1.0: LU1b-Excel Intermediate, Student Edition
  • SP-240202-LU1bIG_rev1.0: LU1b-Excel Intermediate, Instructor Edition [There is no additional instructor guide, instructors need to receive a copy of the Student Edition. Instructors should also refer to the Instructor Programme Guidelines document].

Each edition consists of:

  • Student / Instructor Programme Guidelines
  • Book: NQF94-041SG: MS Excel Intermediate (7532-1) (Learning Material). Print option is available.
  • Note there is no additional instructor guide available instructors will need to consult the learner guide. Supporting overhead files are available and answers to the questions found in the learner guide has been placed at the back of the instructor guideline document.
  • Assessment Guidelines

Learning Unit 1c: powerpoint intermediate

23 hrs 15 min / 2 ½ days

  1. ELO3: Apply essential operating procedures to create intermediate level presentation documents that meet the integrated standards in terms of purpose, structure, and quality of the documents.

Resources Required for this learning unit:

  • Access to equipment (computers), applicable software applications, internet connectivity, classroom facilities or training space.

Book: NQF94-043SG: MS PowerPoint Intermediate (7536-1)  - Student Edition

Learners will only be required to cover the following lessons:

  • Lesson 1: Working with Slides
  • Lesson 2: Working with Charts and Tables
  • Lesson 3: Adding Multimedia Elements
  • Lesson 4: Enhancing Presentations
  • Lesson 5: Preparing the Slide Show
  • Lesson 6: Sharing Presentations

These lessons will cover the following knowledge and practical modules / topics:

  • 900239-000-00-KM-01, Concepts and principles underpinning the Intermediate use of core computing applications (Word Processing, Spreadsheets, Presentations, and electronic mail. NQF Level 4, 4 credits
  • 900239-000-00-PM-01, Use Intermediate level Functionalities of Word processing, Spreadsheets and Presentation Applications. NQF Level 4, 16 credits.

Facilitation Suggested Duration: 16 hrs.

Associated Assessment Activities:

  • Formative Assessment 1 (FA1) = 10 minutes, 5 marks
  • Formative Assessment 2 (FA2) = 20 minutes, 11 marks
  • Formative Assessment 3 (FA3) = 15 minutes, 8 marks
  • Formative Assessment 4 (FA4) = 10 minutes, 9 marks
  • Formative Assessment 5 (FA5) = 20 minutes, 10 marks
  • Formative Assessment 6 (FA6) = 1-2 hours, 48 marks
  • Summative Assessment 1 (SA1) = 4 hours, 67 marks

Assessment Duration: 7 hrs. 15 min.

Content: All the above content will be covered by eBook via Masterskill LMS platform.

Content is grouped into a student and instructor edition:

  • SP-240202-LU1cSG_rev1.0: LU1c-PowerPoint Intermediate, Student Edition
  • SP-240202-LU1cIG_rev1.0: LU1c- PowerPoint Intermediate, Instructor Edition [There is no additional instructor guide, instructors need to receive a copy of the Student Edition. Instructors should also refer to the Instructor Programme Guidelines document].

Each edition consists of:

  • Student / Instructor Programme Guidelines
  • Book: NQF94-043SG: MS PowerPoint Intermediate (7536-1) (Learning Material). Print option is available.
  • Note there is no additional instructor guide available instructors will need to consult the learner guide. Supporting overhead files are available and answers to the questions found in the learner guide has been placed at the back of the instructor guideline document.
  • Assessment Guidelines

Learning Unit 1d: Outlook intermediate

17 hrs 10 min / 2 days

  1. No associated ELO

Resources Required for this learning unit:

  • Access to equipment (computers), applicable software applications, internet connectivity, classroom facilities or training space.

Book: NQF94-042SG: MS Outlook Intermediate (7534-1)   - Student Edition

Learners will only be required to cover the following lessons:

  • Lesson 1: Getting Started with Email
  • Lesson 2: Working with Outlook
  • Lesson 3: Managing Email
  • Lesson 4: Organizing Outlook

These lessons will cover the following knowledge and practical modules / topics:

  • 900239-000-00-KM-01, Concepts and principles underpinning the Intermediate use of core computing applications (Word Processing, Spreadsheets, Presentations, and electronic mail. NQF Level 4, 4 credit

Facilitation Suggested Duration: 12 hrs.

Associated Assessment Activities:

  • Formative Assessment 1 (FA1) = 1 hour, 18 marks
  • Formative Assessment 2 (FA2) = 20 minutes, 12 marks
  • Formative Assessment 3 (FA3) = 30 minutes, 18 marks
  • Formative Assessment 4 (FA4) = 10 minutes, 5 marks
  • Formative Assessment 5 (FA5) = 10 minutes, 4 marks
  • Summative Assessment 1 (SA1) = 3 hours, 34 marks

Assessment Duration: 5 hrs. 10 min.

Content: All the above content will be covered by eBook via Masterskill LMS platform.

Content is grouped into a student and instructor edition:

  • SP-240202-LU1dSG_rev1.0: LU1d-Outlook Intermediate, Student Edition
  • SP-240202-LU1dIG_rev1.0: LU1d- Outlook Intermediate, Instructor Edition [There is no additional instructor guide, instructors need to receive a copy of the Student Edition. Instructors should also refer to the Instructor Programme Guidelines document].

Each edition consists of:

  • Student / Instructor Programme Guidelines
  • Book: NQF94-042SG: MS Outlook Intermediate (7534-1) (Learning Material). Print option is available.
  • Note there is no additional instructor guide available instructors will need to consult the learner guide. Supporting overhead files are available and answers to the questions found in the learner guide has been placed at the back of the instructor guideline document.
  • Assessment Guidelines

Final Integrated Supervised Assessment

A FISA (Final Integrated Supervised Assessment) has been developed. FISA documentation is available upon request. The FISA will test associated exit level outcomes. Within the FISA the learner will be required to demonstrate applied knowledge and skills to prove that the competencies of the Skills Programme has been achieved.

Suggested Assessment Hrs: 6 hrs

Curriculum Hours Breakdown

20 credits = 200 Notional Hours, 25 days

Course Duration

90 hrs.

Assessment Duration

90 hrs.

FISA

20 hrs.

 

Facilitated sessions = 66 hrs.

FA= 11 hrs 45 min

SA = 16 hrs

FISA = 6 hrs.

Learner own preparation = 24 hrs.

Learner own preparation = 62 hrs. 15 min

Learner own preparation = 14 hrs.

To download the full course outline, please click on the link below:

Advanced End User Computing.pdf