A software tool for e-assessment of relational database skills

The objective of this paper is to present a software tool for the e-assessment of relational database skills. The tool is referred to as LearnSQL (Learning Environment for Automatic Rating of Notions of SQL). LearnSQL is able to provide automatic feedback, and grade the responses of relational database exercises. It can assess the acquisition of knowledge and practical skills in relational database that are not assessed by other systems. The paper also reports on the impact of using the tool over the past 8 years by 2500 students.

[1]  David Bañeres,et al.  Experiences in Digital Circuit Design Courses: A Self-Study Platform for Learning Support , 2014, IEEE Transactions on Learning Technologies.

[2]  Antonia Huertas.  Ten Years of Computer-Based Tutors for Teaching Logic 2000-2010: Lessons Learned , 2011, TICTTL.

[3]  Herbert Kuchen,et al.  E-assessment of Mathematical Proofs: Chances and Challenges for Students and Tutors , 2008, 2008 International Conference on Computer Science and Software Engineering.

[4]  Norbert Pachler,et al.  Exploring formative e‐assessment: using case stories and design patterns , 2010 .

[5]  Joanna Bull,et al.  Computer-assisted assessment , 2004 .

[6]  Christopher Douce,et al.  Automatic test-based assessment of programming: A review , 2005, JERC.

[7]  Antonija Mitrovic,et al.  An Intelligent SQL Tutor on the Web , 2003, Int. J. Artif. Intell. Educ..

[8]  Caroline F. Timmers,et al.  Motivational beliefs, student effort, and feedback behaviour in computer-based formative assessment , 2013, Comput. Educ..

[9]  Charles E. McDowell,et al.  Pair programming improves student retention, confidence, and program quality , 2006, CACM.

[10]  Carme Quer,et al.  LEARN-SQL: Automatic Assessment of SQL Based on IMS QTI Specification , 2008, 2008 Eighth IEEE International Conference on Advanced Learning Technologies.

[11]  Hazem M. El-Bakry,et al.  Design of Adaptive E-Learning for Logic Operations , 2010 .

[12]  Abdullah Y. Al-Zoubi,et al.  Integration of an online digital logic design lab for it education , 2008, SIGITE '08.

[13]  Tim A. Majchrzak,et al.  Evaluating the Synergies of Integrating E-Assessment and Software Testing , 2011, ISD.

[14]  Bill Houston.  The MIT Guide to Science and Engineering Communication , 1997 .

[15]  Geoffrey T. Crisp.  Interactive e-assessment - Practical approaches to constructing more sophisticated online tasks , 2010 .

[16]  Antonija Mitrovic,et al.  KERMIT: A Constraint-Based Tutor for Database Modeling , 2002, Intelligent Tutoring Systems.

[17]  Erkki Sutinen,et al.  Success Factors for e-Assessment in Computer Science Education , 2008 .

[18]  J. W. Gikandi,et al.  Online formative assessment in higher education: A review of the literature , 2011, Comput. Educ..

[19]  Vic Jenkins,et al.  Getting Started with e-Assessment , 2010 .

[20]  Antonija Mitrovic,et al.  NORMIT: a Web-enabled tutor for database normalization , 2002, International Conference on Computers in Education, 2002. Proceedings..

[21]  Ramón Fabregat,et al.  An Automatic Correction Tool for Relational Algebra Queries , 2007, ICCSA.

[22]  E de Bruyn,et al.  Computer-based testing - the ideal tool to assess on the different levels of Bloom's taxonomy , 2011, 2011 14th International Conference on Interactive Collaborative Learning.

[23]  Zaharije Radivojevic,et al.  ADVICE—Educational System for Teaching Database Courses , 2011, IEEE Transactions on Education.

[24]  Claus Pahl,et al.  Interactive Correction and Recommendation for Computer Language Learning and Training , 2009, IEEE Transactions on Knowledge and Data Engineering.