Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : International Journal Software Engineering and Computer Science (IJSECS)

Development of a Web-Based SQL Query Online Examination System with Automated Grading Using the MVC Design Pattern Yunhasnawa, Yoppy; Windawati, Atif; Cinderatama, Toga Aldila; Vista, Candra Bella; Abdullah, Moch. Zawaruddin
International Journal Software Engineering and Computer Science (IJSECS) Vol. 4 No. 3 (2024): DECEMBER 2024
Publisher : Lembaga Komunitas Informasi Teknologi Aceh (KITA)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/ijsecs.v4i3.3285

Abstract

In this study, the Researchers provide the design, development, and evaluation of a web-based SQL exam system that utilizes the Model-View-Controller (MVC) architectural pattern to enhance automated grading functionality and ease of maintenance. The main objectives of the system are to simplify the process of administering SQL exams, to make it user-friendly for students to enter their SQL statements, and as a means for teachers to automate the grading process. This allows a clear separation between three separate modules: Model to manage data, View to present the application to users, and Controller to manage the application logic. This separation allows for modular development, easier maintenance, and code reuse. The fundamental aspect of the system lies in its automated grading mechanism, which intelligently compares the SQL queries submitted by students with the corresponding validated answer keys stored in the database. Extensive black-box testing was conducted to ensure the reliability and accuracy of the system with various test cases to assess its ability to assess responses and provide real-time feedback to students, in addition to smooth and intuitive navigation within the system. All testing criteria yielded successful results with 100% agreement proving the robustness of the system with all possible locations that could potentially be used in higher education structures. The system provides a scalable and flexible approach to address the challenges associated with SQL assessment in academic institutions, thereby facilitating uniform, efficient, and objective evaluation standards. The system uses data up to October 2023 to prevent the model from becoming obsolete
Co-Authors Adi Atmoko Afifah Millatina Nugraheni Agustaf Fanisnaini Narolis Allam, Muhammad Faiq Amalia, Astrifidha Rahma Andarini, Dyah Kartika Dwi Anindya Refrina Rahmatanti Aprilianto, Salies Ardiansyah, Muhammad Rizqi Ariadi Retno Tri Hayati Ririd Arifin, Muh. Syamsul Arwin Datumaya Wahyudi Sumari Ashafidz Fauzan Dianta Astiningrum, Mungki Atiqah Nurul Asri Aulia Zahra Musthafawi Ayundha Wulan Kurniawati Bagas Satya Dian Nugraha Buata, Yusliana Gadis Budiprasetyo, Gunawan Candra Bella Vista Deddy Kusbianto Purwoko Aji Devianti, Meryta Dewi, Isyana Wikrama Dharma Tungga Dika Rizky Yunianto Dwi Puspitasari Dyah Kartika Dwi Andarini Eka Larasati Amalia Elok Nur Hamdana Faisal Rahutomo Fanani, Muhamad Zainul Gunawan Budiprasetyo Hakim, Muhammad Ilham El Hamdani Arif Hamzah, Rahmandi Hendrawan, Muhammad Afif Himawan, Dhimas Arbi Sukma Imam Fahrur Rozi Kenneth Pinandhito Kurniawati, Ayundha Wulan Mamluatul Hani’ah Maskur Maskur Mauliwidya Mauliwidya Mauliwidya Misbahudin Moch Zawaruddin Abdullah Moch. Sholeh, Moch. Muhamad Zainul Fanani Muhammad Rifky Prayanta Muhammad Unggul Pamenang Muhammad Unggul Pamenang Permatasari, Twisty Henras Prasetyo, Junaedi Adi Purnomo, Fadjar Rahmandi Hamzah Ridwan Rismanto Rinanza Zulmy Alhamri, Rinanza Zulmy Rokhimatul Wakhidah Rudy Ariyanto Rudy Ariyanto Sofian Efendi, Fery Toga Aldila Cinderatama Trisha Alfandi Twisty Henras Permatasari Ulla Delfana Rosiani Viyus, Vinan Wahyu Devi Nur Hamidah Devi Windawati, Atif Yan Watequlis Syaifudin Yuri Arianto Yuri Ariyanto Yuri Ariyanto Yuri Ariyanto Yusliana Gadis Buata Zulmy Alhamri, Rinanza