The backwash effect on SQL skills grading

Prior, Julia; Lister, Raymond

doi:10.1145/1007996.1008008

Cited by 25 publications

(21 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This also extends to using computers in their assessed work ... and are so used to using computers in their student lives that they even expect online assessment to be used.' (Dalmo & Eyre, 2008) In the field of computer science automated assessment has been used in programming courses (Foxley et al, 1999), database courses (Prior & Lister, 2004), introductory courses on Internet skills (English & Siviter, 2000), algorithms and data structures courses (Laakso et al, 2004) and system administration courses (Baumstark & Rudolph, 2013). It has been used for grading a variety of different types of material, including sequence diagrams (Thomas, Smith, & Waugh, 2008), spreadsheets and databases (Kovačić & Green, 2012), programs with graphical user interfaces (English, 2004) and essays (Valenti et al, 2003).…”

Section: Discussionmentioning

confidence: 99%

Experiences of Using Automated Assessment in Computer Science Courses

English¹,

English²

2015

JITE:IIP

View full text Add to dashboard Cite

In this paper we discuss the use of automated assessment in a variety of computer science courses that have been taught at Israel Academic College by the authors. The course assignments were assessed entirely automatically using Checkpoint, a web-based automated assessment framework. The assignments all used free-text questions (where the students type in their own answers). Students were allowed to correct errors based on feedback provided by the system and resubmit their answers. A total of 141 students were surveyed to assess their opinions of this approach, and we analysed their responses. Analysis of the questionnaire showed a low correlation between questions, indicating the statistical independence of the individual questions. As a whole, student feedback on using Checkpoint was very positive, emphasizing the benefits of multiple attempts, impartial marking, and a quick turnaround time for submissions. Many students said that Checkpoint gave them confidence in learning and motivation to practise. Students also said that the detailed feedback that Checkpoint generated when their programs failed helped them understand their mistakes and how to correct them.

show abstract

Section: Discussionmentioning

confidence: 99%

Experiences of Using Automated Assessment in Computer Science Courses

English¹,

English²

2015

JITE:IIP

View full text Add to dashboard Cite

show abstract

“…However, most of those reports focus on the functionality of the tool itself, or on how the system supports a certain pedagogical model [1][2][3][4][5][6]. Those reports do not analyze the data collected by those systems to determine the syntactic errors that students face when writing SQL queries.…”

Section: Related Workmentioning

confidence: 99%

“…We collected our data in an online assessment system, AsseSQL [5,6]. The students in this study were all novice undergraduate students enrolled in an introductory database course at the authors' university.…”

Section: Data Collectionmentioning

confidence: 99%

Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success

Ahadi

Behbood

Vihavainen

et al. 2016

Proceedings of the 47th ACM Technical Symposium on Computing Science Education

Self Cite

View full text Add to dashboard Cite

The computing education community has studied extensively the errors of novice programmers. In contrast, little attention has been given to student's mistake in writing SQL statements. This paper represents the first large scale quantitative analysis of the student's syntactic mistakes in writing different types of SQL queries. Over 160 thousand snapshots of SQL queries were collected from over 2000 students across eight years. We describe the most common types of syntactic errors that students make. We also describe our development of an automatic classifier with an overall accuracy of 0.78 for predicting student performance in writing SQL queries.

show abstract

“…AsseSQL, a tool created by the University of Technology, Sydney also in 2004 [12,13]. SQL-Tutor, described in [11] and developed at the University of Canterbury in Christchurch in 1998.…”

Section: Sql Tutoring and Assessment Systemsmentioning

confidence: 99%

Do students SQLify ? improving learning outcomes with peer review and enhanced computer assisted assessment of querying skills

Raadt

Dekeyser

Lee

2006

Proceedings of the 6th Baltic Sea Conference on Computing Education Research: Koli Calling 2006

View full text Add to dashboard Cite

In recent years a small number of web-based tools have been proposed to help students learn to write SQL query statements and also to assess students' SQL writing skills. SQLify is a new SQL teaching and assessment tool that extends the current stateof-the-art by incorporating peer review and enhanced automatic assessment based on database theory to produce more comprehensive feedback to students. SQLify is intended to yield a richer learning experience for students and reduce marking load for instructors. In this paper SQLify is compared with existing tools and important new features are demonstrated.

show abstract

The backwash effect on SQL skills grading

Cited by 25 publications

References 6 publications

Experiences of Using Automated Assessment in Computer Science Courses

Experiences of Using Automated Assessment in Computer Science Courses

Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success

Do students SQLify ? improving learning outcomes with peer review and enhanced computer assisted assessment of querying skills

Contact Info

Product

Resources

About