Clause-Driven Automated Grading of SQL’s DDL and DML StatementsGlobal
Automated grading systems for SQL courses can significantly reduce instructor workload while ensuring consistency and objectivity in assessment. At our university, an automated SQL grading tool has become essential for evaluating assignments. Initially, we focused on grading Data Query Language (SELECT) statements, which constitute the core content of assignments in our first-year computer science course. SELECT statements produce a results table, which makes automatic grading relatively easy. However, other SQL statements, such as CREATE TABLE, INSERT, DELETE, UPDATE, do not produce a results table. This makes grading these statements more difficult. Recognizing the need to cover broader course material, we have extended our system to evaluate advanced Data Definition Language (DDL) and Data Manipulation Language (DML) statements. In this paper, we describe our approach to automated DDL/DML grading and illustrate our method of clause-driven tailored feedback generation. We explain how our system generates precise, targeted feedback based on specific SQL clauses or components. In addition, we present a practical example to highlight the benefits of our approach. Finally, we benchmark our grading tool against existing systems. Our extended tool can parse and provide feedback on most student SQL submissions. It can consistently provide targeted feedback, generating nearly one suggestion per error. It generates shorter feedback for simpler DML queries, while more complex syntax leads to longer feedback. It has the ability to pinpoint precise SQL errors. Lastly, it can generate precise and actionable suggestions, with each message directly tied to the specific component that caused the error.
Thu 19 FebDisplayed time zone: Central Time (US & Canada) change
13:40 - 15:00 | Rethinking Data Learning: From Databases to DodgeballsPapers at Meeting Room 103-104 Chair(s): Christopher Moretti Princeton University, USA | ||
13:40 20mTalk | Clause-Driven Automated Grading of SQL’s DDL and DML StatementsGlobal Papers Benard Wanjiru Radboud University Nijmegen, Patrick van Bommel Radboud University Nijmegen, Djoerd Hiemstra Radboud University Nijmegen | ||
14:00 20mTalk | Integrating Hands-On Data Collection Experience in an Introductory Programming Class for Non-CS MajorsK12 Papers | ||
14:20 20mTalk | Reflecting on Thematic Analysis in Computer Science Education Research: A Field Guide for Researchers and Reviewers Papers | ||
14:40 20mTalk | SportSense for Data Literacy: Applying Sports and Movement for Authentic and Personal Data Interactions in Elementary SchoolsK12 Papers Ashley Quiterio Northwestern University, Megan Butler Northwestern University, Arianna Montas Northwestern University, Sara Bouftas Northwestern University, Marcelo Worsley Northwestern University | ||