Development of a Microsoft Excel-Based Management System for Secondary School Chemistry Laboratories

Puan Purnama Wati(1), Ibnu Khaldun(2), Sri Winarni(3), Muhammad Nazar(4), Zulfadli Zulfadli(5), Putri Nabilah(6),

DOI: https://doi.org/10.46843/jpm.v4i4.547


(1) Science Education Study Program, Postgraduate Program, Universitas Syiah Kuala, Indonesia
(2) Department of Chemistry Education, Faculty of Teacher Training and Education, Universitas Syiah Kuala, Indonesia
(3) Department of Chemistry Education, Faculty of Teacher Training and Education, Universitas Syiah Kuala, Indonesia
(4) Department of Chemistry Education, Faculty of Teacher Training and Education, Universitas Syiah Kuala, Indonesia
(5) Department of Chemistry Education, Faculty of Teacher Training and Education, Universitas Syiah Kuala, Indonesia
(6) Prince of Songkla University, Thailand

Abstract

Inefficient digital systems for managing chemistry laboratories in secondary schools often impede effective record-keeping, inventory management, and practicum reporting. This study developed Chemlab Excel, a practical and accessible offline Microsoft Excel-based laboratory management system, eliminating the need for an internet connection or additional software. Employing a Research and Development (R&D) approach with the ADDIE model (Analysis, Design, Development, Implementation, Evaluation), and involved nine purposively selected respondents, including chemistry teachers, laboratory heads, and lab assistants from SMA Negeri 1 Bireuen and SMA Negeri 1 Samalanga. The study utilized expert validation sheets, teacher response questionnaires, and the System Usability Scale (SUS) for data collection. Validity was assessed using Aiken's V, and inter-rater reliability was measured via the Intraclass Correlation Coefficient (ICC). Three experts validated the system, with trials conducted in two secondary schools in Bireuen Regency. Results showed high feasibility, with Aiken's V coefficients of 0.852 (media) and 0.869 (material), and ICC values of 0.768 (media) and 0.761 (material), indicating good reliability. The SUS score averaged 72.22%, and teacher responses reached 94.64%, reflecting user-friendliness and enhanced efficiency. Chemlab Excel proves to be a feasible, contextually relevant solution for laboratory management, contributing to streamlined administrative processes in science education and offering a scalable, accessible tool for secondary schools.

Keywords

Laboratory Management System, Microsoft Excel, System Usability Scale (SUS), ADDIE Model, Science Education

Full Text:

PDF

References

Accettone, S., DeFrancesco, C., King, C., & Lariviere, M. (2023). Laboratory Skills Assignments as a Teaching Tool to Develop Undergraduate Chemistry Students' Conceptual Understanding of Practical Laboratory Skills. Journal of Chemical Education, 100(1), 111–117.

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 Electrical Sciences, 13(2), 19-24.

Ahnaf, F., & Puspitasari, E. (2023). Descriptive Analysis of Inventory of Equipment and Materials for Biology Laboratory Activities in High Schools Throughout Banjarnegara Regency. Symposium on Biology Education (Symbion).

Aisyah, S., Effendi, H., Wandi, J. I., & Noer, S. M. (2023). The Validity of Problem-Based Contextual Model in the History Learning at Senior High School. SiLeT: Journal of Scientific Literacy and Teaching, 4(1), 101–115.

Albert, B., & Tullis, T. (2022). Measuring the User Experience: Collecting, Analyzing, and Presenting UX Metrics. Morgan Kaufmann.

Al-Sultan, A., Elgazzar, A., & Alsultan, K. (2021). The Impact of Instructional Design Models on Learning Outcomes: A Systematic Review. Education and Information Technologies, 26, 3987–4011.

Ardhana, V. Y. P. (2022). Evaluation of E-Learning Usability of Qamarul Huda University Using the System Usability Scale (SUS). Resolution: Informatics and Information Engineering, 3(1), 1–5.

Arum, A., & Khumaedi, M. (2022). Validity and Reliability of Development of Self-Confidence Assessment Instruments for Students on Chemistry Subject. Journal of Research and Educational Research Evaluation (JERE), 11(1), 12–22.

Ayi, M., & Honje, P. (2020). Laboratory Safety Management in Senior High School Science Laboratories in Ghana. International Journal of Science Education, 42(10), 1705–1723.

Cahyadi, R. A. H. (2019). Pengembangan Bahan Ajar Berbasis Addie Model. Halaqa: Islamic Education Journal, 3(1), 35-42.

Clark, R. C., & Mayer, R. E. (2023). E-Learning and the Science of Instruction: Proven Guidelines for Consumers and Designers of Multimedia Learning. John Wiley & Sons.

