Documents

DOI

Spreadsheets are frequently used in industry to support critical business decisions. Unfortunately, they also suffer from error-proneness, which sometimes results in costly consequences. Experiments in the field of program education have shown that programmers tend to make fewer errors and can better focus on the logic of a program if they use a block-based language instead of a textual one. We hypothesize that a block-based formula editor could support spreadsheet users in a similar way. Therefore, we develop XLBlocks and conduct a think-aloud study with 13 experienced spreadsheet users from industry. Participants are asked to create and edit several formulas, using our block-based language. We then ask them to evaluate this editor using the Cognitive Dimensions of Notations framework. We found that for all dimensions the block-based formula editor received a better evaluation than the default text-based formula editor.
Original languageEnglish
Title of host publication2019 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
EditorsJ. Smith, C.A. Bogart, J. Good, S.D. Fleming
Place of PublicationPiscataway
PublisherIEEE
Pages55-63
Number of pages9
ISBN (Electronic)978-1-7281-0810-0
ISBN (Print)978-1-7281-0811-7
DOIs
Publication statusPublished - 2019
Event2019 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC) - Memphis, United States
Duration: 14 Oct 201918 Oct 2019

Conference

Conference2019 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
CountryUnited States
CityMemphis
Period14/10/1918/10/19

ID: 56320988