School Analysis System
A Django based web application designed to manage student information, academic records, and administrative processes. It integrated PostgreSQL for data handling and incorporated a small machine learning model to predict student failure risk.
One of the administrative sections of the school handled everything manually, every process had to be carried out and searched one by one, consuming a lot of time and energy on tasks that could have been automated. The objective was then, to create a solution that would act as an intermediary, process all the data, and generate the required documents. I was in charge of designing and creating the solution from the ground up, ensuring that the administration's requirements were met. I held multiple meetings with the administrator to gather requirements, discuss how they needed to be met, and define the platforms to be used. After collecting both functional and non-functional requirements, I decided to build a web application. I chose Django as the main framework, leveraging my expertise in Python and Django's 'batteries-included' architecture to accelerate development. For the database, I selected PostgreSQL due to its strong compatibility with Django. Since one of the requirements was a prediction tool, I implemented a machine learning model using scikit-learn to estimate the likelihood of student failure. The biggest challenge was integrating with the school's legacy system, which was highly problematic. The final solution involved connecting to the system's API to replicate part of its database, enabling processing and the automated generation of required documents. I worked alongside a colleague who was responsible for setting up the servers and implementing fault-tolerance strategies with Kubernetes. I also received continuous input from several professionals who helped guide the design of the solution. This professionals weren't part of the team, but they played a very important role in this project for me. I'm very grateful with them and with my colleague for working with me. Although the project ultimately stalled due to the school not granting API access, it was successfully developed to the prototype stage and formally presented. Despite the school later prioritizing another internal initiative, our prototype earned positive feedback from teachers and researchers and was recognized as fulfilling the requirements for graduation. The experience not only strengthened my technical skills but also gave me valuable insights into real-world constraints, stakeholder management, and the importance of adaptability in software projects.
Brian Magaña
Link to repository: github.com/BrialexMaga/coordinacion