Duke, R., Bhat, V., & Risko, C. (2022). Data Storage Architectures to Accelerate Chemical Discovery: Data Accessibility for Individual Laboratories and the Community. Chemical Science, 13(46), 13646-13656.

Efe, A., & Abamba, E. (2023). Effects of Laboratory Method on Students' Acquisition of Science Process Skills in Senior Secondary School Chemistry in Delta State, Nigeria. European Journal of Education Studies, 10(11).

Eymur, G. (2019). The Influence of the Explicit Nature of Science Instruction Embedded in the Argument-Driven Inquiry Method in Chemistry Laboratories on High School Students' Conceptions About the Nature of Science. Chemistry Education Research and Practice, 20(3), 622–639.

Fagbohun, B. J., Adewale, O. S., & Adekunle, B. S. (2021). Assessment of Laboratory Safety Awareness Among Secondary School Students and Teachers. Journal of Science Education and Technology, 30, 681–693.

Fitri, C. U. L., Khaldun, I., Gani, A., Zulfadli, & Mujakir. (2024). Development of a Spreadsheet-Based Virtual Laboratory to Improve Students' Science Process Skills. Journal of Chemistry and Chemistry Education (JKPK), 9(3), 405–417.

Freundel, M. (2022). Comparison of Laboratory Standards. Advances in Biochemical Engineering/Biotechnology, 182, 133–145.

Ginsburg, L., Hoben, M., Berta, W., Doupe, M., Estabrooks, C., Norton, P., Reid, C., Geerts, A., & Wagg, A. (2023). Pengembangan dan Validasi Skala Pemberlakuan Kesetiaan Keseluruhan untuk Intervensi Kompleks (OFES-CI). BMJ Quality & Safety, 33, 98 - 108.

Hanifah, S., Sari, F., & Irwansyah, F. S. (2021). Pembuatan Aplikasi Inventaris Alat dan Bahan Laboratorium Kimia Berbasis Web. Dalam Gunung Djati Conference Series (Vol. 2, Seminar Nasional Tadris Kimia 2020). Universitas Islam Negeri Sunan Gunung Djati.

Hanum, L., Hasan, M., & Pada, A. U. T. (2023). Development of Learning Devices Based on Ethnoscience Project-Based Learning to Improve Students' Critical Thinking Skills. Jurnal Pendidikan Sains Indonesia (Indonesian Journal of Science Education), 11(1), 62–74.

Hügel, A. L. (2019). Silting Objects. Bulletin of the London Mathematical Society, 51(4), 658–690.

Hyzy, M., Bond, R., Mulvenna, M., Bai, L., Dix, A., Leigh, S., & Hunt, S. (2022). System Usability Scale Benchmarking for Digital Health Apps: Meta-Analysis. JMIR mHealth and uHealth, 10(9), e37290.

Ismail, R., & Prihatini, E. (2023). Development of Chemical Inventory Management System (CIMS) for Laboratory Safety and Efficiency. Indonesian Journal of Laboratory, 5(1), 25–33.

Javaid, M., & Javaid, M. (2024). Student Perception of Learning Through Laboratory. Dalam 2024 ASEE Annual Conference & Exposition Proceedings. American Society for Engineering Education.

Jofrishal, J., & Munandar, H. (2021, September). Analysis of Problems in Utilizing School Laboratories in the Chemistry Learning. Dalam Proceedings of the 2nd International Conference on Science, Technology, and Modern Society (ICSTMS 2020) (hlm. 106–109). Atlantis Press.

Khaldun, I., Nasir, M., & Maulida, Z. (2022). Development of Virtual Practicum Media for Iron Metal Analysis by UV-VIS Spectrophotometry Based on Microsoft Excel. Journal of Indonesian Science Education, 10(2), 154–166.

Khaldun, I., Zulfadli, Z., & Ramadhana, C. R. (2022). Excel-Based UV-VIS Spectrophotometry Simulation Learning Media: Validation and Usability Test Using SUS. Didactic Chemistry, 11(1), 44–53.

Kim, S., Thiessen, P., Bolton, E., Chen, J., Fu, G., Gindulyte, A., Han, L., He, J., He, S., Shoemaker, B., Wang, J., Yu, B., Zhang, J., & Bryant, S. (2015). Basis Data Zat dan Senyawa PubChem. Nucleic Acids Research, 44, D1202 - D1213.

Kotake, R., Kanehara, A., Miyamoto, Y., Kumakura, Y., Sawada, U., Takano, A., Chiba, R., Ogawa, M., Kondo, S., Kasai, K., & Kawakami, N. (2020). Reliabilitas dan Validitas Versi Jepang dari Ukuran INSPIRE tentang Dukungan Staf untuk Pemulihan Pribadi pada Pengguna Layanan Kesehatan Mental Komunitas di Jepang. BMC Psychiatry, 20.

