The role of visualization tools in spreadsheet error correction from a cognitive fit perspective

Supama Goswami, Hock Chuan Chan, Hee-Woong Kim

Research output: Contribution to journalArticle

13 Citations (Scopus)

Abstract

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.

Original languageEnglish
Pages (from-to)321-343
Number of pages23
JournalJournal of the Association of Information Systems
Volume9
Issue number6
Publication statusPublished - 2008 Jan 1

Fingerprint

Spreadsheets
Error correction
Visualization

All Science Journal Classification (ASJC) codes

  • Information Systems
  • Computer Science Applications

Cite this

@article{4874d7daff4e42158e42a932bc5a0b7d,
title = "The role of visualization tools in spreadsheet error correction from a cognitive fit perspective",
abstract = "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.",
author = "Supama Goswami and Chan, {Hock Chuan} and Hee-Woong Kim",
year = "2008",
month = "1",
day = "1",
language = "English",
volume = "9",
pages = "321--343",
journal = "Journal of the Association of Information Systems",
issn = "1536-9323",
publisher = "Association for Information Systems",
number = "6",

}

The role of visualization tools in spreadsheet error correction from a cognitive fit perspective. / Goswami, Supama; Chan, Hock Chuan; Kim, Hee-Woong.

In: Journal of the Association of Information Systems, Vol. 9, No. 6, 01.01.2008, p. 321-343.

Research output: Contribution to journalArticle

TY - JOUR

T1 - The role of visualization tools in spreadsheet error correction from a cognitive fit perspective

AU - Goswami, Supama

AU - Chan, Hock Chuan

AU - Kim, Hee-Woong

PY - 2008/1/1

Y1 - 2008/1/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=57049159852&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=57049159852&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:57049159852

VL - 9

SP - 321

EP - 343

JO - Journal of the Association of Information Systems

JF - Journal of the Association of Information Systems

SN - 1536-9323

IS - 6

ER -