Occupational Skills Programme: Advanced End User Computing NQF Level 05
- Overview
- Outcome
- Content
Course Duration: 8 Days
Imsimbi Training proudly presents Advanced End User Computing – a practical skills programme designed to prepare learners to perform advanced end-user computing functions by creating and managing complex documents, spreadsheets, presentations, and databases.
This skills programme is registered with the Quality Council for Trades and Occupations (QCTO) under SP-240203 at NQF Level 5, worth 20 credits, delivered over 8 days (including FISA).
The programme focuses on business productivity, data analysis, automation, collaboration, reporting, and technology-enabled decision-making for modern organisations. Learners will learn to automate tasks, analyse data, improve productivity, solve workplace problems, and manage projects using digital technologies.
Entry Requirements: Prerequisite: SP-240202 Intermediate End User Computing (or equivalent computer literacy skills).
Target Group: Office professionals, supervisors, administrators, entrepreneurs, and business support personnel who possess intermediate end-user computing skills and need advanced capabilities in document management, spreadsheet analysis, presentation development, automation, digital collaboration, and business reporting to improve organisational performance and support decision-making.
Imsimbi Training is a fully accredited training provider and a Level 1 BBBEE company with 51% black owned.
Course Duration: 8 Days
COURSE OUTCOMES
By the end of the programme, learners will be able to:
- Create and edit complex business documents.
- Develop advanced spreadsheets for data analysis, reporting, and decision-making.
- Build professional presentations incorporating advanced features and data visualisation.
- Use software tools to automate routine tasks and improve efficiency.
- Analyse, manage, and communicate business information effectively.
- Apply digital collaboration, cybersecurity, and project management principles in the workplace.
Course Duration: 8 Days
Programme Modules
The skills programme consists of 7 modules totalling 20 credits, delivered over 8 days (including FISA).
Module 1: Advanced Digital Productivity and Information Management
- Digital Transformation in the Workplace – the modern digital workplace, business productivity tools, cloud computing fundamentals
- Advanced File and Information Management – document version control, shared drives and cloud repositories, information governance
- Cybersecurity and Data Protection – data privacy principles, secure document sharing, cybersecurity best practices
- Practical Activities – configure cloud storage structures, implement document control procedures, conduct a cybersecurity awareness exercise
- Assessment – Digital workplace productivity exercise
Module 2: Advanced Word Processing and Document Automation
- Complex Document Creation – document templates, corporate branding, advanced page layouts
- Automation Features – building reusable templates, Quick Parts, fields and forms
- Long Document Management – table of contents, cross-references, captions and indexing
- Document Review and Collaboration – advanced Track Changes, shared document editing, approval workflows
- Practical Activities – create a company policy manual, design a reusable corporate template, generate an automated table of contents
- Assessment – Advanced document development project
Module 3: Advanced Spreadsheet Analysis and Automation
- Advanced Formulae and Functions – IF, Nested IF, XLOOKUP/VLOOKUP, INDEX and MATCH, logical functions
- Data Analysis Tools – PivotTables
- Spreadsheet Automation – Macros (introduction), templates, automated reporting
- Data Validation and Integrity – validation rules, error checking, data auditing
- Practical Activities – create an automated sales dashboard, build a financial analysis workbook, generate management reports
- Assessment – Business data analysis assignment
Module 4: Business Intelligence and Reporting
- Data Interpretation – trend analysis, comparative analysis, forecasting concepts
- Dashboard Design – KPIs and metrics, executive reporting, visual analytics
- Reporting for Decision Making – report structures, data storytelling, executive summaries
- Practical Activities – build a KPI dashboard, create interactive charts, produce a management report
- Assessment – Business reporting project
Module 5: Advanced Presentations and Visual Communication
- Strategic Presentation Design – audience-focused communication, executive presentations, storytelling with data
- Advanced PowerPoint Features – Slide Master, custom templates, multimedia integration
- Data Visualisation – charts and dashboards, infographics, SmartArt enhancements
- Presentation Delivery Skills – managing questions, executive communication, persuasive presentations
- Practical Activities – design a boardroom presentation, develop a data-driven presentation, deliver a professional presentation
- Assessment – Individual presentation evaluation
Module 6: Digital Collaboration, Project Support and Problem Solving
- Advanced Collaboration Tools – Microsoft Teams, SharePoint fundamentals, shared workspaces
- Digital Project Management – task tracking, resource planning, documentation control
- Problem Solving with Technology – identifying workplace challenges, selecting appropriate software solutions, productivity optimisation
- Troubleshooting End-User Issues – common software errors, user support techniques, escalation procedures
- Practical Activities – manage a collaborative project, develop a project tracking workbook, resolve workplace technology scenarios
- Assessment – Digital collaboration project
Module 7: Integrated Workplace Project and Final Assessment
- Integrated Business Simulation – learners complete a comprehensive workplace project requiring them to:
- Phase 1 – Research and Analysis: Gather business information; analyse operational requirements
- Phase 2 – Document Creation: Develop a professional business report; create supporting documentation
- Phase 3 – Spreadsheet Analysis: Analyse business data; generate dashboards and reports
- Phase 4 – Presentation Development: Prepare and deliver a management presentation
- Phase 5 – Collaboration and Communication: Share project outputs electronically; apply professional communication standards
- Final Assessment Components:
- Knowledge Assessment – Advanced EUC concepts, digital business practices, information management
- Practical Assessment
- Portfolio of Evidence – individual assignments, practical exercises, integrated workplace project