oalib
Search Results: 1 - 10 of 100 matches for " "
All listed articles are free for downloading (OA Articles)
Page 1 /100
Display every page Item
Establishing and Measuring Standard Spreadsheet Practices for End-Users  [PDF]
Garry Cleere
Computer Science , 2008,
Abstract: This paper offers a brief review of cognitive verbs typically used in the literature to describe standard spreadsheet practices. The verbs identified are then categorised in terms of Bloom's Taxonomy of Hierarchical Levels, and then rated and arranged to distinguish some of their qualities and characteristics. Some measurement items are then evaluated to see how well computerised test question items validate or reinforce training or certification. The paper considers how establishing standard practices in spreadsheet training and certification can help reduce some of the risks associated with spreadsheets, and help promote productivity.
An Experiment of Evaluating Software Understandability
Shinji UCHIDA,Kazuyuki SHIMA
Journal of Systemics, Cybernetics and Informatics , 2004,
Abstract: Software understandability is one of important characteristics of software quality because it can influence cost or reliability at software evolution in reuse or maintenance. But it is difficult to evaluate software understandability because understanding is an internal process of humans. So, we propose "software overhaul" as a method for externalizing process of understanding software systems and propose a probability model for evaluating software understandability based on it. This paper presented the experiment of evaluating software understandability using a probabilistic model.
МЕТРИЧНЕ ЗАБЕЗПЕЧЕННЯ ВЛАСТИВОСТ РОЗУМ ННЯ ПРОГРАМ Software metrics for attribute understandability Mетрическое обеспечение свойства понимаемости программ
М.Г. Луцький,О.П. Дишлевий
Proceedings of National Aviation University , 2010,
Abstract: Розглянуто п дб р метрик для властивост розум ння програм. Проведено анал з властивост розум ння та п д брано метрики методом ц ль–питання–метрика . Зб р даних виконано вим рюванням п д браних метрик спец альними засобами. Анал з даних проведено предметно-ор нтованим методом побудови залежностей м ж метриками програмного забезпечення. П дтверджено метричне забезпечення властивост розум ння . Розраховано вагом сть кожно метрики для властивост . The article is dedicated to selection of software metrics for attribute understandability. The attribute understandability has been analyzed and selection of metrics has been made by goal-question-metrics method. Data collection has been made with using subject-oriented method of making dependences between software metrics. As a result of analysis software metrics has been confirmed for attribute understandability. Validity of each metric was calculated for this attribute. Рассмотрен подбор метрик для свойства понимаемость программ. Проведен анализ свойства понимаемость и подобраны метрики методом цель–вопрос–метрика . Сбор данных проведен измерением подобранных метрик специальными средствами. Анализ данных осуществлен предметно-ориентированным методом построения зависимостей между метриками программного обеспечения. Подтверждено метрическое обеспечение свойства понимаемость . Рассчитана весомость каждой метрики для этого свойства.
Spreadsheet Debugging  [PDF]
Yirsaw Ayalew,Roland Mittermeir
Computer Science , 2008,
Abstract: Spreadsheet programs, artifacts developed by non-programmers, are used for a variety of important tasks and decisions. Yet a significant proportion of them have severe quality problems. To address this issue, our previous work presented an interval-based testing methodology for spreadsheets. Interval-based testing rests on the observation that spreadsheets are mainly used for numerical computations. It also incorporates ideas from symbolic testing and interval analysis. This paper addresses the issue of efficiently debugging spreadsheets. Based on the interval-based testing methodology, this paper presents a technique for tracing faults in spreadsheet programs. The fault tracing technique proposed uses the dataflow information and cell marks to identify the most influential faulty cell(s) for a given formula cell containing a propagated fault.
A Metrics Based Model for Understandability Quantification  [PDF]
Mohd Nazir,Raees A. Khan,Khurram Mustafa
Computer Science , 2010,
Abstract: Software developers and maintainers need to read and understand source programs and other software artifacts. The increase in size and complexity of software drastically affects several quality attributes, especially understandability and maintainability. False interpretation often leads to ambiguities, misunderstanding and hence to faulty development results. Despite the fact that software understandability is vital and one of the most significant components of the software development process, it is poorly managed. This is mainly due to the lack of its proper management and control. The paper highlights the importance of understandability in general and as a factor of software testability. Two major contributions are made in the paper. A relation between testability factors and object oriented characteristics has been established as a first contribution. In second contribution, a model has been proposed for estimating understandability of object oriented software using design metrics. In addition, the proposed model has been validated using experimental try-out.
Spreadsheet Refactoring  [PDF]
Patrick O'Beirne
Computer Science , 2010,
Abstract: Refactoring is a change made to the internal structure of software to make it easier to understand and cheaper to modify without changing its observable behaviour. A database refactoring is a small change to the database schema which improves its design without changing its semantics. This paper presents example 'spreadsheet refactorings', derived from the above and taking into account the unique characteristics of spreadsheet formulas and VBA code. The techniques are constrained by the tightly coupled data and code in spreadsheets.
Towards a Spreadsheet Engineering  [PDF]
V. R. Vemula,David Ball,Simon Thorne
Computer Science , 2008,
Abstract: In this paper, we report some on-going focused research, but are further keen to set it in the context of a proposed bigger picture, as follows. There is a certain depressing pattern about the attitude of industry to spreadsheet error research and a certain pattern about conferences highlighting these issues. Is it not high time to move on from measuring spreadsheet errors to developing an armoury of disciplines and controls? In short, we propose the need to rigorously lay the foundations of a spreadsheet engineering discipline. Clearly, multiple research teams would be required to tackle such a big task. This suggests the need for both national and international collaborative research, since any given group can only address a small segment of the whole. There are already a small number of examples of such on-going international collaborative research. Having established the need for a directed research effort, the rest of the paper then attempts to act as an exemplar in demonstrating and applying this focus. With regard to one such of research, in a recent paper, Panko (2005) stated that: "...group development and testing appear to be promising areas to pursue". Of particular interest to us are some gaps in the published research record on techniques to reduce errors. We further report on the topics: techniques for cross-checking, time constraints effects, and some aspects of developer perception.
Spreadsheet Hell  [PDF]
Simon Murphy
Computer Science , 2008,
Abstract: 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 developers working with large corporations, either as employees or consultants or contractors. It provides commercial examples of some of the practicalities involved with spreadsheet use around the enterprise.
A Primer on Spreadsheet Analytics  [PDF]
Thomas A. Grossman
Computer Science , 2008,
Abstract: This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts,and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.
How do you know your spreadsheet is right?  [PDF]
Philip L. Bewig
Computer Science , 2013,
Abstract: Principles, Techniques and Practice of Spreadsheet Style
Page 1 /100
Display every page Item


Home
Copyright © 2008-2017 Open Access Library. All rights reserved.