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…

The purpose of this study is to explore the influence of the microlearning instructional approach in an online introductory database programming classroom. The ultimate goal of this study is to inform educators and instructional designers on the design and development of microlearning content that maximizes student learning. Grounded within the…

Educators across disciplines are implementing lessons and activities that integrate computing concepts into their curriculum to broaden participation in computing. Out of myriad important introductory computing skills, it is unknown which--and to what extent--these concepts are included in these integrated experiences, especially when compared to…

Continuing to fill the literature gap, this research replicated and expands a prior study of student performance in database normalization in an introductory database course. The data was collected from four different universities, each having different prerequisite courses for their database course. Student performance on a database normalization…

Query languages are the foundations of database teaching and education practices. The broad adoption of graph databases contrasts with the limited research into how they are taught. Contrary to relational databases, graph databases allow navigational queries with higher expressivity and lack an a priori schema. In this article, we design a…

Background and Context: Gender research shows that women are better at reading comprehension. Other studies indicate a lower tendency in women to choose STEM professions. Since data modeling requires reading skills and also belongs in the areas of information systems and computer science (STEM professions), these findings provoked our curiosity.…

This article presents a multi-stage guided technical project coding Python scripts for utilizing Amazon Web Services (AWS) to work with a document-store database called DynamoDB. Students doing this project should have taken an introductory programming class (ideally in Python) and a database class to have experience with Python coding and…

Advancements in computation and machine learning have revolutionized science, enabling researchers to address once insurmountable challenges. Bioinformatics, a field that heavily relies on computer-driven analysis of biological data, has greatly benefited from these developments. However, traditional bioinformatics instruction frequently lacks the…

Bibliometric mapping is widely used in educational technology research to visualize research field development (e.g. the current status and trend). However, there has been limited research examining the present state, challenges, and potential applications of bibliometric mapping techniques in the field of educational technology. In an effort to…

This design case discusses the complex collaborative design reasoning processes involved in developing an online interactive learning tool for learners of all ages to explore and understand the role of flagellate plants in our society. The learning tool consists of a main website (the "Voyager") and an interactive, dynamic map of the…

SQL query writing is a challenging task for novices, even after considerable training. Query writing is a programming task and a translation task where the writer must translate a user's request for information into code that conforms to the structure, constraints, and syntax of an SQL SELECT statement and that references specific tables and…

The types of programming errors that novice programmers make and struggle to resolve have long been of interest to researchers. Various past studies have analyzed the frequency of compiler diagnostic messages. This information, however, does not have a direct correlation to the types of errors students make, due to the inaccuracy and imprecision…

Structured Query Language (SQL) is still the de facto database query language widely used in industry and taught in almost all university level database courses. The role of SQL is further strengthened by the emergence of NewSQL systems which use SQL as their query language as well as some NoSQL systems, e.g., Cassandra and DynamoDB, which base…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

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,…