A Quality Model for Spreadsheets

• Type: Article in International Conference Proceedings Book
• Date: 2012

Authors

Cunha, J (Author) Other; Joao Paulo Fernandes (Author) FEUP; Peixoto, C (Author) Other; Saraiva, J (Author) Other

Conference proceedings International

Title: Proceedings of the 8th International Conference on the Quality of Information and Communications Technology - QUATIC 2012

Pages: 231-236

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

Lisboa, Portugal, 2 a 6 de Setembro de 2012

Indexing

ISI Web of Knowledge - 6 Citations

Scopus - 7 Citations

Other information

Authenticus ID: P-008-BCP

DOI: 10.1109/quatic.2012.16

Abstract (EN): 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.

Language: English

Type (Professor's evaluation): Scientific

No. of pages: 6