Sistema de apoio à apuração de presença e votação em reuniões de conselhos superiores da UFU

Abstract

This work presents the development of a support system for the Council Secretariat of the Federal University of Uberlândia (UFU) for tallying attendance and voting in meetings of the university's higher councils, such as CONSUN and CONGRAD. The system automates the cross referencing between attendance and voting reports exported from Microsoft Teams and the list of council members eligible to vote in each meeting, keeping the quorum updated in real time and reconciling participants identified in different ways across data sources, such as by name in one spreadsheet and by e-mail in another, relying on manual validation by the secretariat only when this identification is not clear. The system was developed using Java and the Spring Boot framework on the back-end, Angular on the front-end, and an embedded H2 database, following an iterative and incremental process, with each feature tested with real data before proceeding to the next. At the end of development, the twelve functional requirements defined for the system were implemented and validated through a manual test plan, confirming that the system meets the proposed objectives and reduces the manual work previously performed by the secretariat, although it still depends on manually exporting reports from Teams, since there is no direct integration with the platform.