以同儕評量標記工具評估 SQL程式語言學習效果

ASIAIR > College of Computer Science > Department of Applied Informatics and Multimedia > Theses & dissertations > Item 310904400/113718

Please use this identifier to cite or link to this item: http://asiair.asia.edu.tw/ir/handle/310904400/113718

Title:	以同儕評量標記工具評估 SQL程式語言學習效果 Assessing SQL Programming Language Learning Effectiveness with Peer Assessment Annotation Tool
Authors:	楊秉憲 YANG, PING-HSIEN
Contributors:	行動商務與多媒體應用學系
Keywords:	結構化查詢語言;標記工具;學習效果;Moodle structure query language;annotation tool;Moodle;learning outcomes
Date:	2022-08-16
Issue Date:	2022-10-31 04:09:46 (UTC+0)
Publisher:	亞洲大學
Abstract:	近年來，由於開發和維護大量 AI 和 IoT 應用程序的需求，包括程式撰寫和程式追溯在內的編程能力變得越來越重要。因此，許多研究使用對程式區段的追溯來評估學習者對程式撰寫、測試及偵錯的能力。到目前為止，已經有需多經由選擇或填充等題目進行測驗的評估方法。但是，經由這些題目的評量，仍然很難找出學習者犯下這些錯誤的根本原因。從學習者對程式代碼的追溯過程中找出他們的誤解所在之處，是一個有趣且具有挑戰性的問題。本研究所用SQL 標記工具是安裝於 Moodle 平台的一個開放原始碼的附加元件，不僅可以為教師提供在平台上上傳材料供學生學習的方法，還可以為學生提供標記文字和在教材上提問的功能。因此，閱讀和標記的歷程即可用於分析學生的學習行為，找出學習者的概念迷思所在，進而幫助他們的學習。眾所周知，結構化查詢語言（SQL）是一種用於關聯式資料庫管理和資料操作的標準計算機語言，主要用於查詢、新增、修改和刪除資料庫內的紀錄。SQL 語言是資訊領域的學生學習使用資料庫的一項基本技能，也是一門重要課程。因此本研究提出使用SQL 標記工具進行同儕互評學習 SQL語言，並分析該方法與學習成效之關聯，驗證該方法有助於評估學生的SQL 語言撰寫及偵錯能力。通過研究結果顯示，使用SQL標記工具學習結構化查詢語言的同學平均成績對於沒有使用SQL標記工具的同學平均成績高了17.38分，可以驗證SQL標記工具能夠確實提高學習效果。 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. To date, there have been several assessment methods that require testing questions such as selection or filler. However, it is still difficult to identify the root cause of these errors by assessing these questions.It is an interesting and challenging problem to determine where the learners' misunderstandings occur in the process of tracing the program code. The SQL annotation tool used in this study is an open-source add-on installed on the Moodle platform that provides teachers with a way to not only upload materials on the platform for students to learn, but to also provide students with the ability to mark-up texts and ask questions about the materials. Thus, the reading and tagging process can be used to analyze the learning behaviors of students and identify where the conceptual myths of such learners lie, thus helping them in their learning.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 important 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 to analyze the correlation between this method and learning outcomes to verify that the method is indeed useful for assessing 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 really improve learning outcomes.
Appears in Collections:	[Department of Applied Informatics and Multimedia] Theses & dissertations

Files in This Item:

File	Description	Size	Format
index.html		0Kb	HTML	99	View/Open

Loading...