Visualising Formula Structures to Support Exploratory Modelling

Chris Roast, Roxanne Leitão, Michael Gunning


Visualisation is often presented as a means of simplifying information and helping people understand complex data. In this paper we describe a project designing interactive visualisations to support learner competencies in the broad area of numeracy. The work builds upon: (i) the observation that while spreadsheets are traditional ICT tools, their familiarity means that they are used for exploratory mathematical modelling; (ii) a research theme examining the human factors that influence the ease with which formal notations can be understood and applied appropriately. Our paper describes the iterative design and evaluation of a tool to visualise spreadsheets, with the aim of supporting mid-teen learners based on the premise that spreadsheets serve as a gateway tool for supporting learner experimentation and confidence within numerate subjects. This iterative process is informed by background research into notational design, graphic design as well as learner and tutor feedback.


  1. Ballinger, D., Biddle, R. and Noble, J., 2003. Spreadsheet structure inspection using low level access and visualisation. In Proc. Fourth Australasian User Interface Conference (AUIC2003). Biddle, R. and Thomas, B., Eds. ACS. 91-94.
  2. Blackwell, A.F., Britton, C., Cox, A. Green, T.R.G., Gurr, C.A., Kadoda, G.F., Kutar, M., Loomes, M., Nehaniv, C.L., Petre, M., Roast, C., Roes, C., Wong, A. and Young, R.M., 2001. Cognitive Dimensions of Notations: Design tools for cognitive technology. In M. Beynon, C.L. Nehaniv, and K. Dautenhahn (Eds.) Cognitive Technology 2001 (LNAI 2117). SpringerVerlag, pp. 325-341.
  3. Burnett, M., Atwood, J., Djang, R., Gottfried, H., Reichwein, J. and Yang, S., 2001. Forms/3: A firstorder visual language to explore the boundaries of the spreadsheet paradigm. Journal of functional programming 11(2): 155-206.
  4. Burnett, M., Sheretov, A., Ren, A. and Rothermel, G., 2002. Testing homogeneous spreadsheet grids with the "what you see is what you test" methodology," IEEE Trans. Softw. Eng., 28(6) pp. 576-594.
  5. Campbell-Kelly, M.,2007. Number crunching without programming: The evolution of spreadsheet usability. IEEE Annals Of The History Of Computing, 29(3), pp.6-19, ISSN: 1058-6180.
  6. Chambers, C. and C. Scaffidi (2010). Struggling to excel: A field study of challenges faced by spreadsheet users. Visual Languages and Human-Centric Computing (VL/HCC), 2010 IEEE Symposium on, IEEE.
  7. Davis, F.D., Bagozzi, R.P. and Warshaw P.R., 1989. User acceptance of computer technology: A comparison of two theoretical models. Management Science, 35 (8) pp. 982-1003.
  8. Gretton, H. and Challis, N., 2008. "Fundamental Engineering Mathematics; A Student Friendly Workbook" Woodhead Publishing, 2008, ISBN-13: 978-1898563655.
  9. Hendry, D.G. and Green, T.R.G., 1994. "Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model." in International Journal of Human-Computer Studies, 40(6), 1033- 1065, DOI=10.1006/ijhc.1994.1047.
  10. Igarashi, T., Mackinlay, J.D., Chang, B-W and Zellweger, P.T., 1998. Fluid Visualization of Spreadsheet Structures, Proceedings of the IEEE Symposium on Visual Languages, p.118.
  11. Leitão,R. and Roast, C., 2014. Developing visualisations for spreadsheet formulae: towards increasing the accessibility of science, technology, engineering and maths subjects. In: 9th Workshop on Mathematical User Interfaces, Coimbra, Portugal, 10 July 2014.
  12. Myers, B. A. (1986). Visual programming, programming by example, and program visualization: a taxonomy. ACM SIGCHI Bulletin 17(4): 59-66.Panko, R. R., 2008. What We Know About Spreadsheet Errors. Journal of End User Computing's Special issue on Scaling Up End User Development 10, 15-21.
  13. Panko, R. R. and Sprague Jr., R. H., 1998. "Hitting the wall: errors in developing and code inspecting a simple spreadsheet model" Decision Support Systems 22(4): 337-353.
  14. Peyton Jones, S., Blackwell, A. and Burnett, M., 2003. A user-centred approach to functions in Excel. In Proceedings of the eighth ACM SIGPLAN international conference on Functional programming (ICFP 7803). ACM, New York, NY, USA, 165-176. DOI=10.1145/944705.944721.
  15. Rello, L., Kanvinde, G. and Baeza-Yates, R., 2012. Layout guidelines for web text and a web service to improve accessibility for dyslexics. Proceedings of the International Cross-Disciplinary Conference on Web Accessibility, ACM.
  16. Saariluoma, P., Sajaniemi, J.,1991. Extracting Implicit Tree Structures in Spreadsheet Calculation. Ergonomics 34(8), 1027-1046.
  17. Sajaniemi, J., 2000. Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization, Journal of Visual Languages and Computing. 11, 49- 82. doi:10.1006/jvlc.1999.0142.
  18. Sorva, J., Karavirta, V. and Malmi, L., 2013. A Review of Generic Program Visualization Systems for Introductory Programming Education. Trans. Comput. Educ. 13, 4. DOI=
  19. Stein, J. and V. Walsh, 1997. "To see but not to read; the magnocellular theory of dyslexia." Trends in neurosciences 20(4): 147-152.
  20. Technology Insights 2012, e-skills UK (Available at

Paper Citation

in Harvard Style

Roast C., Leitão R. and Gunning M. (2016). Visualising Formula Structures to Support Exploratory Modelling . In Proceedings of the 8th International Conference on Computer Supported Education - Volume 1: CSEDU, ISBN 978-989-758-179-3, pages 383-390. DOI: 10.5220/0005812303830390

in Bibtex Style

author={Chris Roast and Roxanne Leitão and Michael Gunning},
title={Visualising Formula Structures to Support Exploratory Modelling},
booktitle={Proceedings of the 8th International Conference on Computer Supported Education - Volume 1: CSEDU,},

in EndNote Style

JO - Proceedings of the 8th International Conference on Computer Supported Education - Volume 1: CSEDU,
TI - Visualising Formula Structures to Support Exploratory Modelling
SN - 978-989-758-179-3
AU - Roast C.
AU - Leitão R.
AU - Gunning M.
PY - 2016
SP - 383
EP - 390
DO - 10.5220/0005812303830390