跳到主要內容

臺灣博碩士論文加值系統

(44.201.94.236) 您好!臺灣時間:2023/03/24 11:37
字體大小: 字級放大   字級縮小   預設字形  
回查詢結果 :::

詳目顯示

: 
twitterline
研究生:楊秉憲
研究生(外文):YANG, PING-HSIEN
論文名稱:以同儕評量標記工具評估 SQL程式語言學習效果
論文名稱(外文):Assessing SQL Programming Language Learning Effectiveness with Peer Assessment Annotation Tool
指導教授:潘信宏潘信宏引用關係
指導教授(外文):PAN, SHIN-HUNG
口試委員:王淑卿陳政煥潘信宏
口試委員(外文):WANG, SHU-CHINGCHEN, CHENG-HUANPAN, SHIN-HUNG
口試日期:2022-07-21
學位類別:碩士
校院名稱:亞洲大學
系所名稱:行動商務與多媒體應用學系
學門:電算機學門
學類:電算機應用學類
論文種類:學術論文
論文出版年:2022
畢業學年度:110
語文別:中文
論文頁數:35
中文關鍵詞:結構化查詢語言標記工具學習效果Moodle
外文關鍵詞:structure query languageannotation toolMoodlelearning outcomes
相關次數:
  • 被引用被引用:0
  • 點閱點閱:43
  • 評分評分:
  • 下載下載:11
  • 收藏至我的研究室書目清單書目收藏:0
近年來,由於開發和維護大量 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.

摘 要 i
Abstract ii
誌 謝 iii
目 錄 iv
圖 目 錄 vi
一、 緒論 1
1.1 研究背景與動機 1
1.2 研究目的 2
1.3 研究架構 2
二、 文獻探討 4
2.1 結構化查詢語言 4
2.2 結構化查詢語言的學習工具 5
2.3 程序設計評估 5
2.4 同儕互評 7
2.5 SQL標記工具 8
三、 研究方法 10
3.1 實驗設計與參與者 10
3.2 使用SQL標記工具的學生活動與期末測驗設計 11
3.3 SQL標記工具使用成效調查問卷設計 13
四、 研究分析與結果 14
4.1 SQL 標記工具使用率分析結果 14
4.2 問卷調查結果分析 14
4.3 期末測驗成績分析 19
4.4 研究結果與討論 23
五、 結論與未來研究 24
六、 參考文獻 25
附錄1、問卷調查答題選項人數統計 27
附錄2、問卷調查答題詳細內容 28

圖 目 錄
圖 1、研究架構圖(本研究繪製) 2
圖 2、「SQL Learning Support System」學習工具畫面[3] 5
圖 3、「OASYS」編程評估系統[12] 6
圖 4、「Coursemarker」同儕評分工具[14] 7
圖 5 、PDF標記工具欄 8
圖 6、「TeamTat」標記工具使用畫面[21] 9
圖 7、實驗流程圖 11
圖 8、SQL 標記工具使用介面 12
圖 9、SQL 標記工具觀看詳細標記內容 12
圖 10、SQL標記工具使用率 14
圖 11、使用SQL標記工具對於我的學習是有幫助的 15
圖 12、使用SQL標記工具可以節省我的學習時間 15
圖 13、使用SQL標記工具可以節省我的學習時間 16
圖 14、學習SQL標記工具的功能是很簡單的 16
圖 15、SQL標記工具的功能使用起來很容易 17
圖 16、SQL標記工具的介面是友善的 17
圖 17、我會推薦SQL標記工具給其他同學或朋友 18
圖 18、我對於使用SQL標記工具教學效果滿意,願意再繼續使用SQL標記工具 18
圖 19、期末分數分布 19
圖 20、全體測驗成績分析 19
圖 21、實驗組期末分數分布 20
圖 22、實驗組測驗成績分析 20
圖 23、對照組期末分數分布 21
圖 24、對照組測驗成績分析 21
圖 25、期末成績獨立樣本t檢定 22


