SQL编程实例研究

Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1 Pub Date : 2022-07-07 DOI:10.1145/3502718.3524813

Kamil Akhuseyinoglu, Ryan Hardt, Jordan Barria-Pineda, Peter Brusilovsky, Kerttu Pollari-Malmi, Teemu Sirkiä, L. Malmi

{"title":"SQL编程实例研究","authors":"Kamil Akhuseyinoglu, Ryan Hardt, Jordan Barria-Pineda, Peter Brusilovsky, Kerttu Pollari-Malmi, Teemu Sirkiä, L. Malmi","doi":"10.1145/3502718.3524813","DOIUrl":null,"url":null,"abstract":"The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.","PeriodicalId":424418,"journal":{"name":"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1","volume":"2011 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-07-07","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"A Study of Worked Examples for SQL Programming\",\"authors\":\"Kamil Akhuseyinoglu, Ryan Hardt, Jordan Barria-Pineda, Peter Brusilovsky, Kerttu Pollari-Malmi, Teemu Sirkiä, L. Malmi\",\"doi\":\"10.1145/3502718.3524813\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.\",\"PeriodicalId\":424418,\"journal\":{\"name\":\"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1\",\"volume\":\"2011 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-07-07\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3502718.3524813\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3502718.3524813","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 1

摘要

本文重点介绍了一种新型的SQL编程交互式学习内容——SQL代码实例。虽然工作示例在学习编程中很流行，但它们在学习SQL方面的应用是有限的。我们使用一种新颖的工具来呈现交互式示例，数据库查询分析器(DBQA)，进行了一项大规模的随机对照研究，评估示例作为数据库课程中一种新型实践内容的价值。我们报告了课堂研究的结果，调查了DBQA的使用情况和影响。在其他方面，我们探讨了DBQA提供的文本步骤解释的效果。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

A Study of Worked Examples for SQL Programming

The paper focuses on a new type of interactive learning content for SQL programming - worked examples of SQL code. While worked examples are popular in learning programming, their application for learning SQL is limited. Using a novel tool for presenting interactive worked examples, Database Query Analyzer (DBQA), we performed a large-scale randomized controlled study assessing the value of worked examples as a new type of practice content in a database course. We report the results of the classroom study examining the usage and the impact of DBQA. Among other aspects, we explored the effect of textual step explanations provided by DBQA.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1

自引率

0.00%

发文量