A staff training matrix that keeps certificates current

Every organisation has training people must take: fire safety, working at height, food hygiene, how to handle customer data, the procedure for the new machine, the induction for new joiners. Most small teams track it in a spreadsheet with names down the side and courses across the top. It works for a while. Then someone leaves, someone joins, the procedure changes, and the spreadsheet quietly stops being true.

The day it matters is the day someone asks: an auditor, an insurer, a major customer, or worse, an investigator after an accident. "Who has completed the current version of the forklift procedure, and when?" If the honest answer is "I think everyone did it last year", you have a problem.

A training matrix that stays current needs three things: a clear list of what each role must take, refreshers that come round on time without anyone remembering, and a record of who completed which version. This guide shows how to set that up.

Step 1: list what each role must take

Start with the requirements, not the courses. For each role or team, write down the training it needs and how often:

• Everyone: induction, fire safety, data protection, perhaps a code of conduct. Often once at joining, then every year or two.
• Field and warehouse staff: manual handling, working at height, vehicle or forklift use, first aid for some. Often yearly.
• Kitchen or clinic staff: hygiene, infection control. Often yearly or as the rules require.
• Managers: approvals and spending rules, handling complaints, safeguarding where relevant.

Check what your local rules, your insurer and your biggest customers require. Some training is legally required in your country; some is a contractual promise to a customer. Mark which is which.

Step 2: build short courses from what you already have

You probably already have the material: a procedure document, a safety leaflet, a video from the equipment supplier. A course does not have to be a production. A good workplace course is:

• The approved document or procedure, the same version that is in force.
• A short explanation in plain words: why it matters and what to do differently.
• A short quiz, five to ten questions, that checks the points that really matter. "What do you do if the alarm sounds while you are on the roof?" beats "In what year was this procedure written?"
• A pass mark, often 80 %, so a course cannot be completed by clicking through.

Keep each course to what someone can finish in ten or fifteen minutes on a phone. Long courses get postponed.

Step 3: assign by role, not by name

Assigning courses person by person breaks the moment someone joins. Assign by role, branch or team instead: "everyone in the warehouse team takes manual handling within 14 days." A new joiner in that team gets the course automatically, with the full 14 days counted from their start date.

When someone moves to another team, they pick up that team's courses. When someone leaves, they drop out of the matrix without anyone cleaning up.

Step 4: set refreshers and reminders

A completion that never expires is fine for some training, such as an induction. For safety training, set a refresher interval, for example every 12 months. The matrix then knows when each completion lapses.

People should be reminded before a due date or a refresher, not after. A reminder a couple of weeks ahead gives them time to fit it in. Late and expiring training should also reach the person's manager, because the manager can make time for it in the roster.

Step 5: read the matrix every week

The matrix is a grid: one row per person, one column per course, each cell showing the state and date. The useful states are:

• Done: completed and still valid.
• Due soon: assigned, with the due date close.
• Overdue: the due date has passed.
• Expiring: completed, but the refresher is close.
• Expired: the refresher date has passed.

Sort expired and overdue to the top, and spend five minutes a week on them. A percentage of compliant people per branch is a good single number for a monthly management meeting.

Step 6: keep versions honest

Procedures change. When the forklift procedure gets a new step, does everyone need to retake it, or only new joiners? That depends on the change. A typo fix does not need anyone to retake anything; a new safety step does.

Your records should keep each completion with the version it was taken on. When you publish a new version, decide explicitly whether everyone must take it again. Never rewrite old records: the fact that someone completed version 2 last March is exactly what you need to show an auditor.

Training given in a room

Not all training happens on a phone. A first-aid course with a trainer, a practical session on the machine, a toolbox talk on site: record those completions too, with the date and who recorded them, so the matrix shows the full picture.

Certificates

When a completion counts, people and managers should be able to download a certificate. It is useful for the person's file, for customers who ask for proof, and for staff who move between sites.

How to do it in Kluvan

Learning is for the training your team must take, with a record you can prove. Kluvan runs online with nothing to install: everyone takes their training on their phone or a computer, field and restricted seats included.

• Create a course. Add material from your approved documents in Documents, links and short texts, then a quiz with a pass mark (80 % by default), a refresher interval in months and the days to complete it. See create a course with material and a quiz.
• Publish versions. People only take a published version. Each completion keeps the version it was taken on, and when you publish a new one you choose whether everyone takes it again. See publish a course version.
• Assign by role, branch or team. Assign a course to a person, a role, a branch, a team or everyone, with a due date or a number of days; new joiners get the full window from their start date. Roles and teams come from HR. See assign a course.
• Refreshers and reminders. Set a refresher every so many months, the days before which people are reminded, and whether late and expiring training goes on the manager's attention list. See set refreshers, reminders and expiry.
• The compliance matrix. One row per person and one column per course, with tiles for compliant, expired, overdue, expiring and due soon, filters by branch, team and state, and each person's records with the version, score and a certificate. See read the compliance matrix.
• Classroom training. Record a completion given in a room or on paper, with the day, the score and who recorded it.
• On the phone. My training lists each person's courses, the late ones first; they read the material, answer the quiz and get their completion at once. See take a course on your phone.

Learning is sold on its own and comes with Kluvan One and the trial; see pricing. Only published documents of normal confidentiality can be course material, so a restricted file is never shown to everyone a course reaches.

Training starts on the first day. Our post on a simple recruiting pipeline for small teams covers getting the right people in, and field service job costing shows what well-trained crews do to your margins.

Take your most important safety procedure, turn it into a ten-minute course with five questions, and assign it to the team that needs it. Next week, read the matrix.