Carleton University - School of Computer Science Honours Project
Winter 2020
Automatic SQL Grader
SCS Honours Project Image
ABSTRACT
Grading of SQL (Structured Query Language) assignments submitted by students of the Introductory database courses at Carleton University and likely elsewhere can be a time-consuming task. The results of each submitted query must be compared with the results of the correct model queries and given a mark according to how closely it meets the expected output. An application was developed to take as input a single file or group of files containing one or more SQL commands, compare the results against the model results, calculate a grade, and generate an output file of the grades. The application can be easily distributed and installed to run on the TA’s computer. Parameters allow it to connect to the desired database connection and run the model and student queries against the tables in the database. The grades for each question are then calculated using the F-1 scoring formula and displayed in the interface, with the option to save to a CSV file to be used for distribution of marks. This application will prove to be a useful tool for the TAs for the class, freeing up their valuable time to focus on the learning needs of their students.