Sandra Del-Pozo-Arcos and Antonio Balderas
pp. 156 – 182, download
(https://doi.org/10.55612/s-5002-063-008)
Abstract
This article presents a study that combines a systematic mapping of the use of gamification in SQL learning with a case study conducted in a database course in higher education. The research addresses the convergence between gamification and SQL learning by evaluating and categorizing existing literature and integrating this review with the analysis of a specific implementation of gamification techniques. Various gamification strategies and approaches used in educational settings to facilitate the understanding and mastery of SQL are examined, highlighting effective practices and areas of opportunity. It also identifies emerging trends, challenges and research gaps, providing a comprehensive overview of gamification in database education. This blend of theoretical analysis and case study aims to inform educators, researchers and practitioners about the current state of gamification in SQL learning, and to encourage critical reflection and innovation to improve pedagogical practice in this specific area.
Keywords: SQL, Database; gamification, case study, Systematic Mapping Study.
References
1. Rivera, E. S., Garden, C. L. P.: Gamification for student engagement: a framework. Journal of further and higher education, 45(7), pp. 999-1012 (2021). https://doi.org/10.1080/0309877X.2021.1875201
2. García-López, I. M., Acosta-Gonzaga, E., Ruiz-Ledesma, E. F.: Investigating the impact of gamification on student motivation, engagement, and performance, Education Sciences, 13, pp. 813 (2023). https://doi.org/10.3390/educsci13080813
3. Taipalus, T., Seppänen, V.: SQL education: A systematic mapping study and future research agenda, ACM Transactions on Computing Education (TOCE), 20, pp. 1–33 (2020). https://doi.org/10.1145/3398377
4. Cagliero, L., De Russis, L., Farinetti, L., Montanaro, T.: Improving the effectiveness of SQL learning practice: a data-driven approach, in 2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC), IEEE, pp. 980–989 (2018). https://doi.org/10.1109/COMPSAC.2018.00174
5. Oliveira, W., Hamari, J., Joaquim, S., Toda, A. M., Palomino, P. T., Vassileva, J., Isotani, S.: The effects of personalized gamification on students’ flow experience, motivation, and enjoyment. Smart Learn. Environ. 9, 16 (2022). https://doi.org/10.1186/s40561-022-00194-x
6. Csikszentmihalyi, M.: Applications of flow in human development and education, Springer (2014). https://doi.org/10.1007/978-94-017-9094-9
7. Bovermann, K., Bastiaens, T. J.: Towards a motivational design? Connecting gamification user types and online learning activities, Research and Practice in Technology Enhanced Learning, 15, p. 1 (2020). https://doi.org/10.1186/s41039-019-0121-4
8. Ryan, R.M., Deci, E.L.: Self-Determination Theory. In: Maggino, F. (eds) Encyclopedia of Quality of Life and Well-Being Research. Springer, Cham. (2023). https://doi.org/10.1007/978-3-031-17299-1_2630
9. Werbach, K. & Hunter, D.: For the Win, Revised and Updated Edition: The Power of Gamification and Game Thinking in Business, Education, Government, and Social Impact. Philadelphia: University of Pennsylvania Press. (2020). https://doi.org/10.9783/9781613631041
10. Platz, L.: Learning with serious games in economics education a systematic review of the effectiveness of game-based learning in upper secondary and higher education, International Journal of Educational Research, 115, p. 102031 (2022). https://doi.org/10.1016/j.ijer.2022.102031
11. Talan, T., Doğan, Y., Batdı, V.: Efficiency of digital and non-digital educational games: A comparative meta-analysis and a meta-thematic analysis, Journal of Research on Technology in Education, 52, pp. 474–514 (2020). https://doi.org/10.1080/15391523.2020.1743798
12. Módné Takács, J., Pogátsnik, M., Kersánszki, T.: Improving soft skills and motivation with gamification in engineering education, in International Conference on Interactive Collaborative Learning, Springer, pp. 823–834 (2021). https://doi.org/10.1007/978-3-030-93904-5_81
13. Oliveira, W. et al.: Tailored gamification in education: A literature review and future agenda, Education and Information Technologies, 28, pp. 373–406 (2023). https://doi.org/10.1007/s10639-022-11122-4
14. Costello, R.: Gamification Strategies for Retention, Motivation, and Engagement in Higher Education: Emerging Research and Opportunities: Emerging Research and Opportunities. (2020). https://doi.org/10.4018/978-1-7998-2079-6
15. Capatina, A., Juarez-Varon, D., Micu, A., Micu, A. E.: Leveling up in corporate training: Unveiling the power of gamification to enhance knowledge retention, knowledge sharing, and job performance. Journal of Innovation & Knowledge, 9(3), pp. 100530. (2024). https://doi.org/10.1016/j.jik.2024.100530
16. Rienzo, A., Cubillos, C.: Research of Gamification Techniques and their Application in Digital Games for Older Adults, in 2019 IEEE CHILEAN Conference on Electrical, Electronics Engineering, Information and Communication Technologies (CHILECON), pp. 1-7 (2019). https://doi.org/10.1109/CHILECON47746.2019.8988019
17. Petersen, K., Feldt, R., Mujtaba, S., Mattsson, M.: Systematic mapping studies in software engineering, in 12th International Conference on Evaluation and Assessment in Software Engineering (EASE) 12, pp. 1-10 (2008). https://doi.org/10.14236/ewic/EASE2008.8
18. Wieringa, R., Maiden, N., Mead, N., Rolland, C.: Requirements engineering paper classification and evaluation criteria: a proposal and a discussion, Requirements engineering, 11, pp. 102-107 (2006). https://doi.org/10.1007/s00766-005-0021-6
19. Sardi, L., Idri, A., Fernández-Alemán, J. L.: A systematic review of gamification in e-Health, Journal of biomedical informatics, 71, pp. 31-48 (2017). https://doi.org/10.1016/j.jbi.2017.05.011
20. Balderas, A., Caballero-Hernández, J. A., Dodero, J. M., Palomo-Duarte, M., Ruiz-Rube, I.: Model-driven skills assessment in knowledge management systems, Journal of web engineering, 18, pp. 1-7 (2019). https://doi.org/10.13052/jwe1540-9589.18464
21. García-Peñalvo, F. J.: Transformación digital en las universidades: Implicaciones de la pandemia de la COVID-19, Education in the Knowledge Society (EKS), 22, pp. e25465-e25465 (2021). https://doi.org/10.14201/eks.25465
22. Tahir, F., Mitrovic, A., Sotardi, V.: Investigating the effects of gamifying SQL-Tutor, ICCE 2020 – 28th International Conference on Computers in Education, Proceedings, 1, pp. 416-425 (2020). http://hdl.handle.net/10092/17651
23. Tahir, F., Mitrovic, A., Sotardi, V.: Do Gaming Experience and Prior Knowledge Matter When Learning with a Gamified ITS?, in 2021 International Conference on Advanced Learning Technologies (ICALT), pp. 75-77 (2021). https://doi.org/10.1109/ICALT52272.2021.00030
24. Tahir, F., Mitrovic, A., Sotardi, V.: Investigating the causal relationships between badges and learning outcomes in SQL-Tutor, Research and Practice in Technology Enhanced Learning, 17, pp. 1-23 (2022). https://doi.org/10.1186/s41039-022-00180-4
25. Tuparov, G., Keremedchiev, D.: Assessing students’ SQL knowledge and skills in gamification manner, in 2020 43rd International Convention on Information, Communication and Electronic Technology (MIPRO), pp. 1531-1536 (2020). https://doi.org/10.23919/MIPRO48935.2020.9245179
26. Tuparov, G., Tuparova, D.: Gamification in Higher Education-a Pilot Study with SQL Course., in ERIS, pp. 81-90 (2021). https://ceur-ws.org/Vol-3061/ERIS_2021-art09(reg).pdf
27. Pustulka, E., Krause, K., de Espona, L., Kennel, A.: SQL Scrolls-A Reusable and Extensible DGBL Experiment, in Proceedings of the 10th Computer Science Education Research Conference, pp. 39-48 (2021). https://doi.org/10.1145/3507923.3507932
28. Chen, X., Mitrovic, A., Mathews, M.: Investigating the effect of agency on learning from worked examples, erroneous examples and problem solving, International Journal of Artificial Intelligence in Education, 29, pp. 396-424 (2019). https://doi.org/10.1007/s40593-019-00179-x
29. Langlands, E., Morales-Trujillo, M.: Learning from Errors: An Empirical Study on the Impact of Gamification on SQL Query Formulation, in Proceedings of the 2023 Conference on Innovation and Technology in Computer Science Education V. 1, pp. 341-347 (2023). https://doi.org/10.1145/3587102.3588821
30. Lai, P. P.: Cramming Versus Spaced Learning Induced by Strategic Design of Game-based Learning Platform, in 2022 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE), pp. 608-614 (2022). https://doi.org/10.1109/TALE54877.2022.00105
31. Xinogalos, S., Satratzemi, M.: The Use of Educational Games in Programming Assignments: SQL Island as a Case Study, Applied Sciences, 12, pp. 6563 (2022). https://doi.org/10.3390/app12136563
32. Blanco, R., Trinidad, M., Suárez-Cabal, M. J., Calderón, A., Ruiz, M., Tuya, J.: Can gamification help in software testing education? Findings from an empirical study, Journal of Systems and Software, 200, p. 111647 (2023). https://doi.org/10.1016/j.jss.2023.111647
33. Lupano, M., Farinetti, L., Morreale, D.: OPUS: an Alternate Reality Game to learn SQL at university, in 2021 IEEE 45th Annual Computers, Software, and Applications Conference (COMPSAC), pp. 121-126 (2021). https://doi.org/10.1109/COMPSAC51774.2021.00028
34. Khojah, M.: Studying the impact of a serious game on students learning using Task-Technology Fit Model, (2019). https://aisel.aisnet.org/amcis2019/is_education/is_education/25
35. Soflano, M., Connolly, T. M., Hainey, T.: Learning style analysis in adaptive GBL application to teach SQL, Computers & Education, 86, pp. 105-119 (2015). https://doi.org/10.1016/j.compedu.2015.02.009
36. Soflano, M., Connolly, T. M., Hainey, T.: An application of adaptive games-based learning based on learning style to teach SQL, Computers & Education, 86, pp. 192-211 (2015). https://doi.org/10.1016/j.compedu.2015.03.015
37. Hainey, T., Soflano, M., Connolly, T. M.: A randomised controlled trial to evaluate learning effectiveness using an adaptive serious game to teach SQL at higher education level, in Gamification: Concepts, Methodologies, Tools, and Applications, IGI Global, pp. 1346-1367 (2015). https://doi.org/10.4018/978-1-4666-8200-9.ch068
38. Siepermann, M.: Database Engineering Game, in Games and Learning Alliance: 5th International Conference, GALA 2016, Utrecht, The Netherlands, December 5-7, 2016, Proceedings 5, Springer, pp. 70-79 (2016). https://doi.org/10.1007/978-3-319-50182-6_7
39. Canale, L., Farinetti, L.: SQL Murder Mystery: a serious game to learn querying databases, in 2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC), pp. 129-138 (2022). https://doi.org/10.1109/COMPSAC54236.2022.00027
40. Butgereit, L.: Four NoSQLs in Four Fun Fortnights: Exploring NoSQLs in a Corporate IT Environment, in SAICSIT ’16 Proceedings of the Annual Conference of the South African Institute of Computer Scientists and Information Technologists, (2016). https://doi.org/10.1145/2987491.2987494
41. Morales-Trujillo, M. E., García-Mireles, G. A.: Gamification and SQL: an empirical study on student performance in a database course, ACM Transactions on Computing Education (TOCE), 21, pp. 1-29 (2020). https://doi.org/10.1145/3427597
42. Lai, P. P.: Engaging students in SQL learning by challenging peer during the pandemic, in 2020 IEEE International Conference on Teaching, Assessment, and Learning for Engineering (TALE), pp. 205-212 (2020). https://doi.org/10.1109/TALE48869.2020.9368433
43. Portela, F.: Towards an engaging and gamified online learning environment-A real Case Study, Information, 13, p. 80 (2022). https://doi.org/10.3390/info13020080
44. Pérez-Mercado, R., Balderas, A., Muñoz, A., Cabrera, J. F., Palomo-Duarte, M., Dodero, J. M.: ChatbotSQL: Conversational agent to support relational database query language learning, SoftwareX, 22, p. 101346 (2023). https://doi.org/10.1016/j.softx.2023.101346
45. Somyürek, S., Brusilovsky, P., Çebi, A., Akhüseyinoğlu, K., Güyer, T.: How do students perceive their own and their peers’ progress in e-learning?, The International Journal of Information and Learning Technology, 38, pp. 49-74 (2020). https://doi.org/10.1108/IJILT-05-2020-0073
46. El Agha, M. I., Jarghon, A. M., Abu-Naser, S. S.: SQL tutor for novice students, International Journal of Academic Information Systems Research (IJAISR), 2, (2018). http://ijeais.org/wp-content/uploads/2018/02/IJAISR180201.pdf
47. Oates, B. J., Griffiths, M., McLean, R.: Researching information systems and computing. Sage. (2022).
48. Balderas, A., Baena-Pérez, R., Person, T., Mota, J.M., Ruiz-Rube, I. Chatbot-Based Learning Platform for SQL Training, International Journal of Interactive Multimedia and Artificial Intelligence, vol. 8, no. 6, pp. 135-145. (2024). https://doi.org/10.9781/ijimai.2022.05.003
49. Hansen, R. S.: Benefits and problems with student teams: Suggestions for improving team projects, Journal of Education for business, 82, p. 11 (2006). https://doi.org/10.3200/JOEB.82.1.11-19
50. Rocha, V. M., Delabrida, S. E.: Augmented Reality Applied to Reducing Risks in Work Safety in Electric Substations., in ICEIS (2), pp. 533-540 (2021). https://doi.org/10.5220/0010454805330540
51. Scheffer, S., Martinetti, A., Damgrave, R., Thiede, S., van Dongen, L.: How to make augmented reality a tool for railway maintenance operations: operator 4.0 perspective, Applied Sciences, 11, p. 2656 (2021). https://doi.org/10.3390/app11062656