Sportkompas

Sportkompas is a web app I co-developed with Gilles Beugnies, Hanne Hellin, and Lennard Verhaege for the Team Project course at HOWEST.

Commissioned by Sport Vlaanderen, the app supports their Sportkompas program, which helps children discover sports that suit them best through two tests: “I Like” (a playful questionnaire) and “I Do” (a set of physical challenges).

We were tasked with digitizing some of the physical tests. To do this, we created a tablet-friendly web interface with two views: a teacher dashboard for managing classes and students, and a student view where children join with a six-digit pin, pick their name, and start a test.
Each test includes example videos, and even non-digital tests can be launched. The student interface is styled playfully to match the “I Like” experience.

My main focus was on the backend's development, which utilized an Azure Functions App and Azure Table Storage for its database. The backend, responsible for all core operations, handled managing teachers, students, classes, sessions, devices, test results, and hardware kits, including CRUD operations, test start/stop actions, and result processing.

The tests were digitized by rebuilding them from scratch and adding electronics and various ESP32 microcontrollers. I co-wrote the firmware for these devices, which included functionalities like Bluetooth and Wi-Fi connectivity. These devices automatically connected to a 4G router provided by our school and were managed remotely using Azure IoT. To house most of these devices, I also designed and 3D printed custom cases on my own 3D printer.

Thanks to the use of a Digital Twin, we could change settings remotely, such as the device's ID and the hardware kit ID it belonged to. A hardware kit is essentially a group of digital tests, which teachers could assign from their dashboard. When a test was started, an Azure Function sent a message to the correct device in the selected hardware kit. The results were then stored in the database.