Interactive dashboard
The dashboard runs on GitHub Pages from SQL-shaped synthetic extracts, with browser-side aggregation, SVG charts, filters, and no external JavaScript dependencies.
Open dashboardProject Brief
Assessment Intelligence
Public-safe assessment system work: SQL-backed extracts, analytics, reproducible R processing, dashboarding, diagnostics, and decision-support reporting for mathematics programs.
Overview
Analytics layer for synthetic assessment records
This project demonstrates how assessment records can become dashboard views, reproducible reports, diagnostics, and decision-support notes without publishing real student data. The current local DuckDB analytics layer uses five SQL-backed synthetic extracts with 3,020 rows, including 2,009 readiness records across 174 course-section groups.
Inspect First
- Hosted synthetic assessment dashboard
- Rendered R gradebook synthesis report and PDF export
- Validation summary for the synthetic gradebook reconstruction
- SQL warehouse assessment report in the source repository
- Dashboard data extracts generated from public-safe synthetic marts
- Assessment reporting case study
Proof Lanes
Three proof lanes
R gradebook synthesis
The R workflow reconstructs a Canvas-style synthetic gradebook from private-reference structure, exports long-form score records, and renders validation-backed reports.
Read R reportWarehouse reporting
The repo extracts course-section performance, assignment growth, non-participation, LMS reconciliation, and readiness records from the synthetic DuckDB warehouse. DuckDB remains the reproducible local baseline, while hosted extracts are treated as a serving layer.
Simulation foundationSafety Boundary
Synthetic by design
Public artifacts must not include real student names, emails, IDs, grades, rosters, LMS exports, submissions, or private school reporting artifacts. Canvas is treated as one possible adapter, not the project identity.