Corpus ID: 18026488

Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice

@article{Panko2008ThinkingIB,
  title={Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice},
  author={R. Panko},
  journal={ArXiv},
  year={2008},
  volume={abs/0801.3114}
}
  • R. Panko
  • Published 20 January 2008
  • Computer Science
  • ArXiv
In the spreadsheet error community, both academics and practitioners generally have ignored the rich findings produced by a century of human error research. These findings can suggest ways to reduce errors; we can then test these suggestions empirically. In addition, research on human error seems to suggest that several common prescriptions and expectations for reducing errors are likely to be incorrect. Among the key conclusions from human error research are that thinking is bad, that… Expand

Figures and Topics from this paper

Do Spreadsheet Errors Lead to Bad Decisions: Perspectives of Executives and Senior Managers
TLDR
Executives and senior managers / analysts in the private, public, and non-profit sectors interviewed about their experiences with spreadsheet quality control and with errors affecting decision making believed spreadsheet errors were a significant problem and that more formal spreadsheetquality control could be beneficial. Expand
IMPROVEMENT OF SPREADSHEET SKILLS IN BUSINESS- ORIENTED UNIVERSITY COURSES
TLDR
Based on a selection of current best practices, this paper presents several proposals for updating/innovating courses related to spreadsheet development, and suggests that spreadsheet error prevention and reduction techniques are used rarely. Expand
Empirical study on spreadsheet quality: Case of Serbian SMEs
This paper presents the results of a research which involved analysis of spreadsheets collected from 40 Serbian SMEs. Based on related research, the collected spreadsheets were analysed for presenceExpand
Using Bayesian statistical methods to determine the level of error in large spreadsheets.
  • L. Bradley, Kevin McDaid
  • Computer Science
  • 2009 31st International Conference on Software Engineering - Companion Volume
  • 2009
TLDR
The research that has been carried out into the use of Bayesian Statistical methods to estimate the level of error in large spreadsheets based on expert knowledge and spreadsheet test data can aid in the decision to accept or re-examine a large time consuming spreadsheet. Expand
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. Expand
In Pursuit of Spreadsheet Excellence
TLDR
A simple sampling test - The Clean Sheet Test - which can be used to objectively evaluate if an organisation is in control of the spreadsheets it is using in important processes such as financial reporting. Expand
Controlling End User Computing Applications - a case study
TLDR
Several workstreams were employed in order to bring about a cultural change within the bank towards the use of spreadsheets and other end-user tools, covering policy development, awareness and skills training, inventory monitoring, user licensing, key risk metrics and mitigation approaches. Expand
On-line support - a virtual treasure trove for end-user developers in small organisations?
TLDR
In an explorative study it is tried to pinpoint what, if anything, the participants feel about on-line support and if they use it to solve problems. Expand
Requirements for Automated Assessment of Spreadsheet Maintainability
TLDR
This position paper argues for the need to create a model to estimate the maintainability of a spreadsheet based on (automated) measurement and proposes the creation of a curated, community-contributed repository of spreadsheets. Expand
Qualitative Deviation Models for Spreadsheet Debugging
  • Birgit Hofer, I. Nica, F. Wotawa
  • Computer Science
  • 2017 IEEE International Symposium on Software Reliability Engineering Workshops (ISSREW)
  • 2017
TLDR
A new improved model that makes use of the deviations obtained between the expected value of cells and the actual ones is introduced that allows interactive debugging for spreadsheets. Expand
...
1
2
3
...

References

SHOWING 1-10 OF 25 REFERENCES
An empirical study of spreadsheet error-finding performance
TLDR
While CPAs were more accurate than non-CPAs in finding accounting-related errors, spreadsheet experts did not outperform novices in finding spreadsheet formula errors, and while spreadsheet expertise contributed to greater speed, accounting expertise did not. Expand
Spreadsheet Presentation and Error Detection: An Experimental Study
The pervasiveness and impact of electronic spreadsheets have generated serious concerns about their integrity and validity when used in significant decision-making settings. Previous studies haveExpand
Spreadsheets and Sarbanes-Oxley: Regulations, Risks, and Control Frameworks
  • R. Panko
  • Engineering, Computer Science
  • Commun. Assoc. Inf. Syst.
  • 2006
TLDR
This paper examines spreadsheet risks for Sarbanes-Oxley (and other regulations) and discusses how general and IT-specific control frameworks can be used to address the control risks created by spreadsheets. Expand
Recommended Practices for Spreadsheet Testing
TLDR
This paper presents the authors recommended practices for spreadsheet testing, and logic inspection appears to be feasible for spreadsheet developers to do and safe and effective for module testing. Expand
Applying Code Inspection to Spreadsheet Testing
  • R. Panko
  • Computer Science
  • J. Manag. Inf. Syst.
  • 1999
TLDR
Findings were that subjects were overconfident when inspecting alone, that certain types of errors are especially difficult to detect, and that the benefits of the group phase is greatest for these difficult-to-detect type of errors. Expand
Error Detection Processes in Statistical Problem Solving
TLDR
Good problemsolvers detected a higher proportion of their errors compared to poor problem solvers, probably due to differences in the processes leading up to the triggering of an evaluative episode rather than to differences after the episode had been triggered. Expand
Mental procedures in real-life tasks: a case study of electronic trouble shooting.
TLDR
The mental procedures used by skilled electronics repair men in their normal working environment have been studied by analysis of verbal protocols and demonstrate a great ability by the men to conduct the search by general routines mostly depending upon their general professional background. Expand
Design and Code Inspections to Reduce Errors in Program Development
TLDR
It is shown that by using inspection results, a mechanism f o r initial error reduction followed by ever-improving error rates can be achieved. Expand
Two models of group behavior in the solution of eureka-type problems
A study by Shaw (7) some twenty years ago is frequently cited by social scientists to support the generalization that groups are superior to individuals in problem-solving. Shaw suggests thatExpand
Categorization of action slips.
A slip is the error that occurs when a person does an action that is not intended. In this article I examine several collections of slips, primarily of actions, with the aim of devising a theoreticalExpand
...
1
2
3
...