PemanfaatanSpreadsheet (Google Sheet) dalam Pengembangan Sistem Informasi Inventaris Peralatan pada Gereja XYZ di Kota Salatiga
DOI:
https://doi.org/10.18196/berdikari.v13i1.25430Keywords:
Salatiga, nformation System, Inventory, EquipmentAbstract
Spreadsheet is a familiar application, and many people use it to record data in tabular form and process data, which makes it very easy to create the information needed faster. Nowadays, spreadsheets can be implemented using Google Sheets. The Community Service Program was carried out at XYZ Church in Salatiga City using the spreadsheet application. Activity Objective: Help churches to have an equipment inventory information system and mentor the use of information systems. Using Google Sheets (spreadsheet) applications so that they can help churches record and organize a number of inventories effectively and efficiently. Using the PRA (Participatory Rapid Appraisal) method and following stages such as initial surveys, problem identification, alternative solution design, system development, system training, and application use assistance for parties related to church inventory. Application development using Google Sheets by using the App Sheet module to create the user interface, while the database still uses sheets in the spread sheet. The training was given to representatives per category. The implementation of community service is likely successful because of the training participants who agree on average above 75%, those who are neutral on average below 25%, and those who are not neutral 0%. The results of the equipment inventory information system model from this community service can be used as an example for other churches in the city of Salatiga
References
N. . . , W. . I. M. . , & Nurlaily. Oktaviani, “Sistem Informasi Inventaris Barang Berbasis Web Pada SMP Negeri 1 Buer ,” Jurnal Informatika Teknologi Dan Sains (Jinteks), vol. 1, no. 2, pp. 160–168, 2019.
M. , N. S. , & B. B. Setiawan, “Pelatihan Pengelolaan Inventory Dan Asset Bagi Pengelola Ereveld. ,” Jurnal Penamas, vol. 8, no. 1, pp. 90–94, 2024.
H. Agusvianto, “Sistem informasi inventori gudang untuk mengontrol persediaan barang pada gudang studi kasus: PT. Alaisys Sidoarjo. ,” JIEET (Journal of Information Engineering and Educational Technology), vol. 1, no. 1, pp. 40–46, 2017.
T. D. T. Desyani and A. T. N. A. T. Ningrum, “Perancangan Sistem Inventaris Barang Berbasis Website Pada Pusat Data Dan Informasi Kementerian Agraria Dan Tata Ruang Badan Pertanahan Nasional.,” Jurnal Ilmu Komputer, Teknik, dan Multimedia, vol. 2, no. 3, pp. 110–117, 2024.
H. , Setiawan, Y. , Rahmawati, W. , Sumarmi, R. B. , Jakaria, and P. A. Kusumawardani, “Public Library: Efforts to Increase Reading Interest of Orphans at the Taqwa Al-Kausar House Foundation, Sidoarjo.,” Procedia of Social Sciences and Humanities, vol. 3, no. 1, pp. 1051–1053, 2022.
A. T. Naibaho, “Analisis pengendalian internal persediaan bahan baku terhadap efektivitas pengelolaan persediaan bahan baku.,” Jurnal EMBA: Jurnal Riset Ekonomi, Manajemen, Bisnis dan Akuntansi, , vol. 1, no. 3, 2013.
W. Tamodia, “Evaluasi penerapan sistem pengendalian intern untuk persediaan barang dagangan pada PT. Laris Manis Utama Cabang Manado.,” Jurnal EMBA: Jurnal Riset Ekonomi, Manajemen, Bisnis dan Akuntansi, , vol. 1, no. 3, 2013.
T. A. , Doloksaribu and D. T. MANURUNG, “Urgensi Inventarisasi Peralatan Musik Gereja Yang Sistematis, Teratur Dan Tertib. Akuntansi dan Humaniora:,” Jurnal Pengabdian Masyarakat, vol. 1, no. 3, pp. 177–188, 2022.
I. H. Naufal, “ Science and Engineering National Seminar. Aplikasi Stok Barang Gudang Berbasis VBA Excel dengan metode Waterfall di UPT TIK UPGRIS,” pp. 687–688, 2020.
Yuswanto, Melesat Jauh Bersama Microsoft Excel 2010. Jakarta: AV Publisher., 2010.
MADCOMS, Kupas Tuntas Microsoft Excel 2016. Yogyakarta : CV Andi Offset., 2016.
J. Woodhouse, “Asset Management : concepts & practices Asset Management : concepts & practices Optimised, Whole life cycle Asset Management,” pp. 1–12, Oct. 2019.
A. A Kurniawan, “ Pengembangan Aplikasi web manajemen aset pemerintah bandung modul inventarisasi, penilaian, penghapusan menggunakan metode iterative dan incremental,” eProceedings Eng, vol. 2, no. 3, 2015.
R. , Sirait, A. , Gunaryati, and B. Rahman, “Sistem Inventarisasi Berbasis Web Menggunakan Metode Rapid Application Development,” Jurnal Ilmiah Wahana Pendidikan, , vol. 9, no. 10, pp. 709–718, 2023.
M. D. Erwin, “Perancangan Website dan Sistem informasi Gereja Katolik Paroki Santa Maria Bintang Laut Ambon,” Jurnal Simetrik P3M Politeknik Negeri Ambon, vol. 12, no. 2, 2022.
V. Hermawan, “Pembuatan Sistem Informasi Manajemen Inventaris, Keuangan Dan Jemaat Pada Gereja X.,” 2013.
E. Yuniarsi, “Sistem Informasi Manajemen Aset Inventaris Gereja Berbasis Website Pada Gereja Kristen Jawa Delanggu,” 2023.
K. H. Dwi, “Implementasi dan pelatihan aplikasi manajemen aset gereja berbasis progressive web application,” Abdimasku, vol. 6, no. 3, pp. 735–740, 2023.
Hasanah, “Pengaruh Metode PRA(Participatory Rapid Appraisal) Terhadap Implementasi pembangunan masyarakat Kelompok tani Mekar Sari I Tahun 2019,” Jurnal Transformasi, vol. 6, no. 1, pp. 49–56, 2020.
Mardikanto, Totok, and Soebianto, Pemberdayaan Masyarakat Dalam Perspektif Kebijakan Publik. Bandung: .: Alfabeta, 2019.
Asep. Supriatna, “Relevansi Metode Participatory Rural Appraisal Dalam Mendukung Implementasi Undang-Undang Pemerintah Desa,” Jurnal Lingkar Widyaiswara, pp. 40–25, 2014.
M. , N. E. D. , Praseptiawan and A. Iqbal, “Pelatihan Sistem Informasi Desa untuk Meningkatkan Kemampuan Literasi Digital Perangkat Desa Taman Sari,” ABDIMAS: Jurnal Pengabdian Masyarakat, vol. 4, no. 1, pp. 521–528, 2021.
A. A. , J. M. , Nababan and F. A. Sianturi, “ Pelatihan Sistem Informasi Penelitian Dan Pengabdian Kepada Masyarakat (SIM-PPM) STMIK Pelita Nusantara. ,” Jurnal Pengabdian Kepada Masyarakat Nusantara, vol. 3, no. 1, pp. 241–251, 2022.
N. , Purnama and N. W. Utami, “Pendampingan Pelatihan Sistem Pencatatan Inventaris Berbasis Android dan Website Pada SDN 1 Tumbakbayuh, Kabupaten Badung,” Jurnal Pengabdian kepada Masyarakat Radisi, vol. 3, no. 1, pp. 16–22, 2023.
F. Effendy, “Pelatihan Penggunaan Sistem Informasi Inventaris bagi petugas Poliklinik dikawasan Pamulang Rangkah Surabaya,” Jati Emas, vol. 5, no. 1, 2021.
M. A. , Yaqin, S. I. , Maghfiroh, N. , A. C. J. , Halizah, and R. F. Sahro, “PKM Pendampingan Penerapan Sistem Inventaris QR Code Dan Pengelolaan Bahan Habis Pakai Di Fakultas Kesehatan Universitas Nurul Jadid.,” Sinar: Sinergi Pengabdian dan Inovasi untuk Masyarakat, , vol. 1, no. 1, pp. 20–29, 2024.
R. , Setiyowati, S. , Sutanto, D. R. S. , Saputro, and P. Widyaningsih, “Pelatihan dan Pendampingan Pembuatan Peta Digital Berbasis Data Spasial di Desa Rejoso Jogonalan Klaten Menggunakan Aplikasi QGIS 3.8. 3. ,” Budimas: Jurnal Pengabdian Masyarakat, , vol. 3, no. 2, pp. 457-464Budimas: Jurnal Pengabdian Masyarakat, 2021.
A. Yandra, “ProKlim: Institutional Data Inventory Assistance at Site Level. ,” Dinamisia: Jurnal Pengabdian Kepada Masyarakat, vol. 7, no. 1, p. 278, 2023.
M. , Rifa’i and F. A. Z. Mukhlisin, “PKM-Barcoding Sistem Bidang Sarana Dan Prasarana Dalam Mewujudkan Administrasi Yang Ideal Di Stebi Bama (Sekolah Tinggi Ekonomi Dan Bisnis Islam Badri Mashduqi Probolinggo),” Bama: Jurnal Pengabdian Masyarakat, vol. 3, no. 2, 2024.
E. , Wahyudi, K. , Kharisma, S. T. , Aldawiyah, and L. Reghita, “Pengembangan sistem informasi pengelolaan inventaris dengan metode agile feature driven development.,” Applied Information Technology and Computer Science (Aicoms), vol. 1, no. 1, pp. 9–15, 2022.
S. , Handayani and W. Choiriyah, “Pengabdian Kepada Masyarakat Penerapan Sistem Informasi Inventarisasi Aset Pada SMK Migas Inovasi Riau,” J-COSCIS: Journal of Computer Science Community Service, , vol. 4, no. 1, pp. 1–7, 2024.
D. L. R. , Tini and N. I. Alfiyah, “Pelatihan Sistem Pengelola Arsip Inventaris (SIPARIN) Dalam Meningkatkan Sistem Administrasi Kependudukan di Desa Ellak Daya Kecamatan Lenteng Kabupaten Sumenep,” Abhakte Jurnal Pengabdian Kepada Masyarakat, , vol. 2, no. 2, pp. 19–30, 2024.
I. , Zulfa, R. , Septima, H. , Syahputra, and M. Saputra, “Sistem Inventarisasi Barang Pada Dinas Kependudukan Dan Catatan Sipil Kabupaten Aceh Tengah . ,” Jurnal Widya Laksmi: Jurnal Pengabdian Kepada Masyarakat, , vol. 3, no. 2, pp. 60–68, 2023.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Purwanto - Purwanto
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright
Authors retain copyright and grant BERDIKARI Jurnal Inovasi dan Penerapan IPTEK the right of first publication with the work simultaneously licensed under an Attribution 4.0 International (CC BY 4.0) that allows others to remix, adapt and build upon the work with an acknowledgment of the work's authorship and of the initial publication in BERDIKARI Jurnal Inovasi dan Penerapan IPTEK.
Authors are permitted to copy and redistribute 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 BERDIKARI Jurnal Inovasi dan Penerapan IPTEK
License
Articles published in the BERDIKARI Jurnal Inovasi dan Penerapan IPTEK) are licensed under an Attribution 4.0 International (CC BY 4.0) license. You are free to:
- Share — copy and redistribute the material in any medium or format.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
This license is acceptable for Free Cultural Works. The licensor cannot revoke these freedoms as long as you follow the license terms. Under the following terms:
- Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
