A methodology for testing spreadsheet grids Public Deposited

http://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/1z40kw31p

Descriptions

Attribute NameValues
Creator
Abstract or Summary
  • 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 Copyright
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Academic Affiliation
Non-Academic Affiliation
Subject
Rights Statement
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
Additional Information
  • description.provenance : Approved for entry into archive by Patricia Black(patricia.black@oregonstate.edu) on 2012-09-10T15:48:59Z (GMT) No. of bitstreams: 1 SheretovAndrei2000.pdf: 4228967 bytes, checksum: 00b13ab21f76a34dbbc19b91f2172f1b (MD5)
  • description.provenance : Approved for entry into archive by Patricia Black(patricia.black@oregonstate.edu) on 2012-09-10T15:51:07Z (GMT) No. of bitstreams: 1 SheretovAndrei2000.pdf: 4228967 bytes, checksum: 00b13ab21f76a34dbbc19b91f2172f1b (MD5)
  • description.provenance : Made available in DSpace on 2012-09-10T15:51:07Z (GMT). No. of bitstreams: 1 SheretovAndrei2000.pdf: 4228967 bytes, checksum: 00b13ab21f76a34dbbc19b91f2172f1b (MD5) Previous issue date: 2000-01-14
  • description.provenance : Submitted by John Valentino (valentjo@onid.orst.edu) on 2012-09-08T00:18:56Z No. of bitstreams: 1 SheretovAndrei2000.pdf: 4228967 bytes, checksum: 00b13ab21f76a34dbbc19b91f2172f1b (MD5)

Relationships

In Administrative Set:
Last modified: 08/03/2017

Downloadable Content

Download PDF
Citations:

EndNote | Zotero | Mendeley

Items