Development of Student Status Reports of a Faculty in University Using Interactive Microsoft Power BI for Effective Academic Administration

The student status report is generally designed for academic administration to get information
to analyze the learning progress. For the case study at the Faculty of Industrial Education and
Technology (FIET), King Mongkut’s University of Technology Thonburi, there are 8
undergraduate programs, 7 master’s programs, and 1 doctoral program. There are average
number of 755 students per academic year for all undergraduate students, graduate students,
and PhD students. The big data of FIET students could be retrieved from the Academic
Information System (New ACIS) which shows the information of student admission,
students’ history, enrollment, request, study timetable, grades, etc. To support the student
admission and academic administration, the data of student status was summarized to be an
interactive report using Microsoft Power BI. The system has been continuously improvement
from the academic year of 2012 to 2021. The online report included of 3 items: (i) current
students registered in the system, (ii) graduated students, and (iii) students who dropped out.
In addition, it also showed the grades before admission, current grades, category of
application, education history, etc. This developed system could be conveniently reported via
online to the administrators for planning and decision-making. The satisfaction of 10 users
was evaluated with online questionnaire of 5-scale on 4 topics: ease of viewing, sufficient of
data, benefits and outcomes, suitability of report, showing that the average score was >4.
Moreover, there was suggestion to develop the system linkage between the faculty and
programs to follow-up and analyze the progress of student learning.