Matches in SemOpenAlex for { <https://semopenalex.org/work/W3176172920> ?p ?o ?g. }
- W3176172920 abstract "The use of spreadsheets in industry is widespread. It is known that spreadsheets have an average life span of five years, and during this life span, they are used on average by thirteen different persons. Consequently, spreadsheets need maintenance, and knowledge about the spreadsheet needs to be transferred from one user to another. To minimize the risk of introducing new errors, a thorough understanding of the spreadsheet's formulas is needed during maintenance and knowledge transfer tasks.Research on the use of block-based languages has shown that they positively affect the comprehension of program code. We hypothesize that using a block-based representation of a spreadsheet formula will positively affect formula comprehension.Hence, we extended XLBlocks, a block-based formula editor for spreadsheets, with the functionality to generate a block-based representation of an existing formula. We conduct a think-aloud study with twenty-one experienced spreadsheet users from industry and ask them to perform a set of spreadsheet comprehension tasks using XLBlocks. During an interview, we ask them, using the Cognitive Dimensions of Notations framework, to reflect on the use of XLBlocks.We found that participants preferred to use the block-based representation of formulas when analyzing or explaining formulas or to implement non-trivial changes. Named function parameters and the absence of parentheses and commas make functions easier to understand. Furthermore, the visualization enables the user to separate smaller parts in the formula, which improves comprehension. Finally, the possibility to navigate from formula to formula makes it clear how formulas work together and improve the understanding of the spreadsheet as a whole." @default.
- W3176172920 created "2021-07-05" @default.
- W3176172920 creator A5034150823 @default.
- W3176172920 creator A5057383263 @default.
- W3176172920 date "2021-05-01" @default.
- W3176172920 modified "2023-09-23" @default.
- W3176172920 title "The Effect of a Block-based Language on Formula Comprehension in Spreadsheets" @default.
- W3176172920 cites W1504931050 @default.
- W3176172920 cites W1524044080 @default.
- W3176172920 cites W1553589896 @default.
- W3176172920 cites W1575549743 @default.
- W3176172920 cites W1578962373 @default.
- W3176172920 cites W1899639145 @default.
- W3176172920 cites W1933103375 @default.
- W3176172920 cites W1962796098 @default.
- W3176172920 cites W1969600276 @default.
- W3176172920 cites W1985846218 @default.
- W3176172920 cites W1987842730 @default.
- W3176172920 cites W2026539153 @default.
- W3176172920 cites W2038340833 @default.
- W3176172920 cites W2058413426 @default.
- W3176172920 cites W2060404275 @default.
- W3176172920 cites W2064189581 @default.
- W3176172920 cites W2084671376 @default.
- W3176172920 cites W2084944215 @default.
- W3176172920 cites W2089451637 @default.
- W3176172920 cites W2109545181 @default.
- W3176172920 cites W2117490177 @default.
- W3176172920 cites W2126014381 @default.
- W3176172920 cites W2137619003 @default.
- W3176172920 cites W2144849164 @default.
- W3176172920 cites W2149557049 @default.
- W3176172920 cites W2151867683 @default.
- W3176172920 cites W2169917840 @default.
- W3176172920 cites W2171561334 @default.
- W3176172920 cites W2172161420 @default.
- W3176172920 cites W2469012091 @default.
- W3176172920 cites W2535073923 @default.
- W3176172920 cites W2601734385 @default.
- W3176172920 cites W2734094570 @default.
- W3176172920 cites W2751057302 @default.
- W3176172920 cites W2774136356 @default.
- W3176172920 cites W2796012663 @default.
- W3176172920 cites W2898089993 @default.
- W3176172920 cites W2898211431 @default.
- W3176172920 cites W2915549126 @default.
- W3176172920 cites W2974347137 @default.
- W3176172920 cites W2974439448 @default.
- W3176172920 doi "https://doi.org/10.1109/icpc52881.2021.00035" @default.
- W3176172920 hasPublicationYear "2021" @default.
- W3176172920 type Work @default.
- W3176172920 sameAs 3176172920 @default.
- W3176172920 citedByCount "0" @default.
- W3176172920 crossrefType "proceedings-article" @default.
- W3176172920 hasAuthorship W3176172920A5034150823 @default.
- W3176172920 hasAuthorship W3176172920A5057383263 @default.
- W3176172920 hasBestOaLocation W31761729202 @default.
- W3176172920 hasConcept C107457646 @default.
- W3176172920 hasConcept C149091818 @default.
- W3176172920 hasConcept C154945302 @default.
- W3176172920 hasConcept C170130773 @default.
- W3176172920 hasConcept C177264268 @default.
- W3176172920 hasConcept C17744445 @default.
- W3176172920 hasConcept C199360897 @default.
- W3176172920 hasConcept C199539241 @default.
- W3176172920 hasConcept C204321447 @default.
- W3176172920 hasConcept C24457124 @default.
- W3176172920 hasConcept C2524010 @default.
- W3176172920 hasConcept C2776359362 @default.
- W3176172920 hasConcept C2777210771 @default.
- W3176172920 hasConcept C2777561058 @default.
- W3176172920 hasConcept C2777904410 @default.
- W3176172920 hasConcept C33923547 @default.
- W3176172920 hasConcept C36464697 @default.
- W3176172920 hasConcept C41008148 @default.
- W3176172920 hasConcept C45357846 @default.
- W3176172920 hasConcept C511192102 @default.
- W3176172920 hasConcept C78821406 @default.
- W3176172920 hasConcept C94375191 @default.
- W3176172920 hasConcept C94625758 @default.
- W3176172920 hasConceptScore W3176172920C107457646 @default.
- W3176172920 hasConceptScore W3176172920C149091818 @default.
- W3176172920 hasConceptScore W3176172920C154945302 @default.
- W3176172920 hasConceptScore W3176172920C170130773 @default.
- W3176172920 hasConceptScore W3176172920C177264268 @default.
- W3176172920 hasConceptScore W3176172920C17744445 @default.
- W3176172920 hasConceptScore W3176172920C199360897 @default.
- W3176172920 hasConceptScore W3176172920C199539241 @default.
- W3176172920 hasConceptScore W3176172920C204321447 @default.
- W3176172920 hasConceptScore W3176172920C24457124 @default.
- W3176172920 hasConceptScore W3176172920C2524010 @default.
- W3176172920 hasConceptScore W3176172920C2776359362 @default.
- W3176172920 hasConceptScore W3176172920C2777210771 @default.
- W3176172920 hasConceptScore W3176172920C2777561058 @default.
- W3176172920 hasConceptScore W3176172920C2777904410 @default.
- W3176172920 hasConceptScore W3176172920C33923547 @default.
- W3176172920 hasConceptScore W3176172920C36464697 @default.
- W3176172920 hasConceptScore W3176172920C41008148 @default.
- W3176172920 hasConceptScore W3176172920C45357846 @default.
- W3176172920 hasConceptScore W3176172920C511192102 @default.