Inventory management dashboard for tracking of sports equipment and facilities in a secondary school's sport centre

Yap, Rui Ya (2025) Inventory management dashboard for tracking of sports equipment and facilities in a secondary school's sport centre. Final Year Project, UTAR.

PDF Download (10Mb)

Abstract

Manual inventory management in secondary school sports centres often results in misplaced equipment, overbooked facilities, and inefficient maintenance tracking. This project aims to address these issues by developing an Inventory Management Dashboard that digitalizes the management of sports equipment and facilities. The system integrates QR code-based tracking, real-time updates, and a centralized booking platform to enhance operational accuracy and accountability. Using a prototyping methodology, the system was iteratively designed, developed, and refined through continuous user feedback from stakeholders, including administrators, quartermasters, teachers, and students. The solution was implemented as a web-based application using React.js for the frontend, Laravel for the backend, and a MySQL database for persistent storage. Key features include role-based access control, QR code generation and scanning for equipment check-in and check-out, real-time inventory and facility booking, maintenance scheduling, and an analytics dashboard for performance insights and decision-making. The system underwent comprehensive unit testing, integration testing, and user acceptance testing, confirming its functionality, usability, and effectiveness in meeting user requirements. Results demonstrate significant improvements in inventory accuracy, booking transparency, and maintenance monitoring. The developed dashboard offers a scalable and user-friendly solution that reduces manual workload, minimizes errors, and promotes data-driven management of sports resources. Future improvements may include the integration of predictive maintenance, automated reporting, and multi-school scalability to broaden its impact across educational institutions. Keywords: inventory management; sports facilities; QR code tracking; web application; React.js; Laravel; MySQL; prototyping methodology Subject Area: QA76.76 Computer software

Actions (login required)