Assessment Workflow Automation

Case study · Learning operations automation

Assessment Workflow Automation for Instructor-Led Training.

Replacing a paper-based end-of-training quiz with a QR-code assessment, automated scoring, learner feedback, pass/fail routing, and training record preparation while preserving the live assessment experience.

Project snapshot

A small workflow change that gave time back to teaching.

Learners were failing a required training, and staff believed many were close enough that a little more instructional time could help. I reviewed the session flow and found that the paper exam at the end was one of the biggest time drains.

AudienceLearners in instructor-led procedural or compliance training.
RoleWorkflow analysis, automation logic, assessment redesign, SOP documentation.
ToolsMicrosoft Forms, Power Automate, Excel, Outlook, QR codes.
OutputAutomated scoring, emails, pass/fail routing, tracking list, SOP.

The problem

The quiz was taking time away from the training itself.

The paper exam created a slow end-of-session process. The instructor had to find the quiz, hand it out, make sure learners had pens, wait while learners completed it, grade responses manually, discuss answers, and then handle score follow-up.

The assessment was important, but the manual process was using time that could have gone toward final clarification, practice, or review. The issue was not that the quiz existed. The issue was that the workflow around it was too slow.

Design challenge

Keep the assessment in the live training, but remove the avoidable administration around it.

The solution had to preserve accountability while making scoring, feedback, notifications, retakes, and records easier to manage.

The solution

A QR-code quiz connected to automated scoring and notifications

Learners scanned a QR code, completed the quiz on their phone, and Power Automate handled scoring, feedback emails, pass/fail routing, and record preparation.

01

Digital assessment

The paper exam was replaced with a Microsoft Forms quiz that could still be completed during the live session.

02

Automated grading

Power Automate checked each answer, added points to a score variable, and calculated the final score.

03

Feedback and routing

Learners received score emails, incorrect-answer feedback, and either pass confirmation or retake instructions.

My process

From bottleneck to repeatable workflow

1. Identify the bottleneck

I reviewed the training flow and found that the paper quiz process was consuming time that could be used for instruction.

2. Preserve the requirement

The quiz still needed to happen during the live session, so the design kept the accountability while changing the delivery method.

3. Build the quiz

I used Microsoft Forms so learners could access the assessment through a QR code and complete it on their phones.

4. Map the automation

I designed the flow to pull responses, score answers, branch by pass/fail status, and notify the right people.

5. Prepare records

Passing scores were routed into a tracking list that could support LMS upload and training record preparation.

6. Document the SOP

I wrote procedural instructions so the workflow could be tested, maintained, and handed off.

Artifacts and thinking

Showing the workflow, not just describing it

These visuals show what changed, how the automation worked, and how the process was documented for future use.

Before / after workflow

How the assessment shifted from a paper-based manual workflow to a digital quiz with automated support.

Before: paper quiz workflow Find quiz Hand outpaper + pens Manual quiz Manualgrading Result: slower feedback, more admin work, and less time for final instruction. After: automated assessment workflow QR codelive session Forms quizon phone Automatedscoring Pass/failrouting Result: faster scoring, immediate emails, cleaner records, and more time for teaching.

Automation logic map

The basic Power Automate logic: submission, response capture, score calculation, routing, emails, and tracking.

Automation logic map Form submittedQR quiz completed Get detailsresponses pulled in Initialize scoreinteger variable Check answerscondition + increment score Final scorecompose total Score ≥ 80?pass/fail branch Pass routeEmail learner, trainer, coordinatorAdd row for LMS upload Retake routeSend retake instructionsUse alternate quiz version

SOP documentation preview

The supporting SOP documented Forms setup, group ownership, QR sharing, Power Automate triggers, response details, score variables, answer conditions, email notifications, Excel tracking, testing, and shared ownership.

Form submitted → Get response details → Initialize score → Check answers → Compose final score → If score ≥ 80, update records and send pass email → If under 80, send retake instructions.

Results and takeaways

The automation recovered time and reduced manual follow-up.

The change freed up enough time, along with a few other small adjustments, to give learners more support before the final assessment. Staff no longer had to spend as much time distributing, grading, and manually processing the quiz.

The new workflow also improved feedback and record consistency. Learners received faster information about their score and incorrect answers, while staff received completion and score details needed for follow-up and LMS record preparation.

Why this matters for L&D

This is learning operations work, not just automation.

It shows how small process changes can improve instructional time, assessment feedback, trainer workload, learner accountability, and training record readiness without removing the live structure of instructor-led training.

Project takeaway

Sometimes improving training means redesigning the workflow around the learning.

This project shows how assessment design, automation, documentation, and learning operations can work together to make instructor-led training more efficient and easier to manage.