A quality model for spreadsheets

Jácome Cunha, João Paulo Fernandes, Christophe Peixoto, João Saraiva

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

In this paper we present a quality model for spreadsheets based on the ISO/IEC 9126 standard that defines a generic quality model for software. To each of the software characteristics defined in the ISO/IEC 9126, we associate an equivalent spreadsheet characteristic. Then, we propose a set of spreadsheet specific metrics to assess the quality of a spreadsheet in each of the defined characteristics. To obtain the normal distribution of expected values for a spreadsheet in each of the proposed metrics, we have executed them in the widely used EUSES spreadsheet corpus. Then, we quantify each characteristic of our quality model after computing the values of our metrics, and we define quality scores for the different ranges of values. Finally, to automate the quality assessment of a given spreadsheet, according to our quality model, we have integrated the computation of the metrics it includes in both a batch and a web-based tool.

Original languageEnglish (US)
Title of host publicationProceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012
Pages231-236
Number of pages6
DOIs
StatePublished - 2012
Event2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012 - Lisbon, Portugal
Duration: Sep 2 2012Sep 6 2012

Publication series

NameProceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012

Conference

Conference2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012
Country/TerritoryPortugal
CityLisbon
Period9/2/129/6/12

ASJC Scopus subject areas

  • Computer Networks and Communications
  • Information Systems

Fingerprint

Dive into the research topics of 'A quality model for spreadsheets'. Together they form a unique fingerprint.

Cite this