loading
Documents

Research.Publish.Connect.

Paper

Author: Aisha AL-Salmi

Affiliation: Loughborough University, United Kingdom

ISBN: 978-989-758-291-2

Keyword(s): Semi-Automated, Learning, Assessment, Online, SQL.

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. (More)

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.161.77.30

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.