A quality model for spreadsheets

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

doi:10.1109/QUATIC.2012.16

A quality model for spreadsheets

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

Computer Science

Research output: Chapter in Book/Report/Conference proceeding › Conference 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 language	English (US)
Title of host publication	Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012
Pages	231-236
Number of pages	6
DOIs	https://doi.org/10.1109/QUATIC.2012.16
State	Published - 2012
Event	2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012 - Lisbon, Portugal Duration: Sep 2 2012 → Sep 6 2012

Publication series

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

Conference

Conference	2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012
Country/Territory	Portugal
City	Lisbon
Period	9/2/12 → 9/6/12

ASJC Scopus subject areas

Computer Networks and Communications
Information Systems

Access to Document

10.1109/QUATIC.2012.16

Cite this

Cunha, J., Fernandes, J. P., Peixoto, C., & Saraiva, J. (2012). A quality model for spreadsheets. In Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012 (pp. 231-236). Article 6511816 (Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012). https://doi.org/10.1109/QUATIC.2012.16

A quality model for spreadsheets. / Cunha, Jácome; Fernandes, João Paulo; Peixoto, Christophe et al.
Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012. 2012. p. 231-236 6511816 (Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Cunha, J, Fernandes, JP, Peixoto, C & Saraiva, J 2012, A quality model for spreadsheets. in Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012., 6511816, Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012, pp. 231-236, 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012, Lisbon, Portugal, 9/2/12. https://doi.org/10.1109/QUATIC.2012.16

Cunha J, Fernandes JP, Peixoto C, Saraiva J. A quality model for spreadsheets. In Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012. 2012. p. 231-236. 6511816. (Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012). doi: 10.1109/QUATIC.2012.16

@inproceedings{aca3dc36f9884bbf95585f11e66ee323,

title = "A quality model for spreadsheets",

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.",

author = "J{\'a}come Cunha and Fernandes, {Jo{\~a}o Paulo} and Christophe Peixoto and Jo{\~a}o Saraiva",

year = "2012",

doi = "10.1109/QUATIC.2012.16",

language = "English (US)",

isbn = "9780769547770",

series = "Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012",

pages = "231--236",

booktitle = "Proceedings - 2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012",

note = "2012 8th International Conference on the Quality of Information and Communications Technology, QUATIC 2012 ; Conference date: 02-09-2012 Through 06-09-2012",

}

TY - GEN

T1 - A quality model for spreadsheets

AU - Cunha, Jácome

AU - Fernandes, João Paulo

AU - Peixoto, Christophe

AU - Saraiva, João

PY - 2012

Y1 - 2012

N2 - 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.

AB - 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.

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

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

U2 - 10.1109/QUATIC.2012.16

DO - 10.1109/QUATIC.2012.16

M3 - Conference contribution

AN - SCOPUS:84878850436

SN - 9780769547770

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

SP - 231

EP - 236

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

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

Y2 - 2 September 2012 through 6 September 2012

ER -

A quality model for spreadsheets

Abstract

Publication series

Conference

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this