Please use this identifier to cite or link to this item: http://scholarbank.nus.edu.sg/handle/10635/42820
Title: Spreadsheet error correction using an activity framework and a cognitive fit perspective
Authors: Goswami, S.
Chan, H.C. 
Kim, H.W.
Keywords: Activity framework
Cognitive fit
Experiment
Spreadsheet
Visualization tools
Issue Date: 2006
Source: Goswami, S.,Chan, H.C.,Kim, H.W. (2006). Spreadsheet error correction using an activity framework and a cognitive fit perspective. ICIS 2006 Proceedings - Twenty Seventh International Conference on Information Systems : 695-710. ScholarBank@NUS Repository.
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.
Source Title: ICIS 2006 Proceedings - Twenty Seventh International Conference on Information Systems
URI: http://scholarbank.nus.edu.sg/handle/10635/42820
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

49
checked on Dec 9, 2017

Google ScholarTM

Check


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.