User-friendly spreadsheet querying: An empirical study

Rui Pereira; João Saraiva; Jácome Cunha; João Paulo Fernandes

doi:10.1145/2851613.2851910

User-friendly spreadsheet querying: An empirical study

Rui Pereira, João Saraiva, Jácome Cunha, João Paulo Fernandes

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

Abstract

Spreadsheets are nowadays used in a variety of contexts, including in in manipulatin large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets. In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.

Original language	English
Title of host publication	2016 Symposium on Applied Computing (SAC 2016)
Publisher	ACM - Association for Computing Machinery
Pages	202-204
Number of pages	3
Volume	04-08-April-2016
ISBN (Electronic)	9781450337397
DOIs	https://doi.org/10.1145/2851613.2851910
Publication status	Published - 4 Apr 2016
Event	31st Annual ACM Symposium on Applied Computing, SAC 2016 - Pisa, Italy Duration: 4 Apr 2016 → 8 Apr 2016

Conference

Conference	31st Annual ACM Symposium on Applied Computing, SAC 2016
Country/Territory	Italy
City	Pisa
Period	4/04/16 → 8/04/16

Keywords

Empirical studies
Querying
Spreadsheets

Access to Document

10.1145/2851613.2851910Licence: Unspecified

Cite this

@inproceedings{dba0b65e1526423aad47d405896cfa73,

title = "User-friendly spreadsheet querying: An empirical study",

abstract = "Spreadsheets are nowadays used in a variety of contexts, including in in manipulatin large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets. In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.",

keywords = "Empirical studies, Querying, Spreadsheets",

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

note = "Funda{\c c}{\~a}o para a Ci{\^e}ncia e a Tecnologia (SFRH/BPD/112733/2015); 31st Annual ACM Symposium on Applied Computing, SAC 2016 ; Conference date: 04-04-2016 Through 08-04-2016",

year = "2016",

month = apr,

day = "4",

doi = "10.1145/2851613.2851910",

language = "English",

volume = "04-08-April-2016",

pages = "202--204",

booktitle = "2016 Symposium on Applied Computing (SAC 2016)",

publisher = "ACM - Association for Computing Machinery",

address = "United States",

}

TY - GEN

T1 - User-friendly spreadsheet querying

T2 - 31st Annual ACM Symposium on Applied Computing, SAC 2016

AU - Pereira, Rui

AU - Saraiva, João

AU - Cunha, Jácome

AU - Fernandes, João Paulo

N1 - Fundação para a Ciência e a Tecnologia (SFRH/BPD/112733/2015)

PY - 2016/4/4

Y1 - 2016/4/4

N2 - Spreadsheets are nowadays used in a variety of contexts, including in in manipulatin large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets. In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.

AB - Spreadsheets are nowadays used in a variety of contexts, including in in manipulatin large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets. In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.

KW - Empirical studies

KW - Querying

KW - Spreadsheets

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

U2 - 10.1145/2851613.2851910

DO - 10.1145/2851613.2851910

M3 - Conference contribution

AN - SCOPUS:84975856227

VL - 04-08-April-2016

SP - 202

EP - 204

BT - 2016 Symposium on Applied Computing (SAC 2016)

PB - ACM - Association for Computing Machinery

Y2 - 4 April 2016 through 8 April 2016

ER -

User-friendly spreadsheet querying: An empirical study

Abstract

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this