Curriculum-to-Competency Gap Mapper: Build the Training People Actually Need

The problem this kills

You have a training library — dozens, maybe hundreds of courses — and a nagging suspicion it doesn't line up with the jobs people actually do. Some critical skill has no course behind it. Some course nobody can quite explain still runs every quarter, teaching something no role requires. Two courses overlap so much they're really the same course with different titles. And nobody can answer the simple question a leader keeps asking: "Does our training actually cover what this role needs?"

So the audit happens in a giant spreadsheet. Someone tries to tag each course with the competencies it teaches, cross-references that against role requirements pulled from job descriptions, and color-codes the holes by hand. It takes weeks, it's stale the moment a course changes, and the "gap report" is one person's tab nobody trusts. You don't need to live in that spreadsheet, and you don't need to be a developer to replace it.

What you'll build

A simple internal web tool. You load three things: your course list, your competency library, and your role-to-competency requirements (with proficiency targets — "Beginner / Working / Expert"). The tool asks AI to suggest, for each course, which competencies it teaches and at what level — but it never trusts those suggestions blindly. Your L&D manager reviews each suggested course-to-competency mapping and approves it. Only approved mappings count.

Then the tool does the math you've been doing by hand: it builds a coverage matrix, computes uncovered skills (competencies a role needs that no approved course teaches), flags orphan courses (courses that teach nothing any role requires), and spots overlapping/duplicate courses. It ranks the gaps by how many roles need each missing skill, so you fix the biggest holes first. You get a prioritized gap report and a one-click coverage-matrix CSV export for your LMS or your leadership deck.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how you run training today, where your course catalog and competency framework live, exactly how courses and competencies are named and coded, how role requirements and proficiency levels are defined, your typical and peak volumes, and your messy edge cases (one course teaching many skills, one skill taught by several courses, shared roles across departments) — and then it tailors the data model, the mapping logic, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through loading your data, the AI mapping suggestions, the manager review-and-approve screen, the gap computation, the prioritized report, and the CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no integration to your LMS.

The governance it includes (this is the point)

This is decision-grade tooling — the gap report can drive course-building budget — so it ships with the controls a serious L&D function needs: login so only your team can use it, row-level security so you only ever see your own organization's curriculum, a complete audit trail of who suggested, reviewed, and approved which mappings and when, a hard human-approval gate so no mapping counts toward the gap report until your L&D manager signs off, and duplicate guards keyed on the course-and-competency pair so the same mapping can't be recorded twice. The AI drafts; a person decides; the gap report only ever reflects approved mappings.

Who it's for

L&D managers, training coordinators, and ops leaders who own a training library and need to prove — or fix — whether it covers the real job. If you can describe how your roles map to skills and what your courses teach, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your first coverage matrix and gap list take shape the same afternoon.