Educational Data Warehouse: A View about Dropout on Higher Education

  • G. A. S. Santos CEFET-RJ
  • A. L. Bordignon UFF
  • D. B. Haddad CEFET-RJ
  • D. N. Brandão CEFET-RJ
  • L. Tarrataca CEFET-RJ
  • K. T. Belloze CEFET-RJ

Abstract


Dropout is one of the main challenges of educational institutions. In this sense, this paper presents the implementation of a Data Warehouse for data analysis and decision making in a higher education institution in Brazil. The presented Data Warehouse allows integrated views that assist in analysis such as: 1) distribution of students’ performance coefficient; 2) identification of student profiles and 3) insight into student achievement by locality. These analyzes are intended to assist academic management in identifying patterns that lead to dropout and thus to promote directions for preventive actions and mainly to expand the use of this analytical database developing new solutions, such as predictive models.

Keywords: Data Warehouse, Higher Education, Dropout, Data Analytics

References

dos Santos Baggi, C. A. and Lopes, D. A. (2011). Evasão e avaliação institucional no ensino superior: uma discussão bibliográfica. Avaliação: Revista da Avaliação da Educação Superior, 16(2). DOI: http://dx.doi.org/10.1590/S1414-40772011000200007

INEP (2016). Censo da educação superior - notas estatísticas 2016. In Diretoria de Estatísticas Educacionais (DEED)- Instituto Nacional de Estudos e Pesquisas Educacionais Anísio Teixeira (INEP). Acessado em 13 de Outubro de 2018.

Inmon, W. H. and Linstedt, D. (2014). Data architecture: a primer for the data scientist: big data, data warehouse and data vault. Morgan Kaufmann.

OECD (2016). Education at a Glance 2016. DOI: . https://doi.org/10.1787/eag-2016-en

Olszak, C. M. and Ziemba, E. (2007). Approach to building and implementing business intelligence systems. Interdisciplinary Journal of Information, Knowledge, and Management, 2(1):135–148. DOI: https://doi.org/10.28945/105

Shim, J. P., Warkentin, M., Courtney, J. F., Power, D. J., Sharda, R., and Carlsson, C. (2002). Past, present, and future of decision support technology. Decision support systems, 33(2):111–126. DOI: https://doi.org/10.1016/S0167-9236(01)00139-7

Speller, P., Robl, F., and Meneghel, S. M. (2012). Desafios e perspectivas da educação superior brasileira para próxima década. Oficina de Trabalho. p. 164, 2012. ISBN: 978-85-7652-171-6
Published
2019-10-07
SANTOS, G. A. S.; BORDIGNON, A. L.; HADDAD, D. B.; BRANDÃO, D. N.; TARRATACA, L.; BELLOZE, K. T.. Educational Data Warehouse: A View about Dropout on Higher Education. In: BRAZILIAN SYMPOSIUM ON DATABASES (SBBD), 34. , 2019, Fortaleza. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2019 . p. 235-240. ISSN 2763-8979. DOI: https://doi.org/10.5753/sbbd.2019.8829.