“There is no ambiguity on what to return”: Investigating the Prevalence of SQL Misconceptions

Daphne Miedema, Michael Liut, George H. L. Fletcher, Efthimia Aivaloglou

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

1 Downloads (Pure)

Abstract

In recent years, database education has been receiving more attention, with research in various directions such as the development of tools for education, the analysis of students’ homework, and the exploration of misconceptions. Misconceptions are mistakes in student reasoning that lead to errors during problem-solving. Recent work has documented misconceptions and errors in SQL. In this study we test the prevalence of several of these misconceptions through a multiple-choice questionnaire, to see if they hold on a larger, more diverse, student population. We found that all misconceptions are held to some extent, with prevalence scores ranging from one to fifty-two percent of the student population. Additionally, we have uncovered previously unidentified areas of struggle, allowing us to identify new misconceptions.
Original languageEnglish
Title of host publicationKoli Calling '23
Subtitle of host publicationProceedings of the 23rd Koli Calling International Conference on Computing Education Research
EditorsA. Mühling, I. Jormanainen
Place of PublicationNew York
PublisherAssociation for Computing Machinery (ACM)
Number of pages12
ISBN (Print)979-8-4007-1653-9
DOIs
Publication statusPublished - 2024
EventKoli Calling '23 - Koli, Finland
Duration: 13 Nov 202318 Nov 2024

Conference

ConferenceKoli Calling '23
Country/TerritoryFinland
CityKoli
Period13/11/2318/11/24

Keywords

  • Information systems
  • Structured Query Language
  • Social and professional topics
  • Computing education

Fingerprint

Dive into the research topics of '“There is no ambiguity on what to return”: Investigating the Prevalence of SQL Misconceptions'. Together they form a unique fingerprint.

Cite this