The computing education community has studied extensively the errors of novice programmers. In contrast, little attention has been given to student's mistake in writing SQL statements. This paper represents the first large scale quantitative analysis of the student's syntactic mistakes in writing different types of SQL queries. Over 160 thousand snapshots of SQL queries were collected from over 2000 students across eight years. We describe the most common types of syntactic errors that students make. We also describe our development of an automatic classifier with an overall accuracy of 0.78 for predicting student performance in writing SQL queries.
%0 Conference Paper
%1 ahadi2016students
%A Ahadi, Alireza
%A Behbood, Vahid
%A Vihavainen, Arto
%A Prior, Julia
%A Lister, Raymond
%B Proceedings of the 47th ACM Technical Symposium on Computing Science Education
%C New York, NY, USA
%D 2016
%I ACM
%K LearningAnalytics SQL SemanticMistake
%P 401--406
%R 10.1145/2839509.2844640
%T Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and Its Application to Predicting Students' Success
%U http://doi.acm.org/10.1145/2839509.2844640
%X The computing education community has studied extensively the errors of novice programmers. In contrast, little attention has been given to student's mistake in writing SQL statements. This paper represents the first large scale quantitative analysis of the student's syntactic mistakes in writing different types of SQL queries. Over 160 thousand snapshots of SQL queries were collected from over 2000 students across eight years. We describe the most common types of syntactic errors that students make. We also describe our development of an automatic classifier with an overall accuracy of 0.78 for predicting student performance in writing SQL queries.
%@ 978-1-4503-3685-7
@inproceedings{ahadi2016students,
abstract = {The computing education community has studied extensively the errors of novice programmers. In contrast, little attention has been given to student's mistake in writing SQL statements. This paper represents the first large scale quantitative analysis of the student's syntactic mistakes in writing different types of SQL queries. Over 160 thousand snapshots of SQL queries were collected from over 2000 students across eight years. We describe the most common types of syntactic errors that students make. We also describe our development of an automatic classifier with an overall accuracy of 0.78 for predicting student performance in writing SQL queries.},
acmid = {2844640},
added-at = {2016-07-18T03:58:54.000+0200},
address = {New York, NY, USA},
author = {Ahadi, Alireza and Behbood, Vahid and Vihavainen, Arto and Prior, Julia and Lister, Raymond},
biburl = {https://www.bibsonomy.org/bibtex/2dc045ef58cd80b01446ca36623e9ec15/vngudivada},
booktitle = {Proceedings of the 47th ACM Technical Symposium on Computing Science Education},
doi = {10.1145/2839509.2844640},
interhash = {18d829198eaa4bf93be2f8399d958ea0},
intrahash = {dc045ef58cd80b01446ca36623e9ec15},
isbn = {978-1-4503-3685-7},
keywords = {LearningAnalytics SQL SemanticMistake},
location = {Memphis, Tennessee, USA},
numpages = {6},
pages = {401--406},
publisher = {ACM},
series = {SIGCSE '16},
timestamp = {2019-03-25T17:13:22.000+0100},
title = {Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and Its Application to Predicting Students' Success},
url = {http://doi.acm.org/10.1145/2839509.2844640},
year = 2016
}