What is serious? What is funny? Who is a player? Who is a student? But, most importantly, who is the murderer? Serious games are gaining an ever increasing interest in education and training, and recent studies have used board games as inspirational. This study introduces SQL Murder Mystery, a serious game inspired by the popular board game Cluedo. This game has been designed to assess students' SQL skills and has been tested in a university database management system course during a lab session in which students played in teams. Query logs were examined to explore the behavioural patterns of the teams, by distinguishing different categories of queries: exploratory, focused, review queries, and to relate behaviour with specific SQL learning goals. The analysis revealed that success in the game and fulfilment of SQL learning goals are correlated. In addition, the game helped the instructors to identify the major knowledge gaps of the students, to allow on-time recovery.

SQL Murder Mystery: a serious game to learn querying databases / Canale, Lorenzo; Farinetti, Laura. - (2022), pp. 129-138. ((Intervento presentato al convegno IEEE Annual International Computer Software and Applications Conference (COMPSAC) nel 27 June 2022 - 01 July 2022 [10.1109/COMPSAC54236.2022.00027].

SQL Murder Mystery: a serious game to learn querying databases

Canale, Lorenzo;Farinetti, Laura
2022

Abstract

What is serious? What is funny? Who is a player? Who is a student? But, most importantly, who is the murderer? Serious games are gaining an ever increasing interest in education and training, and recent studies have used board games as inspirational. This study introduces SQL Murder Mystery, a serious game inspired by the popular board game Cluedo. This game has been designed to assess students' SQL skills and has been tested in a university database management system course during a lab session in which students played in teams. Query logs were examined to explore the behavioural patterns of the teams, by distinguishing different categories of queries: exploratory, focused, review queries, and to relate behaviour with specific SQL learning goals. The analysis revealed that success in the game and fulfilment of SQL learning goals are correlated. In addition, the game helped the instructors to identify the major knowledge gaps of the students, to allow on-time recovery.
978-1-6654-8810-5
File in questo prodotto:
File Dimensione Formato  
SQL_Murder_Mystery_a_serious_game_to_learn_querying_databases.pdf

non disponibili

Tipologia: 2a Post-print versione editoriale / Version of Record
Licenza: Non Pubblico - Accesso privato/ristretto
Dimensione 2.07 MB
Formato Adobe PDF
2.07 MB Adobe PDF   Visualizza/Apri   Richiedi una copia
Pubblicazioni consigliate

Caricamento pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11583/2971016