Title
Automated grading and tutoring of SQL statements to improve student learning
Abstract
In this paper we present a concept and prototypical implementation of a software system (aSQLg) to automatically assess SQL statements. The software can be used in any introductory database class that teaches students the use of SQL. On one hand it increases the efficiency of grading students submissions of SQL statements for a given problem statement by automatically determining a score for the statement based on different aspects. On the other hand it may also be used to improve student learning of SQL statements by enabling them to continuously (re-)submit their solutions and determine improvements in quality by comparing the automatically determined scores. In order to keep the administrative overhead for using it minimal we have implemented the software in a way that it may be plugged into any course/learning management system with minimal overhead. We have used it in conjunction with WebCAT as well as our own proprietary course management system. Student feedback collected after its first usage in a database class shows promising results for future usage of the system.
Year
DOI
Venue
2013
10.1145/2526968.2526986
Koli Calling
Keywords
Field
DocType
introductory database class,software system,grading students submission,automated grading,own proprietary course management,database class,management system,student learning,minimal overhead,administrative overhead,sql statement,future usage,computer science education,distance learning,sql
SQL,Virtual learning environment,Programming language,Learning Management,Grading (education),Computer science,Software system,Problem statement,Query by Example,Software
Conference
Citations 
PageRank 
References 
4
0.74
12
Authors
3
Name
Order
Citations
PageRank
Carsten Kleiner17321.21
Christopher Tebbe240.74
Felix Heine3185.24