Twinkling Lights and Nested Loops: Distributed Problem Solving and Spreadsheet Development

Abstract In contrast to the common view of spreadsheets as “single-user” programs, we have found that spreadsheets offer surprisingly strong support for cooperative development of a wide variety of applications. Ethnographic interviews with spreadsheet users showed that nearly all of the spreadsheets used in the work environments studied were the result of collaborative work by people with different levels of programming and domain expertise. We describe how spreadsheet users cooperate in developing, debugging and using spreadsheets. We examine the properties of spreadsheet software that enable cooperation, arguing that: (1) the division of the spreadsheet into two distinct programming layers permits effective distribution of computational tasks across users with different levels of programming skill; and (2) the spreadsheet's strong visual format for structuring and presenting data supports sharing of domain knowledge among co-workers.

[1]  Jaan Valsiner,et al.  Cognition, Symbols, and Vygotsky's Developmental Psychology , 1988 .

[2]  Jonathan Grudin,et al.  Why CSCW applications fail: problems in the design and evaluationof organizational interfaces , 1988, CSCW '88.

[3]  J. Lave.  Cognition in Practice: Outdoors: a social anthropology of cognition in practice , 1988 .

[4]  Donald A. Norman,et al.  Computation via Direct Manipulation. Final Report. , 1988 .

[5]  D. Laplane.  Thought and language. , 1992, Behavioural neurology.

[6]  Bonnie A. Nardi,et al.  Browsing schematics: Query-filtered graphs with context nodes , 1988 .

[7]  M. Kyng,et al.  Computers and Democracy: A Scandinavian Challenge , 1987 .

[8]  R. Rosner.  Computer software , 1978, Nature.

[9]  C. Bosk,et al.  Occupational rituals in patient management. , 1980, The New England journal of medicine.

[10]  Derek Coleman,et al.  Introducing Objectcharts or How to Use Statecharts in Object-Oriented Design , 1992, IEEE Trans. Software Eng..

[11]  James Warner.  Visual data analysis into the '90s , 1990 .

[12]  Kurt W. Piersol.  Object Oriented Spreadsheets: The Analytic Spreadsheet Package , 1986, OOPSLA.

[13]  Ian H. Witten,et al.  Inducing programs in a direct-manipulation environment , 1989, CHI '89.

[14]  Gary M. Olson,et al.  Can principles of cognition lower the barriers to programming? in empirical studies of programmers: , 1987 .

[15]  B. Chandrasekaran,et al.  Natural and Social System Metaphors for Distributed Problem Solving: Introduction to the Issue , 1981, IEEE Transactions on Systems, Man, and Cybernetics.

[16]  David M. Lane,et al.  Impact of a restricted natural language interface on ease of learning and productivity , 1989, CACM.

[17]  S. Engel.  Thought and Language , 1964 .

[18]  John D. Gould,et al.  How People Create Spreadsheets , 1986 .

[19]  Raymond R. Panko.  End user computing: management applications and technology , 1988 .

[20]  Michael Spenke,et al.  A spreadsheet interface for logic programming , 1989, CHI '89.

[21]  Vernon Gregson,et al.  On Learning From an Error , 1983 .

[22]  Deane E. Arganbright.  Mathematical modeling with spreadsheets , 1986 .

[23]  John R. Doyle,et al.  Naïve users and the Lotus* interface: a field study , 1990 .

[24]  G. W. Furnas,et al.  Generalized fisheye views , 1986, CHI '86.

[25]  Ellen D. Hoadley.  Investigating the effects of color , 1990, CACM.

[26]  James D. Hollan,et al.  Direct Manipulation Interfaces , 1985, Hum. Comput. Interact..

[27]  Elliot Soloway,et al.  Empirical Studies of Programmers: Second Workshop , 1991 .

[28]  Sirkka L. Jarvenpaa,et al.  Graphics and managerial decision making: research-based guidelines , 1988, CACM.

[29]  J. Doug Tygar,et al.  Constraining Pictures with Pictures , 1989, IFIP Congress.

[30]  D. Norman.  The psychology of everyday things , 1990 .

[31]  Donald A. Norman,et al.  User Centered System Design , 1986 .

[32]  Bonnie A. Nardi,et al.  The spreadsheet interface: A basis for end user programming , 1990, IFIP TC13 International Conference on Human-Computer Interaction.

[33]  David Harel,et al.  On visual formalisms , 1988, CACM.

[34]  Lisa Rubin Neal,et al.  A system for example-based programming , 1989, CHI '89.

[35]  Kjeld Schmidt,et al.  CSCW: Four Characters in Search of a Context , 1989, ECSCW.

[36]  John D. Gould,et al.  An experimental study of people creating spreadsheets , 1987, TOIS.