End-user encounters with lambda abstraction in spreadsheets: Apollo's bow or Achilles' heel?Full paper
The value of computational abstractions to non-expert end-user programmers is contentious. We study reactions to the LAMBDA function in Microsoft Excel, which enables users to define their own functions using the spreadsheet formula language, through a thematic analysis of nearly 2,700 comments posted on the Reddit, Hacker News, YouTube, and Microsoft Tech Community online forums. We find that computational abstractions are viewed both as helpful and harmful, that users encounter learning and understanding barriers to applying them, and that there are deficiencies and opportunities in tooling such as in formula editing, versioning, reuse and sharing. We find that the introduction of LAMBDA prompts new debate around whether spreadsheets are code, whether writing formulas can be considered programming, and whether spreadsheet users identify themselves as programmers.
Thu 15 SepDisplayed time zone: Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna change
09:00 - 10:30 | |||
09:00 30mTalk | Accessibility of UI Frameworks and Libraries for Programmers with Visual ImpairmentsFull paper Research Papers Maulishree Pandey University of Michigan School of Information, Sharvari Bondre University of Michigan School of Information, Sile O'Modhrain University of Michigan, Steve Oney University of Michigan DOI | ||
09:30 30mTalk | Barriers in Front-End Web DevelopmentFull paper Research Papers DOI | ||
10:00 30mTalk | End-user encounters with lambda abstraction in spreadsheets: Apollo's bow or Achilles' heel?Full paper Research Papers Advait Sarkar Microsoft, Sruti Srinivasa Ragavan Microsoft Research; School of EECS, Oregon State University, Jack Williams Microsoft, Andrew D. Gordon Microsoft Research and University of Edinburgh DOI |