Preliminary study on SQLearn : Sql Query Learning Tool Using Close Ended Drag and Drop Approach
Putra Prima Arhandi, Annisa Taufika Firdausi, Banni Satria Andoko, Muhammad Shulhan Khairy, Muhammad Ilham Adhim, Ahmad Afif Supianto · 2022
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 students's understanding in SQL query.SQLearn uses close ended questions approach.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.Twentyeight 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.