Training attendance and assessment tracking for certificates and audits

Picture a trainee on the last day of a twelve-week course, asking for her certificate. Her trainer is happy with her work. Then the office adds up the register and finds she missed nine of thirty-six training days, which puts her under the institute's 80 percent rule. Nobody told her in week six, when she could still have caught up. Now the institute either bends its own rule or turns away a trainee who did the work, and the employer who paid for her place hears about it whichever way it goes.

Training attendance and assessment tracking during the course would have caught her in week six. This guide follows a fictional cohort at Elmwood Accounting Institute: 18 trainees on a bookkeeping program that meets three days a week for 12 weeks, so 36 training days in all. These numbers are an example.

Write the certificate rules in plain numbers

A rule such as "at least 80 percent attendance" sounds clear until someone asks what counts. Turn it into days and settle the edge cases before the course starts.

• 80 percent of 36 days is 28.8, so Elmwood requires 29 days. A trainee can miss seven days, and the eighth puts the certificate out of reach.
• Decide whether a late arrival counts as attended. Elmwood counts it, and the trainer adds a note when someone arrives more than half an hour late.
• Decide what happens to excused absences, such as illness with a note. Elmwood counts them as missed, but the manager can approve up to two catch-up sessions per trainee.
• Put the assessment requirement next to it, for example a pass in every module and in the final assessment, with one resit allowed per module.

Print these rules in the enrolment pack and read them out on the first day. A rule that trainees heard in week one is much easier to apply in week twelve.

A register that still holds up a year later

The register has to be taken on the day, by the trainer in the room. A register filled in on Friday for the whole week is a guess, and it reads like one to an auditor. Every trainee needs a mark every day, including the ones who were present, so that a blank can never be mistaken for attendance.

Corrections happen, and they are fine when they leave a trace. If a trainee was marked absent but was in the practical room next door, change the mark and record who changed it. A register where every change has a name and a date is more convincing than one that looks perfect.

Practical days belong in the same register as classroom days. If a cohort spends a day on a workplace visit or in a skills lab, take attendance for that day like any other, or the days that matter most for a skills qualification end up with the thinnest records.

Plan continuous and final assessment at the start

Continuous assessment only works when the dates, maximum marks and pass marks are fixed before the cohort begins. Elmwood's bookkeeping program uses this plan, as an example:

Week	Assessment	Type	Pass mark
3	Double entry exercise	Written, out of 40	24
6	Bank reconciliation task	Practical, out of 50	30
9	Small business case study	Written, out of 60	36
12	Final assessment	Written out of 100, practical out of 50	60 and 30

The practical parts carry their own pass marks, so a strong written paper cannot hide a weak practical. Institutes where most of the course is hands-on will find more detail in our guide to recording practical assessments and competency.

Moderate, then lock

Before results reach trainees, a second trainer checks a sample of the marking. Elmwood takes five scripts per assessment, including the highest, the lowest and one close to the pass mark. Once moderation is done, the marks are locked. Any later change needs a senior person and leaves a record of who made it.

Check the threshold while there is still time

Elmwood checks attendance at the end of weeks 4 and 8. By the end of week 4 the cohort has had 12 training days, and three trainees are under 80 percent:

Trainee	Days attended out of 12	Rate so far	Days they can still miss
Trainee A	9	75%	4
Trainee B	8	67%	3
Trainee C	7	58%	2

Each of them gets a conversation that week, with these numbers on the table. Trainee C has two days to spare and eight weeks to go, so the manager also calls her sponsor, as agreed in the enrolment terms for sponsored trainees. Week 8 repeats the check. By then the margin is nearly gone, and the conversation is about catch-up sessions.

When an awarding body samples a trainee

External reviewers rarely ask for everything. They pick a cohort and a few trainees and ask you to show the full trail for each one. For a single sampled trainee, Elmwood aims to produce these within an hour:

• every register of the cohort, with who took each one and any corrections;
• the assessment plan, and the trainee's mark in each assessment with who marked it;
• moderation notes, and any change made to a mark after it was locked;
• the certificate number and issue date, or the reason no certificate was issued;
• any appeal or resit, with dates.

Keep these for as long as your awarding body or your sponsor contracts require. If one sampled trainee takes an afternoon of searching, a full visit will take days.

Attendance and assessment in SkoolBro

In SkoolBro each cohort is a class section, and its trainers mark the day's register as present, absent, late or excused, with an optional note. If the connection drops, the register saves on the phone and sends when the connection returns. Each register keeps who took it, and later corrections go into the audit log. A trainee's attendance rate counts present and late as attended. Excused days count as recorded days that were not attended, so if your rule forgives some excused absences, check those trainees by hand. When a sponsor is the trainee's guardian, they get the same-day absence notice by email or in the app.

For the week 4 check, the AI assistant answers a question such as "Which trainees are under 80 percent attendance?" from your own records, lowest first, with each trainee's cohort. It only reads, so it cannot change a mark. Our guide to AI in training institute administration covers what else it can answer.

Each assessment point is set up as an exam, with a paper for each module and a date, maximum marks and pass mark on every paper. Practical work is set up as its own module, so it gets its own paper. Trainers enter marks for their own cohorts and lock them, and the office publishes results to the trainee portal. The exam analysis shows how each module and cohort did. SkoolBro does not combine several assessments into one weighted final mark yet, so if your rule weights continuous and final assessment, work out the final figure from each assessment's results in your own spreadsheet. Online tests are not built either.

When a trainee meets the rules, your office issues a certificate from a template of the "other" kind, in your institute's own wording, with a number and a code that anyone can check online. SkoolBro does not issue certificates automatically when a course ends, so the final check stays with your office.

Questions

Should excused absences count towards a certificate attendance threshold?

That is your rule to set, and it should be written down before the course starts. A simple approach is to count every missed day the same way and allow a fixed number of catch-up sessions that a manager approves.

Can SkoolBro combine continuous and final assessment into one weighted mark?

Not yet. Each assessment has its own results for each module. If your rule weights continuous and final assessment, work out the final figure from those results in your own spreadsheet.

How do we show an awarding body that our attendance records are genuine?

Show the daily registers for the cohort, who took each one and any later corrections. In SkoolBro each register keeps who took it, and corrections are written to the audit log with who made them and when.