A Pragmatic Approach to Spreadsheet Training Based Upon the “Projection–Screen” Model

  • Karin Hodnigg
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3422)


Spreadsheets are part of the educational syllabus of instruction for secondary schools in Austria. They are mainly taught using applications, disregarding the fact that building spreadsheets is programming. But the programming nature of spreadsheets is undeniable. Data in cells is interconnected with a rather sophisticated formula language. Since the spreadsheet paradigm differs from common procedural or object-oriented paradigms that students may already be aware of, teaching spreadsheets is a complex task. Moreover, the data flow paradigm is a concept foreign to students or trainees.

Lack of proper paradigms or computational models even complicates the situation. Is there a so called spreadsheet didactics – and if not, how should it look like? Should teachers train spreadsheet applications or insist on building models before implementing? How should they consider the spreadsheet programming viewpoint – without students scaring away and without loosing the spreadsheet’s charm since they are said to be easy to use? This paper presents the main problem fields, presents a didactical model, and finally presents some rather pragmatic advice on how to teach spreadsheets.


Data Dependency Pragmatic Approach Graph Reduction Spreadsheet Model Data Dependency Graph 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [ACM00]
    Ayalew, Y., Clermont, M., Mittermeir, R.T.: Detecting errors in spreadsheets. In: EuSpRIG 2000 Symposium - Spreadsheet Risks, Audit and Development Methods (2000)Google Scholar
  2. [BBN03]
    Ballinger, D., Biddle, R., Noble, J.: Spreadsheet structure inspection using low level access and visualization. In: Proceedings of the Fourth Australian user interface conference on User Interfaces 2003, vol. 18, pp. 91–94 (2003)Google Scholar
  3. [BCP+03]
    Burnett, M., Cook, C., Pendse, O., Rothermel, G., Summet, J., Wallace, C.: End-user software engineering with assertions in the spreadsheet paradigm. In: International Conference on Software Engineering 2003, Portland, Oregon (2003)Google Scholar
  4. [CHM02]
    Clermont, M., Hanin, C., Mittermeir, R.: A spreadsheet auditing tool evaluated in an industrial context. In: Proceedings of the 3rd Annual Symposium of the EuSpRIG (2002)Google Scholar
  5. [Cle03]
    Clermont, M.: A Scalable Approach to Spreadsheet Visualization. PhD thesis, University of Klagenfurt (2003)Google Scholar
  6. [CRBK98]
    Chi, E.H.-H., Riedl, J., Barry, P., Konstan, J.: Principles for information visualization spreadsheets. IEEE ComputerGraphics 18(4), 30–38 (1998)Google Scholar
  7. [EM94]
    Ellis, S., Maltzahn, C.: Collaboration with spreadsheets. Journal of the Brazilian Computer Society 1(Special Edition on CSCW), 15–23 (1994)Google Scholar
  8. [Fil98]
    Filby, W.G.: Spreadsheets in Science and engineering. Springer, Heidelberg (1998)Google Scholar
  9. [HK04]
    Clermont, M., Hodnigg, K., Mittermeir, R.: Computational models of spreadsheet devlopment: Basis for educational approaches. In: Proceedings of EuSpRIG 2004, vol. 5, pp. 153–168 (2004)Google Scholar
  10. [IMCZ98]
    Igarashi, T., Mackinlay, J., Chang, B.-W., Zellweger, P.: Fluid visualization of spreadsheet structures. In: Proceedings of the 1998 IEEE Symposium on Visual Languages (1998)Google Scholar
  11. [KCK+01]
    Krishna, V., Cook, C., Keller, D., Cantrell, J., Wallace, C., Burnett, M., Rothermel, G.: Incorporating incremental validation and impact analysis into spreadsheet maintenance: An empirical study. In: Proceedings of the International Conference on Software Maintenance (November 2001)Google Scholar
  12. [Lar02]
    Larmann, C.: Applying UML and Patterns. Prentice-Hall, Englewood Cliffs (2002)Google Scholar
  13. [NM90]
    Nardi, B.A., Miller, J.R.: The spreadsheet interface: A basis for end user programming (1990)Google Scholar
  14. [Pan00]
    Panko, R.: What we know about spreadsheet errors. Journal of End Users Computing’s Special Issue on Scling Up End User Development 10(2), 15–21 (Spring 1998)Google Scholar
  15. [RB00]
    Rajlich, V., Bennet, K.: Software maintainance and evolution: A roadmap. In: Finkelstein, A. (ed.) The future of Software Engineering (2000)Google Scholar
  16. [RPL89]
    Ronen, B., Palley, R., Lucas, H.: Spreadsheet analysis and design. Communications of the ACM 32 (1), 84–93 (1989)CrossRefGoogle Scholar
  17. [Saj98]
    Sajaniemi, J.: Modelling spreadsheet audit: A rigorous approach to automatic visualization (1998)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • Karin Hodnigg
    • 1
  1. 1.Institut für InformatiksystemeKlagenfurt UniversityAustria

Personalised recommendations