Jurnal IPTEK Bagi Masyarakat
Vol 6 No 1 (2026)

Microsoft Excel and Google Form Training for Administrative Data Management of Hamlet Heads in Wedomartani

Aloysius Agus Subagyo (Universitas Teknologi Digital Indonesia)
Asyahri Hadi Nasyuha (Universitas Teknologi Digital Indonesia)
Wijang Widhiarso (Universitas Teknologi Digital Indonesia)
Mesti Woro Mahatmi (Universitas Teknologi Digital Indonesia)
Catur Setyono (Universitas Teknologi Digital Indonesia)



Article Info

Publish Date
09 Jul 2026

Abstract

The administration of hamlets at the grassroots level requires orderly data management and clear information presentation to support effective public services. Hamlet heads (Kepala Padukuhan) in Wedomartani Village still face limitations in processing administrative data and presenting information digitally, as recording activities largely rely on manual methods and paper-based forms. This community service activity aims to improve the competence of hamlet heads in administrative data processing and information visualization through the use of Microsoft Excel and Google Form. The activity was carried out through three stages, namely preparation, training implementation, and mentoring with evaluation, using participatory and learning by doing approaches. Data were collected through pre-test and post-test, direct observation, and a participant satisfaction questionnaire. The results showed an increase in the average participant mastery score from 37.2% in the pre-test to 81.6% in the post-test, an improvement of 44.4 points across the five trained competency aspects. Participants were able to process administrative data, create tables and simple charts in Microsoft Excel, and design digital forms with Google Form for community data collection. The activity also produced ready-to-use Excel and Google Form templates. It is concluded that practical and applicable training effectively strengthens the digital capacity of hamlet heads and supports more orderly, accurate, and efficient administrative governance.

Copyrights © 2026






Journal Info

Abbrev

j-ibm

Publisher

Subject

Agriculture, Biological Sciences & Forestry Humanities Computer Science & IT Education Mechanical Engineering Physics Public Health Social Sciences

Description

J-IbM: Jurnal IPTEK bagi Masyarakat, diterbitkan oleh Ali Institute of Research and Publication (AIRA). J-IbM menerbitkan artikel ilmiah berkaitan dengan pengabdian, praktik dan proses keterlibatan masyarakat. J-IbM adalah jurnal online peer-review yang didedikasikan untuk publikasi penelitian ...