Start with roles and actual tasks
A role requirement describes what learning or assessment the work calls for. An individual completion record describes an event involving a particular employee. Start by defining the former so the latter has a clear purpose. A shared role name is not enough if the tasks or responsibilities differ.
Use the training matrix construction guide for the wider setup. Here, the examples focus on choosing useful role-to-task relationships. They are editorial starting points, not a universal syllabus or instructions for performing the work.
Four role-based examples
| Role | Illustrative task | Evidence to consider | Review trigger |
|---|---|---|---|
| Production operator | Assembly setup | Instruction version, training event and any required demonstration | Changed setup instruction or unresolved assessment |
| Maintenance technician | Servicing under the site procedure | Procedure reference, completion evidence and task assessment where required | Changed equipment responsibility or procedure |
| Quality inspector | Inspection against the current instruction | Instruction reference and evidence of applying the inspection criteria | Revised inspection instruction or review finding |
| Shift supervisor | Checking role coverage | Applicable role requirements and evidence of the coverage review | Changed staffing responsibilities or role requirements |
The rows deliberately describe different evidence questions. They do not prescribe the same assessment for each role. Check which requirements apply, who owns them and what evidence would support the relevant decision. Keep a task that is outside the role visibly excluded with its reason, rather than recording an invented completion.
Add people only after defining the requirements
Once the role requirements are clear, connect each employee's actual assignments to their own training and assessment records. Check the work they perform, including changes in responsibility. These examples are not evidence that anyone completed training. Do not copy an illustrative result into a working record.
The ISO/IAF APG competence guidance, pages 5-6 distinguishes participation from effective application and notes that competence needs can change. This is ISO 9001:2015 auditing guidance, not a rule that these four roles or fields are mandatory. Keep completion and assessment evidence separate when adapting a row.
Keep the example and the working record separate
Use the existing training matrix tool for the separate worksheet workflow. The explanation here helps choose relationships; it is not another downloadable file or a substitute for the source record. Preserve the distinction between a sample structure and an employee's documented history.
The software and spreadsheet comparison helps frame a different decision: how to maintain the working record. Whichever approach you evaluate, test whether the requirement, event and evidence stay connected when a role changes. Do not assume that a copied example is suitable for import.
What TrainGrid records
TrainGrid records training and evidence; it does not deliver or grade e-learning courses.
TrainGrid records six competency outcomes: Competent, Competent with conditions, Needs improvement, Not competent, Not assessed and Exempt.
Import .xlsx or .csv training history as a matrix with one row per person or a log with one row per completion. Check matches and row errors in a preview before saving. An Administrator can undo an import for 30 days. The import does not complete existing open assignments. Before importing, tick Repeats to set Repeat every (days) for recurring courses. For expiring certificates, tick Requires certificate to set Valid for (days).
Adapt the examples to your site
The UK HSE guide asks organizations to identify actual training needs and check effectiveness in health and safety training, steps 1 and 5. Use those workflow principles with their stated UK context. The example table is not a worldwide legal syllabus, required training interval or certificate of readiness.
Take one role and replace the illustrative task with an actual requirement. Identify the procedure reference, the relevant training event and any assessment needed, then have the appropriate reviewer check the relationship. Record unanswered questions before expanding the structure to other roles.
Continue with the combined training and competency matrix for evidence fields and the operator records guide for evaluating an individual task record.
Read the product guide for the documented workflow and compare the published plans against your requirements.
