Abstract
Spreadsheets have become very popular tools for analyzing and visualizing data from business and science. To better understand human-spreadsheet interaction, we explore readers’ information models, but in contrast to most studies we focus on spreadsheet readers rather than spreadsheet authors. We conducted a study using the repertory grid technique and analyzed the result with the help of a Generalized Procrustes Analysis yielding a deeper understanding of human’s information model of spreadsheets. Based on this we envision new human-spreadsheet interactions to increase the readibility and thus, usability of spreadsheets.
Chapter PDF
Similar content being viewed by others
Keywords
References
Caulkins, J.P., Morrison, E.L., Weidemann, T.: Spreadsheet errors and decision making: evidence from field interviews. JOEUC 19(3), 1–23 (2007)
Chambers, C., Scaffidi, C.: Struggling to excel: a field study of challenges faced by spreadsheet users. In: VLHCC 2010, Washington, DC, USA, pp. 187–194 (2010) ISBN 978-0-7695-4206-5
Dillmann, R., Beyerer, J., Hanebeck, U.D., Schultz, T. (eds.): KI 2010. LNCS (LNAI), vol. 6359. Springer, Heidelberg (2010)
EUSPRIG, European spreadsheet risks interest group (2010), http://www.eusprig.org
Grice, J.W.: Generalized procrustes analysis example with annotation (2007)
Hendry, D.G., Green, T.R.G.: CogMap: a visual description language for spreadsheets. J. Vis. Lang. Comput. 4(1), 35–54 (1993)
Hendry, D.G., Green, T.R.G.: Creating, comprehending and explaining spread-sheets: a cognitive interpretation of what discretionary users think of the spreadsheet model. Int. J. Hum.-Comput. Stud. 40(6), 1033–1065 (1994)
Jankowicz, D.: The easy guide to repertory grids. Wiley (2003) ISBN 0470854049
Kelly, G.: International handbook of personal construct technology, pp. 3–20 (2003)
Ko, A.J., Abraham, R., Beckwith, L., Blackwell, A., Burnett, M., Erwig, M., Scaffidi, C., Lawrance, J., Lieberman, H., Myers, B., Rosson, M.B., Rothermel, G., Shaw, M., Wie-denbeck, S.: The state of the art in end-user software engineering. ACM Comput. Surv. 43(3), 21:1–21:44 (2011) ISSN 0360-0300
Kohlhase, A.: Towards user assistance for documents via interactional semantic technology. In: [3], pp. 107–115 (2010)
Lewis, C., Olson, G.: Can principles of cognition lower the barriers to programming? In: Sheppard, S., Soloway, E. (eds.) Empirical Studies of Programmers, Norwood, NJ, USA, pp. 248–263 (1987)
McKnight, C.: The personal construction of information space. Journal of the American Society for Information Science 51(8), 730–733 (2000) ISSN 1097-4571
McLuhan, M.: Understanding media: the extensions of man. McGraw-Hill, New York (1964)
Nardi, B.A., Miller, J.R.: An ethnographic study of distributed problem solving in spreadsheet development, pp. 197–208 (1990)
Panko, R.R.: Spreadsheet errors: what we know. what we think we can do. In: [20] (2000)
Powell, S.G., Baker, K.R., Lawson, B.: A critical review of the literature on spreadsheet errors. Decision Support Systems 46(1), 128–138 (2008)
Probst, G., Raub, S., Romhardt, K.: Wissen managen, 4th edn. Gabler Verlag (1997)
Scaffidi, C., Shaw, M., Myers, B.A.: Estimating the numbers of end users and end user programmers, pp. 207–214 (2005)
Symp. of the european spreadsheet risks interest group (eusprig 2000)
Tan, F.B., Hunter, M.G.: The repertory grid technique: a method for the study of cognition in information systems. MIS Quarterly 26(1), 39–57 (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kohlhase, A. (2013). Human-Spreadsheet Interaction. In: Kotzé, P., Marsden, G., Lindgaard, G., Wesson, J., Winckler, M. (eds) Human-Computer Interaction – INTERACT 2013. INTERACT 2013. Lecture Notes in Computer Science, vol 8120. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-40498-6_47
Download citation
DOI: https://doi.org/10.1007/978-3-642-40498-6_47
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-40497-9
Online ISBN: 978-3-642-40498-6
eBook Packages: Computer ScienceComputer Science (R0)