Student Management Tool

During my time as a tutor at redacted, I identified the need for a more efficient way to manage student information and track progress. To address this, I developed a Student Management Tool using web technologies. This tool allows tutors to easily add and manage student profiles, record session notes, and monitor academic progress over time. By implementing this tool, I aimed to streamline administrative tasks, allowing tutors to focus more on teaching and less on paperwork.

The primary motivation was the inneficiencies in the existing system, which relied on google drive. Where each location, had their own folder, each daypart, each student, and per student 2 different types of files. One for the student themselves to see a planner, and one for the tutor to write notes and assess the students progress. Using this system during work was incredibly time consuming, google drive does not neccesarily load very fast, pair this with navigating through a lot of folders, and opening multiple files, you might build some frustration.

Due to having experience with the google sheets api for my discord clocking bot, i knew there was a way for me to do this faster, without all the slow page loading. I decided to create a desktop application that interfaces with the current google drive system, but provides a much faster and more user friendly interface.

The application is built using Electron.js for the desktop environment and plain js,html and css for the frontend. It connects to Google Sheets API to fetch and update student data in real-time. The user interface is designed to be intuitive, allowing tutors to quickly access student profiles, add notes, and track progress with minimal clicks.

This project taught me a lot about working with APIs, desktop application development, and user interface design. It was rewarding to see how technology can be leveraged to improve educational processes and make a tangible difference in the day-to-day operations of tutoring.

It would be a shame not to mention, that while for employees this was indeed faster, I did not involve the "stakeholder" in the development process. So when I eventually showcased it, they where enthousiastic, but also mentioned elements which I did not include which where fairly obvious elements to add. This experience revealed the value of including stakeholders in the design, where they showed me multiple elements they valued I did not expect, reinforcing my commitment to inclusive, iterative processes.