A user-centred approach to functions in Excel

ACM SIGPLAN Notices

Volumn 38, Issue 9, 2003, Pages 165-176

  Jones, Simon Peyton ^a   Blackwell, Alan ^b   Burnett, Margaret ^c  

^a MICROSOFT RESEARCH   (United Kingdom)

^b UNIVERSITY OF CAMBRIDGE   (United Kingdom)

^c OREGON STATE UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER PROGRAMMING; COMPUTER PROGRAMMING LANGUAGES; CONSTRAINT THEORY; HUMAN COMPUTER INTERACTION; MATRIX ALGEBRA; PROGRAM DEBUGGING; VECTORS;

ATTENTION INVESTMENT MODEL; COGNITIVE DIMENSIONS OF NOTATIONS; EXCEL;

SPREADSHEETS;

EID: 1442337718     PISSN: 03621340     EISSN: None     Source Type: Journal    
DOI: 10.1145/944746.944721     Document Type: Conference Paper

References (42)

1. A Ambler. Forms: Expanding the visualness of sheet languages. In Workshop on Visual Languages, Linkoping, Sweden, August 1987.
2. M Burnett and A Ambler. Interactive visual data abstraction in a declarative visual programming language. Journal of Visual Languages and Computing, 5:29-60, March 1994.
3. B Boehm, A Abts, S Brown, B Chulani, E Clark, R Horowitz , D Madachy, Reifer, and B Steece. Software Cost Esimation with COCOMO II. Prentice Hall PTR, Upper Saddle River, NJ, 2000.
4. Margaret Burnett, John Atwood, Rebecca Walpole Djang, Herkimer Gottfried, James Reichtwein, and Sherry Yang. Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm. Journal of Functional Programming, 11:155-206, March 2001.
5. AF Blackwell and M Burnett. Applying attention investment to end-user programming. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. pages 28-30. IEEE Computer Society, September 2002.
6. L. Beckwith, M Burnett, and C Cook. Reasoning about many-to-many requirement relationships in spreadsheets. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. pages 149-157, IEEE Computer Society, September 2002.
7. M Burnett, N Cao, M Arrendondo-Castro, and J Atwood. End-user programming of time as an 'ordinary' dimension in grid-oriented visual programming languages. Journal of Visual Languages and Computing, 13(4):421-447, August 2002.
8. P. Brown and J. Gould. Experimental study of people creating spreadsheets. ACM Transactions on Office Information Systems, 5:258-272, 1987.
9. AF Blackwell and TRG Green. Notational systems - the cognitive dimensions of notations framework. In JM Carroll, editor, HCI Models, Theories, and Frameworks: Toward an Interdisciplinary Science. Morgan Kaufmann, 2003.
10. A Blackwell. See what you need: helping end users to build abstractions. Journal of Visual Languages and Computing, 5:475-499, October 2001.
11. AF Blackwell. First steps in programming: A rationale for attention investment models. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. pages 2-10. IEEE Computer Society, September 2002.
12. E Chi, J Riedl, P Barry, P Konstan, and J Konstan. Principles for information visualization spreadsheets. IEEE Computer Graphics and Applications, pages 30-38, July 1998.
13. C. Corritore and S. Wiedenbeck. Direction and scope of comprehension-related activities by procedural and object-oriented programmers: An empirical study. In International Workshop on Program Comprehension, pages 139-148, Limerick, Ireland, June 2000.
14. JS Davis. Tools for spreadsheet auditing. International Journal of Human-Computer Studies, 45:429-442, 1996.
15. Joseph Dumas and Paige Parsons. Discovering the way programmers think about new programming environments. Communications of the ACM, 38:45-56, June 1995.
16. R Findler, C Flanagan, M Flatt, S Krishnamurthi and M Felleisen. DrScheme: A Pedagogic Programming Environment for Scheme. International Symposium on Programming Languages Implementations, Logics, and Programs (PLILP'97), volume 1292 of Lecture Notes in Computer Science. Springer Verlag, September 1997. pages 369-388.
17. TRG Green and M Petre. Usability analysis of visual programming environments: a "cognitive dimensions" framework. Journal of Visual Languages and Computing, 7:131-174, 1996.
18. T. Green, M. Petre, and R. Bellamy. Comprehensibility of visual and textual programs: A test of superlativism against the 'match-mismatch' conjecture. In Empirical Studies of Programmers: Fourth Workshop, New Brunswick, New Jersey, pages 121-146. Ablex, December 1991.
19. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. IEEE Computer Society, September 2002.
20. Christopher M. Hoadley, Marcia C. Linn, Lydia M. Mann, and Michael J. Clancy. When, why and how do novice programmers reuse code? In Empirical Studies of Programmers: Sixth Workshop. Ablex, 1996.
21. C Hughes and J Moshell. Action Graphics: A spreadsheet-based language for animated simulation. In T Ichikawa, E Jungert, and R Korfhage, editors, Visual Languages and Applications, pages 203-235, Plenum Publishing, 1990.
22. CV Hall and JT O'Donnell. Debugging in a side-effect-free programming environment. In Proc ACM Symposium on Language Issues and Programming Environments. ACM Seattle, January 1985.
23. S Hudson. User interface specification using an enhanced spreadsheet model. ACM Transactions on Graphics, 13:209-239, July 1994.
24. Takeo Igarashi, Jock Mackinlay, Bay-Wei Chang, and Polle Zellweger. Fluid visualization of spreadsheet structures. In IEEE Symposium on Visual Languages, Halifax, Nova Scotia, pages 118-125. IEEE, September 1998.
25. M Levoy. Spreadsheet for images. Computer Graphics, 28:139-146, 1994.
26. Y. Li, J. Grundy, R. Amor, and J. Hosking. A data mapping specification environment using a concrete business form-based metaphor. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. IEEE Computer Society, September 2002, pages 158-166.
27. H. Lieberman. Steps toward better debugging tools for LISP. In ACM Symposium on Lisp and Functional Programming (LFP'84), pages 247-255. ACM, 1984.
28. B Myers. Graphical techniques in a spreadsheet for specifying user interfaces. In ACM Conference on Human Factors in Computing Systems, New Orleans, pages 243-249, April 1991.
29. B. Nardi. A Small Matter of Programming: Perspectives on End User Computing. The MIT Press, Cambridge, MA, 1993.
30. A Newell and SK Card. The prospects for psychological science in human-computer interaction. Human-Computer Interaction, 1:209-242, 1985.
31. Henrik Nilsson. Declarative Debugging for Lazy Functional Languages. PhD thesis, Department of Computer and Information Science, Linköpings universitet, S-581 83, Linköping, Sweden, May 1998.
32. J Nielsen and R Molich. Heuristic evaluation of user interfaces. In Proceedings of ACM CHI'90 Conference, Seattle, pages 249-256, April 1990.
33. RR Panko. What we know about spreadsheet errors. Journal of End User Computing, 10:15-21, 1998.
34. International Symposium on Programming Languages Implementations, Logics, and Programs (PLILP'97), volume 1292 of Lecture Notes in Computer Science. Springer Verlag, September 1997.
35. JF Pane and BA Myers. Usability issues in the design of novice programming systems. Technical Report CMU-CS-96-132, Carnegie Mellon University, School of Computer Science, August 1996.
36. J Pane, B Myers, and L Miller. Using HCI techniques to design a more usable programming system. IEEE Conference on Human-Centric Computing Languages and Environments, Arlington. IEEE Computer Society, September 2002, pages 198-206.
37. G Rothermel, L Li, C DuPuis, and M Burnett. What you see is what you test. In International Conference on Software Engineering, Kyoto, pages 198-207, April 1998.
38. T Smedley, P Cox, and S Byrne. Expanding the utility of spreadsheets through the integration of visual programming and user interface objects. In Advanced Visual Interfaces '96, Gubbio, Italy, pages 148-155, May 1996.
39. J Sparud and C Runciman. Tracing lazy functional computations using redex trails. International Symposium on Programming Languages Implementations, Logics, and Programs (PLILP'97), volume 1292 of Lecture Notes in Computer Science. 1997. Springer Verlag, September 1997.
40. AP Tolmach and AW Appel. Debubbing Standard ML without reverse engineering. In Proc ACM Conference on Lisp and Functional Programming, Nice. ACM, June 1990.
41. D. Ungar and R. Smith. Self: The power of simplicity. ACM Conference on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA), pages 227-242, October 1987.
42. S. Yang, M. Burnett, E. DeKoven, and M. Zloof. Representation design benchmarks: a design-time aid for VPL navigable static representations. Journal of Visual Languages and Computing, 8(5/6):563-599, Oct/Dec 1997.