Development and Evaluation of Cloud-Based Virtual Coding Laboratory for SQL Assessment in Database Learning
Keywords:
Automatic Assessment, Cloud Computing, Database Learning, SQL Practicum, Virtual Coding LaboratoryAbstract
This study develops and evaluates a cloud-based Virtual Coding Laboratory to support database learning and SQL practicum activities. The system was designed to address common practicum constraints, including dependency on physical computer laboratories, local database installation, heterogeneous device configurations, delayed assessment, and limited learning activity records. A research and development approach was applied using the ADDIE model, consisting of analysis, design, development, implementation, and evaluation. The product integrates authentication, class management, learning materials, SQL exercises, an online query editor, execution workspace, automatic SQL assessment, feedback, scores, reset database functionality, and submission history. The system was developed using PHP with a separated practice database workspace to isolate student queries from the main application database. Evaluation involved black-box functional testing, expert validation, and practicality testing with two lecturers and 30 students. The functional testing result reached 100%, indicating that all main features worked as expected. Expert validation achieved an overall feasibility score of 90.00%, categorized as very feasible, while practicality testing achieved 87.90%, categorized as very practical. These findings indicate that the proposed Virtual Coding Laboratory is suitable as an integrated, flexible, and browser-based practicum environment for database learning.
References
[1] Y. Aliev, G. Ivanova, and A. Borodzhieva, "Design and research of a virtual laboratory for coding theory," Applied Sciences, vol. 14, no. 20, Art. no. 9546, 2024, doi: 10.3390/app14209546.
[2] M. Garefalakis, Z. Kamarianakis, and S. Panagiotakis, "Towards a supervised remote laboratory platform for teaching microcontroller programming," Information, vol. 15, no. 4, Art. no. 209, 2024, doi: 10.3390/info15040209.
[3] E. Martin-Martin, M. Montenegro, A. Riesco, R. Rubio, and F. Saenz-Perez, "LearnSQL: Impact of an automatic judge in database learning," ACM Transactions on Computing Education, vol. 26, no. 1, Art. no. 3, pp. 1-37, 2026, doi: 10.1145/3769852.
[4] M. Messer, N. C. C. Brown, M. Kolling, and M. Shi, "Automated grading and feedback tools for programming education: A systematic review," ACM Transactions on Computing Education, vol. 24, no. 1, Art. no. 10, pp. 1-43, 2024, doi: 10.1145/3636515.
[5] J. Geetha, D. S. Jayalakshmi, E. Naresh, and N. Sreenivasa, "Lightweight cloud-based solution for digital education and assessment," Science & Technology Libraries, vol. 43, no. 3, pp. 274-286, 2024, doi: 10.1080/0194262X.2023.2247460.
[6] A. Sapriati et al., "The effect of virtual laboratories on improving students' SRL: An umbrella systematic review," Education Sciences, vol. 13, no. 3, Art. no. 222, 2023, doi: 10.3390/educsci13030222.
[7] A. P. Cavalcanti et al., "Automatic feedback in online learning environments: A systematic literature review," Computers and Education: Artificial Intelligence, vol. 2, Art. no. 100027, 2021, doi: 10.1016/j.caeai.2021.100027.
[8] J. Wang, S. Chen, Z. Tang, P. Lin, and Y. Wang, "False positives and deceptive errors in SQL assessment: A large-scale analysis of online judge systems," ACM Transactions on Computing Education, vol. 24, no. 3, Art. no. 30, pp. 1-23, 2024, doi: 10.1145/3654677.
[9] N. Zhang and Y. Liu, "Design and implementation of virtual laboratories for higher education sustainability: A case study of Nankai University," Frontiers in Education, vol. 8, Art. no. 1322263, 2024, doi: 10.3389/feduc.2023.1322263.
[10] R. Elmoazen, M. Saqr, M. Khalil, and B. Wasson, "Learning analytics in virtual laboratories: A systematic literature review of empirical research," Smart Learning Environments, vol. 10, Art. no. 23, 2023, doi: 10.1186/s40561-023-00244-y.
[11] I. Georgakopoulos, D. Piromalis, S. Ntanos, V. Zakopoulos, and P. Makrygiannis, "A prediction model for remote lab courses designed upon the principles of education for sustainable development," Sustainability, vol. 15, no. 6, Art. no. 5473, 2023, doi: 10.3390/su15065473.
[12] M. G. Hahn, S. M. B. Navarro, L. de la Fuente Valentin, and D. Burgos, "A systematic review of the effects of automatic scoring and automatic feedback in educational settings," IEEE Access, vol. 9, pp. 108190-108198, 2021, doi: 10.1109/ACCESS.2021.3100890.
[13] Y. Hou et al., "Post-COVID-19 student and faculty perceptions of online computing labs: Better targeted, better perceptions, but still need improvement," Education Sciences, vol. 14, no. 12, Art. no. 1359, 2024, doi: 10.3390/educsci14121359.
[14] A. Sypsas and D. Kalles, "Analysis, evaluation and reusability of virtual laboratory software based on conceptual modeling and conformance checking," Mathematics, vol. 11, no. 9, Art. no. 2153, 2023, doi: 10.3390/math11092153.
[15] B. Fernandez-Gauna, N. Rojo, and M. Grana, "Automatic feedback and assessment of team-coding assignments in a DevOps context," International Journal of Educational Technology in Higher Education, vol. 20, Art. no. 17, 2023, doi: 10.1186/s41239-023-00386-6.
