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

Abstract

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.



Author Information
Pattavee Kittaratip, King Mongkut's University of Technology Thonburi, Thailand
Wisitsree Wiyaratn, King Mongkut’s University of Technology Thonburi, Thailand

Paper Information
Conference: ACE2023
Stream: Educational policy

This paper is part of the ACE2023 Conference Proceedings (View)
Full Paper
View / Download the full paper in a new tab/window


To cite this article:
Kittaratip P., & Wiyaratn W. (2024) Development of Student Status Reports of a Faculty in University Using Interactive Microsoft Power BI for Effective Academic Administration ISSN: 2186-5892 The Asian Conference on Education 2023: Official Conference Proceedings https://doi.org/10.22492/issn.2186-5892.2024.57
To link to this article: https://doi.org/10.22492/issn.2186-5892.2024.57


Comments & Feedback

Place a comment using your LinkedIn profile

Comments

Share on activity feed

Powered by WP LinkPress

Share this Research

Posted by James Alexander Gordon