Pendampingan Pembuatan Dan Pengelolaan Data Elektronik Jemaat GKJ Wates
DOI:
https://doi.org/10.21460/servirisma.2021.11.7Keywords:
electronic data management, Excel Macro, Church Parishioners, Data Visualization, DashboardAbstract
Church parishioners data management is an important part of the administration of a church. In fact, many churches do it manually where parishionersal data is stored in physical forms or in church record books. This condition happened at GKJ Wates. The initial condition at GKJ Wates is the data from of a physical form . The data is the result of the census about 2 (two) years ago. It is realized that the data has changed a lot, so it is necessary to update before implementing electronic data management. In an effort to assist the administration of the church's data, assistance steps have been developed that include the compilation of attributes relevant to the church's data management. Furthermore, the attributes are compiled into a form that is ready to be filled out by each parishioners. This agreed form is then distributed to the parishioners through their respective district administrators. The church team, assisted by the UKDW PkM team, recorded the parishioners's data electronically, complete with a spiritual journey scheme including baptism, sidi, and marriage. By utilizing Excel Macro, the electrical data of the GKJ Wates parishioners was successfully visualized in the form of a dashboard. The visualized parishioners data includes the percentage of the parishioners by blood type and gender, the church's spiritual journey scheme based on membership category, membership records, age category, and gender. The information on this dashboard can help the church in making decisions related to the development of the parishioners at GKJ Wates.
References
Adiwijaya, F. F. (2018). Pembangunan Data Mart Untuk Membantu Pengawasan Divisi Pemasaran dan Penjualan Di PT.XYZ. Jurnal Ilmiah Komputer dan Informatika, 1.
Boru, M. (2016, April). Rancang Bangun Sistem Informasi Basis Data GMIT Sion Oepura Berbasis Web. Jurnal MIPA FST UNDANA, Volume 20, Nomor 1, 96-103.
Djamaris, A. (2017). Analisis Data Menggunakan Excel. Universitas Bakrie.
GKJ Wates Setia Dalam Pelayanan. (n.d.). Retrieved Januari 24, 2018, from Watespahpoh: https://watespahpoh.net/2015/sejarah-gkj-wates-setia-dalam-pelayanan.html
Lamalewa, L., & Darsono, T. A. (2018, April). Sistem Informasi Pengolahan Data Jemaat pada Gereja Masehi Advent Hari Ketujuh Wilayah Merauke. Jurnal Ilmiah Mustek Anim Ha Vol. 7 No.1, 35-47.
Manuputty, E. A., Kowey, W. O., & Waelauruw, A. T. (2020, Juni). Pembuatan Aplikasi Pencarian Data Jemaat pada Gereja Protestan Maluku di Amahusu. Jurnal Pengabdian Masyarakat Jamak (Manajemen dan Akuntansi) Vol 03. No. 01, 177-188.
Panduan VBA Excel: Pengenalan Macro VBA Excel Dasar Untuk Pemula #01. (2018, Maret). Retrieved November 23, 2020, from Kelas Excel: https://www.kelasexcel.id/2018/03/belajar-macro-vbaexcel-dasar-untuk-pemula.html
Safi'i, M. F. (2019, Maret 25). Fungsi Microsoft Excel yang Perlu Diketahui, Cocok untuk Perkantoran. Retrieved November 23, 2020, from Liputan 6: https://www.liputan6.com/citizen6/read/3925285/fungsi-microsoft-excel-yang-perludiketahui-cocok-untukperkantoran#:~:
text=Liputan6.com%2C%20Jakarta%20Microsoft%20Excel,menjadi%20bagian%20dari%20Microsoft%20Office
Sagala, D. C., Sadikin, A., & Irawan, B. (2018, Desember). Perancangan Sistem Pengolahan Data Jemaat Berbasis Web pada Gereja Gkpi Kota Jambi. Journal V-Tech (Vision Technology) Volume 1 No. 2, 14-24.
Sinaga, A. S. (2019, April). Implementasi OLAP Menggunakan Dashboard Holistics Software Pada LPPM STMIK Pelita Nusantara. 328.
Subagyo. (2010). Manfaat Fitur "Pivot Table" dari Microsoft Office Excel untuk Pengolahan Data Statistik Perpustakaan. Jurnal Pustakawan Indonesia Volume 10 No. 1.
Zulkarnain, I., & Syahfitri, Y. (2010, Januari). Aplikasi Excel 2007 untuk Perkantoran. Jurnal SAINTIKOM Vol. VIII, No. 1.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2021 Yetli Oslan, Harianto Kristanto, Raden Gunawan Santosa
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish articles in SERVIRISMA agree on the following rules:
1. The author grants non exclusive royalty free rights, and is willing to publish articles online and complete (full access). With such rights SERVIRISMA reserves the right to save, transfers, manages in various forms, maintains and publishes articles while keeping the author's name as the copyright owner.
2. Each author contained in the article has contributed fully to the substance and intellectual, and is accountable to the public. If in the future there is a copyright infringement notification then this will be responsibility of the author, not SERVIRISMA .