Spreadsheet Use and Programming Experience: An Exploratory Survey (original) (raw)
Related papers
A comparison of spreadsheet users with different levels of experience
2009
How do experienced spreadsheet users compare to inexperienced ones, and what light can this comparison shed on spreadsheet best practices? This is the question we address in this paper, using the results from a survey of nearly 1600 respondents. This survey was completed by a wide range of spreadsheet users and focused on their significant characteristics and practices. We were interested in their training, experience, collaboration, and quality control methods. We also examined the number of spreadsheet functions they used regularly, the manner in which they created spreadsheets, and the types of tests they used to check results. We compared two subgroups corresponding to two extremes with respect to their self-reported level of experience and skill. Each subgroup was represented by roughly 10% of the total respondents. Our results suggest that there is a substantial difference between these groups, not only in their personal backgrounds and the corporate setting within which they work, but also in their individual spreadsheet skills and practices. We find that the most experienced subgroup exhibits many desirable characteristics and practices.
2008
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 reflect gaps between these two groups and between these groups and the entire population of nearly 1600 respondents. Moreover, our results indicate that these gaps have multiple dimensions: they reflect not only the context, skill, and practices of individual users but also the policies of large organizations.
Research Strategy and Scoping Survey on Spreadsheet Practices
2008
We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices can he combined into proposed best practices for deployment. As a first step we propose a scoping survey to gather non-anecdotal data on spreadsheet usage. The scoping survey will interview people who develop spreadsheets. We will investigate the determinants of spreadsheet importance, identify current industry practices, and document existing standards for creation and use of spreadsheets. The survey will provide insight into user attributes, spreadsheet importance, and current practices. Results will be valuable in themselves, and will guide future empirical research.
SSaaPP: SpreadSheets as a Programming Paradigm Project's Final Report
2014
This technical report describes the research goals and results of the SpreadSheet as a Programming Paradigm research project. This was a project funded by Fundação para a Ciencia e Tecnologia-FCT: the Portuguese research foundation, under reference FCOMP-01-0124-FEDER-010048, that ran from May 2010 till July 2013. This report includes the complete document reporting the results achieved during the project execution, which was submitted to FCT for evaluation on October 2013. It describes the goals of the project, and the different research tasks presenting the deliverables of each of them. It also presents the management and result dissemination work performed during the project's execution. The document includes also a self assessment of the achieved results, and a complete list of scientific publications describing the contributions of the project. Finally, this document includes the FCT evaluation report.
Didactic Connection between Spreadsheet and Teaching Programming
Didactic Connection between Spreadsheet and Teaching Programming, 2022
When we talk about problem-solving skills, then, generally, programming comes to our minds as an activity that can develop algorithmic thinking and abstraction. Regarding the spreadsheet, the software application area could be our first, and mathematics could be our second thought. When spreadsheets and programming are mentioned together, programming of macros is in focus, which is in fact programming. In this paper, we want to focus on how these two areas impact each other, and we want to emphasize that the spreadsheet is an efficient tool to develop algorithmic thinking. Moreover, there is more "crosstalk" between these two tools. This paper will show through examples that there is a two-way connection between spreadsheet and programming; that is why it can be useful to build the concepts of these two topics mutually on each other.
A user-centred approach to functions in excel
ACM SIGPLAN Notices, 2003
We describe extensions to the Excel spreadsheet that integrate userdefined functions into the spreadsheet grid, rather than treating them as a "bolt-on". Our first objective was to bring the benefits of additional programming language features to a system that is often not recognised as a programming language. Second, in a project involving the evolution of a well-established language, compatibility with previous versions is a major issue, and maintaining this compatibility was our second objective. Third and most important, the commercial success of spreadsheets is largely due to the fact that many people find them more usable than programming languages for programming-like tasks. Thus, our third objective (with resulting constraints) was to maintain this usability advantage.
On Programming and Spreadsheet Calculations
2003
Experiment", "discovery" and "self-teaching" are basic components of active learning. Despite the fact that learners are investigating notions and relationships known long before, their own discovery of something new and unknown for them results in their fascination with an irreplaceable educational value. Spreadsheets are one of many environments that can successfully be used for building stages for similar experimentation. Activities described in this paper show how spreadsheet-based calculations can lead students to a deeper comprehension of algorithms, their execution and notation in a programming language. Their goal is to identify a relationship between a notation of an algorithm and the series of figures produced by its execution. During their investigations, students exploit the adaptability of spreadsheets-each change of an input value evokes the complete recalculation of the entire sheet. The instant recalculations allow the students to observe many "runs" of the studied algorithm, to formulate hypotheses and to verify them much faster than any other methods of traditional programming.
Exploring Human Factors in Spreadsheet Development
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.