Publication Date

Fall 2023

Degree Type

Master's Project

Degree Name

Master of Science in Computer Science (MSCS)

Department

Computer Science

First Advisor

Chris Pollett

Second Advisor

Ben Reed

Third Advisor

Jahan Ghofraniha and Fabio Di Troia

Keywords

Database systems, SQL, Automated evaluation, Immediate feedback

Abstract

In computer science programs, database is a fundamental subject taught through several undergraduate courses. These courses develop theoretical and practical concepts of databases. Building queries is a key aspect of this learning process, and students are assessed through assignments and quizzes. However, grading these assignments can be time-consuming for professors, and students usually receive feedback only after the deadlines have passed. As a result, students may miss the opportunity to improve their work and achieve better grades. To address this issue, it would be beneficial to provide students with immediate feedback on their submissions. EvalSQL is an automated system that allows the evaluation of assignments to provide constructive feedback to students on Canvas after submissions. The feedback is based on the correctness of the query, the state of the database after a query execution, and keyword matching. This would allow them to identify their mistakes and correct them promptly, which can lead to a better learning experience and improved grades. Additionally, professors could benefit from a streamlined evaluation process that allows them to focus on teaching and other tasks.

Download

Share

COinS