Developing Visualisations For Spreadsheet Formulae: Towards Increasing the Accessibility of Science, Technology, Engineering and Maths Subjects

Spreadsheets are widely used within Science, technology, engineering and maths education. Despite their widespread use, end-user spreadsheet errors are still extremely common and have been shown to have an adverse effect on learning. The textual representation of formulas can be particularly complex and error-prone, exacerbating barriers to dyslexic users. Our work focuses on the design and development of a visual language to graphically represent spreadsheet formulae, with the objective of making them easier to understand than their default textual form. This work contributes to a body of human factors research focused upon spreadsheets.

[1]  Christopher Scaffidi,et al.  Struggling to Excel: A Field Study of Challenges Faced by Spreadsheet Users , 2010, 2010 IEEE Symposium on Visual Languages and Human-Centric Computing.

[2]  Ralph H. Sprague,et al.  Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model , 1998, Decis. Support Syst..

[3]  J. Stein,et al.  To see but not to read; the magnocellular theory of dyslexia , 1997, Trends in Neurosciences.

[4]  S. A. OKE.  Spreadsheet Applications in Engineering Education: A Review* , 2004 .

[5]  Raymond R. Panko,et al.  Spreadsheet Errors: What We Know. What We Think We Can Do , 2008, ArXiv.

[6]  M. A. Tafti,et al.  Dyslexia, a deficit or a difference: Comparing the creativity and memory skills of dyslexic and nondyslexic students in Iran , 2009 .

[7]  Ricardo Baeza-Yates,et al.  Layout guidelines for web text and a web service to improve accessibility for dyslexics , 2012, W4A.

[8]  Suzanne R. Harper,et al.  Promoting Appropriate Uses of Technology in Mathematics Teacher Preparation , 2000 .

[9]  David G. Hendry,et al.  Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model , 1994, Int. J. Hum. Comput. Stud..

[10]  Margaret M. Burnett,et al.  Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm , 2001, Journal of Functional Programming.

[11]  Samantha Sharpe,et al.  British Dyslexia Association , 2015 .

[12]  B. A. Myers,et al.  Visual programming, programming by example, and program visualization: a taxonomy , 1986, CHI '86.

[13]  Peter Gregor,et al.  SeeWord - a personal word processing environment for dyslexic computer users , 2003, Br. J. Educ. Technol..

[14]  Raymond R. Panko,et al.  What we know about spreadsheet errors , 1998 .

[15]  Ronald D. Davis,et al.  The Gift of Dyslexia: Why Some of the Brightest People Can't Read and How They Can Learn , 1993 .