Assessing SQL Programming Language Learning Effectiveness with Peer Assessment Annotation Tool
Vincent Shin-Hung Pan, Bing-Sian Yang · 2023
In recent years, programming skills such as programming and program traceability have become increasingly important due to the need to develop and maintain many Artificial Intelligence (AI) and Internet and Things (IoT) applications. As a result, many studies have used the traceability of program segments to assess the ability of learners to write, test, and debug programs. Several assessment methods have required testing questions such as selection or filler. However, it is still challenging to identify the root cause of these errors by assessing these questions.Structured Query Language (SQL) is a standard computer language used for relational database management and data manipulation; though particularly useful for querying, adding, modifying, and deleting records in databases, it is a fundamental skill and an essential course for students in the information field to learn how to use databases. Therefore, this study proposes using an annotation tool for peer assessment of SQL language learning and analyzing the correlation between this method and learning outcomes to verify that the method helps assess students' SQL language writing and error detection abilities. The results of the study showed that the average score of students who used the annotation tool to learn SQL language was 17.38 points higher than that of students who did not use the annotation tool, thus proving that the annotation tool can improve learning outcomes.