Skip navigation

The development of a structured methodology for the construction and integrity control of spreadsheet models

The development of a structured methodology for the construction and integrity control of spreadsheet models

Rajalingham, Kamalasen (2002) The development of a structured methodology for the construction and integrity control of spreadsheet models. PhD thesis, University of Greenwich.

[img]
Preview
PDF (Pages containing signatures redacted)
Kamalasen Rajalingham 2002 - Redacted.pdf - Published Version
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (70MB) | Preview

Abstract

Numerous studies and reported cases have established the seriousness of the frequency and impact of user-generated spreadsheet errors. This thesis presents a structured methodology for spreadsheet model development, which enables improved integrity control of the models. The proposed methodology has the potential to ensure consistency in the development process and produce more comprehensible, reliable and maintainable models, which can reduce the occurrence of user-generated errors.

An insight into the nature and properties of spreadsheet errors is essential for the development of a methodology for controlling the integrity of spreadsheet models. An important by-product of the research is the development of a comprehensive classification or taxonomy of the different types of user-generated spreadsheet errors based on a rational taxonomic scheme.

Research on the phenomenon of spreadsheet errors has revealed the need to adopt a software engineering based methodology as a framework for spreadsheet development in practical situations. The proposed methodology represents a new approach to the provision of a structured, software engineering based discipline for the development of spreadsheet models.

It is established in this thesis that software engineering principles can in fact be applied to the process of spreadsheet model building to help improve the quality of the models. The methodology uses Jackson structures to produce the logical design of the spreadsheet model. This is followed by a technique to derive the physical model, which is then implemented as a spreadsheet. The methodology’s potential for improving the quality of spreadsheet models is demonstrated.

In order to evaluate the effectiveness of the proposed framework, the various features of the proposed structured methodology are tested on a range of spreadsheet models through a series of experiments. The results of the tests provide adequate evidence of the methodology’s potential to reduce the occurrence of user-generated errors and enhance the comprehensibility of the models.

Item Type: Thesis (PhD)
Additional Information: uk.bl.ethos.571385
Uncontrolled Keywords: spreadsheet, spreadsheet models, structured methodology, spreadsheet errors, software engineering, taxonomy, modularisation, Jackson Structured Programming (JSP), integrity control, structured methods, structured spreadsheet development,
Subjects: Q Science > QA Mathematics > QA76 Computer software
Pre-2014 Departments: School of Computing & Mathematical Sciences
School of Computing & Mathematical Sciences > Department of Mathematical Sciences
Last Modified: 08 Mar 2017 17:03
URI: http://gala.gre.ac.uk/id/eprint/6276

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year

View more statistics