Analternative mechanism for the cognitive fit theory in spreadsheet analysis

Hock Chuan Chan, Hee Woong Kim, Suparna Goswami

Research output: Contribution to conferencePaper

Abstract

A basic task in spreadsheet analysis in order to understand the structure of a given spreadsheet is that of finding precedent cells (cells that are referenced in the formula of a given cell). The cognitive fit theory is used to analyze this task. Current applications of the cognitive fit theory assert a fit when the information emphasized by the task matches the information emphasized by the problem representation. This study applies the concept of cognitive fit from a different perspective, with the intention of assessing mental representation in problem solving. By keeping the task invariant, the study does a detailed analysis of the different problem representations (the "A1" referencing style and the "R1C1" referencing style), and the corresponding mental representations. It is experimentally shown that the problem representation affects the mental representation, the cognitive fit between the mental representation and the problem representation, and the subsequent performance.

Original languageEnglish
Publication statusPublished - 2007
Event28th International Conference on Information Systems, ICIS 2007 - Montreal, QC, Canada
Duration: 2007 Dec 92007 Dec 12

Other

Other28th International Conference on Information Systems, ICIS 2007
CountryCanada
CityMontreal, QC
Period07/12/907/12/12

All Science Journal Classification (ASJC) codes

  • Information Systems

Fingerprint Dive into the research topics of 'Analternative mechanism for the cognitive fit theory in spreadsheet analysis'. Together they form a unique fingerprint.

Cite this