Development of a Dashboard and Calendar Monitoring System for Official Leave and Workload-Based Duty Performance of Faculty Members at the Faculty of Science and Agricultural Technology, Rajamangala University of Technology Lanna Phitsanulok

Abstract

This research aimed to 1) design and develop a dashboard and calendar-based monitoring system for official leave and workload-based duty performance of faculty members at the Faculty of Science and Agricultural Technology, Rajamangala University of Technology Lanna, Phitsanulok; 2) evaluate the effectiveness of the developed system; and 3) examine the results of system implementation from the users’ perspectives. The target group consisted of 39 participants, including administrators/supervisors, faculty members, and office staff, selected through purposive sampling to ensure alignment with the research objectives. The research instruments comprised the leave and duty monitoring system, a system effectiveness evaluation form, and a user feedback questionnaire administered individually. Data were analyzed using descriptive statistics, namely frequency, percentage, mean, and standard deviation.

            The research findings revealed that 1) the dashboard- and calendar-based monitoring system was developed using PHP in conjunction with MySQL, Bootstrap 5, and FullCalendar. The system employs role-based access control and is organized into five main functional modules: dashboard, data entry, leave reports, duty performance reports, and calendar. It supports accurate data recording, processing, and storage, enables rapid information retrieval, and presents data in multiple formats, including tables, charts, dashboards, and calendar views. Administrators and supervisors can access information on their subordinates and effectively monitor both leave and duty performance according to assigned workloads. 2) The evaluation of system effectiveness by five experts indicated that the system’s overall quality was at a very high level and 3) The trial implementation with 39 users showed that faculty members and office staff rated the system at a very high level of overall satisfaction. The highest-rated aspect was system usefulness, followed by data quality, system design, and usability, respectively. Administrators and supervisors also rated the system’s usefulness for management at a very high level. Therefore, the developed system effectively meets user needs in terms of data management, ease of use, appropriate design, and its role as a practical tool for supporting administrative tasks and monitoring faculty members’ official leave and workload-based duty performance.