Pengembangan Aplikasi Laporan Bulanan Berbasis VBA Macro Excel di Kantor Urusan Agama Kecamatan Kadudampit-Sukabumi
Abstract
The Office of Religious Affairs is one of the institutions that facilitates the community in managing various needs related to services and administration. At the end of each month KUA must recapitulate data which will then be deposited to the central institution, usually monthly reports are made manually by inputting data one by one and of course it takes quite a long time because it must meet various formats. so it is hoped that the process of managing monthly reports can be carried out more effectively and efficiently. The purpose of this research is to create a software that can assist in the preparation of monthly reports from the KUA Kadudampit District. The method used in making the application is the Agile Software Development method while in making the application using a VBA Macro connected to Ms. Office Excel. The results of the study stated that there is a need for an application system that helps in completing monthly reports to make performance time more effective, therefore the authors create a system that can automate the creation of monthly reports. With the monthly report application, it is expected to reduce the time in the data entry process automatically, speed up the process of filling out various formats, reduce errors in data input and the system can be used repeatedly.
Full Text:
PDFReferences
G. Mayra, “Analisis Pelaksanaan Tugas pokok dan Fungsi (TUPOKSI) Kantor Urusan Agama (KUA) Kecamatan Mandau dalam Melaksanakan Pelayanan dan Bimbingan Kepada Masyarakat,” J. Chem. Inf. Model., vol. 53, no. 9, p. 1689, 2013.
A. P. Nanda, “Analisa Dan Perancangan Sistem Informasi Pengolahan Data Pernikahan Pada Kantor Urusan Agama (Kua),” J. J – Click, vol. 5, no. 1, pp. 85–97, 2018, [Online]. Available: http://ejurnal.jayanusa.ac.id/index.php/J-Click/article/view/70.
David, “Pemanfaatan Macro VBA dalam Perekaman Data Untuk Meningkatkan Keahlian Pranata Komputer,” Sindimas, pp. 128–132, 2019.
D. David, “Peningkatan Keterampilan Penggunaan Macro VBA,” SNPMas Semin. Nas. Pengabdi. pada …, pp. 29–37, 2019. “157152-ID-wawancara-sebagai-salah-satu-metode-peng.pdf.” .
S. Pratasik and I. Rianto, “Pengembangan Aplikasi E-DUK Dalam Pengelolaan SDM Menggunakan Metode Agile Development,” CogITo Smart J., vol. 6, no. 2, p. 204, 2020, doi: 10.31154/cogito.v6i2.267.204-216.
B. P. Rakyat, “Pedoman penyusunan laporan bulanan bank perkreditan rakyat,” no. 15, pp. 2086–2228, 2010.
S. Informasi and S. A. Luhur, “ISSN: 2614-719X Vol. 1, No. 1, April 2019 PENGGUNAAN MICROSOFT OFFICE DI KECAMATAN GABEK,” vol. 1, no. 1, pp. 1–4, 2019.
D. Rahmawati, “Analisis Faktor Faktor yang Berpengaruh Terhadap Pemanfaatan Teknologi Informasi,” J. Ekon. dan Pendidik., vol. 5, no. 1, pp. 107–118, 2012, doi: 10.21831/jep.v5i1.606.
N. Puji Astuti and I. Dharmadiaksa, “Pengaruh Efektivitas Penerapan Sistem Informasi Akuntansi, Pemanfaatan dan Kesesuaian Tugas dengan Teknologi Informasi pada Kinerja Karyawan,” E-Jurnal Akunt., vol. 9, no. 2, pp. 373–384, 2014.
Refbacks
- There are currently no refbacks.
Copyright (c) 2022 Rizki Gunawan
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Publisher: Universitas Pendidikan Indonesia