Learner's Progress Monitoring Tool for AWS re/Start Program

Summary

A web application I built to automate progress monitoring for the AWS re/Start program. It reads Canvas LMS gradebook exports and turns them into a summary of each learner’s Knowledge Check and Lab progress across cohorts.

Problem

Canvas gradebook exports can have 170+ columns per cohort. Now try managing 10 or more cohorts in one batch. Reading each file by hand does not scale, and it is easy to get wrong. The program also ran in Indonesia and India at the same time, which pushed the numbers up again.

Solution

A small web app where coordinators upload several gradebook files at once and get structured results back.

flowchart LR
    A[Upload CSVs] --> B["Parse and Aggregate Data"]
    B --> C[Download Summary]

The workflow is just three steps:

Upload the CSV files (one per cohort)
The app parses and aggregates KC and Lab data
Download the summary

Nothing to install on the user’s side, because it is hosted as a web application.

Impact

Used across 3 AWS re/Start batches
Supports 50+ cohorts in Indonesia and India
Cut manual gradebook processing time significantly
Helped coordinators spot learners who needed support sooner

Tech Stack

Python
Pandas
Streamlit
Deployed on PythonAnywhere

Extras

I also added a learner-facing progress leaderboard using Google Sheets. Learners could see their own KC and Lab scores next to everyone else in the cohort. It cut down the reminder messages coordinators had to send, and learners started checking their own progress instead of waiting to be told.

The step I would change is the one that comes before all of this: someone still has to export the gradebooks from Canvas and upload them, and I never got around to wiring that to the Canvas API.

If you want the full build story, the walkthrough is here:

Creating Learners Progress Monitoring for AWS re/Start Using Canvas Gradebooks