|Title||User-friendly spreadsheet querying: An empirical study|
|Authors||Rui Pereira, Joao Saraiva, Jacome Cunha, & Joao Paulo Fernandes|
|Publication||31st ACM/SIGAPP Symposium on Applied Computing|
Spreadsheets are nowadays used in a variety of contexts, including in the manipulation of 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.
We developed a graphical user interface for visual query construction. This visual interface, named Graphical-QuerySheet, hides syntax peculiarities and lets users choose attributes based on the spreadsheet's model.