Optimalisasi Sistem Informasi Administrasi Desa Melalui Pelatihan Microsoft Excel Dan Google Workspace Bagi Aparatur Pemerintahan Desa Sanankerto,  Kabupaten Malang

Mohammad Syafriel; Novy Karmelita Indrawati; Roni Angger Aditama; Gusnar Mustapa; M. Shabry

doi:10.61132/kegiatanpositif.v3i2.2130

Authors

Mohammad Syafriel Sekolah Tinggi Ilmu Ekonomi Indocakti Malang
Novy Karmelita Indrawati Sekolah Tinggi Ilmu Ekonomi Indocakti Malang
Roni Angger Aditama Sekolah Tinggi Ilmu Ekonomi Indocakti Malang
Gusnar Mustapa Sekolah Tinggi Ilmu Ekonomi Indocakti Malang
M. Shabry Sekolah Tinggi Ilmu Ekonomi Indocakti Malang

DOI:

https://doi.org/10.61132/kegiatanpositif.v3i2.2130

Keywords:

Administrative Information System, Microsoft Excel, Google Workspace, Community Service

Abstract

Sanankerto Village still relies on manual administration, which affects the efficiency of data management and public services. This community service program aims to optimize the village administrative information system through training in Microsoft Excel and Google Workspace for 20 village officials. The methods used include lectures, demonstrations, hands-on practice, and one-month mentoring. Evaluation results show a significant increase in skills—the average pre-test score of 50% rose to 85% in the post-test. Participants are now able to prepare financial reports, use spreadsheets for archiving, and utilize Google Docs and Google Drive for collaborative village data management. These findings align with similar community programs in Kedondong District, where Excel has been used for systematic administrative archiving. Moreover, the use of Google Spreadsheet has proven to enhance organizational efficiency in the Karang Taruna youth organization. This program demonstrates that strengthening village officials' capacity in information technology can support more professional and accountable village governance.

Downloads

Download data is not yet available.

References

Abdussamad, M., N. Amir, dan M. Amin. “Optimalisasi Tata Kelola Pelayanan Administrasi Desa Berbasis Digital di Desa Limbato, Kabupaten Boalemo.” Jurnal Ilmiah Pengabdian Masyarakat Siber Mas 9, no. 2 (2025): 123–132. https://ejurnal.ung.ac.id/index.php/sibermas/article/view/29055.

Amali, R., T. Abas, dan M. Yusuf. “Membangun Desa Digital: Implementasi Sistem Informasi Administrasi Berbasis Website di Desa Toluwaya.” Jurnal Ilmiah Pengabdian Masyarakat Siber Mas 9, no. 1 (2025): 45–55. https://ejurnal.ung.ac.id/index.php/sibermas/article/view/31607.

Ferdinan, H. A., M. Munadi, dan E. A. Wibowo. “Implementasi dan Digitalisasi Sistem Administrasi Desa di Kantor Desa Kedungcino, Jepara.” Jurnal Pengabdian Jumintal 5, no. 2 (2023): 88–98. https://journal.literasisains.id/index.php/jumintal/article/view/2482.

Hasanuddin, M., dan B. Fachri. “Pelatihan Microsoft Office untuk Meningkatkan Kompetensi Aparatur Desa.” Jurnal Hasil Pengabdian Masyarakat (JURIBMAS) 3, no. 3 (2025): 168–174. https://doi.org/10.62712/juribmas.v3i3.314.

Herawati, N., S. Saidi, K. Nisa, dan E. Setiawan. “Pelatihan Penggunaan Microsoft Office Excel dalam Penataan Administrasi Desa bagi Operator/Sekretaris Desa se-Kecamatan Kedondong, Kabupaten Pesawaran.” Buguh: Jurnal Pengabdian Kepada Masyarakat 1, no. 4 (2024). https://wnj.westscience-press.com.

Imaduddin, R., U. Wahyudin, dan A. Syahrul. “Digitalisasi Layanan Administrasi Surat di Desa Wangunsari Berbasis Mobile.” Jurnal Teknologi Informasi dan Komunikasi 11, no. 1 (2023): 60–69. https://jurnal.lldikti4.or.id/index.php/jurnaltekno/article/view/976.

Imansari, N., I. Prastyaningrum, dan U. Kholifah. “Pelatihan Penggunaan Google Spreadsheet untuk Karang Taruna Desa Sukowidodo.” Abdimas Galuh (2022). https://ejurnal.unisri.ac.id.

Jamaludina, H., R. Kusnandar, dan S. Putri. “Implementasi Penggunaan Aplikasi Sistem Administrasi Desa Setu Berbasis Website.” Jurnal Pengabdian Masyarakat UMUS 4, no. 1 (2023): 30–39. https://jurnal.umus.ac.id/index.php/jamu/article/view/1236.

Lestari, D., I. Zulakarnain, dan F. Fauziyah. “Empowering Masyarakat dengan Pelatihan Microsoft Excel di Kelurahan Mampang-Kota Depok.” Jurnal Pengabdian West Science 3, no. 11 (2024). https://wnj.westscience-press.com.

Mahendra, D. A., dan Yuliani, R. “Digital Transformation in Village Governance: Success Factors and Challenges in Integrating Local Administrative Systems.” Jurnal Teknologi dan Masyarakat Digital 4, no. 2 (2025): 44–57. https://doi.org/10.5678/jtmd.v4i2.240.

Nasir, R. S., dan Nursyamsi. “Sosialisasi Pemanfaatan Software Microsoft Excel dalam Pengolahan Data Desa Bulo-Bulo.” Jurnal Pengabdian Masyarakat Hasanuddin 5, no. 1 (2024). https://journal.unhas.ac.id.

Pahayahay, A. “Enhancing Collaboration Through Google Workspace: Assessing and Strengthening Current Practices.” arXiv (2025). https://arxiv.org.

Rohmawati, S., dan Hidayat, A. “Penguatan Tata Kelola Administrasi Desa melalui Pelatihan Digital Office Suite untuk Aparatur Pemerintah Desa.” Jurnal Abdi Masyarakat Digital 2, no. 2 (2024): 101–110. https://doi.org/10.25077/jamd.2.2.2024.101-110.