24 May 2026 8 min read by Eris Taylor

AQA Unit Award Scheme Portfolio Tracking: Ditch the Spreadsheets

aqa-unit-award-schemealternative-provisionsendaward-trackereducationdashdeck

If you run an Alternative Provision centre or a SEND unit that delivers AQA Unit Award Scheme programmes, you already know the admin. The folder for each learner. The photocopied evidence sheets. The spreadsheet — or the three spreadsheets — tracking who has completed what, which units are still outstanding, which learners need one more piece of work before you can submit. And the particular dread that comes the week before an AQA moderation visit, when you're pulling all of it together and hoping nothing has gone missing since last term.

This post is about that specific problem. Why it's harder than it looks. Where most centres are stuck. And what purpose-built AQA unit award scheme portfolio tracking actually looks like when it's done properly.

Why AQA UAS Admin Is Genuinely Hard to Manage at Scale

The AQA Unit Award Scheme is one of the most flexible qualifications in UK education. That flexibility — thousands of available units, no fixed syllabus, evidence gathered at any point, learners accumulating certificates gradually — is exactly what makes it valuable for AP and SEND provision. Learners who can't sit a GCSE can still build a real qualification record, unit by unit, on their own timeline.

But that same flexibility creates an admin structure that doesn't fit neatly into anything schools usually use.

Your MIS records enrolments and attendance. It wasn't designed to track individual unit completion across an open catalogue. Your spreadsheet tracks who has passed what — but it can't hold evidence, it doesn't flag gaps, and it breaks the moment two people edit it at once. Your paper folders hold the evidence — but they're not searchable, they're not shareable with a line manager doing quality assurance, and they won't survive a flood or a fire.

The result, in most centres, is a patchwork: some combination of shared drives, printed portfolios, wall charts, and a spreadsheet that one member of staff owns and everyone else is frightened to touch.

It works — mostly — until it doesn't. It holds up until you have a staff absence, a moderation visit with three days' notice, or a query from AQA about a specific learner's evidence record.

What AQA Actually Expects from a Centre

AQA's guidance is clear on what you're responsible for maintaining:

A record of each learner's unit completions, with dates
The evidence underpinning each unit, stored against the learner's record
A clear audit trail showing who assessed the work and when
The ability to produce that evidence on request, in a format an external moderator can review

None of this is unreasonable. The challenge is that AQA doesn't prescribe how you store it. Which means most centres fall back on what they already have: paper folders and spreadsheets, tools built for entirely different purposes.

An AQA moderation visit isn't looking to catch you out. The moderators want to see that you know your learners, that your assessments are consistent, and that the evidence behind each unit certificate is genuine and accessible. If you can demonstrate that clearly, the visit is straightforward. If your admin is fragmented across folders, drives, and an Excel file that only one person understands, demonstrating it clearly becomes much harder than it should be.

Where Most Centres Are Right Now

The honest picture across most AP and SEND provision is this:

Paper portfolios are still the most common approach. Each learner has a physical folder — sometimes a lever arch file, sometimes a ring binder — containing printed evidence for each unit completed. It works, but it's slow to update, impossible to search, and creates a single point of failure if the file is lost, misfiled, or damaged.

Spreadsheet tracking usually runs alongside the paper system. One spreadsheet per cohort, or one per unit, listing which learners have completed which work. It's better than nothing for getting an overview, but it doesn't hold evidence, it doesn't link to learner records, and the version-control problem (which spreadsheet is current?) is a recurring source of frustration.

Shared drives are a partial fix — scanning evidence and filing it in a folder structure per learner. But folder structures drift over time. Files get named inconsistently. Nobody agrees on whether the folder hierarchy should go year > learner > unit or unit > year > learner, and both versions usually exist by the time the provision has been running a few years.

The patchwork isn't a sign that the staff aren't doing their jobs. It's a sign that they're doing a specialised job with general-purpose tools.

What Purpose-Built Portfolio Tracking Actually Looks Like

EducationDashDeck is the modular education platform we built here at Cognito Coding. It was designed specifically for providers who carry workloads that mainstream school software doesn't support well — tutoring agencies, AP settings, SEND units, and independent providers running accredited programmes.

The Award Tracker module handles AQA UAS portfolio tracking end to end.

Here's what that means in practice:

Learner records mapped to AQA frameworks. Each learner has a profile, and their unit completion is tracked against the AQA UAS catalogue. You can see at a glance which units have been completed, which are in progress, and which are outstanding — without opening a folder or building a pivot table.

Evidence centralised against each unit. Evidence is uploaded and stored against the specific unit it supports, linked to the learner record. There's no separate folder system to maintain. The evidence lives where the tracking lives.

Progress visible at every level. Staff see their own caseloads. Managers get a centre-wide view. No one needs to ask someone else for a summary, and no one needs to rebuild the spreadsheet from scratch each half-term.

Audit-ready reporting. When you need to demonstrate your provision to AQA, to a line manager, or to an Ofsted inspector, you generate a report from the data that's already there. You're not collating across systems at the last minute. You're clicking a button.

Accessible anywhere staff need it. Because Award Tracker is a web platform, not a file on someone's desktop, it's available wherever staff are working — in class, during planning time, or from home when someone needs to update records off-site.

The Workflow Shift

The difference Award Tracker makes isn't just time saved, though staff do spend significantly less time on portfolio admin when the system is working properly. The bigger shift is where energy goes.

When evidence is scattered, a lot of staff time goes into the administration of administration: finding things, consolidating things, updating things in multiple places, recovering from version drift. That's time taken away from learners.

When evidence is centralised and the tracking is automatic, staff can spend their time doing actual quality assurance — reviewing whether the evidence is genuinely meeting the AQA unit descriptors, identifying learners who are close to completing a unit and need one more push, spotting cohort-wide gaps in provision before they become a problem at moderation.

The goal isn't to eliminate the professional judgement that goes into running a good UAS programme. It's to stop the paperwork from competing with it.

EducationDashDeck Is the Ecosystem, Not Just One Tool

Award Tracker is one module within EducationDashDeck — the modular command centre we've built for education providers. The modules are designed to work together, and for AP and SEND providers the natural path is:

EducationDashDeck as the core platform — your centre management hub
Award Tracker for AQA UAS portfolio tracking (£19.99/mo add-on)
Lesson Logs for session-by-session logging with learner voice capture
Target Tracker for half-termly targets and progress reports
Session Pay if you need to track sessional costs and invoicing

You don't have to take all of them. Every module works standalone. But they share a single learner record, which means the data flows: a session note in Lesson Logs sits alongside the unit evidence in Award Tracker, and the half-termly report in Target Tracker draws from both. No double-entry. No re-importing CSV files between systems.

EducationDashDeck Small starts from £69/month for up to 50 users with one Basic app included. Award Tracker is a Premium app add-on at £19.99/month. So a centre running EducationDashDeck with Award Tracker is looking at around £89/month to replace their paper portfolios, their tracking spreadsheets, and the hours that go into maintaining both.

There's no setup fee. We don't charge separately for the build or configuration. You pay the monthly subscription once you're happy with what you see.

Who This Is For

Award Tracker is built for provision that's already running AQA UAS programmes and feeling the friction of managing it on general-purpose tools.

That means:

AP centres managing diverse cohorts, often with complex individual needs and non-standard learning trajectories
SEND units within mainstream schools or operating independently, where learners may be working across multiple accreditation frameworks
Pupil Referral Units that need a clear audit trail to demonstrate quality to commissioners and inspectors
Independent SEND providers delivering accredited programmes outside the mainstream school structure

If you're managing fewer than ten learners on UAS, you might still get by with what you have. But if you're running any kind of scale — multiple cohorts, multiple staff, multiple unit frameworks running in parallel — the patchwork admin starts costing more than it saves.

A Note on the People Behind This

Cognito Coding was founded by Eris Taylor, who spent over 25 years in UK education — classroom teacher, Head of Science, Advanced Skills Teacher, Deputy Headteacher. The EducationDashDeck ecosystem exists because Eris has lived the admin problem from the inside. The tools were designed by someone who understands what AQA moderation actually looks like, what Ofsted inspectors ask about evidence, and what happens to provision quality when the admin burden on staff gets too heavy.

We didn't build this to sell software. We built it to fix a workload problem we know from experience.

Next Steps

If you're running AQA UAS provision and the portfolio tracking is causing you pain, we'd like to show you what EducationDashDeck and Award Tracker look like in practice.

Get in touch at info@cognitocoding.com to arrange a walkthrough — no sales script, just a look at the system against your actual workflow. Or visit cognitocoding.com/education-dashdeck to read more about the full module ecosystem.

The portfolios exist to support your learners. The tracking shouldn't be competing with that.