Spreadsheet error correction using an activity framework and a cognitive fit perspective

Suparna Goswami, Hock Chuan Chan, Hee Woong Kim

Research output: Contribution to conferencePaper

1 Citation (Scopus)

Abstract

Errors in a spreadsheet constitute a serious reason for concern among organizations as well as academics. There are ongoing efforts toward finding ways to reduce errors, designing and developing visualization tools to support error correction activities being one of them. In this paper, we propose a framework for classifying activities associated with spreadsheet error correction. The purpose of this framework is to help in understanding the activities that are important for correcting different types of spreadsheet errors and how different visualization tools can help in error correction by effectively supporting these activities. An experiment is designed to test the effectiveness of a visualization tool that supports one of the most important activities from the framework - chaining activity. Two groups of subjects, with and without the visualization tool, are required to correct two types of errors. Our hypotheses are derived based on the notion of cognitive fit between problem representation and task, and the results of the experiment support most of the hypotheses. Thus, this study demonstrates the usefulness of the activity-based framework for spreadsheet error correction, and also provides guidelines for designing and developing tools for spreadsheet audit. It also provides empirical evidence to the cognitive fit theory by showing that performance is significantly better when visual support tools result in a match between problem representation and the task in hand, as in the case of correcting link errors with the tool used in this study. Theoretical and practical implications of the findings are discussed.

Original languageEnglish
Pages695-710
Number of pages16
Publication statusPublished - 2006 Dec 1
Event27th International Conference on Information Systems, ICIS 2006 - Milwaukee, WI, United States
Duration: 2006 Dec 102006 Dec 13

Other

Other27th International Conference on Information Systems, ICIS 2006
CountryUnited States
CityMilwaukee, WI
Period06/12/1006/12/13

Fingerprint

Spreadsheets
Error correction
Visualization
Experiments

All Science Journal Classification (ASJC) codes

  • Information Systems

Cite this

Goswami, S., Chan, H. C., & Kim, H. W. (2006). Spreadsheet error correction using an activity framework and a cognitive fit perspective. 695-710. Paper presented at 27th International Conference on Information Systems, ICIS 2006, Milwaukee, WI, United States.
Goswami, Suparna ; Chan, Hock Chuan ; Kim, Hee Woong. / Spreadsheet error correction using an activity framework and a cognitive fit perspective. Paper presented at 27th International Conference on Information Systems, ICIS 2006, Milwaukee, WI, United States.16 p.
@conference{538549b6b1774bc1a68aa0f52b27d6f1,
title = "Spreadsheet error correction using an activity framework and a cognitive fit perspective",
abstract = "Errors in a spreadsheet constitute a serious reason for concern among organizations as well as academics. There are ongoing efforts toward finding ways to reduce errors, designing and developing visualization tools to support error correction activities being one of them. In this paper, we propose a framework for classifying activities associated with spreadsheet error correction. The purpose of this framework is to help in understanding the activities that are important for correcting different types of spreadsheet errors and how different visualization tools can help in error correction by effectively supporting these activities. An experiment is designed to test the effectiveness of a visualization tool that supports one of the most important activities from the framework - chaining activity. Two groups of subjects, with and without the visualization tool, are required to correct two types of errors. Our hypotheses are derived based on the notion of cognitive fit between problem representation and task, and the results of the experiment support most of the hypotheses. Thus, this study demonstrates the usefulness of the activity-based framework for spreadsheet error correction, and also provides guidelines for designing and developing tools for spreadsheet audit. It also provides empirical evidence to the cognitive fit theory by showing that performance is significantly better when visual support tools result in a match between problem representation and the task in hand, as in the case of correcting link errors with the tool used in this study. Theoretical and practical implications of the findings are discussed.",
author = "Suparna Goswami and Chan, {Hock Chuan} and Kim, {Hee Woong}",
year = "2006",
month = "12",
day = "1",
language = "English",
pages = "695--710",
note = "27th International Conference on Information Systems, ICIS 2006 ; Conference date: 10-12-2006 Through 13-12-2006",

}

Goswami, S, Chan, HC & Kim, HW 2006, 'Spreadsheet error correction using an activity framework and a cognitive fit perspective', Paper presented at 27th International Conference on Information Systems, ICIS 2006, Milwaukee, WI, United States, 06/12/10 - 06/12/13 pp. 695-710.

Spreadsheet error correction using an activity framework and a cognitive fit perspective. / Goswami, Suparna; Chan, Hock Chuan; Kim, Hee Woong.

2006. 695-710 Paper presented at 27th International Conference on Information Systems, ICIS 2006, Milwaukee, WI, United States.

Research output: Contribution to conferencePaper

TY - CONF

T1 - Spreadsheet error correction using an activity framework and a cognitive fit perspective

AU - Goswami, Suparna

AU - Chan, Hock Chuan

AU - Kim, Hee Woong

PY - 2006/12/1

Y1 - 2006/12/1

N2 - Errors in a spreadsheet constitute a serious reason for concern among organizations as well as academics. There are ongoing efforts toward finding ways to reduce errors, designing and developing visualization tools to support error correction activities being one of them. In this paper, we propose a framework for classifying activities associated with spreadsheet error correction. The purpose of this framework is to help in understanding the activities that are important for correcting different types of spreadsheet errors and how different visualization tools can help in error correction by effectively supporting these activities. An experiment is designed to test the effectiveness of a visualization tool that supports one of the most important activities from the framework - chaining activity. Two groups of subjects, with and without the visualization tool, are required to correct two types of errors. Our hypotheses are derived based on the notion of cognitive fit between problem representation and task, and the results of the experiment support most of the hypotheses. Thus, this study demonstrates the usefulness of the activity-based framework for spreadsheet error correction, and also provides guidelines for designing and developing tools for spreadsheet audit. It also provides empirical evidence to the cognitive fit theory by showing that performance is significantly better when visual support tools result in a match between problem representation and the task in hand, as in the case of correcting link errors with the tool used in this study. Theoretical and practical implications of the findings are discussed.

AB - Errors in a spreadsheet constitute a serious reason for concern among organizations as well as academics. There are ongoing efforts toward finding ways to reduce errors, designing and developing visualization tools to support error correction activities being one of them. In this paper, we propose a framework for classifying activities associated with spreadsheet error correction. The purpose of this framework is to help in understanding the activities that are important for correcting different types of spreadsheet errors and how different visualization tools can help in error correction by effectively supporting these activities. An experiment is designed to test the effectiveness of a visualization tool that supports one of the most important activities from the framework - chaining activity. Two groups of subjects, with and without the visualization tool, are required to correct two types of errors. Our hypotheses are derived based on the notion of cognitive fit between problem representation and task, and the results of the experiment support most of the hypotheses. Thus, this study demonstrates the usefulness of the activity-based framework for spreadsheet error correction, and also provides guidelines for designing and developing tools for spreadsheet audit. It also provides empirical evidence to the cognitive fit theory by showing that performance is significantly better when visual support tools result in a match between problem representation and the task in hand, as in the case of correcting link errors with the tool used in this study. Theoretical and practical implications of the findings are discussed.

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

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

M3 - Paper

AN - SCOPUS:84869990221

SP - 695

EP - 710

ER -

Goswami S, Chan HC, Kim HW. Spreadsheet error correction using an activity framework and a cognitive fit perspective. 2006. Paper presented at 27th International Conference on Information Systems, ICIS 2006, Milwaukee, WI, United States.