Code quality is a critical aspect of programming, as high-quality code is easier to maintain, and code maintenance constitutes the majority of software costs. Consequently, code quality should be emphasized in programming education. While previous research has identified numerous code quality defects commonly made by students, the current state…

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…

Although ample research has focused on computing skill development over a single course or specific programming language, relatively little attention is paid to how computing skills evolve across a program. Our work aims to understand how specific skills develop throughout a progression of CS courses. We use qualitative content analysis to catalog…

In this paper the "Memory Transfer Language" program visualization (MTL PV) technique is combined with "constructivism" ("conceptual contraposition and colloquy") and "reversibility" to evolve a new approach for instructional design for teaching and learning introductory programming. A sample of 1,364…

SQL compiler error messages are the primary way users receive feedback when they encounter syntax errors or other issues in their SQL queries. Effective error messages can enhance the user experience by providing clear, informative, and actionable feedback. Despite the age of SQL compilers, it still remains largely unclear what contributes to an…

Regular expressions (REs) are often taught to undergraduate computer science majors in the Formal Languages and Automata (FLA) course; they are widely used to implement different software functionalities such as search mechanisms and data validation in diverse fields. Despite their importance, the difficulty of REs has been asserted many times in…

Prior studies in the Computer Science education literature have illustrated that novices make many mistakes in composing SQL queries. Query formulation proves to be difficult for students. Only recently, some headway was made towards understanding why SQL leads to so many mistakes, by uncovering student misconceptions. In this article, we shed new…

Block programming has been suggested as a way of engaging young learners with the foundations of programming and computational thinking in a syntax-free manner. Indeed, syntax errors--which form one of two broad categories of errors in programming, the other one being logic errors--are omitted while block programming. However, this does not mean…

The rise of online programming education has necessitated more effective personalized interactions, a gap that PythonPal aims to fill through its innovative learning system integrated with a chatbot. This research delves into PythonPal's potential to enhance the online learning experience, especially in contexts with high student-to-teacher ratios…

In this study, we developed a classification system of programming errors based on the historical data of 680,540 programming records collected on the Online Judge platform. The classification system described six types of programming errors (i.e., syntax, logical, type, writing, misunderstanding, and runtime errors) and their connections with…

The emergence of Large Language Models (LLMs) has marked a significant change in education. The appearance of these LLMs and their associated chatbots has yielded several advantages for both students and educators, including their use as teaching assistants for content creation or summarisation. This paper aims to evaluate the capacity of LLMs…

Background: With the development of computational literacy, there has been a surge in both research and practice application of text-based and block-based modalities within the field of computer programming education. Despite this trend, little work has actually examined how learners engaging in programming process when utilizing these two major…

To date, many AI initiatives (eg, AI4K12, CS for All) developed standards and frameworks as guidance for educators to create accessible and engaging Artificial Intelligence (AI) learning experiences for K-12 students. These efforts revealed a significant need to prepare youth to gain a fundamental understanding of how intelligence is created,…

Background and Context: We explore the potential for understanding the processes involved in students' programming based on studying their behaviour and dialogue with each other and "conversations" with their programs. Objective: Our aim is to explore how a perspective of inquiry can be used as a point of departure for insights into how…

This study investigated common student errors and underlying difficulties of two groups of Chinese middle school students in an introductory Python programming course using data in the automated assessment tool (AAT) Mulberry. One group of students was from a typical middle school while the other group was from a high-ability middle school. By…