The DOI matches its Crossref record; 14 of the 14 references it cites were found in a registry or an index.
An empirical study of spreadsheet authors' mental models in explaining and debugging tasks
Abstract
In this paper, we report on an empirical study exploring the nature of mental models of spreadsheet authors when they are explaining and debugging their own spreadsheets. Study participants were first asked to explain one of their own spreadsheets, and then to find and fix seeded errors in the same spreadsheets. Talk-aloud protocols were collected and analyzed to reveal the nature of participants' mental models in these activities. The findings indicate that the authors explain their spreadsheets mainly in terms of real-world and problem domain concepts; in debugging, they constantly switch between problem domain concepts and spreadsheet-specific concepts, although they mainly use spreadsheet-specific concepts to fix an identified error. These study findings provide insights on the need for developing spreadsheet authoring and debugging tools that correspond to spreadsheet authors' mental models of spreadsheets.
Overview
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
Citations
Cites
An overview of content analysis
Stemler, S. (2020) · ScholarWorks@UMassAmherst (University of Massachusetts Amherst) · doi:10.7275/z6fm-2e34 · Cited by 2,813
Program comprehension during software maintenance and evolution
Von Mayrhauser, A., & Vans, A. M. (1995) · Computer · doi:10.1109/2.402076 · Cited by 575
Stimulus structures and mental representations in expert comprehension of computer programs
Pennington, N. (1987) · Cognitive Psychology · doi:10.1016/0010-0285(87)90007-7 · Cited by 526
What we know about spreadsheet errors
Panko, R. R. (1998) · Journal of Organizational and End User Computing · doi:10.4018/joeuc.1998040102 · Cited by 464 · cited 1×
“I. INTRODUCTION Spreadsheets are one of the most widely used applications in business and other related fields for various purposes such as accounting [7], [9].”
BackgroundMental models concepts for system dynamics research
Doyle, J. K., & Ford, D. N. (1998) · System Dynamics Review · doi:10.1002/(sici)1099-1727(199821)14:1<3::aid-sdr140>3.0.co;2-k · Cited by 440 · cited 1×
“The term “mental model” has been defined differently by different researchers [2].”
BackgroundCognitive processes in program comprehension
Letovsky, S. (1987) · Journal of Systems and Software · doi:10.1016/0164-1212(87)90032-x · Cited by 327
Theories, methods and tools in program comprehension: past, present and future
Storey, M.-A. (2005) · 13th International Workshop on Program Comprehension (IWPC'05) · doi:10.1109/wpc.2005.38 · Cited by 209
Hendry, D. G., & Green, T. R. G. (1994) · International Journal of Human-Computer Studies · doi:10.1006/ijhc.1994.1047 · Cited by 114
Beyond Models and Metaphors: Visual Formalisms in User Interface Design
Nardi, B. A., & Zarmer, C. L. (1993) · Journal of Visual Languages & Computing · doi:10.1006/jvlc.1993.1002 · Cited by 78
Allen, R. B. (1997) · Elsevier eBooks · doi:10.1016/b978-044481862-1.50069-8 · Cited by 74 · cited 1×
“It is quite agreeable among researchers that a programmer can have various simultaneous mental models of a program [1], [5], [8], [13], [14].”
Background
Research works printed but not linked: 1
- raffensperger, 2008, The Art of the Spreadsheet
Cited by
Spreadsheet quality assurance: a literature review
Poon, P., Lau, M. F., Yu, Y. T., & Tang, S.-F. (2024) · Frontiers of Computer Science · doi:10.1007/s11704-023-2384-6 · Cited by 31
Tehranchi, F., Bagherzadeh, A., & Ritter, F. E. (2023) · Artificial intelligence for engineering design analysis and manufacturing · doi:10.1017/s089006042300015x · Cited by 10
“Furthermore, Kankuzi and Sajaniemi (2013, 2014) have shown that experts employ unique mental models when interpreting spreadsheet data, identifying errors, and rectifying them.”
Embedding model-driven spreadsheet queries in spreadsheet systems
Cunha, J., Fernandes, J. P., Mendes, J., Pereira, R., & Saraiva, J. (2014) · IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC) · doi:10.1109/vlhcc.2014.6883039 · Cited by 7
“Indeed, as shown in [18], users need mental models to build a bridge between spreadsheet data and the real world.”
BackgroundWork fragmentation in developer interaction data
Cruz, L. C., Sanchez, H., González, V. M., & Robbes, R. (2017) · Journal of Software: Evolution and Process · doi:10.1002/smr.1839 · Cited by 6
Cunha, J., Fernandes, J. P., Mendes, J., & Saraiva, J. (2015) · Lecture notes in computer science · doi:10.1007/978-3-319-15940-9_6 · Cited by 6
“In fact, this is in line with the results presented in [46] where authors showed that spreadsheet users create a mental model of the spreadsheet that helps them understand and work with the spreadsheet.”
Result
Metadata
- Authors
- Kankuzi, B., & Sajaniemi, J.
- Affiliations
- University of Eastern Finland (FI)
- ORCID
- Kankuzi, Bennett
- Venue
- 2013 IEEE Symposium on Visual Languages and Human Centric Computing
- Publisher
- IEEE
- Published
- 2013-09
- Pages
- 15-18
- ISSN
- 1943-6092 (ISSN-L)
- OpenAlex
- W2081379656
- Cited by
- 14
- References
- 14
- Citations by year
- 2024: 1 · 2023: 2 · 2019: 1 · 2017: 2 · 2016: 2 · 2015: 3 · 2014: 3
- FWCI
- 1.83
- Type
- conference paper
- Language
- en
- Open access
- closed
- Locations
- IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC) (publishedVersion)
- Topics
- Physical Sciences › Computer Science › Software › Spreadsheets and End-User Computing
- Physical Sciences › Computer Science › Computer Graphics and Computer-Aided Design › Data Visualization and Analytics
- Physical Sciences › Computer Science › Human-Computer Interaction › Usability and User Interface Design
- Keywords
- mental models, spreadsheet debugging, authoring tools, debugging tools
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: An empirical study of spreadsheet authors' mental models in explaining and debugging tasks. https://app.cochat.ai/papers/10.1109/vlhcc.2013.6645237
- The paper
- Kankuzi, B., & Sajaniemi, J. (2013). An empirical study of spreadsheet authors' mental models in explaining and debugging tasks. 2013 IEEE Symposium on Visual Languages and Human Centric Computing. https://doi.org/10.1109/vlhcc.2013.6645237
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.