Expert Perspectives on Student Errors in SQL

Autor/inn/en	Miedema, Daphne; Fletcher, George; Aivaloglou, Efthimia
Titel	Expert Perspectives on Student Errors in SQL
Quelle	In: ACM Transactions on Computing Education, 23 (2023) 1, Artikel 11 (28 Seiten)Infoseite zur Zeitschrift PDF als Volltext Verfügbarkeit
Zusatzinformation	ORCID (Miedema, Daphne) ORCID (Fletcher, George) ORCID (Aivaloglou, Efthimia)
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
Schlagwörter	Computer Science Education; Novices; Misconceptions; Programming Languages; Error Patterns; Delphi Technique; Teacher Attitudes; College Students; Foreign Countries; Belgium; Chile; France; Germany; Netherlands; Poland; Singapore; United Kingdom; United States + Suchen Sie Ihr Suchwort? Computer science lessons; Informatikunterricht; Missverständnis; Fehlertyp; Delphi-Methode; Lehrerverhalten; Collegestudent; Ausland; Belgien; Frankreich; Deutschland; Niederlande; Polen; Singapur; Großbritannien; USA
Abstract	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 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. (As Provided).
Anmerkungen	Association for Computing Machinery. 2 Penn Plaza Suite 701, New York, NY 10121. Tel: 800-342-6626; Tel: 212-626-0500; Fax: 212-944-1318; e-mail: acmhelp@acm.org; Web site: http://toce.acm.org/
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2024/1/01