Graduate Thesis Or Dissertation
 

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

Public Deposited

Downloadable Content

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

Descriptions

Attribute NameValues
Creator
Abstract
  • 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 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, 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

Relationships

Parents:

This work has no parents.

In Collection:

Items

Thumbnail Title Date Uploaded Visibility Actions
file details BeckwithLauraA2003.pdf 2017-08-15 Public Download