Abdimas Talenta : Jurnal Pengabdian Kepada Masyarakat
Vol. 11 No. 1 (2026): ABDIMAS TALENTA: Jurnal Pengabdian Kepada Masyarakat

Transforming Population Data Governance through PivotTables and Digital Archiving in Pagarbatu Village, North Tapanuli

Yulia Kurni Sari Sitepu (Institut Agama Kristen Negeri Tarutung)
Rony Marpaung (Institut Agama Kristen Negeri Tarutung)
Limmarten Simatupang (Institut Agama Kristen Negeri Tarutung)
Diana Martiani Situmeang (Institut Agama Kristen Negeri Tarutung)
Dostri Ambarita (Institut Agama Kristen Negeri Tarutung)
Jontinus Manullang (Institut Agama Kristen Negeri Tarutung)
Jonas Franky R Panggabean (Institut Agama Kristen Negeri Tarutung)
Veronika H Purba (Institut Agama Kristen Negeri Tarutung)



Article Info

Publish Date
17 Jul 2026

Abstract

Digital transformation at the village-government level is essential for improving administrative efficiency, data accuracy, institutional accountability, and public information services. Pagar Batu Village, Sipoholon District, North Tapanuli Regency, covers an area of approximately 17.49 km² and is administered by only five village officials. Prior to this community engagement program, population records had been maintained using basic Microsoft Excel worksheets, while document storage lacked standardized classification, file-naming conventions, access restrictions, and systematic backup procedures. This program aimed to strengthen the capacity of village officials to manage, summarize, store, and retrieve population data through the use of Microsoft Excel PivotTables and a structured digital archiving system. The program was implemented through needs assessment, data standardization, preparation of learning materials, hands-on demonstrations, guided practice, product-based assignments, evaluation, and follow-up assistance. The outputs included a standardized population database template, automated population summaries, a classified digital archive structure, file-naming guidelines, access-level classifications, and an operational guide. The program demonstrated that optimizing familiar and readily available digital tools can provide a practical approach to improving population data governance in a village with limited human and technological resources. This initiative contributes primarily to Sustainable Development Goal 16 by supporting effective, accountable, and transparent local institutions, while also contributing to SDGs 4 and 9 through digital capacity development and administrative innovation.

Copyrights © 2026






Journal Info

Abbrev

abdimas

Publisher

Subject

Agriculture, Biological Sciences & Forestry Law, Crime, Criminology & Criminal Justice Social Sciences

Description

ABDIMAS TALENTA merupakan Jurnal Pengabdian Kepada Masyarakat yang diterbitkan oleh Lembaga Pengabdian/Pelayanan kepada Masyarakat Universitas Sumatera Utara (LPPM ...