Analytical Tool for the University Data Management

Every university needs some kind of information system that will allow the university to record students, teachers, student results and other elements related to the student's studies. Such software is called an academic information system. This paper describes the analysis, design, implementation and testing of similar system. However, unlike a typical academic information system, this system, which was created as part of a bachelor's thesis on the topic Analytical Tool for the University Data Management, also contains advanced analytical tools that will allow both students and teachers to analyse the course of study of individual students and find the weak points of teaching and educational process. In order to create the analytical tool, it was first necessary to analyse the transition of students through their studies. The Faculty of Management and Informatics of the University of Žilina was used as a source of this analysis. Based on this analysis, we designed a database that uses Oracle SQL language running on the Oracle Cloud technology, and then created a tool in the Oracle Application Express environment. The tool allows registering of students, their exams, teachers, and subjects. At the same time, it also contains functions for searching, sorting, and filtering according to various criteria. Another functionality is the ability of user to display summary and individual statistics for teachers, students, and study groups. Each student and teacher have their own account to access global statistics. The tool offers possibilities for future expansion, such as comparing students and advanced analysis using the functionalities of the Oracle Machine Learning service.