Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
A computer skills assessment measures what your staff can actually do in Excel, Word, Outlook, PowerPoint and core digital tools — so you stop guessing about training needs and start fixing real gaps. For South African HR, L&D and operations leaders, it is the fastest way to justify a training budget, target spend, and prove return on your skills-development investment. This guide shows you how to run one, what to measure, and how to turn the results into accredited, often funded training for your team.
BOTI (Business Optimization Training Institute) helps SA employers benchmark their teams and then close the gaps with practical Microsoft Office and data courses — the same 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 across the everyday software your business runs on. Instead of asking “can you use Excel?” (everyone says yes), it 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 expensive and common:
- Wasted time. Staff who fight their tools take longer on every task — manual workarounds in Excel, re-typing data, slow document formatting.
- Hidden risk. Untrained users make costly 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; everyone else routes work through them.
An assessment replaces opinion with evidence. You get a clear picture of where each person sits — beginner, intermediate or advanced — so your next training rand is spent exactly where it moves the needle.
Who This Is For
This guide is written for South African organisations training their own staff and teams, 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 live in Excel, reports and email all day
- Skills-development facilitators mapping spend to B-BBEE and SETA reporting
If you are buying training for a team rather than for yourself, an assessment is the planning step that makes every other decision easier to defend.
How to Run a Computer Skills Assessment: 6 Steps
Step 1 — Define the roles and software that matter
List the actual tools each role uses and the level required. A finance analyst needs advanced Excel; a receptionist needs solid Outlook and intermediate Word. Don’t 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 (best): give staff a real file and ask them to complete tasks — clean this data, build this report, format this document.
- Scenario questionnaires: quick self-rating plus knowledge questions, useful for large teams as a first filter.
- Observation: a trainer reviews live work for hands-on roles.
A short practical test (20–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 are comparable. Keep it low-pressure — frame it as planning, not a performance review, so staff answer honestly.
Step 5 — Map gaps to a skills matrix
Plot people against required levels to see your gaps at a glance — who needs Excel intermediate, who needs Power BI, 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 — not a generic “computer course” for everyone. This is where BOTI’s course range lets you assign the exact right programme to each band.
What the Assessment Should Cover
A thorough computer skills assessment for an SA workplace typically spans:
- Microsoft Excel — formulas, functions, formatting, charts, PivotTables, data cleaning, dashboards (the highest-impact area for most teams)
- Microsoft Word — professional documents, styles, templates, mail merge, track changes
- Microsoft Outlook — inbox and calendar management, rules, professional email
- Microsoft PowerPoint — clear, on-brand presentations
- Power BI / data analytics — turning data into reports and dashboards for decision-makers
- General computer literacy — file management, navigation, security basics for staff newer to digital work
From Assessment to Training: How BOTI Closes the Gaps
Once you know each person’s level, BOTI matches them to the right course. We deliver a full Microsoft and data curriculum so one provider can cover every band your assessment reveals:
- MS Excel Beginners and Advanced Microsoft Excel — the workhorse courses for most teams
- Microsoft Power BI Basics and Data Analytics — for staff moving into reporting and dashboards
- Microsoft Office All-in-One — broad upskilling across Word, Excel, Outlook and PowerPoint in one programme
- Introduction to Computers — for staff who need core digital literacy first
- Browse the full range on our training courses hub to build a multi-level plan
Because we deliver in-house, we can tailor the assessment and the training to your real files, systems and reports — so staff learn on the work they actually do.
Delivery Formats and National Reach
BOTI runs assessments and the follow-on training in the format that suits your operation:
- In-house / on-site at your premises — most cost-effective for teams and tailored to your data
- Off-site at a venue, away from desk distractions
- Online / remote for distributed or multi-branch teams
We deliver across Johannesburg, Cape Town, Durban and Pretoria, plus remote arrangements nationwide, so a single, consistent standard reaches every site.
Accreditation
BOTI’s core Microsoft Office and computer-skills training is accredited as the IT: End User Computing qualification through the Services SETA and MICT SETA (BOTI is an accredited training provider — Services SETA 12582, MICT SETA ACC/2016/07/0045, and a QCTO Quality Partner). These unit-standard qualifications are migrating to the new QCTO system — accredited enrolment is available now, and we will confirm current accreditation for your chosen course when you book, so your spend counts towards staff development and your organisation’s skills-development reporting. Where a specific role needs a particular accredited outcome, our consultants will confirm the right course and pathway for you.
Funding: Skills Development Budget and B-BBEE Points
Assessing and then training your team can form part of your structured skills-development planning. As general guidance only:
- The Skills Development Levy (SDL) is 1% of payroll for employers above the threshold.
- The B-BBEE skills-development element targets spend of 6% of the leviable amount (not 6% of payroll).
- Building assessment-led training into your WSP and ATR supports both staff capability and your transformation scorecard, and may help you reclaim a portion of your levy through your SETA.
A computer skills assessment strengthens this reporting because it gives you documented, role-based justification for every training rand. This is general information, not financial or legal advice — confirm specifics with your SETA or B-BBEE verification professional.
Why BOTI
- Assessment-led, not generic — we benchmark first, then train to the gaps
- Full Microsoft and data curriculum — one provider for every level your team needs
- Accredited computer-skills training — IT: End User Computing via Services SETA / MICT SETA (these unit-standard qualifications are migrating to QCTO; accredited enrolment is available now — confirm current accreditation when you book)
- Tailored, in-house delivery — built around your real spreadsheets, reports and systems
- Trusted by leading SA organisations including Sasol, Glencore and the City of Johannesburg
- 450+ courses and national reach — 011 882 8853 | boti.co.za
Free resource: Ask us for a free Computer Skills Assessment template and skills-matrix — a ready-to-use spreadsheet to benchmark your team and map training needs before you spend a cent. Request the free template.
Frequently Asked Questions
What is a computer skills assessment?
It is a structured test of what your staff can actually do across everyday business software — Excel, Word, Outlook, PowerPoint and data tools. It places each person at a beginner, intermediate or advanced level so you can target training precisely instead of guessing.
How do I run a computer skills assessment for my team?
Define the software each role needs, set clear competency levels, give staff a short practical task test (more reliable than self-rating), map the results to a skills matrix, then book training that matches each person’s level. BOTI can run the assessment for you and supply a free template to get started.
What software should the assessment cover?
For most SA teams: Microsoft Excel (the highest-impact area), Word, Outlook and PowerPoint, plus Power BI or data analytics for reporting roles and general computer literacy for staff newer to digital work.
Can BOTI deliver the assessment and training in-house?
Yes. We assess and train in-house, off-site or online across Johannesburg, Cape Town, Durban, Pretoria and remotely. In-house delivery lets us tailor everything to your own files, reports and systems, and group rates lower the cost per person.
Does this training qualify for skills-development funding or B-BBEE points?
BOTI’s computer-skills training is accredited as IT: End User Computing through the Services SETA and MICT SETA — these unit-standard qualifications are migrating to the new QCTO system, so accredited enrolment is available now and we will confirm current accreditation when you book. Accredited training can form part of your Workplace Skills Plan and supports both your SDL position (1% of payroll) and the B-BBEE skills-development element (target of 6% of the leviable amount). This is general guidance, not financial or legal advice — confirm with your skills-development facilitator.
Request a Quote or a 15-Minute Callback
Stop guessing about your team’s computer skills. Request a quote or book a free 15-minute callback and a BOTI consultant will help you run a computer skills assessment, interpret the results, and build a targeted, funded training plan for your team. Call 011 882 8853 or ask for our free Computer Skills Assessment template to start benchmarking today.