Graduate Thesis Or Dissertation
 

A methodology for testing spreadsheet grids

Public Deposited

Downloadable Content

Download PDF
https://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/1z40kw31p

Descriptions

Attribute NameValues
Creator
Abstract
  • Although there has been research into ways to design spreadsheet systems to improve the processes of creating new spreadsheets and of understanding existing ones, little attention has been given to helping users of these environments test their spreadsheets. To help address this need, we introduce two visual approaches to testing large grids in spreadsheet systems. The first approach is a straightforward extension of a visual testing methodology we previously developed for individual cells (and hence is termed the Straightforward approach), and serves as a useful baseline with which to compare the second approach. The second approach, termed the Region Representative approach, contributes scalability by overcoming the inefficiency of the Straightforward approach. Prototypes of both approaches have been tightly integrated into Forms/3, a research spreadsheet language, and communication with the user happens solely through the use of checkbox devices and coloring mechanisms. The intent of this work is to bring to end users at least some of the benefits of formalized notions of testing, without requiring knowledge of testing beyond a naive level.
Resource Type
Date Available
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Academic Affiliation
Non-Academic Affiliation
Subject
Rights Statement
Publisher
Peer Reviewed
Language
Digitization Specifications
  • File scanned at 300 ppi (Monochrome, 8-bit Grayscale) using ScandAll PRO 1.8.1 on a Fi-6670 in PDF format. CVista PdfCompressor 4.0 was used for pdf compression and textual OCR.
Replaces

Relationships

Parents:

This work has no parents.

In Collection:

Items

Thumbnail Title Date Uploaded Visibility Actions
file details SheretovAndrei2000.pdf 2017-08-03 Public Download