• Corpus ID: 2405544

Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience

@article{Baker2008ComparisonOC,
  title={Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience},
  author={Kenneth R. Baker and Stephen G. Powell and Barry Lawson and Lynn Foster-Johnson},
  journal={ArXiv},
  year={2008},
  volume={abs/0803.0168}
}
We developed an internet-based questionnaire on spreadsheet use that we administered to a large number of users in several companies and organizations to document how spreadsheets are currently being developed and used in business. In this paper, we discuss the results drawn from of a comparison of responses from individuals with the most experience and expertise with those from individuals with the least. These results describe two views of spreadsheet design and use in organizations, and… 

Figures and Tables from this paper

Spreadsheets in Financial Departments: An Automated Analysis of 65,000 Spreadsheets using the Luminous Technology
TLDR
An analysis of 65,000 spreadsheets for the financial departments of both a government and a private commercial organisation provides important insight into the nature and structure of these spreadsheets, the links between them, the existence and nature of macros and the level of repetitive processes performed through the spreadsheets.
Co-Occurrences of Context Dimensions of Spreadsheets
TLDR
This paper looks into the “context space” of spreadsheets, i.e., the space induced by information dimensions along which users try to grasp the presented content, to find out whether and if so, how context dimensions depend on each other.
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.
Textbooks for Responsible Data Analysis in Excel
TLDR
There is a need to re-evaluate the teaching approaches being used in office application courses, and a wide range of approaches are shown, and none of the 10 books fully cover the methodologies needed to create well-rounded Excel data analysts.
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.
Spreadsheets and Long Term Corporate Survival
TLDR
There is a material and statistically significant increase in the long term survival rate of all of these groups of companies compared to the control.
Are workplace end-user computing skills at a desirable level? A New Zealand perspective
TLDR
A study involving the testing of people who, in their jobs, use word-processing and spreadsheet software confirmed that end-user computer skill, while required, is not at a level that could be deemed proficient.
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.
A Primer on Spreadsheet Analytics
TLDR
This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model by presenting native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient.
A Primer on Spreadsheet Analytics
TLDR
This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model by presenting native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient.
...
...

References

SHOWING 1-10 OF 18 REFERENCES
Spreadsheets in business
The commercial spreadsheet is 21 years old and is now a commonplace business tool. To assess its impact on today’s modern business, this paper presents research based on a questionnaire survey of 227
Spreadsheet Knowlege: Measuring what User Developers Know
TLDR
The development of a diagnostic test for spread sheet knowledge is described, designed to be used by individuals, teachers, trainers, and organizations to identify the spreadsheet development training needed by spreadsheet user developers and to examine the success of spreadsheet training programs.
Spreadsheet knowledge: Measuring what user developersknow
TLDR
The development of a diagnostic test for spreadsheet knowledge is described, designed to be used by individuals, teachers, trainers, and organizations to identify the spreadsheet development training needed by spreadsheet user developers and to examine the success of spreadsheet training programs.
A risk and control-oriented study of the practices of spreadsheet application developers
  • M. Hall
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The significance to the management of end-user computing of tolerating a high level of risk is discussed and the need for an end- user spreadsheet control model is established.
The Importance and Criticality of Spreadsheets in the City of London
TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.
Spreadsheets on trial: a survey of research on spreadsheet risks
  • R. Panko, R. Halverson
  • Economics
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The paper presents a framework for risks in spreadsheeting and organizes selected research findings in terms of this framework.
Financial modeling of project financing transactions
The aim of the paper is to provide the audience with the essential features to understand Project Financing as a key point of the development of Romanian infrastructure. Key elements of the
...
...