Is it feasible to teach query programming in three different languages in a single session?
Is it feasible to teach query programming in three different languages in a single session?
复制标题
在一次课程中用三种不同的语言教授查询编程是否可行？
DOI：
10.1145/3351287.3351293
复制
发表时间：
2019
期刊：
影响因子：
--
通讯作者：
Sundin L
中科院分区：
文献类型：
--
作者：
Sundin L
人们越来越期望理科本科生和研究生使用R、SQL和Python进行数据分析。这就要求教师开发资源，让学生快速上手。这项研究提出并评估了一种学习设计：(1)使用面向模式的教程来教授实现数据分析查询的独立于语言的键操作，以及(2)使用小抄来显示这些操作如何映射到特定于语言的语法。评估研究(N=21)得出的结论是，使用这种方法，三分之二的数据科学新手可以在两小时内用上述所有语言执行简单到中等复杂的查询。此外，排列测试还产生了显著的语言主效应，其中SQL的准确率最高。这些结果是关于面向模式的辅助工具用于加速数据科学教学的优点和依赖于语言的可行性的一般性讨论的一部分。
Undergraduates and postgraduates in science subjects are increasingly expected to conduct their data analyses using R, SQL and Python. This requires of instructors to develop resources that get students up and running quickly. This study presents and evaluates a learning design that (1) uses a pattern-oriented tutorial to teach language-independent key operations for implementing data analytic queries, and (2) uses cheat sheets to show how these operations map onto language-specific syntax. The evaluation study (N=21) concludes that using this approach, two thirds of the data science novices sampled could implement simple to moderately complex queries in all the aforementioned languages within two hours. A permutation test moreover produced a significant main effect of language, with SQL ranking the highest in accuracy. The results form part of a general discussion on the merits and language-dependent feasibility of pattern-oriented aids for accelerated data science instruction.