Computer assisted assessment of SQL query skills

Dekeyser, Stijn and de Raadt, Michael and Lee, Tien Yu (2007) Computer assisted assessment of SQL query skills. In: 18th Australasian Database Conference (ADC 2007), 29 Jan-2 Feb 2007, Ballarat, Australia.

[img]
Preview
PDF (Published Version)
Dekeyser_DeRaadt_Lee_ADC2007_PV.pdf

Download (352Kb)

Abstract

Structured Query Language (SQL) is the dominant language for querying relational databases today, and is an essential topic in introductory database courses in higher education. Even though the language is syntactically simple, relatively concise, and highly structured, students experience many difficulties while learning to express queries in SQL. In recent years a small number of software tools have been proposed to help students learn to write query statements and to assess their querying skills. In this paper we compare and evaluate existing tools mainly from the perspective of database theory and practice, but also from a pedagogical perspective. Addressing the deficiencies and opportunities uncovered by the evaluation, we then introduce SQLify, a new tool that extends the current state of the art by incorporating semantic feedback, enhanced automatic assessment based on database theory, and peer review to arrive at a richer learning experience for students, as well as consistent assessment results and reduced marking for instructors.


Statistics for USQ ePrint 1180
Statistics for this ePrint Item
Item Type: Conference or Workshop Item (Commonwealth Reporting Category E) (Paper)
Refereed: Yes
Item Status: Live Archive
Additional Information: Deposited in accordance with the copyright policy of the publisher. Copyright c 2007, Australian Computer Society, Inc. This paper appeared at Eighteenth Australasian Database Conference (ADC2007), Ballarat, Australia. Conferences in Research and Practice in Information Technology, Vol. 63. James Bailey and Alan Fekete, Ed. Reproduction for academic, not-for profit purposes permitted provided this text is included.
Depositing User: Dr. Stijn Dekeyser
Faculty / Department / School: Historic - Faculty of Sciences - Department of Maths and Computing
Date Deposited: 11 Oct 2007 00:36
Last Modified: 02 Jul 2013 22:36
Uncontrolled Keywords: computer assisted learning and assessment; SQL; conjunctive queries; query equivalence
Fields of Research (FOR2008): 08 Information and Computing Sciences > 0806 Information Systems > 080602 Computer-Human Interaction
08 Information and Computing Sciences > 0806 Information Systems > 080605 Decision Support and Group Support Systems
13 Education > 1303 Specialist Studies in Education > 130306 Educational Technology and Computing
Socio-Economic Objective (SEO2008): E Expanding Knowledge > 97 Expanding Knowledge > 970113 Expanding Knowledge in Education
URI: http://eprints.usq.edu.au/id/eprint/1180

Actions (login required)

View Item Archive Repository Staff Only