abstract

MSMI1: Towards a Validated SQL Misconceptions Instrument

Authors:

Daphne Miedema,

Michael Liut,

George Fletcher,

Efthimia AivaloglouAuthors Info & Claims

ICER '23: Proceedings of the 2023 ACM Conference on International Computing Education Research - Volume 2

Pages 16 - 17

https://doi.org/10.1145/3568812.3603471

Published: 13 September 2023 Publication History

Get Access

Abstract

No abstract available.

References

[1]

Alireza Ahadi, Julia Prior, Vahid Behbood, and Raymond Lister. 2015. A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries. In Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education. 201–206.

Digital Library

Google Scholar

[2]

Stefan Brass and Christian Goldberg. 2006. Semantic errors in SQL queries: A quite complete list. Journal of Systems and Software 79, 5 (2006), 630–644.

Digital Library

Google Scholar

[3]

Daphne Miedema, Efthimia Aivaloglou, and George Fletcher. 2021. Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study. In Proceedings of the 17th ACM Conference on International Computing Education Research. 355–367.

Digital Library

Google Scholar

[4]

Kai Presler-Marshall, Sarah Heckman, and Kathryn T Stolee. 2021. SQLRepair: Identifying and Repairing Mistakes in Student-Authored SQL Queries. In 2021 IEEE/ACM 43rd International Conference on Software Engineering: Software Engineering Education and Training (ICSE- SEET). 199–210. https://doi.org/10.1109/ICSE-SEET52601.2021.00030

Digital Library

Google Scholar

[5]

Julia Coleman Prior. 2003. Online Assessment of SQL Query Formulation Skills. In Australasian Computing Education Conference.247–256.

Google Scholar

[6]

Phyllis Reisner. 1986. Measurement of SQL Problems and Progress. Springer-Verlag Tokyo, Nemu-no-sato, Japan, 165–187.

Google Scholar

[7]

Erin Ruel, W Wagner III, and B Gillespie. 2016. The quality of measurement: reliability and validity. The practice of survey research: Theory and applications (2016), 78–100.

Google Scholar

[8]

Lütfi Sürücü and Ahmet MASLAKÇI. 2020. Validity and reliability in quantitative research. Business & Management Studies: An International Journal 8, 3 (2020), 2694–2726.

Google Scholar

[9]

Hamed Taherdoost. 2016. Validity and reliability of the research instrument; how to test the validation of a questionnaire/survey in a research. (2016). https://doi.org/10.2139/ssrn.3205040

Crossref

Google Scholar

[10]

Toni Taipalus. 2020. Explaining Causes behind SQL Query Formulation Errors. Proceedings - Frontiers in Education Conference, FIE 2020-Octob (2020). https://doi.org/10.1109/FIE44824.2020.9274114

Digital Library

Google Scholar

[11]

Toni Taipalus, Mikko Siponen, and Tero Vartiainen. 2018. Errors and Complications in SQL Query Formulation. ACM Transactions on Computing Education 18, 3 (2018).

Digital Library

Google Scholar

Cited By

View all

Sibia NBernuy ATran EXu JWilliams JPetersen ALiut M(2024)Exploring Self-Explanations in a Flipped Database CourseProceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research10.1145/3663649.3664374(20-26)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3663649.3664374
Miedema DLiut MFletcher GAivaloglou E(2023)“There is no ambiguity on what to return”: Investigating the Prevalence of SQL MisconceptionsProceedings of the 23rd Koli Calling International Conference on Computing Education Research10.1145/3631802.3631821(1-12)Online publication date: 13-Nov-2023
https://dl.acm.org/doi/10.1145/3631802.3631821

Recommendations

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study
ICER 2021: Proceedings of the 17th ACM Conference on International Computing Education Research

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 ...
Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)
SQL: The Complete Reference, Second Edition

Comments

Information & Contributors

Information

Published In

ICER '23: Proceedings of the 2023 ACM Conference on International Computing Education Research - Volume 2

August 2023

140 pages

ISBN:9781450399753

DOI:10.1145/3568812

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 13 September 2023

Check for updates

Qualifiers

Abstract
Research
Refereed limited

Conference

ICER 2023

Sponsor:

SIGCSE

ICER 2023: ACM Conference on International Computing Education Research

August 7 - 11, 2023

IL, Chicago, USA

Acceptance Rates

Overall Acceptance Rate 189 of 803 submissions, 24%

Upcoming Conference

ICER 2025

Sponsor:
sigcse

ACM Conference on International Computing Education Research

August 3 - 6, 2025

Charlottesville , VA , USA

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
76
Total Downloads

Downloads (Last 12 months)41
Downloads (Last 6 weeks)3

Reflects downloads up to 03 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Sibia NBernuy ATran EXu JWilliams JPetersen ALiut M(2024)Exploring Self-Explanations in a Flipped Database CourseProceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research10.1145/3663649.3664374(20-26)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3663649.3664374
Miedema DLiut MFletcher GAivaloglou E(2023)“There is no ambiguity on what to return”: Investigating the Prevalence of SQL MisconceptionsProceedings of the 23rd Koli Calling International Conference on Computing Education Research10.1145/3631802.3631821(1-12)Online publication date: 13-Nov-2023
https://dl.acm.org/doi/10.1145/3631802.3631821

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

HTML Format

View this article in HTML Format.

HTML Format

Abstract

References

Cited By

Recommendations

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)

SQL: The Complete Reference, Second Edition

Comments

Information

Published In

Sponsors

Publisher

Publication History

Check for updates

Qualifiers

Conference

Acceptance Rates

Upcoming Conference

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

HTML Format

Share

Share this Publication link

Share on social media

Affiliations