Blogs (2) >>
ICER 2021
Mon 16 - Thu 19 August 2021 ICER 2021 will take place online.
Thu 19 Aug 2021 14:20 - 14:30 at Shrimp - Advanced Topics Chair(s): Kathi Fisler

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 Aug

Displayed time zone: Eastern Time (US & Canada) change

14:20 - 15:00
Advanced TopicsResearch Papers at Shrimp
Chair(s): Kathi Fisler Brown University
14:20
10m
Paper
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
10m
Paper
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
10m
Other
Roundtables
Research Papers

14:50
10m
Live Q&A
Q&A
Research Papers