Combining information on structure and content to automatically annotate natural science spreadsheets

• Published in: International journal of human-computer studies Vol. 103; pp. 63 - 76
• Main Authors: de Vos, Martine, Wielemaker, Jan, Rijgersberg, Hajo, Schreiber, Guus, Wielinga, Bob, Top, Jan
• Format: Journal Article
• Language: English
• Published: Elsevier Ltd 01-07-2017
• Subjects: Domain Model; Implicit knowledge; Methodology; Spreadsheets; Units of measure; Vocabularies; Vocabularies; Methodology; Domain Model; Implicit knowledge; Spreadsheets; Units of measure
• ISSN: 1071-5819; 1095-9300
• DOI: 10.1016/j.ijhcs.2017.02.006

In this paper we propose several approaches for automatic annotation of natural science spreadsheets using a combination of structural properties of the tables and external vocabularies. During the design process of their spreadsheets, domain scientists implicitly include their domain model in the content and structure of the spreadsheet tables. However, this domain model is essential to unambiguously interpret the spreadsheet data. The overall objective of this research is to make the underlying domain model explicit, to facilitate evaluation and reuse of these data.
We present our annotation approaches by describing five structural properties of natural science spreadsheets, that may pose challenges to annotation, and at the same time, provide additional information on the content. For example, the main property we describe is that, within a spreadsheet table, semantically related terms are grouped in rectangular blocks. For each of the five structural properties we suggest an annotation approach, that combines heuristics on the property with knowledge from external vocabularies. We evaluate our approaches in a case study, with a set of existing natural science spreadsheets, by comparing the annotation results with a baseline based on purely lexical matching.
Our case study results show that combining information on structural properties of spreadsheet tables with lexical matching to external vocabularies results in higher precision and recall of annotation of individual terms. We show that the semantic characterization of blocks of spreadsheet terms is an essential first step in the identification of relations between cells in a table. As such, the annotation approaches presented in this study provide the basic information that is needed to construct the domain model of scientific spreadsheets.
•We describe five structural properties of scientific spreadsheet tables.•Within a spreadsheet table, semantically related terms are grouped in blocks.•We annotate tables using information on their structure and external vocabularies.•Including information on table structure improves annotation of spreadsheet terms.•We identify relations within a table by semantically categorizing blocks of terms.