Fifty years of the Psychology of Programming

This paper reflects on the evolution (past, present and future) of the ‘psychology of programming' over the 50 year period of this anniversary issue. The International Journal of Human-Computer Studies (IJHCS) has been a key venue for much seminal work in this field, including its first foundations, and we review the changing research concerns seen in publications over these five decades. We relate this thematic evolution to research taking place over the same period within more specialist communities, especially the Psychology of Programming Interest Group (PPIG), the Empirical Studies of Programming series (ESP), and the ongoing community in Visual Languages and Human-Centric Computing (VL/HCC). Many other communities have interacted with psychology of programming, both influenced by research published within the specialist groups, and in turn influencing research priorities. We end with an overview of the core theories that have been developed over this period, as an introductory resource for new researchers, and also with the authors’ own analysis of key priorities for future research

Cognition Matters: Enduring Questions in Cognitive IS Research

We explore the history of cognitive research in information systems (IS) across three major research streams in which cognitive processes are of paramount importance: developing software, decision support, and human-computer interaction. Through our historical analysis, we identify “enduring questions” in each area. The enduring questions motivated long-standing areas of inquiry within a particular research stream. These questions, while perhaps unapparent to the authors cited, become evident when one adopts an historical perspective. While research in all three areas was influenced by changes in technologies, research techniques, and the contexts of use, these enduring questions remain fundamental to our understanding of how to develop, reason with, and interact with IS. In synthesizing common themes across the three streams, we draw out four cognitive qualities of information technology: interactivity, fit, cooperativity, and affordances. Together these cognitive qualities reflect IT’s ability to influence cognitive processes and ultimately task performance. Extrapolating from our historical analysis and looking at the operation of these cognitive qualities in concert, we envisage a bright future for cognitive research in IS: a future in which the study of cognition in IS extends beyond the individual to consider cognition distributed across teams, communities and systems, and a future involving the study of rich and dynamic social and organizational contexts in which the interplay between cognition, emotion, and attitudes provides a deeper explanation of behavior with IS

Design and implementation of queries for model-driven spreadsheets

This paper presents a domain-specific querying language for model-driven spreadsheets. We briefly show the design of the language and present in detail its implementation, from the denormalization of data and translation of our user-friendly query language to a more efficient query, to the execution of the query using Google. To validate our work, we executed an empirical study, comparing QuerySheet with an alternative spreadsheet querying tool, which produced positive results

"What It Wants Me To Say": Bridging the Abstraction Gap Between End-User Programmers and Code-Generating Large Language Models

Code-generating large language models translate natural language into code. However, only a small portion of the infinite space of naturalistic utterances is effective at guiding code generation. For non-expert end-user programmers, learning this is the challenge of abstraction matching. We examine this challenge in the specific context of data analysis in spreadsheets, in a system that maps the users natural language query to Python code using the Codex generator, executes the code, and shows the result. We propose grounded abstraction matching, which bridges the abstraction gap by translating the code back into a systematic and predictable naturalistic utterance. In a between-subjects, think-aloud study (n=24), we compare grounded abstraction matching to an ungrounded alternative based on previously established query framing principles. We find that the grounded approach improves end-users' understanding of the scope and capabilities of the code-generating model, and the kind of language needed to use it effectively

The Role of Visualization Tools in Spreadsheet Error Correction from a Cognitive Fit Perspective

Errors in spreadsheets pose a serious problem for organizations and academics. This has resulted in ongoing efforts to devise measures for reducing errors or efficient ways of correcting them. Visualization tools are often advertised as means for improving spreadsheet error correction performance. This study investigates the role of visualization tools in spreadsheet error correction. For this purpose, this study proposes a framework for classifying activities associated with spreadsheet error correction. The framework is to highlight the activities that are important for correcting different types of spreadsheet errors, and to show how different visualization tools can aid error correction by effectively supporting these activities. By identifying chaining as one of the most important activities from the framework, this study uses cognitive fit theory to examine the effects of a visualization tool that supports chaining on spreadsheet error correction performance. Experimental methodology is used to test the outcome of cognitive fit between the error correction task and the visualization tool. The results of the experiment highlight the importance of cognitive fit between the type of task and the visualization tool for attaining better performance. This study also provides guidelines for designing and developing tools for spreadsheet error correction

Virtual reality and program comprehension: application using spreadsheet visualisation

Program comprehension is an important function undertaken in the process of software maintenance. Compared to other research subjects, program comprehension has received little attention even though it is one of the biggest influences on a programmer's output. Research into aiding program comprehension has led to software visualisations, but these are mainly two-dimensional views and overload the viewer with information. With the advent of more powerful computers, virtual reality can be used to create three dimensional visualisations, in which the viewer is able to navigate freely. Spreadsheets were studied in this work on visualisation because programming languages are extremely complex and a model employing spreadsheets was developed. Spreadsheets offer many similarities to programming languages, for example, cell referencing and formulas in spreadsheets are similar to procedure calls, variable referencing and data manipulation in conventional programming languages. Common mistakes made in spreadsheets have been shown to be very difficult to locate, mainly because the spreadsheet user has a reduced ability to make hypotheses about the computational domain of a spreadsheet. Therefore, in order to address this shortcoming a visualisation model was developed to allow a spreadsheet user to be able to view both the problem domain (the what) and the computational domain (the how) simultaneously. A spreadsheet, a spreadsheet description language and a virtual reality system were the objects in the model, and a generator and translator were the links between those objects. Implementing the model indicated that spreadsheets could be visualised in virtual reality, and this technique was shown to improve the process of spreadsheet comprehension