Contributor: Bio-natural and technical expert collaborator, Faisca, A. M., M. Coord.: Caprile, E. Eds: Addis, C. Castaño, I. Klinge, C. M. Larios, D. Meulders, J. Müller, S. O’Dorchai, M. Palasik, R. Plasman, S. Roivas, F. Sagebiel, L. Schiebinger, N. Vallès, and Vázquez-Cupeiro S. Meta-analysis of gender and science research: Synthesis report. Luxembourg: European Commission, Directorate-General for Research and Innovation, Publications Office of the European Union, 2012.
Cunha, Jácome, João Paulo Fernandes, Jorge Mendes, and João Saraiva. "
MDSheet: A Framework for Model-driven Spreadsheet Engineering."
Proceedings of the 34rd International Conference on Software Engineering. ICSE'12. ACM, 2012. 1395-1398.
Abstractn this paper, we present MDSHEET, a framework for the embedding, evolution and inference of spreadsheet models. This framework offers a model-driven software development mechanism for spreadsheet users.
Cunha, Jácome, João Saraiva, and Joost Visser. "
Model-Based Programming Environments for Spreadsheets."
Programming Languages. Eds. Francisco de Carvalho Junior, and Luis Barbosa. Vol. 7554. Lecture Notes in Computer Science, 7554. Springer Berlin / Heidelberg, 2012. 117-133.
AbstractAlthough spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.
Cunha, Jácome Model-based Spreadsheet Engineering: Using Relational Models to Improve Spreadsheets. Eds. Shahanaz Soogah. LAP LAMBERT Academic Publishing, 2012.
AbstractSpreadsheets can be viewed as programming languages for non-professional programmers. These so-called ``end-user'' programmers vastly outnumber professional programmers creating millions of new spreadsheets every year. As a programming language, spreadsheets lack support for abstraction, testing, encapsulation, or structured programming. As a result, and as numerous studies have shown, the high rate of production is accompanied by an alarming high rate of errors. Some studies report that up to 90% of real-world spreadsheets contain errors. After their initial creation, many spreadsheets turn out to be used for storing and processing increasing amounts of data and supporting increasing numbers of users over long periods of time, making them complicated systems. An emerging solution to handle the complex and evolving software systems is Model-driven Engineering (MDE). To consider models as first class entities and any software artifact as a model or a model element is one of the basic principles of MDE. We adopted some techniques from MDE to solve spreadsheet problems. Most spreadsheets (if not all) lack a proper specification or a model. Using reverse engineering techniques we are able to derive various models from legacy spreadsheets. We use functional dependencies (a formalism that allow us to define how some column values depend on other column values) as building blocks for these models. Models can be used for several spreadsheet improvements, namely refactoring, safe evolution, migration or even generation of edit assistance. The techniques presented in this work are available under the framework HAEXCEL that we developed. It is composed of online and batch tools, reusable HASKELL libraries and OpenOffice.org extensions. A study with several end-users was organized to survey the impact of the techniques we designed. The results of this study indicate that the models can bring great benefits to spreadsheet engineering helping users to commit fewer errors and to work faster.
Monteiro, Rui, João Araújo, Vasco Amaral, Miguel Goulão, and Pedro Patrício. "
Model-Driven Development for Requirements Engineering: The Case of Goal-Oriented Approaches."
8th International Conference on the Quality of Information and Communications Technology (QUATIC 2012). Eds. João Pascoal Faria, Ana Paiva, and Ricardo Machado. Lisbon, Portugal: IEEE CPS, 2012.
AbstractGoal-Oriented Requirements Engineering (GORE) has received increasing attention over the past few years.
There are several goal-oriented approaches, each one using different kinds of models. We argue that it would be useful to relate them or even perform transformations among them automatically, in order to understand their similarities and differences, their advantages and disadvantages, allowing a possible migration or comparison between approaches. This is something that has not received enough attention. In this paper
we propose the definition and implementation of goal model transformations between i* and KAOS. As an immediate contribution, the approach can be used to migrate from one goal model to another through automatic model transformations. This approach also contributes to relate the concepts of i* and KAOS models and will help, for example, a development team in making the decision on which approach to follow, according to the nature of the project and the expressiveness of an approach to represent certain concepts
(e.g., obstacles are represented explicitly in KAOS, but not in i*). Another contribution is to facilitate communication among members of the same team, if they are specialized in different approaches.