Uma abordagem automatizada para integração e análise de dados acadêmicos e profissionais de alunos dos cursos de Engenharia da UFC

Abstract

Since antiquity, the concept of school and the concern with shaping citizens capable of impacting society have been observed. Over time, universities and colleges emerged from this evolutionary process. In today’s world, these educational institutions face constant transformations due to technological advances of the Fourth Industrial Revolution, also known as Industry 4.0, which require them to seek continuous updates to keep pace with rapid changes in the job market. This is evidenced in the World Economic Forum’s annual report, The Future of Jobs, which analyzes labor market trends and the skills required for future professionals, highlighting global changes year after year. Based on this context, this study developed Python tools and scripts to perform web scraping on publicly available SIGAA data regarding the academic status of students and graduates—such as “completed,” “active,” or “canceled”—for each individual admitted through SISU, as well as to collect LinkedIn data on professional experience and academic background, tracking as many students and graduates from UFC’s Engineering programs as possible. Finally, a Power BI dashboard was created to correlate academic and professional data, generating indicators and insights. The results demonstrated the feasibility of automating the extraction and updating of SIGAA and LinkedIn profile data using Selenium and Python, overcoming challenges related to dynamic web navigation, date-format standardization, automated login, and more. As a result, a relevant dataset was obtained for the creation of a Business Intelligence report, including indicators related to skills aligned with market demands, as well as course completion and dropout rates. It was observed, for example, that students typically take longer to finish their degrees than stipulated in the curriculum. These data provide valuable support for academic decision-making, enabling improvements to programs and better preparing students to meet professional demands.