Automated grading and tutoring of SQL statements to improve student learning

  • Authors:

  • Carsten Kleiner;Christopher Tebbe;Felix Heine

  • Affiliations:

  • University of Applied Sciences&Arts, Hannover, Germany;University of Applied Sciences&Arts, Hannover, Germany;University of Applied Sciences&Arts, Hannover, Germany

  • Venue:
  • Proceedings of the 13th Koli Calling International Conference on Computing Education Research
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

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.