The Development of SQL Language Skills in Data Definition and Data Manipulation Languages Using Exercises with Quizizz for Students' Learning Engagement

Ratchadaporn Amornchewin

Abstract

The exercise is one of the educational activities that help students to understand and achieve their learning goals. Quizizz is a great online tool which helps students to check their knowledge and learning progress. In this paper, the researcher applied the SQL (Structured Query Language) skill in data definition language (DDL) and data manipulation language (DML) exercises and engaged the student’s learning by using Quizizz on students’ Introduction to Database course. The exercises and Quizizz were employed to an experimental group and a conventional teaching method was used for the control groups. The groups of students were of the heterogeneous level. Using the DDL and DML exercises, the students can review the knowledge repeatedly by doing exercises. In addition, the student can learn something from doing quizzes via Quizizz. The study on SQL exercises were conducted in order to improve students' achievement in DDL and DML. The purposes of this research were to 1) compare the students’ pre-test and post-test achievement using Quizizz and 2) investigate the students’ satisfaction while using SQL language skill exercises and Quizizz. The sample consisted of 34 students who enrolled in an Introduction to Database course in semester 1 of the academic year 2017. The students applied SQL language skill exercises when working on SQL assignment statement syntax. The students' pre-tests and post-tests were assessed. Percentage, mean and standard deviation, and average score (t-test) were used to analyze the data. The result showed that the students’ scores from the post-test was higher than the pre-test. There was a statistical significance at the level of 0.05. According to the result, it indicated that the students’ achievement was improved by the implementation. The students' satisfaction with the SQL language skill exercises and Quizizz was at a highest level (X = 4.58, S.D. = 0.54).

Full Text:

PDF

References

Kearns, R., Shead, S., and Fekete, A. (1997). A Teaching System for SQL. Australasian Computer Science Education Conference. ACM Press, Australia.

Silva, Y.N., Almeida, I., Queiroz, M. (2016). SQL: From Traditional Database to Big Data. Special Interest Group on Computer Science Education 2016 (SIGCSE '16). Memphis, TN, USA.

Thorndike, E. L. (1898). Animal Intelligence: an Experimental Study of the Associative Processes in Animals. The Psychological Review: Monograph Supplements. 2(4): i-109.

Sadiq, S., Orlowska, M., Sadiq, W., & Lin, J. (2004). Sqlator: An online SQL learning workbench. Proceedings of the 9th Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE 2004). Leeds, UK.

Cembalo, M., Santis, D.A., & Petrillo, F.U. (2011). Savi: A new system for advanced SQL visualization. Special Interest Group for Information Technology Education 2011 (SIGITE ’11). New York, USA.

Prior, J. C. (2003). Online assessment of SQL query formulation skills. In Proceedings of

the Fifth Australasian Conference on Computing Education (ACE’03). Darlinghurst, Australia.

Kearns, R., Shead, S., & Fekete, A. (1996). A teaching system for SQL. In Proceedings of the 2nd Australasian Conference on Computer Science Education (ACSE ’97). Melbourne, Australia.

Mitrovic, A. (1998). A Knowledge-Based Teaching System for SQL. Proceedings of World Conference on Educational Multimedia, Hypermedia & Telecommunications (ED-MEDIA/ED-TELECOM’98). Freiburg, Germany.

Barnes, S., & Kuzma, J.(2009). Empirical Study in Teaching First-year Database Students. 7th International Workshop on Teaching, Learning, and Assessment of Databases (TLAD 2009). University of Birmingham.