Browse > Article
http://dx.doi.org/10.9708/jksci.2019.24.11.127

Relational Database SQL Test Auto-scoring System  

Hur, Tai-Sung (Dept. of Computer Science, Inha Technical College)
Abstract
SQL is the most common language in data processing. Therefore, most of the colleges offer SQL in their curriculum. In this research, an auto scoring SQL test is proposed for the efficient results of SQL education. The system was treated with algorithms instead of using expensive DBMS(Data Base Management System) for automatic scoring, and satisfactory results were produced. For this system, the test question bank was established out of 'personnel management' and 'academic management'. It provides users with different sets of test each time. Scoring was done by dividing tables into two sections. The one that does not change the table(select) and the other that actually changes the table(update, insert, delete). In the case of a search, the answer and response were executed at first and then the results were compared and processed, the user's answers are evaluated by comparing the table with the correct answer. Modification, insertion, and deletion of table actually changes the data table, so data was restored by using ROLLBACK command. This system was implemented and tested 772 times on the 88 students in Computer Information Division of our college. The results of the implementation show that the average scoring time for a test consisting of 10 questions is 0.052 seconds, and the performance of this system is distinguished considering that multiple responses cannot be processed at the same time by a human grader, we want to develop a problem system that takes into account the difficulty of the problem into account near future.
Keywords
Relational Database; CBT; SQL(Structured Query Language); auto scoring;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Wikipedia, https://en.wikipedia.org/wiki/Big_data
2 Song Tae Min, Song juyoung, "Checking th Big Data Analysis", Hannarae Publishing, 2015, pp. 23-26.
3 Wikipedia, https://en.wikipedia.org/wiki/SQL
4 Dikli, Semire, "An Overview of Automated Scoring of Essays", The Journal of Technology, Learning and Assessment, Vol. 5, No. 1, Aug. 2006, pp.4.
5 Tai-Sung Hur, "ORACLE SQL&PL/SQL", BooksHolic publishing, pp.38-175, 2016.
6 Kim, Kyunghee and others, "Introduced plans for Computer Based National Assessment of Educationa Achievement", Korea Institute for Curriculum and Evaluation, 2012, pp.1-3
7 Butcher, P.G., Jordan, S.E., "Acomprison of Human and computer markong of short free-text student responses", Vol. 55, Issue 2, Sep. 2010, p.489.   DOI
8 Node.js Express, https://expressjs.com/ko/
9 Noh, Eunhee, Sung, Kyunghee, "Developing an Automatic Content Scoring Program for Short Answer Korean Items in Large-Scale Assessments", The Journal of Curriculum and Evaluation, Vol. 17, No. 2, 2014, pp.101-104.
10 JavaSctipt, https://developer.mozilla.org/ko/docs/Web/JavaScript/Reference/
11 Matia DB, https://mariadb.com/kb/ko/mariadb/