SLMS: Development of a Science Laboratory Management System with Analytics Using the Apriori Algorithm

This study developed a Science Laboratory Management System (SLMS) with analytics using the Apriori Algorithm to improve science laboratory resource management and support data-driven decision-making. The study used Agile Software Development methodology to guide the system’s design, development, testing, and evaluation. The system developed modules for user management, equipment and chemical inventory, borrowing and return transactions, report generation, and an analytics dashboard. Historical laboratory transaction data were processed using the Apriori Algorithm to identify frequent itemsets and association rules among laboratory equipment, materials, chemicals, and activities. The developed system was evaluated using the ISO/IEC 25010 Software Quality Model in terms of functional suitability, performance efficiency, usability, reliability, security, maintainability, and portability. Results demonstrated that the system effectively automated key laboratory management processes and generated meaningful usage patterns that could support inventory monitoring, procurement planning, and resource allocation. The system received an overall evaluation interpreted as excellent, indicating its acceptability and suitability for laboratory operations. The findings suggest that integrating association rule mining into science laboratory management can enhance operational efficiency and provide actionable insights for administrators. Future enhancements may include predictive analytics, barcode or RFID integration, mobile and cloud deployment, and interoperability with institutional information systems.

Information Technology

1. Adekunle, A. A., Abolore, B. L., Mutiu, G., & Olalekan, A. M. (2024). Design and implementation of a Web-Based Laboratory Management System for efficient resource tracking. Asian Journal of Managerial Science, 13(2), 19–24. https://doi.org/10.70112/ajes-2024.13.2.4248 [Google Scholar] [Crossref]

2. Akanbi, N. O. D., Hinmikaiye, N. O. R., & Adeyemi, N. O. W. (2024). The integration of Artificial Intelligence in demand forecasting and inventory management in the United States. International Journal of Science and Research Archive, 13(1), 740–745. https://doi.org/10.30574/ijsra.2024.13.1.1712 [Google Scholar] [Crossref]

3. Becerra, P., Mula, J., & Sanchis, R. (2022). Sustainable Inventory Management in Supply Chains: Trends and Further research. Sustainability, 14(5), 2613. https://doi.org/10.3390/su14052613 [Google Scholar] [Crossref]

4. Da Costa, T. P., Da Costa, D. M. B., & Murphy, F. (2024). A systematic review of real-time data monitoring and its potential application to support dynamic life cycle inventories. Environmental Impact Assessment Review, 105, 107416. https://doi.org/10.1016/j.eiar.2024.107416 [Google Scholar] [Crossref]

5. Edayan, D., Perez, R., & Singh, A. (2024). Integration technologies in laboratory information systems: A systematic review. Research Gate. https://www.researchgate.net/ publication/382837126 Integration Technologies in Laboratory Information Systems A Systematic Review [Google Scholar] [Crossref]

6. Ellarby, C. (2025, June 25). What is equipment booking software and do I need it? Itemit. https://itemit.com/what-is-equipment-booking-software-and-do-i-need-it/ [Google Scholar] [Crossref]

7. Grooss, O. F. (2023). Advancing maintenance strategies through digitalization: A case study. Procedia Computer Science, 217, 1522–1531. https://doi.org/10.1016/j.procs.2022.12.352 [Google Scholar] [Crossref]

8. Gummaru, J., Mercado, D. R., Vallejo, M. F., & Gumarang, S. (2025).Biology Chemistry Laboratory Inventory System. The Light Explorer, 10(1). https://doi.org/10.57180/rlqs3996 [Google Scholar] [Crossref]

9. Hanton, S. D., PhD. (2024, July 2). Simplifying chemical inventory management in the lab. Lab Manager. https://www.labmanager.com/simplifying-chemical-inventory-management-in-the-lab-32426 [Google Scholar] [Crossref]

10. IBM. (n.d.). What is inventory management? IBM Think. Retrieved August 15, 2025, from https://www.ibm.com/think/topics/inventory-management [Google Scholar] [Crossref]

11. Kenton, W. (2024, June 26). What is inventory? Definition, types, and examples. Investopedia. https://www.investopedia.com/terms/i/inventory.asp [Google Scholar] [Crossref]

12. King, J., Smith, R., & Lee, P. (2024). Enhancing usability and accessibility through iterative user-centered design. ACM. https://doi.org/10.1145/3732801.3732882 [Google Scholar] [Crossref]

13. Krutskikh, V. V., Ushkov, A. N., Chukashov, D. S., & Trofimov, A. Y. (2024). Smart Cloud equipment tracking and control system. 2022 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM), 783–788. https://doi.org/10.1109/icieam60818.2024.10553994 [Google Scholar] [Crossref]

14. LabWare. (n.d.). Overcoming Paperless laboratory Risks: A Comprehensive guide. https://www.labware.com/blog/risks-of-paper-based-laboratory-data [Google Scholar] [Crossref]

15. Lerro, F., Orduña, P., Marchisio, S., & García-Zubía, J. (2014). [Google Scholar] [Crossref]

16. Development of a Remote Laboratory Management System and Integration with Social Networks. International Journal of Recent Contributions From Engineering Science & IT (iJES), 2(3), 33. https://doi.org/10.3991/ijes.v2i3.3821 [Google Scholar] [Crossref]

