SQL/DB Error -- [
Error establishing a database connection!]
- Are you sure you have the correct user/password?
- Are you sure that you have typed the correct hostname?
- Are you sure that the database server is running?
MSU–IIT’s Students Academic Information Through Data Visualization
(A My.IIT Subsystem)
Background of the study
Mindanao State University–Iligan Institute of Technology admits approximately 11,500 students every year. During enrolment, each student is required to provide personal information which would then be added to the database. From time to time, reports are generated upon request by faculty members or as requested by government institutions, like DOST and CHED. The reports generated by the e.SMS are in tabular form, thus, not very appealing and burdening to the person inspecting it. The e.SMS does not have the capability of viewing data over time making it hard to study the data involved.
With the involvement of different types of data, it is very difficult to see the data set as an overall. Furthermore, the problem is further aggravated by the data’s periodically changing nature, which may be due to the newly added data or further data continuously being refined. In line with this, for every student admitted to the institute, a new set of data is also entered into the system. Uncovering relationships, trends and revealing hidden patterns among the students’ academic data are in fact very hard if the college deans, professors and advisers have to inspect many tables holding these data one by one. The current case is such that, the only way to track these trends occurring among students is to query it on the database. However, the end-users (professors, advisers, deans) of the e.SMS fail to do so, since they only possess a limited control over the system. Thus, only the developer of the e.SMS has the full authority to do all sorts of database querying.
Moreover, with respect to the request of organizations such as DOST, CHED and the OVCAA, reports regarding the students’ academic data are being generated in a tabular form, although it is still usable, but it is not appealing to those who will view these data. It is also very difficult to examine the students’ academic data in the previous years for future decision making, since the e.SMS has no capability to view data over time in one interface. According to Professor Salasa Nawang, the chairman of the Department of Physics, the institute’s website has been of great help not only to the students but also to the faculty. Since grade entries are accessed online, it might be possible to have visualizations on the grade distribution as it would aid on the part of the faculty in determining the effectiveness of their teaching techniques and it would play a significant part in monitoring the performance of the students in the institute.