This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with…

Educational curricula in data analysis are increasingly fundamental to statistics, data science, and a wide range of disciplines. The educational literature comparing coding syntaxes for instruction in data analysis recommends utilizing a simple syntax for introductory coursework. However, there is limited prior work to assess the pedagogical…

CODAP is a widely-used programming environment for secondary school data science. Its direct-manipulation-based design offers many advantages to learners, especially younger students. Unfortunately, these same advantages can become a liability when it comes to repeating operations consistently, replaying operations (for reproducibility), and also…

Background: Academic help-seeking benefits students' achievement, but existing literature either studies important factors in students' selection of all help resources via self-reported surveys or studies their help-seeking behavior in one or two separate help resources via actual help-seeking records. Little is known about whether computing…

The combination of the quantitative turn in linguistics and the emergence of text analytics has created a demand for new methodological skills among linguists and data scientists. This paper introduces KNIME as a low-code programming platform for linguists interested in learning text analytic methods, while highlighting the considerations…

Understanding data structures is fundamental for mastering algorithms. In order to solve problems and tasks, students must be able to choose the most appropriate data structure in which the data is stored and that helps in the process of the solution. Of course, there is no single correct solution, but in many cases, it is an important step to…

With the growing desire to incorporate data science and informatics into STEM curricula, there is an opportunity to integrate research-based software and tools (e.g., Python) within existing pedagogical methods to craft new, accessible learning experiences. We show how the open-source Jupyter Book software can achieve this goal by creating a…

Despite the elevated importance of Data Science in Statistics, there exists limited research investigating how students learn the computing concepts and skills necessary for carrying out data science tasks. Computer Science educators have investigated how students debug their own code and how students reason through foreign code. While these…

Modern technology threatens traditional modes of classroom assessment by providing students with automated ways to write essays and take exams. At the same time, modern technology continues to expand the accessibility of computational tools that promise to increase the potential scope and quality of class projects. This paper presents a case study…

Theorists and educators increasingly highlight the importance of computational thinking in STEM education. While various scaffolding strategies describe how to best support this skillset (i.e., paired programming, worked examples), less research has focused on the design and development of these digital tools. One way to support computational…

Data science programming presents many challenges for programmers entering the field. Roughly, data science programming can be broken up into several activities: data wrangling, analysis, modeling, or visualization. Data wrangling is an important first step that involves cleaning and shaping tabular data--or dataframes--into a form amenable for…

Data science encompasses the most prominent collection of methods for creating scientific knowledge in the 21st century. Currently, data scientists must navigate a wide-ranging and often incoherent ecosystem of tools, in addition to organizing sociotechnical interactions with colleagues across many fields of expertise. This predicament motivates…

This article reports on a study investigating how computational essays can be used to help students in higher education STEM take up disciplinary epistemic agency--cognitive control and responsibility over one's own learning within the scientific disciplines. Computational essays are a genre of scientific writing that combine live, executable…

Business analytics is a fast-growing field that requires a combination of technical, analytical, and communication skills. This article aims to identify the most sought after skills for business analytics jobs based on a content analysis of over 2600 online job postings. The results show that the top skills include analytics, communication,…

Even though working with data is as important as coding for understanding and dealing with complex problems across multiple fields, it has received very little attention in the context of Computational Thinking. This paper discusses an approach for bridging the gap between Computational Thinking with Data Science by employing and studying…