Rancang Bangun Sistem Informasi Administrasi Santri Pondok Pesantren Darul Musthofa Sangatta dengan Menggunakan Macro VBA Excel
DOI:
https://doi.org/10.31294/justian.v5i2.7406Keywords:
Administration, Islamic Boarding School, VBA ExcelAbstract
The rapid advancement of information technology, particularly Microsoft Excel, facilitates the management of administrative data in educational institutions. Information systems are crucial for enhancing efficiency and effectiveness. The administration at Pondok Pesantren Darul Musthofa Sangatta is conducted manually, resulting in deficiencies such as inaccurate data, difficulties in information retrieval, limitations in student data management, and inefficient operations. The student administration information system is considered a solution to address these challenges. This system facilitates the management of student administrative data for administrators. The system is developed using the waterfall methodology, encompassing phases of requirement analysis, design, coding with VBA Macro in Microsoft Excel, testing, and maintenance. This study has produced a web-based student administration information system at Pondok Pesantren Darul Musthofa Sangatta. The system streamlines the administration of student data within the institution, conserving time, effort, and resources. Furthermore, it allows students and parents/guardians to access administrative information, including monthly payments, re-registration, and remaining funds. The system has been customized to meet the specific requirements of Pondok Pesantren Darul Musthofa Sangatta
References
R. Mahrisa, S. Aniah, H. P. Daulay, and Z. Dahlan, “Pesantren Dan Sejarah Perkembangannya Di Indonesia,” J. Abdi Ilmu, vol. 13, no. 2, p. 34, 2020.
R. Fitri and S. Ondeng, “Pesantren Di Indonesia: Lembaga Pembentukan Karakter,” Al Urwatul Wutsqa Kaji. Pendidik. Islam, vol. 2, no. 1, pp. 42–54, 2022, [Online]. Available: https://journal.unismuh.ac.id/index.php/alurwatul
I. A. Haris, “Pesantren: Karakteristik Dan Unsur-Unsur Kelembagaan,” An-Najah J. Pendidik. Islam dan Sos. Agama, vol. 02, no. 04, pp. 1–9, 2023, [Online]. Available: https://journal.nabest.id/index.php/annajah
M. A. Haris, “Urgensi Digitalisasi Pendidikan Pesantren Di Era Society 5.0 (Peluang Dan Tantangannya Di Pondok Pesantren Al-Amin Indramayu),” Islam. Manag. J. Manaj. Pendidik. Islam, vol. 6, no. 01, pp. 49–64, 2023, doi: 10.30868/im.v4i02.3616.
M. N. Syafaat and M. Sukur, “Rancang Bangun Sistem Informasi Administrasi Santri Di Ponpes Roudlotus Syifa Azzakia Berbasis Web,” INTECOMS J. Inf. Technol. Comput. Sci., vol. 6, no. 2, pp. 780–786, 2023, doi: 10.31539/intecoms.v6i2.6986.
I. S. Akbar and T. Haryanti, “Pengembangan Entity Relationship Diagram Database Toko Online Ira Surabaya,” Comput. Insight J. Comput. Sci., vol. 3, no. 2, pp. 28–35, 2023, doi: 10.30651/comp_insight.v3i2.12002.
Y. Yasri, “Penerapan Visual Basic for Application (VBA) Sebagai Alat Bantu Ajar Enkripsi dan Dekripsi DES,” ComTech Comput. Math. Eng. Appl., vol. 2, no. 1, p. 555, 2011, doi: 10.21512/comtech.v2i1.2805.
A. A. Wahid, “Jurnal Ilmu-ilmu Informatika dan Manajemen STMIK Oktober (2020) Analisis Metode Waterfall Untuk Pengembangan Sistem Informasi,” Ilmu-ilmu Inform. dan ManajemenSTMIK, pp. 1–5, 2020.
Z. Ariza, “Perancangan Sistem Informasi Penilaian Angka Kredit Kenaikan Jabatan Fungsional Atau Pangkat Dosen di Fakultas Tarbiyah Dan Ilmu Keguruan UIN Bukittinggi,” J. Inf. Syst. Educ. Dev., vol. 2, no. 1, pp. 13–19, 2024, doi: 10.62386/jised.v2i1.50.
H. Kurniawan, W. Apriliah, I. Kurnia, and D. Firmansyah, “Penerapan Metode Waterfall Dalam Perancangan Sistem Informasi Penggajian Pada Smk Bina Karya Karawang,” J. Interkom J. Publ. Ilm. Bid. Teknol. Inf. dan Komun., vol. 14, no. 4, pp. 13–23, 2021, doi: 10.35969/interkom.v14i4.78.
N. Sudarsono and R. Sumandani, “Sistem Informasi E-Marketplace ‘Vendorsland’ Bagi Penyedia Event Dan Wedding Organizer (Studi Kasus Wedding Organizer Kota Tasikmalaya),” J. VOI (Voice Informatics), vol. x, No.x, no. x, pp. 1–5, 2020.
A. B. Ameylea, F. F. Kurniawan, B. Suciatmojo, and A. R. Yusuf, “Pemanfaatan Sistem Informasi Berbasis Web Untuk Monitoring Kegiatan Santri Di Tpq Awwalul Huda,” J. Comput. Sci. Inf. Technol., vol. 1, no. 3, pp. 159–170, 2024, doi: 10.59407/jcsit.v1i3.924.
D. K. AM, F. E. Febriansyah, R. Prabowo, and D. Sakethi, “Sistem Informasi Pemberkasan Perkuliahan Berbasis Web Menggunakan Framework Laravel,” J. Komputasi, vol. 7, no. 1, 2019, doi: 10.23960/komputasi.v7i1.2015.
F. C. Amijoyo, K. Santoso, K. J. Yana, and ..., “Pengembangan Aplikasi E-Learning Berbasis Web Menggunakan Model Waterfall Pada Sekolah Menengah Kejuruan,” Sci. Sacra J. …, vol. 3, no. 2, pp. 11–21, 2023, [Online]. Available: http://pijarpemikiran.com/index.php/Scientia/article/view/481
Ilham Tri Maulana, “Penerapan Metode Sdlc ( System Development Life Cycle ) Waterfall Pada E-Commerce Smartphone,” J. Ilm. Sist. Inf. dan Ilmu Komput., vol. 2, no. 2, pp. 1–6, 2022, doi: 10.55606/juisik.v2i2.162.
Y. M. Maulana, “Model Perencanaan Pemodelan Proses Bisnis berdasarkan Business Process Management,” J. Ilm. Media Sisfo, vol. 17, no. 1, pp. 73–85, 2023, doi: 10.33998/mediasisfo.2023.17.1.722.
B. Bambang, J. Lalu Takdir, and N. D. Tialurra Della, “Penggunaan Macro Visual Basic Untuk Penggabungan File dan Pembuatan Ledger,” J. Abdimas Indep., vol. 4, no. 1, pp. 1–8, 2023, doi: 10.29303/independen.v4i1.413.
S. Fatine, “Pemberdayaan Masyarakat Kota Dibidang Ekonomi Melalui Umkm Ladu Arai Pinang Di Lubuk Buaya Kota Padang,” Lamahu J. Pengabdi. Masy. Terintegrasi, vol. 1, no. 2, pp. 78–83, 2022, doi: 10.34312/ljpmt.v1i2.15346.
A. Satria et al., “Mengenal Apa Itu Microsoft Excel,” J. Pengabdi. Kpd. Masy. , vol. 1, no. 4, pp. 237–241, 2023, [Online]. Available: https://jurnalmahasiswa.com/index.php/appa
A. Azzahra, E. E. Rohaeti, and A. Nurjaman, “Media Visual Basic for Application (VBA) Excel dalam meningkatkan kemampuan penalaran dan keaktifan belajar melalui penerapan model problem based learning,” J. Pembelajaran Mat. Inov. Vol., vol. 7, no. 4, pp. 665–674, 2024, doi: 10.22460/jpmi.v7i4.23736.
D. Khoerunisa, F. Amelia, and A. Anita, “Pengelolaan Uang Kas Masjid Dalam Memakmurkan Warga Yang Tidak Mampu,” Pros. Pekan Ilm. Mhs. FKIP UNIS, vol. 1, no. 1, 2021.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Angga Kusumah, Ibrahmi Musa, Marwanto, Aya Estiningtyas, Salsabela Nur Safitri
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
