Graduate Thesis Or Dissertation
 

End-user software engineering in the spreadsheet paradigm

Público Deposited

Contenido Descargable

Descargar PDF
https://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/zg64tr080

Descriptions

Attribute NameValues
Creator
Abstract
  • Spreadsheets are among the most widely used end-user programming systems. Unfortunately, there is a high incidence of errors in end-user spreadsheets, and some of these errors have high impact. In this dissertation, we describe techniques we have developed to help end users develop safer spreadsheets. As part of our research, we have examined typical software development activities like programming, testing, and debugging from an end-user software engineering perspective, and developed approaches to support them better. To achieve this goal, we have drawn extensively from research in the areas of software engineering and programming languages to develop techniques for the following. 1. Prevention of reference, range, and type errors by generating spreadsheets from user-defined templates. 2. Detection of unit errors by carrying out automatic consistency checking of spreadsheet formulas using labels within spreadsheets. 3. Detection of faults within spreadsheets by helping end users test better using constraint-based automatic test-case generation. 4. Correction of identified faults within spreadsheet formulas using a spreadsheet debugger that exploits the user’s expectations about the output of their spreadsheets.
License
Resource Type
Fecha Disponible
Fecha de Emisión
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Academic Affiliation
Non-Academic Affiliation
Subject
Declaración de derechos
Publisher
Language
File Format
File Extent
  • 5396539 bytes
Replaces

Relaciones

Parents:

This work has no parents.

En Collection:

Elementos