Serious Game Adventure for Learning Data Exploration Skills

  1. Palomo-Duarte, Manuel 1
  2. Caballero-Hernández, Juan Antonio 1
  3. Díaz-Brotons, Francisco 1
  4. Balderas, Antonio 1
  5. Ortega, Jose Antonio 1
  6. Dodero, Juan Manuel 1
  1. 1 Computer Science Department, University of Cadiz, Cadiz, Spain
Book:
Innovation and Technologies for the Digital Transformation of Education

ISSN: 2196-4963,  2196-4971

ISBN: 9789819724673,  9789819724680

Year of publication: 2024

Pages: 133-142

Type: Book chapter

DOI: 10.1007/978-981-97-2468-0_13 GOOGLE SCHOLAR lock_openOpen access editor

Abstract

SQL stands as a potent yet straightforward language for querying Relational Databases, extensively used in software development and data exploration. However, students often encounter frustration after the initial ease of learning SQL due to its profound intricacies. We present CSE-Investigaciones: a serious game presented in an adventurous format designed to facilitate the acquisition of SQL language skills. Players face various challenges requiring the construction of SQL queries using a graphical interface. The game is built through an architecture composed of a video game interface, a game engine, and a database system. The queries are executed on a database server, providing players with feedback on their progress. We detail the system architecture and a conducted case study. The feedback collected through a Likert-scale test and an open questionnaire reflects positive outcomes.

Bibliographic References

  • Abt, C. (1970). Serious games: The art and science of games that simulate life. Viking Press.
  • Balderas, A., Berns, A., Palomo-Duarte, M., Dodero, J. M., & Ruiz-Rube, I. (2017). Retrieving objective indicators from student logs in virtual worlds. Journal of Information Technology Research, 10, 69–83.
  • Balderas, A., Baena-Pérez, R., Person, T., Mota, J. M., & Ruiz-Rube, I. (2022). Chatbot-based learning platform for SQL training. International Journal of Interactive Multimedia and Artificial Intelligence. https://doi.org/10.9781/ijimai.2022.05.003
  • Beaulieu, A. (2020). Learning SQL: Generate, manipulate, and retrieve data (3rd ed.). O’Reilly Media, Incorporated, Sebastopol.
  • Boyle, E. A., Hainey, T., Connolly, T. M., Gray, G., Earp, J., Ott, M., Lim, T., Ninaus, M., Ribeiro, C., & Pereira, J. (2016). An update to the systematic literature review of empirical evidence of the impacts and outcomes of computer games and serious games. Computers and Education, 94, 178–192. https://doi.org/10.1016/j.compedu.2015.11.003
  • Caballero-Hernández, J. A., Palomo-Duarte, M., & Dodero, J. M. (2017). Skill assessment in learning experiences based on serious games: A systematic mapping study. Computers & Education, 113, 42–60.
  • Canale, L., & Farinetti, L. (2022). SQL Murder Mystery: a serious game to learn querying databases. In 2022 IEEE 46th Annual Computers, Software, and Applications Conference (COMPSAC), 129–138. https://doi.org/10.1109/COMPSAC54236.2022.00027
  • Carrillo Chaves, F. (2018). Informe asignaturas de bases de datos en estudios de grado en ingeniería informática en universidades españolas. http://hdl.handle.net/10498/20657
  • Egenfeldt-Nielsen, S., Smith, J. H., & Tosca, S. P. (2019). Understanding video games. Routledge. https://doi.org/10.4324/9780429431791
  • Ferrer, J., Ringer, A., Saville, K., A Parris, M., & Kashi, K. (2022). Students’ motivation and engagement in higher education: the importance of attitude to online learning. Higher Education, 83(2), 317–338. https://doi.org/10.1007/s10734-020-00657-5
  • Heilporn, G., Lakhal, S., & Bélisle, M. (2021). An examination of teachers’ strategies to foster student engagement in blended learning in higher education. International Journal of Educational Technology in Higher Education, 18(1), 25. https://doi.org/10.1186/s41239-021-00260-3
  • ACM & IEEE. (2016). Computer Engineering Curricula 2016. https://www.acm.org/education/curricula-recommendations
  • Khan, W., Kumar, T., Zhang, C., Raj, K., Roy, A. M., & Luo, B. (2023). SQL and NoSQL database software architecture performance analysis and assessment—a systematic literature review. Big Data and Cognitive Computing, 7(2). https://doi.org/10.3390/bdcc7020097
  • Kleiner, C. (2010). LeReSpo: Using Game Software in Database Education on all Levels. In 8th International workshop (p. 10).
  • Michael, D. R., & Chen, S. L. (2006). Serious Games: Games that educate, train, and inform. Thomson Course Technology.
  • Mitrovic, A. (1998). A knowledge-based teaching system for SQL. In Proceedings of ED-MEDIA (Vol. 98, pp. 1027–1032).
  • Murillo, J. V., Chavarría, S. B., & Rivera, S. M. (2012). Herramienta asistida por computadora para la enseñanza del álgebra relacional en bases de datos. Uniciencia, 26, 179–195.
  • Pal, S. (2016). Why SQL on big data? In SQL on big data. Apress. https://doi.org/10.1007/978-1-4842-2247-8_1
  • Palomo-Duarte, Baena-Pérez, R., M. Balderas, A., Caballero-Hernández, J. A., Muñoz A., & Dodero, J. M. (2023) Uso de modelo grande de lenguaje en un curso de base de datos: una visión vía TAM. In Proceedings of the XXV international symposium on computers in education. http://hdl.handle.net/10498/29629
  • Palomo-Duarte, M. Balderas, A., Díaz-Brotons, F., Ortega-Pérez J. A., & Dodero, J. M. (2021) Diseño de una videoaventura para el aprendizaje de lenguaje SQL. In Proceedings of the XXIII international symposium on computers in education. http://hdl.handle.net/10498/25616
  • Renaud, K., & Van Biljon, J. (2004). Teaching SQL—Which pedagogical horse for this course? In British National Conference on Databases (pp. 244–256). Springer.
  • Schildgen, J. (2014). SQL island: An adventure game to learn the database language SQL. In Proceedings of the 8th European conference on games based learning (pp. 137–138).
  • Schmidt, R., Emmerich, K., & Schmidt, B. (2015). Applied games—In search of a new definition. In Konstantinos Chorianopoulos, Monica Divitini, L. J. Jannicke Baalsrud Hauge, & Rainer Malaka (Eds.), 14th International Conference in Entertainment Computing—ICEC (pp. 100–111). Springer International Publishing. https://doi.org/10.1007/978-3-319-24589-8_8
  • Soflano, M., Connolly, T. M., & Hainey, T. (2015). An application of adaptive games-based learning based on learning style to teach SQL. Computers & Education, 86, 192–211.
  • Zyda, M. (2005). From visual simulation to virtual reality to games. Computer, 38(9), 25–32. https://doi.org/10.1109/MC.2005.297