Pendampingan Pembuatan Dan Pengelolaan Data Elektronik Jemaat GKJ Wates

Authors

  • (*) Yetli Oslan,  Program Studi Sistem Informasi, Universitas Kristen Duta Wacana
  • Harianto Kristanto,  Program Studi Sistem Informasi, Universitas Kristen Duta Wacana
  • Raden Gunawan Santosa,  Program Studi Informatika, Universitas Kristen Duta Wacana

(*) Corresponding Author

DOI:

https://doi.org/10.21460/servirisma.2021.11.7

Keywords:

electronic data management, Excel Macro, Church Parishioners, Data Visualization, Dashboard

Abstract

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.

Published

2021-11-30

How to Cite

Oslan, Y. ., Kristanto, H. ., & Santosa, R. G. . (2021). Pendampingan Pembuatan Dan Pengelolaan Data Elektronik Jemaat GKJ Wates. Servirisma, 1(1), 73–82. https://doi.org/10.21460/servirisma.2021.11.7