Event-Driven Processing
Built an event-driven Google Apps Script workflow triggered automatically on learner submission, allowing reviews and feedback generation to happen immediately after form completion.
Rule-Based Code Analysis
Developed structured checking logic for SQL requirements, syntax patterns, task completion indicators, extension activities, and common learner mistakes using reusable rule-based validation systems.
AI Review Layer
Added AI review detection logic combining hard evidence markers, soft phrasing analysis, score adjustment rules, instructor visibility controls, and structured AI outcome reporting.
Queued Email Infrastructure
Designed a queued email delivery system with retry handling, trigger automation, delivery tracking, idempotency protection, batch processing, and failure management to improve reliability across large learner groups.
Automated Reporting & QA
Integrated automated RAG tracking, HTML feedback generation, spreadsheet validation, delivery state tracking, and assessment reporting to support scalable quality assurance workflows.
Instructor-Centred Design
Structured the system to support instructor judgement rather than replace it, ensuring automated checks accelerated workflow efficiency while final assessment decisions remained human-led.