Pengembangan aplikasi persuratan berbasis Excel VBA untuk mengoptimalisasi layanan administrasi di Desa Batulaya
Abstract
Abstrak
Program pengabdian masyarakat di Desa Batulaya bertujuan untuk meningkatkan efisiensi administrasi desa melalui pengembangan aplikasi berbasis Excel VBA. Aplikasi ini dirancang untuk mempermudah pembuatan dan pengelolaan surat menyurat, yang sebelumnya dilakukan secara manual. Proses manual ini sering kali memakan waktu lama dan rentan terhadap kesalahan administratif. Melalui pelatihan dan pendampingan implementasi, aparat desa diajarkan cara mengoperasikan aplikasi, memodifikasi template surat, dan mengotomatisasi tugas administratif lainnya. Evaluasi terhadap hasil implementasi menunjukkan adanya peningkatan signifikan dalam efisiensi kerja aparat desa, dengan pengurangan waktu pembuatan surat dari rata-rata 15 menit menjadi hanya 5 menit. Selain itu, aplikasi ini berhasil mengurangi kesalahan administratif yang sering terjadi pada proses manual, meningkatkan akurasi data, dan memperbaiki sistem pengarsipan. Dengan antarmuka sederhana, aplikasi ini mudah digunakan bahkan bagi pengguna dengan pengetahuan teknologi terbatas. Inovasi ini memberikan solusi teknologi yang tepat guna dan berpotensi untuk direplikasi di desa-desa lain dengan tantangan serupa. Program ini juga memberikan dampak jangka panjang berupa peningkatan kapasitas sumber daya manusia desa dalam memanfaatkan teknologi informasi untuk mendukung administrasi yang lebih modern dan efisien.
Kata kunci: aplikasi excel VBA; administrasi desa; efisiensi administrasi; pelatihan teknologi informasi; pengarsipan surat
Abstract
The community service program in Batulaya Village aims to improve administrative efficiency through the development of an Excel VBA-based application. This application is designed to simplify the creation and management of letters, which were previously done manually. Manual processes often took a long time and were prone to administrative errors. Through training and implementation assistance, village officials were taught how to operate the application, modify letter templates, and automate other administrative tasks. The evaluation of the implementation results showed a significant improvement in the work efficiency of village officials, reducing the time required to create a letter from an average of 15 minutes to just 5 minutes. Additionally, the application successfully reduced administrative errors, enhanced data accuracy, and improved the document archiving system. With its simple interface, the application is easy to use even for users with limited technological knowledge. This innovation provides an appropriate technological solution and has the potential to be replicated in other villages facing similar challenges. The program also delivers long-term impacts by enhancing the human resource capacity of the village in utilizing information technology to support more modern and efficient administration.
Keywords: excel VBA application; village administration; administrative efficiency; information technology training; letter archiving
Keywords
Full Text:
PDFReferences
Angga Yoga Aji Patria, & Abidin. (2024). Perancangan Sistem Integrasi Sparepart Menggunakan Aplikasi Macro Visual Basic for Aplication Excel. Journal of Mandalika Literature, 5(4), 676–689. https://doi.org/10.36312/jml.v5i4.3619
Calderón, A., Ruiz, M., & O’Connor, R. V. (2017). Coverage of the ISO 21500 Standard in the Context of Software Project Management by a Simulation-Based Serious Game. Communications in Computer and Information Science Vol. 770, 399–412. https://doi.org/10.1007/978-3-319-67383-7_29
David. (2019). Peningkatan Keterampilan Penggunaan Macro VBA. Seminar Nasional Pengabdian Pada Masyarakat 2019, 29–37.
Firdaus, T. M., & Susanty, A. (2021). Perancangan Sistem Informasi Gudang Pendataan Barang Berbasis Excel VBA Pada CV Cipta Usaha Mandiri Temanggung. Seminar Dan Konferensi Nasional IDEC 26-27 Juli 2021, 12. https://idec.ft.uns.ac.id/wp-content/uploads/IDEC2021/PROSIDING/POSI/ID034.pdf
Iriany, A., Ngabu, W., Solimun, S., Efendi, A., Ariyanto, D., & Putra Rochmanullah, A. (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. https://doi.org/10.21776/ub.jiat.2023.009.01.8
Ishak, A., Ginting, R., & Amalia, T. (2020). Macro excel (VBA) implementation in designing booking information systems in uniform convection (Case Study: Kholidi Taylor SME, Medan Denai). IOP Conference Series: Materials Science and Engineering, 1003(1), 012019. https://doi.org/10.1088/1757-899X/1003/1/012019
Knowles, M. S., Holton III, E. F., Swanson, R. A., & Robinson, P. A. (2020). The Adult Learner: The Definitive Classic in Adult Education and Human Resource Development (9 Th). Routledge. https://doi.org/10.4324/9780429299612
Kolb, D. A. (2015). Experiential Learning: Experience as the Source of Learning and Development (2nd Editio). Pearson Education. https://books.google.co.id/books?id=o6DfBQAAQBAJ
Kristia Yuliawan, & Juridno Wilson. (2024). Implementasi Pengolahan Dokumen Menggunakan VBA dan Microsoft Excel. Jurnal Teknologi Dan Informatika, 2(1), 13–27. https://pesatnabire.id/index.php/jti/article/view/21
Maharani, W. M., Zauhar, S., Makmur, M., & Haryono, B. S. (2021). Blended Learning on Vocational High School in Adaptation of New Habit Era with Whole of Government Approach. Proceedings of the 3rd Annual International Conference on Public and Business Administration (AICoBPA 2020), 191(AICoBPA 2020), 516–520. https://doi.org/10.2991/aebmr.k.210928.098
Mas, A., & Mesquida, A. (2018). Software process improvement and capability determination conference 2017. In A. Mas, A. Mesquida, R. V. O’Connor, T. Rout, & A. Dorling (Eds.), Computer Standards & Interfaces (Vol. 60, pp. 1–2). Springer International Publishing. https://doi.org/10.1016/j.csi.2018.05.002
Merriam, S. B., & Bierema, L. L. (2013). Adult Learning: Linking Theory and Practice (pp. 1–41). Wiley. https://books.google.co.id/books?id=ISJ8AAAAQBAJ
Nadilla, B., Ade, S. P., & Sit, A. (2024). Perancangan Aplikasi Input Surat Berbasis VBA (Visual Basic for Application) di Kantor Sekretariat Daerah Kabupaten Gunung Mas. VISA: Journal of Vision and Ideas, 4(2 SE-Articles), 946 – 954. https://doi.org/10.47467/visa.v4i2.2792
Naufal, I. H. P., & Handayanto, A. (2020). Aplikasi Stok Barang Gudang Berbasis Vba Excel dengan Metode Waterfall di UPT TIK UPGRIS. Science and Engineering …, 5(Sens 5), 686–694. http://conference.upgris.ac.id/index.php/sens/article/view/1455
Ndasak, B. O., Sutal, F. X., Jando, E., Batarius, P., Tedy, F., Ngaga, E., Daeng Bakka Mau, S., Filson M. Tengangatu, P., Samane, I. P. A., Sinlae, A. A. J., & Floribertha, L. (2024). Pembuatan Aplikasi Macro Sebagai Sarana Kontrol Surat Masuk dan Keluar Pada Kantor Lurah Karangsirih. Jurnal Pengabdian Kepada Masyarakat Nusantara (JPkMN), 5(3), 3678–3685.
Rogers, E. M., Singhal, A., & Quinlan, M. M. (2019). Diffusion of Innovations 1. In An Integrated Approach to Communication Theory and Research (pp. 415–434). Routledge. https://doi.org/10.4324/9780203710753-35
Rosalin, S., & Ambarwati, S. A. (2019). Perancangan dan Pembuatan Aplikasi Agenda Surat Berbasis Visual Basic For Application (VBA) Excel di Dinas Permberdayaan Masyarakat dan Desa Kabupaten Kabupaten Lumajang (Issue 12).
Saragih, R. M. A., & Gaffar, M. R. (2023). Making Applications For Archiving Incoming And Outgoing Letters At PT Felixindo Jaya Perkasa Base On VBA Excel. Records Management System Journal, 2(1), 6–21. https://doi.org/10.62201/rmsj.v2i1.75
Siregar, E. T., Alfina, O., Puspita, D., & Safii, M. (2023). Pelatihan Penginputan Data Secara Otomatis di Microsoft Excel Menggunakan Data Form dan Macro VBA (Basic For Aplication) di SMA IT Unggul Al-Munadi Medan. Jurnal Pengabdian Pada Masyarakat METHABDI, 3(2), 150–154. https://doi.org/10.46880/methabdi.Vol3No2.pp150-154
DOI: https://doi.org/10.31764/jpmb.v9i4.32541
Refbacks
- There are currently no refbacks.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
______________________________________________________
Jurnal Selaparang
p-ISSN 2614-5251 || e-ISSN 2614-526X
EDITORIAL OFFICE: