i-nth logo

Authors

Bennett Kankuzi & Jorma Sajaniemi

Abstract

Earlier research on spreadsheet authors' mental models has shown that people possess several types of information about spreadsheets.

Especially, when explaining a spreadsheet, the real-world and domain mental models are prominent and the spreadsheet model is suppressed, but when locating and fixing an error, one must constantly switch back and forth between the domain model and the spreadsheet model, which requires frequent use of the mapping between problem domain concepts and their spreadsheet model counterparts.

This paper introduces a new spreadsheet visualization tool and its empirical evaluation. The tool translates traditional spreadsheet formulas into problem domain narratives and highlights referenced cells.

The tool was found to be easy to learn and helped the participants to locate more errors in spreadsheets. Furthermore, the tool increased the use of the domain mental model and appeared to improve the mapping between the spreadsheet model and the domain model.

Sample

Relative frequencies of located errors for each error type
Relative frequencies of located errors for each error type

There was significant difference in the relative frequency of errors located without the tool (53.9%) and with the tool (66.6%).

We thus conclude that the tool generally helped participants to locate more errors.

Publication

2014, IEEE Symposium on Visual Languages and Human-Centric Computing, July-August, pages 157-160

Full article

Visualizing the problem domain for spreadsheet users: A mental model perspective

Also see

Presentation slides