No half-measures: A study of manual and tool-assisted end-user programming tasks in Excel

Rahul Pandita, Chris Parnin, Felienne Hermans, Emerson Murphy-Hill

Research output: Chapter in Book / Report / Conference proceedingConference contributionAcademicpeer-review

Abstract

The popularity of end-user programming has lead to diverse end-user development environments. Despite accurate and efficient tools available in such environments, end-user programmers often manually complete tasks. What are the consequences of rejecting these tools? In this paper, we answer this question by studying end-user programmers completing four tasks with and without tools. In analyzing 111 solutions to each of these tasks, we observe that neither tool use nor tool rejection was consistently more accurate or efficient. In some cases, tool users took nearly twice as long to solve problems and over-relied on tools, causing errors in 95% of solutions. Compared to manual task completion, the primary benefit of tool use was narrowing the kinds of errors that users made. We also observed that partial tool use can be worse than no tool use at all.

Original languageEnglish
Title of host publicationProceedings - 2018 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2018
EditorsCaitlin Kelleher, Gregor Engels, Joao Paulo Fernandes, Jacome Cunha, Jorge Mendes
PublisherIEEE Computer Society
Pages95-103
Number of pages9
ISBN (Electronic)9781538642351
DOIs
Publication statusPublished - 23 Oct 2018
Externally publishedYes
Event2018 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2018 - Lisbon, Portugal
Duration: 1 Oct 20184 Oct 2018

Publication series

NameProceedings of IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC
Volume2018-October
ISSN (Print)1943-6092
ISSN (Electronic)1943-6106

Conference

Conference2018 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2018
CountryPortugal
CityLisbon
Period1/10/184/10/18

Cite this