Perancangan Aplikasi Pelaporan Akademik Terintegrasi Basis Data Untuk Pendidikan Dasar Dan Menengah
DOI:
https://doi.org/10.61722/jssr.v4i6.12773Keywords:
academic reporting, web-based application, design science research, relational database, data mart, star schema, black-box testingAbstract
Academic reporting requires structured data management to ensure that student information, assessments, grades, attendance, and report-card components can be processed consistently and traced effectively. In the case study of SDN 002 Tarempa, academic data management still involves multiple documents and spreadsheet workbooks, which may lead to repeated data entry, different data versions, and difficulties during the reporting process. This study aims to design and implement a web-based academic reporting application, develop an operational database and dimensional reporting structure, implement academic business rules, and evaluate the functional conformity of the application. The study applies Design Science Research (DSR) as the main research framework, consisting of problem identification, definition of solution objectives, design and development, demonstration, evaluation, and communication. Evolutionary prototyping is used as an iterative mechanism during application development. Data were collected through interviews using structured questions delivered via WhatsApp, document analysis, academic workbook analysis, and literature review. The resulting application was developed using Laravel/PHP with a MariaDB/MySQL database. It supports authentication and role-based access, academic data management, assessments and grades, final grade calculation, learning achievement descriptions, attendance, report finalization and publication, student data import, activity auditing, and PDF report generation. In addition to the operational database, a separate data mart was implemented, consisting of twelve dimension tables, five fact tables, one bridge table, two loading-control tables, and three reporting views. Evaluation results show that all 74 functional requirements included in the tests passed, while three additional requirements have not yet been evaluated through end-to-end testing. Twenty detailed black-box test cases and five calculation-verification samples also produced the expected results. The study is limited to a local environment and does not yet include formal UAT, comprehensive security and load testing, end-to-end ETL testing, or production deployment.
References
Anggraena, Y., Ginanto, D. E., Kesuma, A. T., & Setiyowati, D. (2025). Panduan Pembelajaran dan Asesmen Pendidikan Anak Usia Dini, Jenjang Pendidikan Dasar, Jenjang Pendidikan Menengah: Edisi Revisi Tahun 2025. Jakarta: Badan Standar, Kurikulum, dan Asesmen Pendidikan.
Armaijn, L., Darmayanti, D., Sonia, B., & Rochmat, H. (2024). Peraturan Menteri Pendidikan Dasar dan Menengah Nomor 10 Tahun 2025 tentang Standar Kompetensi Lulusan pada Pendidikan Anak Usia Dini. 2, 306–312.
Ii, B. A. B., Teoretik, A. D., Pembelajaran, H., & Asing, B. (2003). Panduan Pembelajaran dan Asesmen Pendidikan Anak Usia Dini, Jenjang Pendidikan Dasar, Jenjang Pendidikan Menengah. 04(3), 9–47.
Kemendikbud. (2022). Republik Indonesia, Peraturan Menteri Pendidikan, Kebudayaan, Riset, dan Teknologi Nomor 21 Tahun 2022. Kementerian Pendidikan Dan Kebudayaan Riset Dan Teknologi, 9.
Kementerian Pendidikan Dasar dan Menengah Republik Indonesia. (2025a). Peraturan Menteri Pendidikan Dasar dan Menengah Republik Indonesia Nomor 10 Tahun 2025 tentang Standar Kompetensi Lulusan pada Pendidikan Anak Usia Dini, Jenjang Pendidikan Dasar, dan Jenjang Pendidikan Menengah.
Kementerian Pendidikan Dasar dan Menengah Republik Indonesia. (2025b). Peraturan Menteri Pendidikan Dasar dan Menengah Republik Indonesia Nomor 13 Tahun 2025 tentang Perubahan atas Peraturan Menteri Pendidikan, Kebudayaan, Riset, dan Teknologi Nomor 12 Tahun 2024 tentang Kurikulum pada Pendidikan Anak Usia Dini, Jenjang Pend.
Lengkong, J. S. J., Jacobus, S. N. H., Dondokambey, R., Ratumbuisang, K. F., Paath, D., & Liow, E. S. (2023). Web-Based Academic Information Systems in Vocational School. International Journal of Information Technology and Education, 2(4), 12–25. https://doi.org/10.62711/ijite.v2i4.153
Minh Tuan Pham1*, Anh Tuan Hoang2, Anh Tuan Le1, Abdel Rahman M.Said Al-Tawaha3, Van Huong Dong2, V. V. L. (2024). Perubahan atas Peraturan Menteri Pendidikan, Kebudayaan, Riset, dan Teknologi Dan Kurikulum pada Pendidikan Anak Usia Dini, Jenjang Pendidikan Dasar, dan Jenjang Pendidikan Menengah. 2, 306–312.
Muhammad, F., & Sutomo, R. (2024). Implementation of Web-based Student Report Card Score Information Systems in Junior High Schools in Indonesia. SISTEMASI, 13(1), 129. https://doi.org/10.32520/stmsi.v13i1.3431
Sanprasit, N., Titijaroonroj, T., & Kesorn, K. (2021). A semantic approach to automated design and construction of star schemas. Engineering and Applied Science Research, 5, 518–528. https://doi.org/10.14456/easr.2021.54
Sihombing, D. J. C. (2022). Academic Data Warehouse Modeling in Higher Education Using Nine-Step Design Methodology. Journal of Information Systems and Informatics, 4(4), 1126–1134. https://doi.org/10.51519/journalisi.v4i4.399
Wahyudin, W., Wahyudi, H., & Komarudin, K. (2023). Web-Based School Academic Information System Case Study at an MTs School in Bandung. Majalah Bisnis & IPTEK, 16(1), 26–34. https://doi.org/10.55208/rf19hv56
Downloads
Published
Issue
Section
License
Copyright (c) 2026 JOURNAL SAINS STUDENT RESEARCH
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
