e-space
Manchester Metropolitan University's Research Repository

    SQL Tester: An online SQL assessment tool and its impact

    Kleerekoper, AJ and Schofield, A (2018) SQL Tester: An online SQL assessment tool and its impact. In: 23rd Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE 2018), 02 July 2018 - 04 July 2018, Larnaca, Cyprus.

    [img]
    Preview

    Available under License In Copyright.

    Download (1MB) | Preview

    Abstract

    Learning SQL can be surprisingly difficult, given the relative simplicity of its syntax. Automated tools for teaching and assessing SQL have existed for over two decades. Early tools were only designed for teaching and offered increased feedback and personalised learning, but not summative assessment. More recently, however, the trend has turned towards automated assessment, with learning as a side-effect. These tools offer more limited feedback and are not personalised. In this paper, we present SQL Tester, an online assessment tool and an assessment of its impact. We show that students engaged with SQL Tester as a learning tool, taking an average of 10 practice tests each and spending over 4 hours actively engaged in those tests. A student survey also found that over 90% of students agreed that they wanted to keep trying practice tests until they got a “good” mark. Finally, we present some evidence that taking practice tests increased student achievement, with a strong correlation between the number of practice tests a student took and their score on the assessed test.

    Impact and Reach

    Statistics

    Activity Overview
    6 month trend
    557Downloads
    6 month trend
    422Hits

    Additional statistics for this dataset are available via IRStats2.

    Altmetric

    Repository staff only

    Edit record Edit record