TL;DR
EQUS is an interactive visualization tool for spreadsheet formulae designed to improve understanding, developed through iterative refinement with teenage learners, and now integrated into MS Excel for broader usability.
Contribution
This paper introduces EQUS, a novel visualization tool for spreadsheet formulae, created through iterative design and evaluation, enhancing comprehension for diverse spreadsheet users.
Findings
Visualisation aids understanding of complex formulae
Iterative design improved usability and clarity
Successfully integrated as an MS Excel plug-in
Abstract
Visualisation is often presented as a means of simplifying information and helping people understand complex data. In this paper we describe the design, development and evaluation of an interactive visualisation for spreadsheet formulae (EQUS). The work is justified on the grounds that these are widely used tools for significant numerical processing and modeling, yet the formula developed can be easily misunderstood. The development process was one of iterative refinement engaging an initial target audience of mid-teen learners, involving re-design and formative evaluation. The resulting visualisation techniques have been found to be broadly relevant to spreadsheet users beyond the initial target audience. EQUS has since been developed as fully integrated plug-in for MS Excel.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsSpreadsheets and End-User Computing · Statistics Education and Methodologies · Educational Games and Gamification