Naslov
Automatic, configurable, and partial assessment of student SQL queries with subqueries

Autori
Fabijanić, Mario ; Đambić, Goran ; Sasunić, Jan

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), znanstveni

Izvornik
45th Jubilee International Convention on Information, Communication and Electronic Technology, MIPRO 2022 - Proceedings / Skala, Karolj - Opatija : Hrvatska udruga za informacijsku i komunikacijsku tehnologiju, elektroniku i mikroelektroniku - MIPRO, 2022, 606-611

ISBN
978-953-322-412-1

Skup
45th International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO 2022)

Mjesto i datum
Opatija, Hrvatska, 23.05.2022. - 27.05.2022

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
SQL ; assessment ; fully-automated ; partial marks ; configurable assessment process ; subqueries

Sažetak
Universities provide database-related courses, where students demonstrate their acquired knowledge by writing SQL code as a solution to presented problems. Manual assessment of students’ solutions lasts for days and brings up additional problems: inconsistency in grading, students waiting long for their grades, and they get clarification feedback with details only on demand. Also, not a negligible number of teachers’ clarification results in correction of initially obtained points. Many authors research the possibility to create computer systems for fully automated assessments, which would minimize or completely annul listed challenges. The authors propose a novel system for automatic, configurable, and partial assessment of student SQL queries. Initially, it supported only basic SELECT statements but was upgraded later to support also complex joins and groupings. The comparison of new system output and teachers’ manual assessments concluded that the novel, fully automated assessment system is very promising. Now, the authors upgraded the assessment model to support subqueries, which are widely used, and thus, an integral part of database courses and assessments. This paper compares the output of the proposed system with the teachers’ manually provided grades, focused on subqueries. The results of this more comprehensive solution remain promising, even with the new features added.

Izvorni jezik
Engleski

Znanstvena područja
Računarstvo, Informacijske i komunikacijske znanosti

POVEZANOST RADA