Strengthening Digital Data-Based Asset Management Systems to Support School Accountability

Luthfi Firdaus; Fajrin Satria Dwi Kesumah; Salsabila; Reka Aldilana Ramadhan

doi:10.33365/jsstcs.v7i1.938

Luthfi Firdaus Universitas Lampung https://orcid.org/0009-0001-8963-0521
Fajrin Satria Dwi Kesumah Universitas Lampung https://orcid.org/0000-0001-6525-4667
Salsabila Universitas Lampung
Reka Aldilana Ramadhan Universitas Lampung

DOI: https://doi.org/10.33365/jsstcs.v7i1.938

Abstrak

This community service activity aims to strengthen the asset management system at YP Unila High School through the implementation of a simple yet effective digital-based database. Initial observations identified key issues such as scattered asset records, data inconsistencies, and minimal handover documentation, which could potentially reduce the accountability and efficiency of school governance. Interventions included designing a Microsoft Excel-based database template, providing technical training, and assisting with implementation through the initial data entry stage. Pre-post test results for 15 participants (staff) showed an average score increase of 17 points, indicating the training's effectiveness in enhancing human resource capacity. The evaluation also revealed a reduction in asset naming variations, increased inventory code consistency, and the emergence of a data-driven work culture. Further discussion, referring to academic literature, confirmed that asset digitization not only simplifies administrative processes but also strengthens the principles of good governance through transparency and accountability. This program can be replicated in other schools using a phased approach and developed into a web-based system for more comprehensive and sustainable data integration.

Referensi

Ahmad, A. C. (2023). e-AIMSS (Electronic Asset Inventory and Management System in School) for Resource Optimization and Organizational Productivity. International Journal of Multidisciplinary Educational Research and Innovation, 3. https://doi.org/10.5281/zenodo.8326056

Alkhard, A. (2024). Enhancing Asset Management Through Integrated Facilities Data, Digital Asset Management, and Metadata Strategies. Construction Economics and Building , 24(3), 76–94. https://doi.org/10.5130/AJCEB.v24i3.8741

Asyhari, M. S., Akhyak, A., Naim, N., Maftukhin, M., & Patoni, A. (2022). International Journal of Social Science and Education Research Studies Asset Management Based on Wealth Management in an Effort to Increase Funding for Islamic Boarding School Education. International Journal of Social Science and Education Research Studies, 2(12), 854–863. https://doi.org/10.55677/ijssers/V02I12Y2022-20

Coronel, C., & Morris, S. (2019). Database Systems Design, Implementation, & Management (13th ed.). Cengage.

Munn, K., Goh, S., Basson, M., & Thorpe, D. (2021). Asset management competency requirements in Australian local government: a systematic literature review. Australasian Journal of Engineering Education, 26(2), 167–200. https://doi.org/10.1080/22054952.2021.1934262

Ogbuagu, I. G. (2023). Asset Management Practices for Financial Stability of Private Secondary Schools in Rivers State. Journal of Education in Developing Areas (JEDA) Special Edition, 31(2), 453–465. https://journals.journalsplace.org/index.php/JEDA

Priatna, A., Awaludin, D., Wahidin, M., & Darmansyah, D. (2021). Pelatihan Microsoft Office Excel Sebgai Upaya Peningkatan Kompetensi Siswa SMK Rosma Karawang Dalam Mengolah Data. Jurnal Abdimas: Sistem Dan Teknologi Informasi, 1(1), 7–12. https://doi.org/10.35969/abdimas.v1i1.101

Ribhan, R., Firdaus, L., Ahmad, A., & Ramelan, M. R. (2024). PENINGKATAN LITERASI DIGITAL SEBAGAI AKSELERASI TRANSFORMASI DIGITAL PELAKU USAHA MIKRO KECIL MENENGAH. BEGAWI : Jurnal Pengabdian Kepada Masyarakat, 2(2), 47–54. https://doi.org/10.23960/begawi.v2i2.50

Saragih, N. E., Astuti, E., & Desi, E. (2021). Pelatihan Microsoft Excel 2010 Pada Sma Swasta Nurul Hasanah Tembung. PUBLIDIMAS (Publikasi …, 1(1), 21–26.

Waluyo, A., Nasrullah, H., & Ediwidjojo, S. P. (2020). Pelatihan Penggunaan Apkikasi Microsoft Office (Word, Excel, Power Point) 2010 untuk Peningkatan Kemampuan SDM PEMDES Desa Kebakalan, Karanggayam, Kebumen. JURPIKAT (Jurnal Pengabdian Kepada Masyarakat), 1(1), 21–28. https://doi.org/10.37339/jurpikat.v1i1.273

Yuningsih, Y., Andriani, L., Firdaus, L., Nugroho, D., & Putra Pradipta, R. (2024). Improving SMEs Business Productivity with Microsoft Excel Training in the Big Data Era. Journal of Social Sciences and Technology for Community Service (JSSTCS), 5(2), 448. https://doi.org/10.33365/jsstcs.v5i2.4720

Gananda Central School District. (2022).Wasp asset management case study: How Gananda CSD achieved 99% inventory accuracy and reduced audit time by 75%. Wasp Barcode Technologies. Retrieved from https://www.waspbarcode.com

Frontline Education. (2021). DeKalb County School District streamlines asset management and audit readiness with Frontline Asset Management. Frontline Education Case Study. Retrieved from https://www.frontlineeducation.com

Ministry of Manpower. (2021). Managing Numerical Data Using Microsoft Excel (Including Macros and Pivots). Retrieved June 13, 2021, from Pelatihan.kemnaker.go.id website: https://pelatihan.kemnaker.go.id/programs/a9d5cdf5-216b-4ad5-a51cf3cb12604d44/detail/competencies?previous=&acceptPreWorkCard=1

prakerja.go.id. (2021). Sharpen These 3 Skills to Become a Reliable Data Entry Clerk. Retrieved June 13, 2021, from prakerja.go.id website: https://www.prakerja.go.id/artikel/pertajam-3-kuat-ini-untuk-jadi-data-entry-handal

Microsoft Support. (2021). BI Capabilities in Excel and Office 365. Retrieved June 13, 2021, from support.microsoft.com website:https://support.microsoft.com/idid/office/kemampuan-bi-di-excel-dan-office-365-26c0548e-124c-4fd3-aab3-5f64568cb743

University of Baguio. (2020). University of Baguio Research and Property Inventory System (UBRPIS): A prototype development for digital asset management. ResearchGate. Retrieved from https://www.researchgate.net

Timly Software AG. (2023). Digital asset tracking in schools: Improving accuracy and saving administrative time. Timly Asset Tracking Whitepaper. Retrieved from https://www.timly.com