Developing a Concept Inventory for Computer Science 2: What should it focus on and what makes it challenging?

Wittie, Lea; Kurdia, Anastasia; Peng, Judy; Kelly, James; Huggard, Meriel

doi:10.1109/fie44824.2020.9273941

Cited by 3 publications

(1 citation statement)

References 18 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Then, for each concept that occurs in the list more than once, they ask their experts to rate them based on importance and student understanding. Specifically in the Computer Science education domain, Delphi has been applied in the works by Goldman et al [15] and Kaczmarczyk et al [20] on memory models and data assignment, the work by Herman on logic [17], the work by Wittie et al on CS2 [49], and the work by Farghally et al on algorithm analysis [13].…”

Section: The Delphi Protocolmentioning

confidence: 99%

Expert Perspectives on Student Errors in SQL

Miedema

Fletcher

Aivaloglou

2022

ACM Trans. Comput. Educ.

View full text Add to dashboard Cite

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 was made towards understanding why SQL leads to so many mistakes, by uncovering student misconceptions. In this paper, 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 in this paper 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.

show abstract