CSC/ECE 517 Spring 2022 - S2201: Improving User Experience for SQLFE

About SQLFE

SQL File Evaluation (SQLFE) is an open-source tool that helps in the flexible scoring of multiple SQL queries in multiple submitted files from assignments, lab tests, or other work. It was developed by Prof. Paul Wagner at University Of Wisconsin Eau Claire. This tool has features to support the automated grading of the SQL assignments. It allows partial grading of the question to fairly grade the students and also allows students to provide comments, and multiple solutions to the same problem.

Tasks

The project tasks range over several smaller tasks with a cumulative effort directed towards improving the user experience and setting up better processes.

Task 1

Improve the formatting of the query and feedback output in each individual evaluation output file.

Current Implementation

The evaluation files that are generated have a randomly formatted output which is hard to read and is not user-friendly.

           Unformatted AAA_grade_summary.out file. There is no indentation and unwanted commas are present to the end.

Proposed Output

For a cleaner experience, we are going to remove the commas at the end of the lines. Also, we are going to change the alignment of the lines such that they all are indented in the correct manner.

Similar changes will be done for each student's output file.