How to build a training matrix

What a training matrix is

It's a single page a lead can read. You look across a row to see everything one person is trained on. You look down a column to see who can run a given piece of equipment or task.

It isn't a training plan, and it isn't the training records. It points at them. The sign-off, the certificate and the date live in the record. The matrix shows the summary.

Rows and columns

Pick one way to set up rows and stay with it.

• People as rows. Best when you need to know who can run the lift or sign the permit. Use this for a crew or a site.
• Roles as rows. Best for setting what a new operator, a flagger or a lead must have. Use this to define requirements.
• Courses and skills as columns. Group them: site orientation, equipment, safety procedures, permits and certifications.
• Keep a course and a skill apart. A course is something taught. A skill is something shown on the job.
• Start small. One crew and the ten or so items that matter most. Add the rest once that part is trusted.

Levels

A box ticked or empty isn't enough. Use a few levels and define each one in words so every lead reads them the same way.

• Not trained. The person hasn't done the training. If the role requires it, this is a gap.
• In progress. Started, not finished. Often means classroom done, hands-on still to come.
• Trained. Completed the course or instruction. They've been taught, not necessarily checked.
• Verified. A qualified person watched them do the task and signed off. This is the one that lets someone work unsupervised on it.
• Decide who is allowed to verify each item. Often a lead or a competent person. Follow your company's procedure.

Expiry dates

Some training and certifications run out. Some equipment qualifications need refreshing on a schedule. How often depends on the equipment, the maker, the rules and your company's procedure. Look it up, and don't guess.

Put an expiry date on any item that has one. Then decide who gets told, and how many days ahead, so there's time to book a refresher.

Build it step by step

1. 1

   Pick the scope

   Choose one crew, one site or one role. A matrix for the whole company on day one never gets finished.

2. 2

   List the jobs and what each requires

   For each role, write what training, certifications and sign-offs it needs. Use your procedures, the equipment manuals and the current rules that apply to you.

3. 3

   Set your columns

   Turn that list into columns. Group them. Mark which ones are required for which role, so a gap shows up as a gap.

4. 4

   Define the levels

   Write down what not trained, in progress, trained and verified mean on your site. Say who can mark each level.

5. 5

   Fill it from the records you have

   Go to the certificates, sign-in sheets and training files. Enter what you can prove. Leave a box empty if you can't find the record. An honest gap beats a guess.

6. 6

   Add expiry dates and owners

   Put in dates where they apply. Assign one person to own the matrix, and one to own each course or skill.

7. 7

   Look for gaps and act

   Find the empty or expired boxes that matter. Book the training or the sign-off. Put dates on them.

8. 8

   Set a review rhythm

   Decide how often the owner checks it, and what triggers an update: a new hire, a new piece of equipment, a transfer, a near-miss or a change in the rules.

Who owns it and how to keep it live

A matrix is out of date the day after you finish it unless someone owns it. Name one person. Give them time to do it.

• Update it when the event happens, not at year end. Finish a course, update the box.
• Update it when someone joins, leaves or moves crews.
• Check it before assigning a task. Look at the matrix before you put someone on the job.
• Review it in a short regular meeting with leads. Walk the gaps, not the whole grid.
• Keep the records and the matrix together, so a box links to its proof.

Spreadsheet or a system

A spreadsheet is a fine start. It's free to try, and it forces you to decide what goes in it. It gets harder to keep honest as it grows.

• Spreadsheet: quick to start, easy to change, one person edits it. Weak on reminders, version copies, and linking to proof.
• System: updates when training is completed, warns before expiry, shows who's qualified by site and keeps the proof attached. Costs money and takes setup.
• Move when the spreadsheet is being copied, emailed or checked by hand more than it's used.
• If crews have no desk, check that the tool works on a phone and offline.

Common mistakes

• Building the whole company first and never finishing.
• Treating trained as the same as verified.
• No expiry dates, so a lapsed certification looks current.
• Nobody owns it, so it goes stale.
• Ticks with no proof behind them.
• Listing every course, including ones no job requires.
• Only the office can see it. The foreman can't check before assigning work.
• Using it to check a box for an audit. A matrix records what you know. It doesn't make anyone competent.