[1]Panni, F. A. K., & Hoque, A. S. M. L. (2020). “A Model for Automatic Partial Evaluation of SQL Queries.” 2020 2nd International Conference on Advanced Information and Communication Technology, 240–245. doi:10.1109/ICAICT51780.2020.9333475
[2]Al-salmi, A. (2018). “A Web-Based Semi-Automatic Assessment Tool for Formulating Basic SQL Statements: Point-and-Click Interaction Method.” 2018 International Conference on Computer Supported Education, 191–198. doi:10.5220/0006671501910198
[3]Fujita, S., Takano, K., & Hayami, H. (2019). “Analysis of Learning Effect Using a SQL Learning Support System in the Class.” 2019 IEEE International Conference on Engineering, Technology and Education (TALE), 1–4. doi:10.1109/TALE48000.2019.9225905
[4]Phewkum, C., Kaewchaiya, J., Kobayashi, K., & Atchariyachanvanich, K. (2019). “ScrambleSQL: A Novel Drag-and-Drop SQL Learning Tool.” 2019 23rd International Computer Science and Engineering Conference (ICSEC), 340–344. doi:10.1109/ICSEC47112.2019.8974815
[5]Huang, C., & Morreale, P. A. (2016). “A Web-Based, Self-Controlled Mechanism to Support Students Learning SQL.2016 IEEE Integrated STEM Education Conference (ISEC), 218–223. doi:10.1109/ISECon.2016.7457536
[6]Lai, P. P. Y. (2020). “Engaging Students in SQL Learning by Challenging Peer during the Pandemic.” 2020 IEEE International Conference on Teaching, Assessment, and Learning for Engineering (TALE), 205–212. doi:10.1109/TALE48869.2020.9368433
[7]Morales-Trujillo, M. E., & García-Mireles, G. A. (2020). “Gamification and SQL: an empirical study on student performance in a database course.” ACM Transactions on Computing Education (TOCE), 21(1), 1-29. doi:10.1145/3427597
[8]Permpool, T., Nalintippayawong, S., & Atchariyachanvanich, K. (2019). “Interactive SQL Learning Tool with Automated Grading Using MySQL Sandbox.” 2019 IEEE 6th International Conference on Industrial Engineering and Applications (ICIEA), 928–932. doi:10.1109/IEA.2019.8715175
[9]Lavbič, D., Matek, T., & Zrnec, A. (2017). “Recommender System for Learning SQL Using Hints.” Interactive Learning Environments, 25(8), 1048–1064. doi:10.1080/10494820.2016.1244084
[10]Falchikov, N. (2003). “Learning together: Peer tutoring in higher education.” Routledge.
[11]Bhalerao, A., & Ward, A. (2001). “Towards Electronically Assisted Peer Assessment: A Case Study.” Association for Learning Technology Journal, 9(1), 26–37.
[12]Sitthiworachart, J., & Joy, M. (2003). “Deepening Computer Programming Skills by Using Web-Based Peer Assessment.” Proceedings of the 4th Annual Conference of the LTSN Centre for Information and Computer Sciences, 152–156.
[13]Sitthiworachart, J., & Joy, M. (2004). “Effective Peer Assessment for Learning Computer Programming.” ACM SIGCSE Bulletin, 36(3), 122–126.
[14]Sitthiworachart, J., & Joy, M. (2008). “Computer Support of Effective Peer Assessment in an Undergraduate Programming Class.” Journal of Computer Assisted Learning, 24(3), 217–231.
[15]Chalk, B., & Kemi, A. (2005). “Peer Assessment Of Program Code: A Comparison of Two Feedback Instruments.” 6th HEA-ICS Annual Conference, 106–110.
[16]Lewis, S., & Davies, P. (2004). “Automated Peer-Assisted Assessment of Programming Skills.” ITRE 2004. 2nd International Conference Information Technology: Research and Education, 84–86.
[17]Lydia Wen, M., Tsai, C. C., & Chang, C. Y. (2006). “Attitudes towards peer assessment: A comparison of the perspectives of pre‐service and in‐service teachers.” Innovations in Education and Teaching International, 43(1), 83-92.
[18]Wen, M. L., & Tsai, C. C. (2006). “University students’ perceptions of and attitudes toward (online) peer assessment.” Higher Education, 51(1), 27-44.
[19]Decker, B., Schwager, F., & Schroeder, T. (n.d.). PDF Annotator Plugin for Moodle. https://moodle.org/plugins/mod_pdfannotator
[20]Moodle - Open-source learning platform, https://moodle.org/
[21]Islamaj, R., Kwon, D., Kim, S., & Lu, Z. (2020). “TeamTat: a collaborative text annotation tool.” Nucleic acids research, 48(W1), W5-W11.
[22]Chen, C. H., Chen, Y. X., Chow, Y. H., & Pan, S. H. (2019, September). “Investigating and predicting the usability of an e-book system for university students: The role of prior knowledge.” In International Cognitive Cities Conference (pp. 333-342). Springer, Singapore.
[23]吳毓瑩. (1996). “量表奇偶點數的效度議題.” 調查研究: 方法與應用, 2, 5-34.

QRCODE
 
 
 
 
 
                                                                                                                                                                                                                                                                                                                                                                                                               
第一頁 上一頁 下一頁 最後一頁 top