A comparative analysis of student SQL and relational database knowledge using automated grading tools

BOISVERT, Charles, DOMDOUZIS, Konstantinos and LICENSE, Joshua (2018). A comparative analysis of student SQL and relational database knowledge using automated grading tools. In: Proceedings of the international symposium on computers in education (SIIE) 2018. IEEE. [Book Section]

Documents
22250:514108
[thumbnail of preprint-comparative-analysis-student SQL and RDB testing.pdf]
Preview
PDF
preprint-comparative-analysis-student SQL and RDB testing.pdf - Accepted Version
Available under License All rights reserved.

Download (488kB) | Preview
Abstract
This paper evaluates a blended learning methodology for Relational Database Systems. Our module offers students a range of interconnected tools and teaching resources. Among them is \testsql, a query tool giving the students automated feedback on SQL query exercises; but we do not use it to assess the students. Instead assessment is through a range of questions which test not only SQL writing skills, but also other aspects of the field, including questions on optimisation, physical modelling, PL/SQL, and indirect questions on SQL knowledge, such as processing order. The effectiveness of the approach is investigated through a survey of student attitudes', and assessment data. Our analysis shows, unsurprisingly, that the students' use of more resources correlates significantly with better results; but also that success at the different sub-topics tested is not at all well correlated, which shows that students can master some topics while remaining weak at others; and finally, that indirect SQL questions is best predictor of success at each of the other sub-topics. This last result confirms our choice to broaden the testing of SQL skills, and has implications for the use automated SQL assessment tools: we recommend that in automated testing for Database Systems, SQL writing tests be complemented with indirect questions on keyword use, parsing, or error recognition aimed at revealing broader abilities of learners.
More Information
Statistics

Downloads

Downloads per month over past year

Metrics

Altmetric Badge

Dimensions Badge

Share
Add to AnyAdd to TwitterAdd to FacebookAdd to LinkedinAdd to PinterestAdd to Email

Actions (login required)

View Item View Item