Case Study
Economics Manager
Python desktop automation that tabulates student scores for economics teachers - built for Anglo-Chinese Junior College.
Jun 2022 – Aug 2023
The problem
Economics teachers at Anglo-Chinese Junior College (ACJC) were entering student scores into spreadsheets by hand - repetitive, slow work that was easy to get wrong. Every round of assessments meant tabulating the same figures again, leaving less time for the actual teaching.
The approach
I worked with the economics educators to understand their marking workflow, studied the tabulation patterns they already used, and designed a tool tailored to them rather than a generic spreadsheet macro.
Economics Manager is a Python desktop application with a streamlined TKinter interface. It reads class and student data, tabulates results through a file I/O system, and keeps everything organised in a structured folder layout so files stay easy to find.

The outcome
Teachers can now generate accurate scoresheets in a few simple clicks instead of tabulating by hand. Removing the manual step cut the effort and the error risk of results processing, and let teachers redirect their focus toward analysing the data and instructing students.

Learnings
Building for non-technical users meant the interface mattered as much as the logic - the tool had to fit an existing workflow teachers already trusted, not ask them to learn a new one.