17. Liang, C.-Y., Chou, W.-S., Hsu, Y., & Yang, C.-C. (2009). A user-centered design approach to develop a web-based instructional resource system for homeland education. Knowledge Management & E-Learning: An International Journal, 1(1), 67–80. [Google Scholar] [Crossref]

18. Ma, X. (2016, October). The research of the opening system of university laboratory and the design of the laboratory reservation system. In Proceedings of the 2016 International Conference on Computational Science and Engineering (ICCSE 2016) (pp. 113–117). Atlantis Press. https://doi.org/10.2991/iccse-16.2016.19 [Google Scholar] [Crossref]

19. Mostefai, B., Boutefara, T., Bousbia, N., Balla, A., Dhelim, S., & Hammia, A. (2025). Enhancing User Experience in E-Learning Systems: A new User-Centric RESTful Web Services approach. Computers in Human Behavior Reports, 100643. https://doi.org/10.1016/j.chbr.2025.100643 [Google Scholar] [Crossref]

20. Mulyani, S., Gaffar, M. F., Komariah, A., Suryadi, N., Suhendar, A., Rusnati, I., & Wulansari, S. (2021). Academic Management System integration of private universities. International Journal of Science Technology & Management, 2(4), 1095–1101. https://doi.org/10.46729/ijstm.v2i4.244 [Google Scholar] [Crossref]

21. Munyaka, J. B., & Yadavalli, S. V. (2022). INVENTORY MANAGEMENT CONCEPTS AND IMPLEMENTATIONS: A SYSTEMATIC REVIEW. The South African Journal of Industrial Engineering, 32(2). https://doi.org/10.7166/33-2-2527 [Google Scholar] [Crossref]

22. Nurhayati, N., & Prabowo, P. (2023). Implementation of web-based maintenance system to improve asset performance in educational institutions. Procedia Engineering and Management Journal, 35(1), Article 351001. https://doi.org/10.70838/pemj.351001 [Google Scholar] [Crossref]

23. Online platform for reserving shared research facilities. (n.d.). WUR. https://www.wur.nl/en/article/online-platform-for-reserving-shared-research-facilities.htm? [Google Scholar] [Crossref]

24. Partosa, H. E., Despojo, A. G. B., & Futalan, M. C. Z. (2024). Utilization of web-based laboratory in expressing chemical concentrations. https://ejournals.ph/article.php?id=24434 [Google Scholar] [Crossref]

25. Philippine Inventory of Chemicals and Chemical Substances | Chemical Management Section. (n.d.). https://chemical.emb.gov.ph/?page_id=138 [Google Scholar] [Crossref]

26. Princeton University Environmental Health & Safety. (n.d.). Chemical inventory management. Retrieved August 11, 2025. https://ehs.princeton.edu/laboratory-research/chemical-safety/chemical_inventory_management [Google Scholar] [Crossref]

27. Rabiah, N. N., Lindawati, L., & Sarjana, S. (2022). Web-Based Laboratory Inventory Application using QR code and RFID in Telecommunication Engineering Laboratories/Workshops. [Google Scholar] [Crossref]

28. SinkrOn, 7(4), 2248–2261. https://doi.org/10.33395/sinkron.v7i4.11624 [Google Scholar] [Crossref]

29. Samudra, M. R., & Latief, Y. (2019). Web based Information System development of maintenance work to improve government building maintenance performance. IOP Conference Series Earth and Environmental Science, 258, 012034. https://doi.org/10.1088/1755-1315/258/1/012034 [Google Scholar] [Crossref]

30. Seo, S. (2023, December 19). Common Issues with Paper-Based Lab Management System & How to Overcome Them | SoftClinic GenX. SoftClinic GenX | Hospital Management Software. https://www.softclinicsoftware.com/common-issues-with-paper-based-lab-management-system-how-to-overcome-them/ [Google Scholar] [Crossref]

31. Srinivas. (2021). Paper-Based vs Digital Lab Management System. Journal. https://vocal.media/journal/paper-based-vs-digital-lab-management-system [Google Scholar] [Crossref]

32. Symestic. (n.d.). What is real-time data monitoring (RTDM)? Retrieved August 15, 2025, from https://www.symestic.com/en-us/what-is/rtdm [Google Scholar] [Crossref]

33. Taertulakarn, S., Sritart, H., Tosranon, P., Pongpaiboon, K., & Subenja, K. (2023b). The Design and Development of an AI-based Medical Laboratory Inventory Monitoring System. In Proceedings of the 15th Biomedical Engineering International Conference (BMEiCON), 1–5. https://doi.org/10.1109/bmeicon60347.2023.10321987 [Google Scholar] [Crossref]

• Assessment of the Role of Artificial Intelligence in Repositioning TVET for Economic Development in Nigeria
• Teachers’ Use of Assure Model Instructional Design on Learners’ Problem Solving Efficacy in Secondary Schools in Bungoma County, Kenya
• “E-Booksan Ang Kaalaman”: Development, Validation, and Utilization of Electronic Book in Academic Performance of Grade 9 Students in Social Studies
• Analyzing EFL University Students’ Academic Speaking Skills Through Self-Recorded Video Presentation
• Major Findings of The Study on Total Quality Management in Teachers’ Education Institutions (TEIs) In Assam – An Evaluative Study