Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
A computer assessment, also called a computer skills assessment, tests what each staff member can actually do in Excel, Word, Outlook, PowerPoint and everyday digital tasks, and places them at a beginner, intermediate or advanced level. The most reliable way to run one is a short practical test using real work files. Map the results to a skills matrix, then book training that matches each level from BOTI’s Microsoft Office and computer skills courses.
For South African HR, L&D and operations leaders, an assessment is the quickest way to justify a training budget, aim spend where it is needed and show the return on your skills-development investment. This guide shows you how to run one, what to measure and how to turn the results into targeted training for your team.
BOTI (Business Optimization Training Institute) helps South African employers close these gaps with practical Microsoft Office and data courses. This is the same kind of upskilling we deliver for clients including Sasol, Glencore and the City of Johannesburg.
What a Computer Skills Assessment Is, and the Problem It Solves
A computer skills assessment is a structured way to test each staff member’s practical ability in the everyday software your business runs on. Asking “can you use Excel?” is not enough, because nearly everyone says yes. An assessment measures whether they can actually build a formula, clean a dataset, format a report or manage a busy inbox.
The business problem it solves is common and costly:
- Wasted time. Staff who struggle with their tools take longer on every task: manual workarounds in Excel, retyping data, slow document formatting.
- Hidden risk. Untrained users make errors in spreadsheets and reports that go unnoticed until they reach a client or the board.
- Misspent training budget. Without data, you either over-train confident people or under-train the staff who need it most.
- Uneven teams. One “Excel person” carries the department, and everyone else routes work through them.
An assessment replaces opinion with evidence. You get a clear picture of where each person sits, so your next training rand is spent where it makes a difference.
Who This Is For
This guide is written for South African organisations training their own staff, including:
- HR and L&D managers building a Workplace Skills Plan (WSP) or Annual Training Report (ATR)
- Business owners who want a more capable, self-sufficient team
- Department, operations and finance managers whose people work in Excel, reports and email all day
- Skills development facilitators who need evidence behind their training plans
If you are buying training for a team rather than for yourself, an assessment is the planning step that makes every later decision easier to defend.
How to Run a Computer Skills Assessment: 6 Steps
Step 1: Define the roles and software that matter
List the tools each role actually uses and the level it requires. A finance analyst needs advanced Excel; a receptionist needs solid Outlook and intermediate Word. Do not test skills the role never uses.
Step 2: Set the competency levels
Use three clear bands so results are easy to act on:
| Level | What it looks like |
|---|---|
| Beginner | Can open, save and do basic edits; relies on help for anything beyond the basics |
| Intermediate | Works confidently day-to-day; formulas, formatting, mail merge, basic charts |
| Advanced | Builds models, PivotTables, dashboards, macros; teaches others |
Step 3: Choose your assessment method
- Practical task tests (most reliable): give staff a real file and ask them to complete tasks, such as cleaning a dataset, building a report or formatting a document.
- Scenario questionnaires: a quick self-rating plus knowledge questions, useful as a first filter for large teams.
- Observation: a supervisor or trainer reviews live work for hands-on roles.
A short practical test of 20 to 40 minutes per person gives far more reliable data than self-rating alone, because confidence and competence rarely match.
Step 4: Run the assessment consistently
Use the same tasks and marking guide for everyone in a role so results can be compared. Keep it low-pressure. Present it as planning, not a performance review, so staff answer honestly.
Step 5: Map gaps to a skills matrix
Plot people against the required levels to see your gaps at a glance: who needs intermediate Excel, who needs Power BI, and who is ready to mentor others. This matrix becomes the evidence base for your training plan and your WSP.
Step 6: Turn gaps into targeted training
Group staff by the level they need and book training that matches, rather than one generic “computer course” for everyone. BOTI’s course range lets you assign a suitable programme to each band.
What the Assessment Should Cover
A thorough computer competency assessment for a South African workplace usually spans:
- Microsoft Excel: formulas, functions, formatting, charts, PivotTables, data cleaning and dashboards (the highest-impact area for most teams)
- Microsoft Word: professional documents, styles, templates, mail merge and track changes
- Microsoft Outlook: inbox and calendar management, rules and professional email
- Microsoft PowerPoint: clear, on-brand presentations
- Power BI and data analytics: turning data into reports and dashboards for decision-makers
- General computer literacy: file management, navigation and security basics for staff who are newer to digital work
Using the Same Method for Other Skills Assessments
The six steps above work for more than software. For a project management skills assessment, define the tasks the role really performs, such as scoping work, building a schedule, tracking risks and reporting progress. Then test them with a short practical exercise based on a real project. Staff who show gaps can move on to Project Management Fundamentals.
A communication skills assessment follows the same pattern. Ask staff to write a short business email or summary report and mark it against a consistent guide covering clarity, structure and tone. In every case, a practical task with a fixed marking guide gives better evidence than self-rating.
From Assessment to Training: How BOTI Closes the Gaps
Once you know each person’s level, BOTI can match them to the right course. Our Microsoft and data curriculum covers every band your assessment is likely to reveal:
- Microsoft Excel Beginners and Microsoft Excel Intermediate to Advanced: the workhorse courses for most teams
- Microsoft Power BI Basics and Data Analytics Fundamentals with Excel and Power BI: for staff moving into reporting and dashboards
- Microsoft Office All-in-One: broad upskilling across Word, Excel, PowerPoint, Outlook and OneNote in one programme
- Introduction to Computers and Microsoft Office Basics: for staff who need core digital literacy first
When we train in-house, we can build exercises around your own files, systems and reports, so staff practise on the work they actually do. Ask BOTI to help you build a simple skills matrix for your team before you book.
Delivery Formats
BOTI runs the follow-on training in the format that suits your operation:
- In-house at your premises, tailored to your data and convenient for whole teams
- At BOTI’s venue in Sunningdale, Johannesburg, away from desk distractions
- Live online for distributed or multi-branch teams
Using the same course content and marking standard across sites keeps results consistent for every branch.
Accreditation: Short Courses and the Accredited Route
BOTI is a QCTO-accredited Skills Development Provider and a Level 1 B-BBEE contributor. Our Microsoft Office short courses, such as the Excel, Word and All-in-One courses above, are not accredited. They are practical professional skills programmes, and delegates receive a BOTI certificate of attendance.
Where staff need an accredited outcome, the accredited computer route is pending. BOTI has applied for QCTO accreditation for three occupational skills programmes in end user computing: Basic End User Computing (SP-240201), Intermediate End User Computing (SP-240202) and Advanced End User Computing (SP-240203). Enrolment opens only once the QCTO confirms the accreditation, and you can ask BOTI to tell you when it opens. Skills programmes are not full qualifications. Once open, each one will end in a Final Integrated Supervised Assessment (FISA) run by BOTI, and the QCTO will issue the certificate. Until then, BOTI’s non-accredited computer courses above cover each level, and your assessment results show which level suits each person.
The older National Certificate: IT End User Computing (61591) closed to new learners on 30 June 2026.[1] Only learners who were already enrolled can complete it.
Skills Development Planning and Your WSP
Assessing and then training your team fits naturally into structured skills development planning. As general guidance:
- The Skills Development Levy (SDL) is 1% of payroll[2], paid monthly through SARS.
- Employers submit their Workplace Skills Plan and Annual Training Report to their SETA by 30 April[3] each year.
- The SETA mandatory grant is 20% of levies paid.[3] It is paid back when the WSP/ATR is submitted on time and levy payments are up to date. Unclaimed mandatory grant money moves to discretionary funding by 15 August.[3]
A computer skills assessment strengthens your WSP because it gives you documented, role-based reasons for each training intervention. This is general information, not financial or legal advice. Confirm the specifics with your SETA or your skills development facilitator.
Why BOTI
- Assessment-led, not generic: identify the gaps first, then train to them
- Full Microsoft and data curriculum: one provider for every level your team needs
- An accredited route on the way: BOTI has applied for QCTO accreditation for End User Computing skills programmes at three levels, and you can ask BOTI to tell you when enrolment opens
- Tailored, in-house delivery: built around your real spreadsheets, reports and systems
- Clients including Sasol, Glencore and the City of Johannesburg
- 450 courses and a Google rating of 4.8 from more than 770 reviews
Frequently asked questions
What is a computer assessment?
A computer assessment is a structured test of what staff can actually do in everyday business software such as Excel, Word, Outlook and PowerPoint. It places each person at a beginner, intermediate or advanced level, so you can target training instead of guessing.
How do I run a computer skills assessment for my team?
Define the software each role needs and set clear competency levels. Give staff a short practical task test, which is more reliable than self-rating, and map the results to a skills matrix. Then book training that matches each person’s level.
What should a computer competency test cover?
For most South African teams it should cover Microsoft Excel, Word, Outlook and PowerPoint. Add Power BI or data analytics for reporting roles, and general computer literacy for staff who are newer to digital work.
Can BOTI deliver the training in-house or online?
Yes. BOTI trains in-house at your premises, at its venue in Sunningdale, Johannesburg, or live online. In-house delivery lets the trainer use your own files, reports and systems.
Is there an accredited option for computer skills training?
Not yet. The accredited computer route is pending. BOTI has applied for QCTO accreditation for the occupational skills programmes Basic, Intermediate and Advanced End User Computing (SP-240201, SP-240202 and SP-240203), and enrolment opens only once the QCTO confirms it. You can ask BOTI to tell you when enrolment opens. For now, BOTI’s Microsoft Office short courses cover each level. They are not accredited, and delegates receive a BOTI certificate of attendance.
Plan Your Team’s Computer Skills Training
Once your assessment shows where each person sits, Microsoft Office All-in-One: Word, Excel, PowerPoint, Outlook and OneNote gives staff broad, practical upskilling across the core Microsoft tools in one programme. Specialist Excel or Power BI courses can then cover the remaining gaps. Training runs in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online. This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance. To match each level to the right course, request a quote. Call BOTI on 011 882 8853 or email [email protected].
Sources
- National Certificate: Information Technology: End User Computing (SAQA ID 61591) – South African Qualifications Authority (SAQA), 2026.
- Skills Development Levy – South African Revenue Service (SARS), 2026.
- Mandatory Grants – Health and Welfare SETA (HWSETA), 2026.