Spreadsheet Comprehension: Guesswork, Giving up and Going back to the Author

要旨

Spreadsheet users routinely read, and misread, others' spreadsheets, but literature offers only a high-level understanding of users' comprehension behaviours. 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.

著者
Sruti Srinivasa Ragavan
Microsoft Research, Cambridge, United Kingdom
Advait Sarkar
Microsoft Research, Cambridge, United Kingdom
Andrew D Gordon
Microsoft Research, Cambridge, United Kingdom
DOI

10.1145/3411764.3445634

論文URL

https://doi.org/10.1145/3411764.3445634

動画

会議: CHI 2021

The ACM CHI Conference on Human Factors in Computing Systems (https://chi2021.acm.org/)

セッション: Trust, Transparency & Sharing Online

[B] Paper Room 07, 2021-05-14 01:00:00~2021-05-14 03:00:00 / [C] Paper Room 07, 2021-05-14 09:00:00~2021-05-14 11:00:00 / [A] Paper Room 07, 2021-05-13 17:00:00~2021-05-13 19:00:00
Paper Room 07
14 件の発表
2021-05-14 01:00:00
2021-05-14 03:00:00
日本語まとめ
読み込み中…