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.