Kumari, P., Mwesigye, A., & Balimuttajjo, S. (2024). Science Laboratory Education and Students' Perceived Behavior Towards Science Education: A Review. Journal of Research Innovation and Implications in Education.

Lab Manager Editorial Team. (2025). Lab Inventory Management: Best Practices for Efficiency, Cost Savings, and Compliance. Lab Manager.

LabArchives. (2023). LabArchives: Electronic Lab Notebook & Inventory Management.

Maghfirah, N., Putri, M. A., & Indrawati, H. (2023). Development of Contextual-Based Modules to Improve the Understanding of Chemistry Concepts of High School Students. Jurnal Pendidikan Kimia, 15(1), 45–53.

Mamajonov, I., & Zhaparov, M. (2025). Development of Mobile Inventory App for Science Lab of High School. AIJR Proceedings.

Maulana, A. (2022). Analisis Validitas, Reliabilitas, dan Kelayakan Instrumen Penilaian Rasa Percaya Diri Siswa. Jurnal Kualita Pendidikan, 3(3), 133–139.

Ménard, A., & Trant, J. (2019). A Review and Critique of Academic Lab Safety Research. Nature Chemistry, 12(1), 17–25.

Ministry of Education and Culture. (2023). National Report: Good Practices for Science Laboratory Management in Schools. Directorate of High School.

Mohzana, M., Murcahyanto, H., Fahrurrozi, M., & Supriadi, Y. N. (2023). Optimization of Management of Laboratory Facilities in the Process of Learning Science at High School. Journal of Science Education Research, 9(10), 8226–8234.

Moser, A., Waked, A., & DiMartino, J. (2021). Consolidating and Managing Data for Drug Development Within a Pharmaceutical Laboratory: Comparing the Mapping and Reporting Tools from Software Applications. Organic Process Research & Development, 25(5), 859–867.

Nabila, S., Sulastri, S., Winarni, S., Zulfadli, Z., Khaldun, I., & Mohtar, L. E. (2024). Challenges and Alternative Solutions for Implementing Chemistry Practicums in Public High Schools. JTK (Jurnal Tadris Kimiya), 9(2), 136–148.

Nazar, M., Zulfadli, Z., & Oktarina, A. (2020). Development of an Android-Based Interactive Learning Application for Electrolyte and Nonelectrolyte Solution Materials. Indonesian Journal of Science Education, 8(1), 71–81.

Ng, Z. N. (2018). Development of Inventory Control System for Research Laboratory. Nanyang Technological University.

Nilawati, R., Gani, A., Khaldun, I., & Nabilah, P. (2025). Implementation of Digital Student Worksheet Based on Problem-Solving to Enhance Students' Critical Thinking Skills and Learning Outcomes on Quantum Numbers and Electron Configuration Materials. Jurnal Pemberdayaan Masyarakat, 4(1), 235–244.

Nurhafidhah, N., Hasby, H., & Alvina, S. (2021). The Analysis of Student Character Values in the Use of Secondary Metabolic Utilization Lab Module. Jurnal Ilmiah Peuradeun, 9(1), 179–188.

OECD-PISA. (t.t.). PISA 2022 Results (Volume I).

Papavlasopoulou, S., Giannakos, M. N., & Jaccheri, L. (2019). Exploring Children's Learning Experience in Constructionism-Based Coding Activities Through Design-Based Research. Computers in Human Behavior, 99, 415–427.

Praveen, G., Poornima, U., Akkaloori, A., & Bharathi, V. (2024). ChatGPT sebagai Alat Edukasi Kesehatan Gigi dan Mulut: Evaluasi Sistematis Respons ChatGPT terhadap Pertanyaan Pasien Terkait Kesehatan Gigi dan Mulut. Jurnal Nature and Science of Medicine.

Pursitasari, I. D., Jaenudin, D., & Heliawati, L. (2024). Peningkatan Pengetahuan dan Keterampilan Guru IPA Kabupaten Sukabumi dalam Pengembangan Media Pembelajaran. Jurnal Pemberdayaan Masyarakat, 3(2), 85-92.

Putra, D., Kusuma, A., Willdahlia, A., & Pande, N. (2024). Evaluation of the Usability of the E-Database Module Using the System Usability Scale (SUS) Method. Global Education Scientific Journal.

Ramadani, S., Sinaga, P., & Liliawati, W. (2025). Critical Thinking in Science Learning: Systematic Literature Review. Jurnal Pemberdayaan Masyarakat, 4(1), 183–196.

