Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud StudyHonorable Mention
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.
Thu 19 AugDisplayed time zone: Eastern Time (US & Canada) change
14:20 - 15:00 | |||
14:20 10mPaper | Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud StudyHonorable Mention Research Papers A: Daphne Miedema Eindhoven University of Technology, A: Efthimia Aivaloglou University of Leiden, A: George Fletcher Eindhoven University of Technology DOI | ||
14:30 10mPaper | Evaluating Proof Blocks Problems as Exam QuestionsHonorable Mention Research Papers A: Seth Poulsen University of Illinois at Urbana-Champaign, A: Mahesh Viswanathan University of Illinois at Urbana-Champaign, A: Geoffrey Herman University of Illinois at Urbana-Champaign, A: Matthew West University of Illinois at Urbana-Champaign | ||
14:40 10mOther | Roundtables Research Papers | ||
14:50 10mLive Q&A | Q&A Research Papers |