arrow
Return

Expert Perspectives on Student Errors in SQL

delete2022-12-29
delete6
delete
OA
AI
D
Daphne Miedema *
G
George Fletcher
E
Efthimia Aivaloglou
DOI:10.1145/3551392delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Prior studies in the Computer Science education literature have illustrated that novices make many mistakes in composing SQL queries. Query formulation proves to be difficult for students. Only recently, some headway wasmade towards understanding why SQL leads to somanymistakes, by uncovering studentmisconceptions. In this article, we shed new light on SQL misconceptions by analyzing the hypotheses of SQL experts on the causes of student errors. By examining the experts' perceptions, we draw on their understanding of students' misconceptions and on their experiences with studying and teaching SQL. For our analysis, we chose the Policy Delphi, a questionnaire instrument specifically designed for gathering opinions and evidence. Through a two-round process, our nineteen participants proposed and voted on underlying causes for SQL errors which resulted in a set of hypotheses per error. Our main contribution to this article is this new set of possible misconceptions. With them, we can design more complete educational approaches to address misconceptions underlying SQL errors made by students, leading to more effective SQL education.
Keywords:
Errors
misconceptions
delphi study

Journal

A
ACM Transactions on Quantum Computing
IF:
6.8
Papers:
539
Citations:
508

Organization

L
Leiden University
Scholars:
4.0W
Papers: 3.3W
Citations: 3.8W
E
Eindhoven University of Technology
Scholars:
1.6W
Papers: 1.5W
Citations: 2.2W