Digitalization and data management of lab attendance system

• Main Author: Cheng, Chang Wei
• Other Authors: Loke Yuan Ren
• Format: Final Year Project
• Language: English
• Published: Nanyang Technological University 2024
• Subjects: Computer and Information Science
• Online Access: https://hdl.handle.net/10356/175741
• Institution: Nanyang Technological University

As demand for tech talent rises and enrollment in Computer Science at Nanyang Technological University (NTU) surges, the necessity for efficient lab attendance management systems becomes crucial. This paper introduces a comprehensive solution to digitalize and streamline lab attendance at NTU. The proposed system replaces traditional paper-based methods with a tablet application combined with a web application that offers innovative features. Novel web application features include automated email notifications for absent students, integration to automatically load lab schedules from an Excel file generated by NTU's existing system, a simplified process for submitting medical certificates, and an intuitive display of lab roster information with editing capabilities. The tablet application on the other hand, empowers the lab technician to electronically record attendance, incorporating a timer feature to prevent students from assisting others in marking their attendance. Utilizing industry-standard software frameworks like React, Spring Boot, MySQL, and React Native, the system ensures scalability, security, and user-friendliness. Detailed insights into the system's design, covering the user interface, database schema, software architecture, and authentication mechanisms, are provided. By employing a token-based authentication approach with JWTs, the system achieves robust user authentication and authorization, enhancing security and user experience. Through this digitalization initiative, the system aims to reduce the workload of lab technicians, improve data accuracy, and enhance overall efficiency in lab attendance management at NTU.