Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

D.E. Miedema, Efthimia Aivaloglou, George H.L. Fletcher

Onderzoeksoutput: Hoofdstuk in Boek/Rapport/CongresprocedureConferentiebijdrageAcademicpeer review

1 Citaat (Scopus)

Samenvatting

SQL is the most commonly taught database query language. While previous research has investigated the errors made by novices during SQL query formulation, the underlying causes for these errors have remained unexplored. Understanding the basic misconceptions held by novices which lead to these errors would help improve how we teach query languages to our students. In this paper we aim to identify the misconceptions that might be the causes of documented SQL errors that novices make. To this end, we conducted a qualitative think-aloud study to gather information on the thinking process of university students while solving query formulation problems. With the queries in hand, we analyzed the underlying causes for the errors made by our participants. In this paper we present the identified SQL misconceptions organized into four top-level categories: misconceptions based in previous course knowledge, generalization-based misconceptions, language-based misconceptions, and misconceptions due to an incomplete or incorrect mental model. A deep exploration of misconceptions can uncover gaps in instruction. By drawing attention to these, we aim to improve SQL education.
Originele taal-2Engels
TitelICER 2021: Proceedings of the 17th ACM Conference on International Computing Education Research
Pagina's355-367
Aantal pagina's13
ISBN van elektronische versie9781450383264
DOI's
StatusGepubliceerd - 16 aug 2021
Evenement17th ACM Conference on International Computing Education Research - Virtual Event, Verenigde Staten van Amerika
Duur: 16 aug 202119 aug 2021

Congres

Congres17th ACM Conference on International Computing Education Research
Verkorte titelICER 2021
Land/RegioVerenigde Staten van Amerika
Periode16/08/2119/08/21

Vingerafdruk

Duik in de onderzoeksthema's van 'Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study'. Samen vormen ze een unieke vingerafdruk.

Citeer dit