Please use this identifier to cite or link to this item: http://hdl.handle.net/10397/35945
Title: How can non-technical end users effectively test their spreadsheets?
Authors: Poon, PL 
Kuo, FC
Liu, H
Chen, TY
Keywords: Decision support systems
User participation
End user
Information Systems Development (ISD)
Quality
Issue Date: 2014
Publisher: Emerald Group Publishing Limited
Source: Information technology and people, 2014, v. 27, no. 4, p. 440-462 How to cite?
Journal: Information technology and people 
Abstract: Purpose - An alarming number of spreadsheet faults have been reported in the literature, indicating that effective and easy-to-apply spreadsheet testing techniques are not available for "non-technical," end-user programmers. The purpose of this paper is to alleviate the problem by introducing a metamorphic testing (MT) technique for spreadsheets. Design/methodology/approach - The paper discussed four common challenges encountered by end-user programmers when testing a spreadsheet. The MT technique was then discussed and how it could be used to solve the common challenges was explained. An experiment involving several "real-world" spreadsheets was performed to determine the viability and effectiveness of MT. Findings - The experiment confirmed that MT is highly effective in spreadsheet fault detection, and yet MT is a general technique that can be easily used by end-user programmers to test a large variety of spreadsheet applications. Originality/value - The paper provides a detailed discussion of some common challenges of spreadsheet testing encountered by end-user programmers. To the best of the authors knowledge, the paper is the first that includes an empirical study of how effective MT is in spreadsheet fault detection from an end-user programmer's perspective.
URI: http://hdl.handle.net/10397/35945
ISSN: 0959-3845 (print)
1758-5813 (online)
DOI: 10.1108/ITP-01-2013-0004
Appears in Collections:Journal/Magazine Article

Access
View full-text via PolyU eLinks SFX Query
Show full item record

SCOPUSTM   
Citations

3
Citations as of Apr 4, 2017

WEB OF SCIENCETM
Citations

2
Last Week
0
Last month
Citations as of Apr 20, 2017

Page view(s)

17
Last Week
3
Last month
Checked on Apr 23, 2017

Google ScholarTM

Check

Altmetric



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.