1 / 1

Spreadsheet Research Issues Questions identified during the FOS’04 Workshop

Spreadsheet Research Issues Questions identified during the FOS’04 Workshop. Use of Types? Managers vs. Programmers Why don’t students design? Is modeling programming? Why/how are spreadsheets used (by individuals? by businesses?) Why are spreadsheets easy to use? Are errors so important?

aiden
Télécharger la présentation

Spreadsheet Research Issues Questions identified during the FOS’04 Workshop

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet Research IssuesQuestions identified during the FOS’04 Workshop Use of Types? Managers vs. Programmers Why don’t students design? Is modeling programming? Why/how are spreadsheets used (by individuals? by businesses?) Why are spreadsheets easy to use? Are errors so important? Cultures of use vs. formality. Tools & frameworks vs. detail & programming. Can we fix the organization (descriptive, normative)? Programming psychology. Being stuck with Excel -- but better? commercial vs. technical success. Testing! Programming power/abstraction and its integration into the world of end users and spreadsheets. HCI lessons from history (and things to make sure to retain): account for collaboration; be fast & responsive; empower individuals; provide a flat, imageable world; support direct manipulation. Do current products retain these benefits? Spreadsheets and training/education. Neglect of powerful features (not a good investment of attention). How to generate insights into the business question (often associated with a surprise about the business) (Steve says these often come from sensitivity testing). Importance of representation. E.g., charts as visualizations. E.g., “has-a” composition diagrams. An instance of the above question: Should we keep users “away” from the spreadsheet for awhile, to keep their thinking high-level? Or, is it better to integrate design notations directly into the spreadsheet? Spreadsheets are programs. Domain knowledge. How to represent changes to copied formulas? Handling of copy chains. (see a VL/HCC’04 paper, also Walpole’s and also Repenning’s work from VL’97, and new work from CMU called “smart editing”). Keeping ranges correct. (E.g., “My data has changed in the following way?”). Is there some benefit to be had from partitioning the types of spreadsheets? The types of users? A whole array in a single cell? (See also Blackwell et al. at VL/HCC’04) User-defined functions (See also Peyton Jones et al. at ICFP’03). Neats & scruffies. Is there a way to make various research prototypes available for wider use? (If we build it, will they come?)

More Related