About this paper

Appears in:
Pages: 9443-9448
Publication year: 2017
ISBN: 978-84-697-3777-4
ISSN: 2340-1117
doi: 10.21125/edulearn.2017.0779

Conference name: 9th International Conference on Education and New Learning Technologies
Dates: 3-5 July, 2017
Location: Barcelona, Spain


C. Quer1, A. Abelló1, X. Burgués1, M.J. Casany1, C. Martín1, M.E. Rodríguez2, O. Romero1, T. Urpí1

1Universitat Politècnica de Catalunya (SPAIN)
2Universitat Oberta de Catalunya (SPAIN)
The increase of several forms of e-learning in the last few years (i.e., Massive Open Online Courses) has fostered the emergence of e-assessment systems to support the automatic evaluation of students’ responses to proposed exercises. At the Barcelona School of Informatics (FIB) of Universitat Politècnica de Catalunya-BarcelonaTech the e-assessment is especially relevant due to the profile of the students and the nature of the studies.

In database related courses, students require analytical, creative, and constructive skills that cannot be assessed via multiple-choice tests or equivalent forms of basic assessment techniques. From a technological point of view, this requires more complex e-assessment systems. LearnSQL (Learning Environment for Automatic Rating of Notions of SQL) [1] is a software tool that allows the automatic and efficient e-learning and e-assessment of relational database skills. It has been used at FIB for 18 semesters with an average of 200 students per semester.

LearnSQL encourages learning by providing students with exercises to practice and learn the studied topics. Teachers prepare tests that are to be solved during face-to-face laboratory sessions and other tests that are to be solved at home. At laboratory sessions, the students get used to the learning environment. The students, organized in collaborative teams, solve exercises thanks to the immediate feedback provided after submitting their responses and, if necessary, with the teachers’ advice. Both at laboratory sessions and at home, the students can make as many trials as necessary to solve the exercises.

From the assessment perspective, LearnSQL supports the e-assessment of the students’ learned skills by automatically correcting and grading the students’ responses. The teachers prepare exam tests using LearnSQL. When the students come up with a possible response, they send it to LearnSQL to be assessed. Additionally, the teachers can limit the number of submissions during the exams, and a penalty can be applied in case of several trials. Thus, the resulting grade is an indicator for assessing the students’ learned skills.

The architecture of LearnSQL is composed of four subsystems: the Authoring Tool is used by teachers to create and manage exercises; the Remote Test Module is used by students to solve exercises; the Team Creator Module is used by teachers and students to create teams of students; the Scorer implemented in the form of a web service for assessing exercise responses. The architecture of LearnSQL is compliant with the IMS QTI specification [2], which enables the system automatization, interactivity, informativeness, scalability and extensibility.

The poster would highlight the benefits of the LearnSQL system and show the functionalities of their different subsystems by means of specific and understandable examples.

[1] Alberto Abelló, Xavier Burgués, M. José Casany, Carme Martín, Carme Quer, M. Elena Rodríguez, Oscar Romero, Toni Urpí: A Software Tool for E-Assessment of Relational Database Skills. IJEE. 32, 3(A), 2016.
[2] IMS Global Learning Consortium, IMS Question & Test Interoperability Specification. https://www.imsglobal.org/. Accessed March 2017.
author = {Quer, C. and Abell{\'{o}}, A. and Burgu{\'{e}}s, X. and Casany, M.J. and Mart{\'{i}}n, C. and Rodr{\'{i}}guez, M.E. and Romero, O. and Urp{\'{i}}, T.},
series = {9th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN17 Proceedings},
isbn = {978-84-697-3777-4},
issn = {2340-1117},
doi = {10.21125/edulearn.2017.0779},
url = {http://dx.doi.org/10.21125/edulearn.2017.0779},
publisher = {IATED},
location = {Barcelona, Spain},
month = {3-5 July, 2017},
year = {2017},
pages = {9443-9448}}
AU - C. Quer AU - A. Abelló AU - X. Burgués AU - M.J. Casany AU - C. Martín AU - M.E. Rodríguez AU - O. Romero AU - T. Urpí
SN - 978-84-697-3777-4/2340-1117
DO - 10.21125/edulearn.2017.0779
PY - 2017
Y1 - 3-5 July, 2017
CI - Barcelona, Spain
JO - 9th International Conference on Education and New Learning Technologies
JA - EDULEARN17 Proceedings
SP - 9443
EP - 9448
ER -
C. Quer, A. Abelló, X. Burgués, M.J. Casany, C. Martín, M.E. Rodríguez, O. Romero, T. Urpí (2017) E-ASSESSMENT OF RELATIONAL DATABASE SKILLS BY MEANS OF LEARNSQL, EDULEARN17 Proceedings, pp. 9443-9448.