Preliminary study on SQLearn : Sql Query Learning Tool Using Close Ended Drag and Drop Approach

DOI

10.2991/978-94-6463-106-7_4How to use a DOI?

Keywords

SQL Query; Close Ended; Drag and Drop; Learning

Abstract

Structured Query Language (SQL) is an industry standard for writing query. Writing SQL query is one of main competencies that must be possessed when learning database. Writing an SQL query could be challenging for novice students. SQLearn is a web-based application that give several cases study and questions. Our hypothesis is learning by using SQLearn will improve the stu-dents’s understanding in SQL query. SQLearn uses close ended questions ap-proach. Close ended questions are used to minimize possibility of syntax error. The lecturer will create the open-ended questions with a predefined answers and set of draggable SQL blocks. Student can learn while answer the questions by dragging provided SQL blocks into the correct position, when students finish dragging SQL Blocks, SQLearn will check their answer automatically. Twenty-eight sophomore students from Information Technology department are involved in the experiment. Pre-test and post-test are used to measure students’ understanding before using and after using SQLearn. T-test analysis result shows that there is a significant difference between pre-test and post-test score where the post-test score is overachieved the pre-test score. Based on the early result analysis, a promising result occurred, where the use of SQLearn could improve the students’ test score.

Copyright

© 2022 The Author(s)

Open Access

Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Download article (PDF)

TY  - CONF
AU  - Putra Prima Arhandi
AU  - Annisa Taufika Firdausi
AU  - Banni Satria Andoko
AU  - Muhammad Shulhan Khairy
AU  - Muhammad Ilham Adhim
AU  - Ahmad Afif Supianto
PY  - 2022
DA  - 2022/12/29
TI  - Preliminary study on SQLearn : Sql Query Learning Tool Using Close Ended Drag and Drop Approach
BT  - Proceedings of the 2022 Annual Technology, Applied Science and Engineering Conference (ATASEC 2022)
PB  - Atlantis Press
SP  - 29
EP  - 40
SN  - 2352-5401
UR  - https://doi.org/10.2991/978-94-6463-106-7_4
DO  - 10.2991/978-94-6463-106-7_4
ID  - Arhandi2022
ER  -