2015 IEEE 31st International Conference on Data Engineering (ICDE) (2015)
Seoul, South Korea
April 13, 2015 to April 17, 2015
Amol Bhangdiya , IIT Bombay, India
Bikash Chandra , IIT Bombay, India
Biplab Kar , IIT Bombay, India
Bharath Radhakrishnan , IIT Bombay, India
K. V. Maheshwara Reddy , IIT Bombay, India
Shetal Shah , IIT Bombay, India
S. Sudarshan , IIT Bombay, India
Grading of student SQL queries is usually done by executing the query on sample datasets (which may be unable to catch many errors) and/or by manually comparing/checking a student query with the correct query (which can be tedious and error prone). In this demonstration we present the XDa-TA system which can be used by instructors and TAs for grading SQL query assignments automatically. Given one or more correct queries for an SQL assignment, the tool uses the XData system to automatically generate datasets that are designed specifically to catch common errors. The grading is then done by comparing the results of student queries with those of the correct queries against these generated datasets; instructors can optionally provide additional datasets for testing. The tool can also be used in a learning mode by students, where it can provide immediate feedback with hints explaining possible reasons for erroneous output. This tool could be of great value to instructors particularly, to instructors of MOOCs.
Testing, Linear systems, Manuals, Remuneration, Database systems, Syntactics
A. Bhangdiya et al., "The XDa-TA system for automated grading of SQL query assignments," 2015 IEEE 31st International Conference on Data Engineering (ICDE), Seoul, South Korea, 2015, pp. 1468-1471.