Implementation of a Rule-Based Expert System and Weighted Scoring Method in Developing a Student and Alumni Information System for Sustainable Graduate Competency Mapping

Adi Fitrianto; Sahla Rizki  Farhanna

doi:10.63922/ijeter.v4i03.5166

Adi Fitrianto Information System Lecturer at MNC University, Jakarta, Indonesia
Sahla Rizki Farhanna Student at MNC University, Jakarta, Indonesia

DOI: https://doi.org/10.63922/ijeter.v4i03.5166

Keywords: student and alumni information system, rule-based expert system, weighted scoring, SAW, competency mapping, sustainable employability.

Abstract

The management of student activity data scattered across numerous categories and the manual, subjective assessment of graduate competencies make student competency profiles difficult to standardize, compare, and verify. This study develops a Student and Alumni Information System that manages activity data, alumni data, and online CVs while mapping graduate competencies automatically, objectively, and auditably by applying a rule-based expert system and a weighted scoring method based on Simple Additive Weighting (SAW). The system was built using the Laravel 12 framework and a MySQL database with the Prototype development model. The competency engine operates deterministically: verified student activities are normalized, matched against a competency catalog (soft skills through a category matrix and technical skills through keywords), and then scored by multiplying base points with role, level, output, and verification multipliers. The scores are aggregated using a diminishing returns mechanism and enriched with an academic bonus (GPA) to determine competency levels (from Developing to Expert), along with a confidence level and a traceable evidence trail. Testing was carried out using black box testing and validation of the scoring results against student affairs expert judgment. The results show that the system produces consistent and verified competency profiles to support the generation of online CVs and Diploma Supplements (SKPI), thereby supporting sustainable competency development and graduate competitiveness (sustainable employability).

Author Biography

Sahla Rizki Farhanna, Student at MNC University, Jakarta, Indonesia

Student at MNC University, Jakarta, Indonesia

References

Abdillah, T., Dai, R. H., Yunarti, S., & Hadju, R. R. (2023). Perancangan Sistem Informasi Penguatan Kapasitas Mahasiswa, Alumni dan Organisasi Kemahasiswaan Menggunakan Framework Laravel. Digital Transformation Technology (Digitech), 3(2), 336–345. https://doi.org/10.47709/digitech.v3i2.2797
Alimehmeti, G., Fia, M., & Paletta, A. (2024). The sustainability-to-employment pipeline: The impact of SDG-related curricula on graduates’ employability. Studies in Higher Education, 49(12), 2328–2342. https://doi.org/10.1080/03075079.2023.2299328
De Vos, A., Van der Heijden, B. I. J. M., & Akkermans, J. (2020). Sustainable careers: Towards a conceptual model. Journal of Vocational Behavior, 117, 103196. https://doi.org/10.1016/j.jvb.2018.06.011
Fahriza, A. A., & Ujianti, M. H. (2026). Sistem Informasi Penilaian SKPI Berbasis Web di Universitas Teknologi Digital PSDKU Tegal. JATI (Jurnal Mahasiswa Teknik Informatika), 10(3), 4816–4824.
Muzaki, M. S., & Abdillah, N. (2025). Perancangan Sistem Pakar RBES untuk Penilaian Kinerja Guru dan Rekomendasi Kelemahan Menggunakan Aplikasi Kinerja Guru. Kohesi: Jurnal Sains dan Teknologi, 9(5), 21–30.
Nasution, M. N., & Maulana, R. (2024). Pengembangan Aplikasi Sistem Informasi Akademik Berbasis Web Menggunakan Framework Laravel: Studi Kasus di SMK Assalam Depok. Jurnal Informatika Terpadu, 10(2), 156–164. https://doi.org/10.54914/jit.v10i2.1436
Nurhasanah, E. K., Abadi, S., & Sukamto, P. (2020). Sistem Pendukung Keputusan Pemilihan Mahasiswa Berprestasi dengan Metode Simple Additive Weighting. TEKNOSAINS: Jurnal Sains, Teknologi dan Informatika, 7(2), 107–118.
Rahayu, S., & Sindar, A. (2022). Sistem Pendukung Keputusan Penilaian Kinerja Guru Menggunakan Metode Simple Additive Weighting. Jurnal Ilmu Komputer dan Informatika, 2(2), 103–112. https://doi.org/10.54082/jiki.28
Sapitri, J., Vitriani, Y., Haerani, E., & Kurnia, F. (2024). Sistem Pendukung Keputusan untuk Rekomendasi Pemilihan Guru Terbaik Menggunakan Metode Simple Additive Weighting. Indonesian Journal of Innovation Multidisipliner Research, 2(2), 312–330. https://doi.org/10.69693/ijim.v2i2.139
Sihombing, N. N., Aldisa, R. T., & Simatupang, Y. P. (2024). Sistem Pendukung Keputusan Penilaian Kinerja pada Siswa Magang dengan Metode Simple Additive Weighting (SAW). Bulletin of Computer Science Research, 4(2), 155–161. https://doi.org/10.47065/bulletincsr.v4i2.331