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…

Background: Conceptual models are an essential phase in software design, but they can create confusion and reduced performance for students in Database Design courses. Objective: A novel Relational Data Model Validation Tool (MVTool) was developed and tested to determine (1) if students who use MVTool perform better than those who do not, and (2)…

There are known misconceptions about variables which are mostly the same since the first studies since more than 30 years ago. Consciousness about the misconceptions in programming can be crucial for teaching and learning programming for novices because, if we are aware of them, maybe we can minimise or even prevent them. Researchers mostly…

Simulation is an effective tool for analyzing probability models as well as for facilitating understanding of concepts in probability and statistics. Unfortunately, implementing a simulation from scratch often requires users to think about programming issues that are not relevant to the simulation itself. We have developed a Python package called…

LiaScript is an attempt to enable everyone to create free and interactive online courses, without the need of being an experienced programmer. Instead, it aims to bring both parties, software- and course-developers, closer together by introducing Open-Source techniques into the Open-courSe development process. LiaScript was designed to be…

Intertextuality, defined as the presence of one text within another, is a powerful tool in shaping media narratives and engaging audiences. This study explores intertextuality in Kazakh, Russian, and English-language media, examining how precedent expressions like quotes, allusions, proverbs, and aphorisms sued as media texts interact across…

Python is gaining popularity in academia as the preferred language to teach novices serial programming. The syntax of Python is clean, easy, and simple to understand. At the same time, it is a high-level programming language that supports multi programming paradigms such as imperative, functional, and object-oriented. Therefore, by default, it is…

Coding education has been offered to primary school students due to certain reasons: (1) coding improves students' problem solving and creative thinking skills; and (2) it has high visual-quality and easy-to-use block-based tools. In this study, the effects of coding education on 4th grade students' self-efficacy and scratch coding achievement…

Introductory programming courses (CS1) are difficult for novices. Inspired by "Problem solving followed by instruction" and "Productive Failure" approaches, we define an original "necessity-driven" learning design. Students are put in an apparently well-known situation, but this time they miss an essential ingredient…

Serious games, or else educational games, for programming are considered to have a positive impact on learning programming. Specifically, serious games are considered to motivate students and engage them in playing and learning programming. However, more research is required in order to study their effects in learning programming, as well as their…

In the school year 2020-2021, the COVID-19 pandemic imposed distance learning (in Italian, the DAD acronym is used). Therefore, the Degree Course in Primary Education Sciences of the University of Perugia has proposed an innovative programme for the training of future teachers by developing a distance learning laboratory focusing coding and…

Students learn many concepts in the introductory statistics course, but even our most successful students end up with rigid, ritualized knowledge that does not transfer easily to new situations. In this article we describe our attempt to apply theories and findings from learning science to the design of a statistics course that aims to help…

R and Python are commonly used software languages for data analytics. Using these languages as the course software for the introductory course gives students practical skills for applying statistical concepts to data analysis. However, the reliance upon the command line is perceived by the typical nontechnical introductory student as sufficiently…

The assessment of program functionality can generally be accomplished with straight-forward unit tests. However, assessing the design quality of a program is a much more difficult and nuanced problem. Design quality is an important consideration since it affects the readability and maintainability of programs. Assessing design quality and giving…

In our age of big data and growing computational power, versatility in data analysis is important. This study presents a flexible way to combine statistics and machine learning for data analysis of a large-scale educational survey. The authors used statistical and machine learning methods to explore German students' attitudes towards information…