• Corpus ID: 17350990

Exploring Human Factors in Spreadsheet Development

@article{Thorne2008ExploringHF,
  title={Exploring Human Factors in Spreadsheet Development},
  author={Simon Thorne and David Ball},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.1862}
}
In this paper we consider human factors and their impact on spreadsheet development in strategic decision-making. This paper brings forward research from many disciplines both directly related to spreadsheets and a broader spectrum from psychology to industrial processing. We investigate how human factors affect a simplified development cycle and what the potential consequences are. 

Figures and Tables from this paper

Error Estimation in Large Spreadsheets using Bayesian Statistics
TLDR
Early research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets during cell be cell examination based on expert knowledge and partial spreadsheet test data are outlined.
Spreadsheets and the Financial Collapse
TLDR
There is a link between the use of spreadsheets and the recent collapse of the global financial system, and governments and regulating authorities are provided with some simple recommendations to reduce the risks of continued overdependence on unreliable spreadsheets.
An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas
TLDR
The development of an automated (electronic) means for detecting such hard coding is described together with a discussion of some results obtained through analysis of a number of student and practitioner spreadsheet models.
VisualCOBie for facilities management
TLDR
The paper demonstrates that Gestalt’s principles of visual perception provide a suitable conceptual as well as implementable basis for improving the usability and comprehension of COBie spreadsheets.
Exploring the effectiveness of BIM for energy performance management of non-domestic buildings
Following several years of research and development around the subject of BIM, its impact on the design and handover of buildings is now becoming visible across the construction industry. Changes in
Spreadsheets as User Interfaces v5 post-sub-edit
TLDR
Four vignettes related to musicological data demonstrate how spreadsheets can be used as an integral part of interactive processes, for activities from simple data entry, to more complex grouping and linking of datasets, both as fully functional prototypes and as part of a final system.
Teaching methods are erroneous: approaches which lead to erroneous end-user computing
TLDR
Teachers should believe in the incremental nature of science and have high self-efficacy to make students understand and appreciate science, and it is high time fundamental changes were introduced.
Triggered expressions : event driven manipulation of cell states in spreadsheets
TLDR
This thesis proposes triggered expressions, which supplement the spreadsheet paradigm that enables event driven manipulation of cell events, and details a practical implementation within spreadsheets, and analyzes some potential use cases.
Visual Pattern Recognition as a Means to Optimising Building Performance?
TLDR
This research builds on the work previously completed and utilises techniques of visualisation to demonstrate behaviour patterns and presents learning opportunities for optimal performance, demonstrated through visualisation of energy performance data for a case-study building in the UK.

References

SHOWING 1-10 OF 52 REFERENCES
Factors influencing risks and outcomes in end-user development
TLDR
Results indicated that subjects using the methodology showed a significant reduction in the number of "linking errors", i.e., mistakes in creating links between values that must flow from one area of the spreadsheet to another or from one worksheet to another in a common workbook.
Framework for Cognitive Skill Acquisition and Spreadsheet Training
TLDR
Investigating how several important cognitive skills are affected by formalized spreadsheet training indicates one cognitive skill, logical reasoning, significantly increases after a six-week training period, and the greater the increase in logical reasoning skill, the more effectively the subject developed competent spreadsheet models.
A Novel Approach to Formulae Production and Overconfidence Measurement to Reduce Risk in Spreadsheet Modelling
TLDR
A control experiment that compares example driven modelling against traditional approaches over several progressively more difficult tests is discussed and a method for statistically analysing the problem of overconfidence in spreadsheet modellers is proposed.
Strategies for End-User Computing: An Integrative Framework
This paper develops a framework consisting of five core strategies or organizational postures vis-a-vis end-user computing (euc). Following a descrip- tion of each of the strategies, the authors
Reducing Overconfidence in Spreadsheet Development
TLDR
Two experiments in overconfidence in spreadsheet development are described, including a pilot study to determine the existence of overconfidence, and a manipulation to reduce overconfidence and errors.
Organization Designs for the Management of End-User Computing: Re-examining the Contingencies
TLDR
Testing of a previously published contingency model in which two different structural forms are modeled for four states of EUC implementation provides additional evidence for the effectiveness of a more controlled approach to EUC management under a low EUC growth objective at an early stage of implementation.
Managing the Risks Associated with End-User Computing
TLDR
Generic controls are introduced that address each of the risks of euc associated with different stages of the end-user applications life cycle and allow euc management to select those most appropriate to their euc environment.
End‐user computing and information systems methodologies
TLDR
The potential benefits and disadvantages of the use of information systems methodologies for end‐user‐computing, and strategies by which such usage can be accomplished are discussed.
An experimental study of people creating spreadsheets
TLDR
It was found that experienced spreadsheet users spend a large percentage of their time using the cursor keys, primarily for the purpose of moving the cursor around the spreadsheet.
...
...