Title
Spreadsheet Comprehension: Guesswork, Giving Up and Going Back to the Author
Abstract
ABSTRACTSpreadsheet users routinely read, and misread, others' spreadsheets, but literature offers only a high-level understanding of users’ comprehension behaviors. This limits our ability to support millions of users in spreadsheet comprehension activities. Therefore, we conducted a think-aloud study of 15 spreadsheet users who read others’ spreadsheets as part of their work. With qualitative coding of participants’ comprehension needs, strategies and difficulties at 20-second granularity, our study provides the most detailed understanding of spreadsheet comprehension to date. Participants comprehending spreadsheets spent around 40% of their time seeking additional information needed to understand the spreadsheet. These information seeking episodes were tedious: around 50% of participants reported feeling overwhelmed. Moreover, participants often failed to obtain the necessary information and worked instead with guesses about the spreadsheet. Eventually, 12 out of 15 participants decided to go back to the spreadsheet's author for clarifications. Our findings have design implications for reading as well as writing spreadsheets.
Year
DOI
Venue
2021
10.1145/3411764.3445634
Conference on Human Factors in Computing Systems
Keywords
DocType
Citations 
Information seeking,Comprehension,Coding (social sciences),World Wide Web,Feeling,Computer science
Conference
0
PageRank 
References 
Authors
0.34
0
3
Name
Order
Citations
PageRank
Sruti Srinivasa Ragavan100.68
advait sarkar227.83
Andrew Gordon33713268.70