Complexity metrics for classSheet models

Lecture Notes in Computer Science Volume 7972, 2013.This paper proposes a set of metrics for the assessment of the complexity of models defining the business logic of spreadsheets. This set can be considered the first step in the direction of building a quality standard for spreadsheet models, that is still to be defined. The computation of concrete metric values has further been integrated under a well-established model-driven spreadsheet development environment, providing a framework for the analysis of spreadsheet models under spreadsheets themselves.(undefined

Spreadsheets with a Semantic Layer

Spreadsheets are active documents that are heavily employed in administration, financial forecasting, education, and science because of their intuitive, flexible, and direct approach to computation. But they are also error-prone, poorly documented, often contain actual data in legacy form. Therefore, assistance for high-impact spreadsheet users is needed. To determine what kind of help could be useful, we analyze user expectations with an “Wizard-of-Oz” experiment. This shows that background knowledge is missing in spreadsheets. In the SACHS project we approach the missing background knowledge by adding a semantic layer. We illustrate spreadsheets with a semi-formal domain ontology and equip them with a semantically transparent interface that allows new forms of interaction like “semantic navigation”, “framing”, or “playing with variants”, on which a survey is given. Moreover, an integration of assessment knowledge into the SACHS approach is presented. We model it based on theory graphs and sketch a potential SACHS extension with innovative assessment interaction

Computer‐aided assessment in statistics: The CAMPUS project

This paper describes the specification, features and implementation of computer‐aided assessment software designed primarily for conducting assessments in Statistics but equally applicable to other quantitative disciplines. The CAMPUS (Computer Aided Marking Program Using Spreadsheets) package has been developed in Microsoft Excel so as to provide a familiar computing environment for both assessors and students. The principal feature of CAMPUS is the facility for setting questions containing random elements (including random graphs), so that each student sits essentially the same questions but with different answers. This helps to eliminate plagiarism and allows a single test to be used many times, either for reassessment or additional practice. CAMPUS has been implemented in a higher‐education context but could also be used at school level