Ike Lim← All projects

Case Study

Economics Manager

Python desktop automation that tabulates student scores for economics teachers - built for Anglo-Chinese Junior College.

Jun 2022 – Aug 2023

PythonTKinterFile I/O

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 TKinter interface listing classes and students for score entry
The TKinter interface reading class lists

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.

An auto-generated scoresheet produced by the tool
Auto-generated results, output through the file I/O system

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.