Proceedings of the 2022 Annual Technology, Applied Science and Engineering Conference (ATASEC 2022)

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

Authors
Putra Prima Arhandi1, *, Annisa Taufika Firdausi1, Banni Satria Andoko1, Muhammad Shulhan Khairy1, Muhammad Ilham Adhim1, Ahmad Afif Supianto2, 3
1State Polytechnic of Malang, Malang, 65141, Indonesia
2National Research and Innovation Agency (BRIN), Central Jakarta, 10340, Indonesia
3Norwegian University of Science and Technology, Ålesund, 6025, Norway
*Corresponding author. Email: putraprima@polinema.ac.id
Corresponding Author
Putra Prima Arhandi
Available Online 29 December 2022.
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)

Volume Title
Proceedings of the 2022 Annual Technology, Applied Science and Engineering Conference (ATASEC 2022)
Series
Advances in Engineering Research
Publication Date
29 December 2022
ISBN
978-94-6463-106-7
ISSN
2352-5401
DOI
10.2991/978-94-6463-106-7_4How to use a DOI?
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.

Cite this article

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  -