Standard

Spreadsheet testing in practice. / Roy, Sohon; Hermans, Felienne; Van Deursen, Arie.

SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering. Institute of Electrical and Electronics Engineers Inc., 2017. p. 338-348 7884634.

Research output: Scientific - peer-reviewConference contribution

Harvard

Roy, S, Hermans, F & Van Deursen, A 2017, Spreadsheet testing in practice. in SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering., 7884634, Institute of Electrical and Electronics Engineers Inc., pp. 338-348, 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering, SANER 2017, Klagenfurt, Austria, 21-24 February. DOI: 10.1109/SANER.2017.7884634

APA

Roy, S., Hermans, F., & Van Deursen, A. (2017). Spreadsheet testing in practice. In SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering. (pp. 338-348). [7884634] Institute of Electrical and Electronics Engineers Inc.. DOI: 10.1109/SANER.2017.7884634

Vancouver

Roy S, Hermans F, Van Deursen A. Spreadsheet testing in practice. In SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering. Institute of Electrical and Electronics Engineers Inc.2017. p. 338-348. 7884634. Available from, DOI: 10.1109/SANER.2017.7884634

Author

Roy, Sohon; Hermans, Felienne; Van Deursen, Arie / Spreadsheet testing in practice.

SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering. Institute of Electrical and Electronics Engineers Inc., 2017. p. 338-348 7884634.

Research output: Scientific - peer-reviewConference contribution

BibTeX

@inbook{78cb82a1841742e2bd2143ce333780c0,
title = "Spreadsheet testing in practice",
author = "Sohon Roy and Felienne Hermans and {Van Deursen}, Arie",
year = "2017",
month = "3",
doi = "10.1109/SANER.2017.7884634",
pages = "338--348",
booktitle = "SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
address = "United States",

}

RIS

TY - CHAP

T1 - Spreadsheet testing in practice

AU - Roy,Sohon

AU - Hermans,Felienne

AU - Van Deursen,Arie

PY - 2017/3/21

Y1 - 2017/3/21

N2 - Despite being popular end-user tools, spreadsheets suffer from the vulnerability of error-proneness. In software engineering, testing has been proposed as a way to address errors. It is important therefore to know whether spreadsheet users also test, or how do they test and to what extent, especially since most spreadsheet users do not have the training, or experience, of software engineering principles. Towards this end, we conduct a two-phase mixed methods study. First, a qualitative phase, in which we interview 12 spreadsheet users, and second, a quantitative phase, in which we conduct an online survey completed by 72 users. The outcome of the interviews, organized into four different categories, consists of an overview of test practices, perceptions of spreadsheet users about testing, a set of preventive measures for avoiding errors, and an overview of maintenance practices for ensuring correctness of spreadsheets over time. The survey adds to the findings by providing quantitative estimates indicating that ensuring correctness is an important concern, and a major fraction of users do test their spreadsheets. However, their techniques are largely manual and lack formalism. Tools and automated supports are rarely used.

AB - Despite being popular end-user tools, spreadsheets suffer from the vulnerability of error-proneness. In software engineering, testing has been proposed as a way to address errors. It is important therefore to know whether spreadsheet users also test, or how do they test and to what extent, especially since most spreadsheet users do not have the training, or experience, of software engineering principles. Towards this end, we conduct a two-phase mixed methods study. First, a qualitative phase, in which we interview 12 spreadsheet users, and second, a quantitative phase, in which we conduct an online survey completed by 72 users. The outcome of the interviews, organized into four different categories, consists of an overview of test practices, perceptions of spreadsheet users about testing, a set of preventive measures for avoiding errors, and an overview of maintenance practices for ensuring correctness of spreadsheets over time. The survey adds to the findings by providing quantitative estimates indicating that ensuring correctness is an important concern, and a major fraction of users do test their spreadsheets. However, their techniques are largely manual and lack formalism. Tools and automated supports are rarely used.

UR - http://www.scopus.com/inward/record.url?scp=85018436207&partnerID=8YFLogxK

U2 - 10.1109/SANER.2017.7884634

DO - 10.1109/SANER.2017.7884634

M3 - Conference contribution

SP - 338

EP - 348

BT - SANER 2017 - 24th IEEE International Conference on Software Analysis, Evolution, and Reengineering

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

ID: 19482579