A Web-based Semi-Automatic Assessment Tool for Formulating Basic SQL Statements: Point-and-Click Interaction Method

Aisha AL-Salmi

2018

Abstract

Learning the Structured Query Language (SQL) is an important step towards developing students' database skills. As such, the number of higher education students learning SQL is constantly increasing. In this context, most researches focus on marking and providing feedback on the final query output rather than on the formulation of the SQL statement clauses. Focusing on statements formulation can assist the examiners in diagnosing the strengths and weaknesses of students’ answers and provide detailed feedback on SQL statements that have been submitted for marking. This paper proposes a new semi-automatic assessment tool called SQL Formulation Editor (SQL-FE) for higher levels of education. The tool allows students to formulate SQL statements using point-and-click interaction method. To ensure the effectiveness of the method; the research has conducted an experiment which compares SQL-FE with the SQL Management Studio (SSMS) tool. The results have provided reasonable evidence that using SQL-FE can have a beneficial effect on formulating SQL query on-time and demonstrated a significant improvement in students’ performance.

Paper Citation

in Harvard Style

AL-Salmi A. (2018). A Web-based Semi-Automatic Assessment Tool for Formulating Basic SQL Statements: Point-and-Click Interaction Method.In Proceedings of the 10th International Conference on Computer Supported Education - Volume 2: CSEDU, ISBN 978-989-758-291-2, pages 191-198. DOI: 10.5220/0006671501910198

in Bibtex Style

@conference{csedu18,
author={Aisha AL-Salmi},
title={A Web-based Semi-Automatic Assessment Tool for Formulating Basic SQL Statements: Point-and-Click Interaction Method},
booktitle={Proceedings of the 10th International Conference on Computer Supported Education - Volume 2: CSEDU,},
year={2018},
pages={191-198},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006671501910198},
isbn={978-989-758-291-2},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 10th International Conference on Computer Supported Education - Volume 2: CSEDU,
TI - A Web-based Semi-Automatic Assessment Tool for Formulating Basic SQL Statements: Point-and-Click Interaction Method
SN - 978-989-758-291-2
AU - AL-Salmi A.
PY - 2018
SP - 191
EP - 198
DO - 10.5220/0006671501910198