Ramírez-Montoya, M. S., Vicario-Solorzano, C. M., & González-Pérez, L. I. (2024). Navigating Interconnected Complexities: Validation and Reliability of an Instrument for Sustainable Development of Education 5.0. Cogent Education, 11(1), 2388975.

Rasagama, I., Riswanto, R., Salim, M., Suseno, N., & Hidayatullah, D. (2022). How to Manage an Effective Laboratory for Science Learning in Schools? Journal of Physics Education Research & Development.

Riza, M. (2024). Design and Implementation of Laboratory Equipment Information System: A Case Study at SMK 1 Sigli. Journal Dekstop Application (JDA).

Rustandi, A. (2021). The Application of the ADDIE Model in the Development of Learning Media at SMPN 22 Samarinda City. Journal of Fasikom-Information Technology Computer Science, University of Muhammadyah Riau.

Ryanto, R., Wijayanti, A. T., Widiastuti, A., & Riadi, A. (2025). The Effectiveness of Learning Media in Overcoming Learning Difficulties: Student Perceptions. Jurnal Pemberdayaan Masyarakat, 4(1), 169–182.

Saputra, A. M. A., Tawil, M. R., Hartutik, H., Nazmi, R., La Abute, E., Husnita, L., ... & Haluti, F. (2023). Pendidikan Karakter di Era Milenial: Membangun Generasi Unggul dengan Nilai-Nilai Positif. PT. Sonpedia Publishing Indonesia.

Sauro, J., & Lewis, J. R. (2016). Quantifying the User Experience: Practical Statistics for User Research. Morgan Kaufmann.

Souza, M., González, M., & Pinho, A. (2024). Maturity Model for Sustainability Assessment of Chemical Analyses Laboratories in Public Higher Education Institutions. Sustainability, 16(5), 2137.

Subarkah, E., Kartowagiran, B., Sumarno, Hamdi, S., & Rahim, A. (2022). The Development of Life Skill Education Evaluation Model at Life Skill Training Centre. International Journal of Educational Methodology, 8(2), 363–375.

Sugiyono. (2019). Metode Penelitian Pendidikan (Kuantitatif, Kualitatif, dan R&D). Alfabeta.

Sugiyono. (2022). Metode Penelitian Kuantitatif, Kualitatif dan R&D. Alfabeta.

Tong, F., Tang, S., Irby, B. J., Lara-Alecio, R., & Guerrero, C. (2020). The Determination of Appropriate Coefficient Indices for Inter-Rater Reliability: Using Classroom Observation Instruments as Fidelity Measures in Large-Scale Randomized Research. International Journal of Educational Research, 99, 101514.

UNESCO. (2023). Spring Data Refresh 2023.

United Nations. (2021). Globally Harmonized System of Classification and Labelling of Chemicals (GHS) (Edisi revisi ke-9). United Nations Publications.

Van den Berg, C., & Bozalek, V. (2024). Design Principles to Develop Digital Innovation Skills: A Design-Based Research Approach. Educational Technology Research and Development, 72(2), 947–972.

Vlachogianni, P., & Tselios, N. (221). Perceived Usability Evaluation of Educational Technology Using the System Usability Scale (SUS): A Systematic Review. Journal of Research on Technology in Education, 54, 392–409.

Wang, W., Su, Y., Cao, H., & Li, D. (2025). Enhancing Chemical Laboratory Safety with Hazards Risks Mitigation and Strategic Actions. Laboratories, 2(1), 5.

Welda, W., Putra, D., & Dirgayusari, A. (2020). Usability Testing Website Using the System Usability Scale (SUS) Method. International Journal of Natural Science and Engineering.

WHO. (2024). WHO Results Report 2023 Shows Notable Health Achievements.

Yadiannur, M., & Rahmah, R. (2025). E-Modules of Applied Physics Based on I-Sets and Context-Rich Problem Learning (CRP) Approach Complementary to Characters: A Research and Development (R&D). Gravity: Jurnal Ilmiah Penelitian dan Pembelajaran Fisika.

Yuliastrin, A., Vebrianto, R., Berlian, M., & Thahir, M. (2023). Developing Media of Virtual Laboratory of Science to Support as a Pioneer of Cyber-University. Contemporary Educational Technology, 15(2), ep420.

Zhao, A., DeSousa, N., Henriksen, H., May, A., Tan, X., & Lawrence, D. (2024). Assessing Laboratory Safety Training in Undergraduate Education. Journal of Chemical Education.

Zydney, J. M., Warner, Z., & Angelone, L. (2020). Learning Through Experience: Using Design-Based Research to Redesign Protocols for Blended Synchronous Learning Environments. Computers & Education, 143, 103678.

Refbacks

  • There are currently no refbacks.