Reasoning about many-to-many requirement relationships in spreadsheet grids Public Deposited

http://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/wm117s20t

Descriptions

Attribute NameValues
Creator
Abstract or Summary
  • Traditionally, research into end-user programming has focused on how to make programming more accessible to end users. However, few researchers have considered providing end users with devices to help improve the reliability of the programs they create. To help improve the reliability of spreadsheets created by end users, we are working to allow users to communicate the purpose and other underlying information about their spreadsheets using a form of requirement specifications we call "guards." Guards were initially designed for individual cells but, for large spreadsheets, with replicated/shared formulas across groups of rows or columns, guards can only be practical if users can enter them across these groups of rows or columns. The problem is, this introduces many-to-many relationships, at the intersection of rows and columns with guards. It is not clear how the system should reason and communicate about many-to-many relationships in a way that will make sense to end users. In this thesis, we present the human-centric design rationale for our approach to how the system should reason about such many-to-many relationships. The design decisions are presented with their reasons gleaned from two design-time models--Cognitive Dimensions and Attention Investment--and from the users themselves in a small think-aloud study.
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, 256 Grayscale) using Capture Perfect 3.0.82 on a Canon DR-9080C 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-08-14T17:25:50Z (GMT) No. of bitstreams: 1 BeckwithLauraA2003.pdf: 13862224 bytes, checksum: b7d37b83b59c5725120e99c98df908ed (MD5)
  • description.provenance : Approved for entry into archive by Patricia Black(patricia.black@oregonstate.edu) on 2012-08-14T17:27:47Z (GMT) No. of bitstreams: 1 BeckwithLauraA2003.pdf: 13862224 bytes, checksum: b7d37b83b59c5725120e99c98df908ed (MD5)
  • description.provenance : Made available in DSpace on 2012-08-14T17:27:47Z (GMT). No. of bitstreams: 1 BeckwithLauraA2003.pdf: 13862224 bytes, checksum: b7d37b83b59c5725120e99c98df908ed (MD5) Previous issue date: 2002-11-18
  • description.provenance : Submitted by Sergio Trujillo (jstscanner@gmail.com) on 2012-08-13T20:10:27Z No. of bitstreams: 1 BeckwithLauraA2003.pdf: 13862224 bytes, checksum: b7d37b83b59c5725120e99c98df908ed (MD5)

Relationships

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

Downloadable Content

Download PDF
Citations:

EndNote | Zotero | Mendeley

Items