Abstract:Spreadsheets are a widespread functional programming paradigm that offer liveness and directness of interaction. However, spreadsheets are notoriously error-prone and difficult to debug. To overcome this limitation and improve the expressive power of spreadsheets, we propose an extension to the spreadsheet paradigm in the form of sheet-defined lambdas – user-defined functions that abstract computations on the sheet. This concept was developed and deployed in our web-based spreadsheet application named Lattice. We evaluate this approach through a user study which compared the user experience of programming in a spreadsheet with and without lambdas, as well as the difference in performance between learner (N = 12) and experienced (N = 12) programmers. The study measured participant task performance (task time, success rate and number of errors) and the quality of their user experience of using Lattice (video recordings of use, interviews and questionnaire responses). Our findings indicate that programming with lambdas is not only more efficient than writing formulas in a conventional way, but also provides a rewarding hedonic experience. However, we found that learners perceived the concept of functional abstractions with lambdas as difficult to comprehend; while experienced programmers noted potential utilitarian advantages that aid in managing the complexity of a spreadsheet program. The results obtained in this work contribute to a better understanding of human-spreadsheet interaction and can inform the future design of user-friendly computational systems.

Excel in the Teaching of Several Commonly Used Functions

Milestones for Teaching the Spreadsheet Program

Computer-aided calculating in data analysis of pharmaceutics with Microsoft Excel

PERFORMANCE RESEARCH AND IMPROVEMENT ON AN ENTERPRISE SPREADSHEET ENGINE

A Structured Approach to the development of Solutions in Excel

Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel

Application of Excel in Technology Design and the Equipment Calculation of Machines in Cotton Mill

Recording and Compilation of Running Information of Sophisticated Instruments by Excel Software

On the Function and Characteristics of the Art to Handle Classroom Teaching

Teaching statistics with Excel and R

Excel as a Turing-complete Functional Programming Environment

Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function

Teaching Spreadsheets: Curriculum Design Principles

Toward New Vision in Teaching Calculus

The Exploration and Innovation on Basic Computer Experiment Teaching in University

An Electronic Teaching Assistant for Basic Operations Management Methods

Using VBA for microsoft excel based on 6-questions cognitive theory in teaching fraction

Developing a digital game for excel skills learning in higher education - a comparative study analyzing differences in learning between digital games and textbook learning

Current situation and reflections of IT teaching in junior high school--taking the learning of excel as an example

Markov Analysis in Excel and Its Development of Multimedia Courseware

To Abstract or Not to Abstract? A Comparative Study Evaluating the User Experience of Spreadsheet Programming with Sheet-Defined Functional Abstractions