PRISM ↔ PowerSchool Integration

Overview

PRISM is the province's e-learning LMS. For students to access it, their accounts need to be provisioned and kept in sync with the local SIS (PowerSchool). Previously this was a manual process that required staff to export/import spreadsheets and handle exceptions by hand.

What I Built

• Built an automated sync service that provisions new students in PRISM based on PowerSchool enrollment data
• Implemented bi-directional sync: PowerSchool changes propagate to PRISM, and PRISM activity status flows back
• Built a Blazor dashboard using Fluent UI that shows sync status, last run times, error counts, and a per-student audit trail
• Added configurable scheduling and manual trigger support for out-of-cycle runs

Why It Mattered

The manual process was running late regularly and causing students to lose access to course materials. After automation, provisioning happens nightly with near-zero manual intervention. Staff use the dashboard to investigate the handful of exceptions that still require human review.