LEARN-SQL: Automatic Assessment of SQL Based on IMS QTI Specification

Abelló, Alberto; Rodríguez, M. Elena; Urpí, Toni; Burgués, Xavier; Casany, María José; Martín, Carme; Quer, Carme

doi:10.1109/icalt.2008.27

Cited by 24 publications

(22 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Thus it still requires a lot of manual work as opposed to our software. In [4] the authors sketch a system architecture which seems to include both a (newly designed) tutoring as well as a scoring component. No details on the grading component are explained though since the short article focuses on the overall system architecture.…”

Section: Related Workmentioning

confidence: 99%

Automated grading and tutoring of SQL statements to improve student learning

Kleiner¹,

Tebbe²,

Heine³

2013

Proceedings of the 13th Koli Calling International Conference on Computing Education Research

View full text Add to dashboard Cite

In this paper we present a concept and prototypical implementation of a software system (aSQLg) to automatically assess SQL statements. The software can be used in any introductory database class that teaches students the use of SQL. On one hand it increases the efficiency of grading students submissions of SQL statements for a given problem statement by automatically determining a score for the statement based on different aspects. On the other hand it may also be used to improve student learning of SQL statements by enabling them to continuously (re-)submit their solutions and determine improvements in quality by comparing the automatically determined scores. In order to keep the administrative overhead for using it minimal we have implemented the software in a way that it may be plugged into any course/learning management system with minimal overhead. We have used it in conjunction with WebCAT as well as our own proprietary course management system. Student feedback collected after its first usage in a database class shows promising results for future usage of the system.

show abstract

Section: Related Workmentioning

confidence: 99%

Automated grading and tutoring of SQL statements to improve student learning

Kleiner¹,

Tebbe²,

Heine³

2013

Proceedings of the 13th Koli Calling International Conference on Computing Education Research

View full text Add to dashboard Cite

show abstract

“…Not all workbook exercises can be tested through TestSQL. Some of them require answers about SQL, rather than in SQL; also, TestSQL does not yet support checking DDL statements (this is considered for the future, by embedding queries in pre-test and post-test operations to maintain the test database, as shown by [6]). Finally, the TestSQL architecture does not support control and programming statements.…”

Section: Testsqlmentioning

confidence: 99%

“…Automatic grading of SQL has become common, for example in [3], [7], [6], [4], [8]. It offers multiple advantages: testing the students' skills in a realistic environment; giving rich feedback in the form of debugging information and automated test results; allowing for questions that truly test the students' problem solving abilities.…”

Section: A Study Hypothesismentioning

confidence: 99%

A Comparative Analysis of Student SQL and Relational Database Knowledge Using Automated Grading Tools

Boisvert

Domdouzis

License

2018

2018 International Symposium on Computers in Education (SIIE)

View full text Add to dashboard Cite

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.

show abstract

“…These include visualized algorithm exercises [20,22,23], conceptual database drawings [5], SQL skills [1], and object-oriented designs [16]. English and Siviter [13] use AA in a course where basic technical skills in IT work are taught.…”

Section: Contextualizationmentioning

confidence: 99%

Parsi

Lahtonen

Isomöttönen

2012

Proceedings of the 12th Koli Calling International Conference on Computing Education Research

View full text Add to dashboard Cite

A usual target of automatic assessment in CS education has been a computer program or some other software engineering product. In this paper, we describe the 'PARSI' tool that is used for the automatic assessment of stylistic and technical correctness of office documents and some basic IT skills such as email netiquette and email lists usage. The PARSI tool enables us to run a highly populated course with only one teacher, and investigate how we could make such a course a flexible learning experience where learners take an active role.We contextualize the Parsi tool and our goals in Section 2. Section 3 outlines the course context in which we use the tool. The functional idea and the usage of the Parsi tool are described in Section 4, and our experiences with the tool are summarized in Section 5. Concluding remarks and suggestions for future work are presented in Section 6.

show abstract

LEARN-SQL: Automatic Assessment of SQL Based on IMS QTI Specification

Abstract: In this paper we present LEARN-SQL, a system conforming to the IMS QTI specification that allows on-line learning and assessment of students on SQL skills in an automatic, interactive, informative, scalable and extensible manner.

Cited by 24 publications

References 5 publications

Automated grading and tutoring of SQL statements to improve student learning

Automated grading and tutoring of SQL statements to improve student learning

A Comparative Analysis of Student SQL and Relational Database Knowledge Using Automated Grading Tools

Parsi

Contact Info

Product

Resources

About