SQL Murder Mystery: a serious game to learn querying databases

被引：0

作者：

Canale, Lorenzo ^{[1
]}

Farinetti, Laura ^{[1
]}

机构：

[1] Politecn Torino, Turin, Italy

来源：

2022 IEEE 46TH ANNUAL COMPUTERS, SOFTWARE, AND APPLICATIONS CONFERENCE (COMPSAC 2022) | 2022年

关键词：

Edutainment; Serious games; Playful learning; Learning analytics; Educational data mining; BOARD GAME; ERRORS;

D O I：

10.1109/COMPSAC54236.2022.00027

中图分类号：

TP39 [计算机的应用];

学科分类号：

081203 ; 0835 ;

摘要：

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.

引用

页码：129 / 138

页数：10

共 24 条

[1] A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries [J].

Ahadi, Alireza ;

Prior, Julia ;

Behbood, Vahid ;

Lister, Raymond .

ITICSE'15: PROCEEDINGS OF THE 2015 ACM CONFERENCE ON INNOVATION AND TECHNOLOGY IN COMPUTER SCIENCE EDUCATION, 2015, :201-206

[2]

Battistella Paulo Eduardo, 2016, ITEE - IEEE Technology and Engineering Education, V9, P8

[3] Semantic errors in SQL queries: A quite complete list [J].

Brass, Stefan ;

Goldberg, Christian .

JOURNAL OF SYSTEMS AND SOFTWARE, 2006, 79 (05) :630-644

[4] Team-based learning: design, facilitation and participation [J].

Burgess, Annette ;

van Diggele, Christie ;

Roberts, Chris ;

Mellis, Craig .

BMC MEDICAL EDUCATION, 2020, 20 (Suppl 2)

[5] Stereochemistry Game: Creating and Playing a Fun Board Game To Engage Students in Reviewing Stereochemistry Concepts [J].

da Silva Junior, Jose Nunes ;

de Andrade Uchoa, Daniel Esdras ;

Sousa Lima, Mary Anne ;

Monteiro, Andre Jalles .

JOURNAL OF CHEMICAL EDUCATION, 2019, 96 (08) :1680-1685

[6]

Darwesh A, 2016, INT J ENG COMPUTER S, V01

[7] Pedagogy of play [J].

Farné, R .

TOPOI-AN INTERNATIONAL REVIEW OF PHILOSOPHY, 2005, 24 (02) :169-181

[8]

Felicia P., 2011, Handbook of research on improving learning and motivation through educational games: Multidisciplinary approaches, DOI DOI 10.4018/978-1-60960-495-0

[9]

Gros B., 2016, Handb. Res. Serious Games Educ. Appl, P402

[10] Board games in the Computer Science Class to Improve Students' Knowledge of the Java']Java Programming Language: A Lecturer's Perspective [J].

Jordaan, Dawid B. .

ICEMT 2018: PROCEEDINGS OF THE 2018 2ND INTERNATIONAL CONFERENCE ON EDUCATION AND MULTIMEDIA TECHNOLOGY, 2018, :1-4

← 1 2 3 →