PENDAMPINGAN PENATAAN SISTEM ADMINISTRASI DESA DENGAN MENGEMBANGKAN APLIKASI ADMINISTRASI DESA TERPADU DI KELURAHAN ARJOSARI

  • Henny Pramoedyo Universitas Brawijaya
  • Wigbertus Ngabu Universitas Riau https://orcid.org/0000-0002-7153-7310
  • Ni Wayan Surya Wardhani Universitas Brawijaya
  • Atiek Iriany Universitas Brawijaya
  • Abela Chairunissa Universitas Brawijaya
DOI: https://doi.org/10.30598/pakem.5.2.131-142
Keywords: Village Administration, Excel-VBA, Public Service, Community Service

Abstract

This community service activity aims to assist Kelurahan Arjosari in restructuring its administrative system more effectively and efficiently through the development of a village administration application built with Microsoft Excel and Visual Basic for Applications (VBA). Based on initial observations, the administrative processes in the kelurahan were still conducted manually, leading to slow public service delivery and a high risk of errors. The developed application is designed to integrate with the village's population database, automate the generation of documents based on National Identification Numbers (NIK), and provide automatic data validation features. Through Focus Group Discussions (FGD) and the official launching of the application, local officials were actively involved in the planning and training phases. Evaluation results show that the application is easy to use, accelerates the document service process, and improves administrative data accuracy. This initiative has had a positive impact on the quality of public services at the local level and serves as a model for applying simple but effective technology to support digital transformation in village governance

Downloads

Download data is not yet available.

Author Biographies

Henny Pramoedyo, Universitas Brawijaya

Departemen Statistika

Wigbertus Ngabu, Universitas Riau

Pendidikan Matematika

Ni Wayan Surya Wardhani, Universitas Brawijaya

Departemen Statistika

Atiek Iriany, Universitas Brawijaya

Departemen Statistika

Abela Chairunissa, Universitas Brawijaya

Departemen Statistika

References

Aditiyawarman, D., Setiadi, D. R., Kumbara, R., Umbara, I., & Pambudi, N. (2018). Pengembangan Sistem Informasi Administrasi Desa Terpadu Pada Desa Karoya Kabupaten Purwakarta. Jurnal Abdimas BSI: Jurnal Pengabdian Kepada Masyarakat, 1(3).

Baskoro, D. A., Maipita, I., Fitrawaty, F., & Dongoran, F. R. (2023). Digitalisasi sistem informasi dan administrasi desa sebagai upaya menuju desa cerdas di desa kolam, percut sei tuan, deli serdang, sumatera utara. Dinamisia: Jurnal Pengabdian Kepada Masyarakat, 7(3), 624–635.

Fadila, N., Setiawati, D., Wahyono, A., & Aziz, M. A. (2024). Perancangan Prototype User Interface Sistem Informasi Pusat Data Dokumen Menggunakan Figma. Jurnal Komputer, Informasi Dan Teknologi, 4(1), 22.

Iriany, A., Ngabu, W., Solimun, S., Efendi, A., Ariyanto, D., & Rochmanullah, A. P. (2023). Penerapan Aplikasi Sistem Administrasi Desa Untuk Mendukung Tata Kelolah Pemerintah Desa Di Desa Mulyoagung Kecamatan Dau. Journal of Innovation and Applied Technology, 9(1), 43–48.

Mulawarman, A., Wajidi, F., Munaja, R., Utami, A. N. F., & Candaria, C. (2025). Pengembangan aplikasi persuratan berbasis Excel VBA untuk mengoptimalisasi layanan administrasi di Desa Batulaya. SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan, 9(4), 2468–2481.

Netti, H., Subian, S., Khoirin, N., & Eri, S. (2021). Pelatihan Penggunaan Microsoft Office Excel Dalam Penataan Administrasi Desa Bagi Operator/Sekretaris Desa Se Kecamatan Kedondong Kabupaten Pesawaran. Jurnal Pengabdian Kepada Masyarakat BUGUH, 1(4), 23–30.

Romadhon, A. L., & Maryam, M. (2023). Rancang bangun sistem informasi layanan administrasi desa berbasis web di desa dukuh. JIPI (Jurnal Ilmiah Penelitian Dan Pembelajaran Informatika), 8(2), 514–524.

Styawati, S., Samsugi, S., Rahmanto, Y., & Ismail, I. (2022). Penerapan Aplikasi Administrasi Desa Pada Desa Mukti Karya Mesuji. Vol, 3, 123–131.

Sudipa, I. G. I., Udayana, I. P. A. E. D., Rizal, A. A., Kharisma, P. I., Indriyani, T., Asana, I. M. D. P., Ariana, A. A. G. B., & Rachman, A. (2023). Metode Penelitian Bidang Ilmu Informatika (Teori & Referensi Berbasis Studi Kasus). PT. Sonpedia Publishing Indonesia.

Zendrato, B., Lase, D. C., Telaumbanua, A. N., Gulo, A., Hareafa, Y. P., Laoli, H. S., & Zebua, S. (2025). Implementasi Surat Keterangan Desa Berbasis Excel VBA di Kota Gunungsitoli. Jurnal Altifani Penelitian Dan Pengabdian Kepada Masyarakat, 5(4), 578–588.

Zutiasari, I., Saputri, S. E., Yuvita, L. F., Hotimah, H., Assegaff, M. F., & Malang, U. N. (2020). Sistem Aplikasi Tata Kelola Administrasi (SIPATAS) dalam peningkatan pelayanan prima administrasi desa. Jurnal Karinov, 3(3), 140–146.

Published
2025-09-26
How to Cite
Pramoedyo, H., Ngabu, W., Wardhani, N., Iriany, A., & Chairunissa, A. (2025). PENDAMPINGAN PENATAAN SISTEM ADMINISTRASI DESA DENGAN MENGEMBANGKAN APLIKASI ADMINISTRASI DESA TERPADU DI KELURAHAN ARJOSARI. PAKEM : Jurnal Pengabdian Kepada Masyarakat, 5(2), 131-142. https://doi.org/10.30598/pakem.5.2.131-142
Issue
Vol 5 No 2 (2025): Pakem : Jurnal Pengabdian Kepada Masyarakat
Section
Articles

Copyright (c) 2025 PAKEM : Jurnal Pengabdian Kepada Masyarakat

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

 Authors who publish with PAKEM: Jurnal Pengabdian Kepada Masyarakat agree to the following terms:

  1. Authors grant copyright to the journal and right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-NC-SA 4.0)
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.