Enhancing Feedback Generation for Autograded SQL Statements to Improve Student Learning

• Main Authors: Kleiner, Carsten (Prof. Dr.), Heine, Felix (Prof. Dr.)
• Format: Conference Object
• Language: English
• Published: ACM 2024
• Subjects: Informatikstudium; SQL; Selbststudium; Lernerfolgsmessung; ddc:370; ddc:004; DML
• Online Access: https://serwiss.bib.hs-hannover.de/frontdoor/index/index/docId/3230; http://nbn-resolving.org/urn:nbn:de:bsz:960-opus4-32303; https://nbn-resolving.org/urn:nbn:de:bsz:960-opus4-32303; https://doi.org/10.25968/opus-3230; https://serwiss.bib.hs-hannover.de/files/3230/kleiner_heine2024-autograded_sql.pdf

Several tools to support autograding of student provided SQL statements have already been introduced. The full potential of such tools can only be leveraged, if they extend beyond grading efficiency by also providing tutoring capabilities to the students. With that, tools become really useful by offering self-paced and individually timed learning experiences. In this paper we present an extension for an SQL autograder which improves the hints generated for students in cases where their solution is not entirely correct. Our approach is to compare the student’s solution with the model solution structurally to identify differences between the syntax trees describing the statements. This complements comparing the student’s query with a model solution based on query results. In addition to improving the quality of hints generated for the students, this concept can also be used easily for data manipulation language (DML) or data definition language (DDL) statements, thus extending the applicability of the autograder. Along with details about the concept we present some example hints generated to illustrate the usefulness of the approach. We also report anecdotally on experiences with the system in two different level database courses. Results from different instances of one of them show improvements of student learning as well as student involvement by using the newly generated hints.