• Corpus ID: 1978192

What we understand is what we get: Assessment in Spreadsheets

  title={What we understand is what we get: Assessment in Spreadsheets},
  author={Andrea Kohlhase and Michael Kohlhase},
In previous work we have studied how an explicit representation of background knowledge associated with a specific spreadsheet can be exploited to alleviate usability problems with spreadsheet-based applications. We have implemented this approach in the SACHS system to provide a semantic help system for spreadsheets applications. In this paper, we evaluate the (comprehension) coverage of SACHS on an Excel-based financial controlling system via a "Wizard-of-Oz" experiment. This shows that SACHS… 
Navigation in Mathematical Documents
This paper argues for the need for more reader assistance in mathematical documents and believes navigation to be a top candidate in this regard, and elaborate design opportunities for helping the reader to navigate, which are anchored around the PlanetMath website.
Towards User Assistance for Documents via Interactional Semantic Technology
This work argues that high-impact documents require embedded user assistance facilities for their readers (not authors) to cope with their semantic complexity, and suggests to illustrate such documents and their players with a semiformal background ontology, an interpretation mapping between domain concepts and semantic objects.
The Planetary System: Web 3.0 & Active Documents for STEM


Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance
This paper proposes to use (complexity) measures as indicators for proper visualization, and proposes different visualization and representation methods that may ease spreadsheet comprehension but should not be applied with all kind of spreadsheet programs.
Spreadsheet Errors: What We Know. What We Think We Can Do
To date, only one technique, cell-by-cell code inspection, has been demonstrated to be effective, and the degree to which other techniques can reduce spreadsheet errors needs to be determined.
Interpretation as a factor in understanding flawed spreadsheets
The problems of mechanical production and the problems of translation of problem to spreadsheet representation are considered.
Template Parsing with User Feedback
With widespread adoption of spreadsheets by end users there is a greater need for better auditing tools to help users develop safer spreadsheets and to develop tools that work with minimal user intervention.
What users say they want in documentation
The study's participants indicated that they preferred documentation, whether online or printed, that is easy to navigate, provides explanations at an appropriate level of technical detail, enables finding as well as solving problems through examples and scenarios, and is complete and correct.
Compensating the Computational Bias of Spreadsheets with MKM Techniques
It is shown that spreadsheets are interesting applications for MKM techniques which can alleviate usability and maintenance problems as spreadsheet-based applications grow evermore complex and long-lived.
Spreadsheet Hell
This management paper looks at the real world issues faced by practitioners managing spreadsheets through the production phase of their life cycle. It draws on the commercial experience of several
Semantic transparency in user assistance systems
This paper introduces semantic transparency as a user interface property that enables giving appropriate help in user assistance systems and shows how semantic transparency can be strengthened when the underlying software is complemented by a semantic ally system.
Documenting Problem-Solving Knowledge: Proposed Annotation Design Guidelines and their Application to Spreadsheet Tools
A 3-level model of annotation is presented and guidelines are proposed for the design of end-user programming environments supporting the explicit and literate annotation levels.
Modeling task experience in user assistance systems
This paper proposes an ontology-based model, which allows fine-grained modeling of task experience using the concepts of the task domain as granules and is semantic in the sense that it allows to take advantage of the relations between concepts to provide novel semantic services and interactions.