TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors

Soichiro Fujii, Hisao Tamaki

2012

Abstract

We propose the use of spreadsheets representing program executions in introductory programming courses. Each row of a spreadsheet is a snapshot of the execution at each time step showing the values of variables and each column corresponds to a particular variable showing the entire history of its updates. We call such a spreadsheet a tracesheet. We discuss the motivation and potential benefits of the use of tracesheets in introductory programming courses, discuss some design issues, and report on a preliminary implementation of a tracesheet generator for Java.

References

  1. Baecker, R. (1998). Sorting out sorting: a case study of software visualization for teaching computer science. In SoftwareVisualization: Programming as a Multimedia Experience, pages 369-381. MIT Press.
  2. Baecker, R. (1998). Sorting out sorting: a case study of software visualization for teaching computer science. In SoftwareVisualization: Programming as a Multimedia Experience, pages 369-381. MIT Press.
  3. Hundhausen, C. D., Douglas, S. A., and Stasko, J. T. (2002). A meta-study of algorithm visualization effectiveness. Journal of Visual Languages and Computing, 13(3):259-290.
  4. Hundhausen, C. D., Douglas, S. A., and Stasko, J. T. (2002). A meta-study of algorithm visualization effectiveness. Journal of Visual Languages and Computing, 13(3):259-290.
  5. Lahtinen, S.-P., Sutinen, E., and Tarhio, J. (1998). Automated Animation of Algorithms with Eliot. Journal of Visual Languages and Computing, 9(3):337-349.
  6. Lahtinen, S.-P., Sutinen, E., and Tarhio, J. (1998). Automated Animation of Algorithms with Eliot. Journal of Visual Languages and Computing, 9(3):337-349.
  7. Levy, R. B.-B., Ben-Ari, M., and Uronen, P. A. (2003). The Jeliot 2000 program animation system. Computers and Education, 40(1):1-15.
  8. Levy, R. B.-B., Ben-Ari, M., and Uronen, P. A. (2003). The Jeliot 2000 program animation system. Computers and Education, 40(1):1-15.
  9. Microsoft Corporation (1985). Microsoft excel. http://office.microsoft.com/en-us/excel.
  10. Microsoft Corporation (1985). Microsoft excel. http://office.microsoft.com/en-us/excel.
  11. Moreno, A., Myller, N., Sutinen, E., and Ben-Ari, M. (2004). Visualizing programs with Jeliot 3. In Proceedings of the Working Conference on Advanced Visual Interfaces, pages 373-376. ACM Press.
  12. Moreno, A., Myller, N., Sutinen, E., and Ben-Ari, M. (2004). Visualizing programs with Jeliot 3. In Proceedings of the Working Conference on Advanced Visual Interfaces, pages 373-376. ACM Press.
  13. Sajaniemi, J. and Kuittinen, M. (2003). Program animation based on the roles of variables. In Proceedings of the 2003 ACM symposium on Software visualization, pages 7-16. ACM Press.
  14. Sajaniemi, J. and Kuittinen, M. (2003). Program animation based on the roles of variables. In Proceedings of the 2003 ACM symposium on Software visualization, pages 7-16. ACM Press.
  15. Shaffer, C. A., Cooper, M. L., Alon, A. J. D., Akbar, M., Stewart, M., Ponce, S., and Edwards, S. H. (2010). Algorithm Visualization: The State of the Field. ACM Transactions on Computing Education, 10(3):1-22. Microsystems (1995). Java.
  16. Shaffer, C. A., Cooper, M. L., Alon, A. J. D., Akbar, M., Stewart, M., Ponce, S., and Edwards, S. H. (2010). Algorithm Visualization: The State of the Field. ACM Transactions on Computing Education, 10(3):1-22. Microsystems (1995). Java.
  17. Sutinen, E., Tarhio, J., and Teräsvirta, T. (2003). Easy Algorithm Animation on the Web. Multimedia Tools and Applications, 19(2):179-194.
  18. Sutinen, E., Tarhio, J., and Teräsvirta, T. (2003). Easy Algorithm Animation on the Web. Multimedia Tools and Applications, 19(2):179-194.
  19. Timsit, C. and Zertal, S. (2010). Using spreadsheets to teach computer architecture. In CSEDU 2010 2nd International Conference on Computer Supported Education, pages 101-105. INSTICC.
  20. Timsit, C. and Zertal, S. (2010). Using spreadsheets to teach computer architecture. In CSEDU 2010 2nd International Conference on Computer Supported Education, pages 101-105. INSTICC.
  21. Urquiza-Fuentes, J. and Íngel Velázquez-Iturbide, J. (2009). A Survey of Successful Evaluations of Program Visualization and Algorithm Animation Systems. ACM Transactions on Computing Education, 9(2):1-21.
  22. Urquiza-Fuentes, J. and Íngel Velázquez-Iturbide, J. (2009). A Survey of Successful Evaluations of Program Visualization and Algorithm Animation Systems. ACM Transactions on Computing Education, 9(2):1-21.
Download


Paper Citation


in Harvard Style

Fujii S. and Tamaki H. (2012). TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors . In Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU, ISBN 978-989-8565-06-8, pages 158-163. DOI: 10.5220/0003916701580163


in Harvard Style

Fujii S. and Tamaki H. (2012). TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors . In Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU, ISBN 978-989-8565-06-8, pages 158-163. DOI: 10.5220/0003916701580163


in Bibtex Style

@conference{csedu12,
author={Soichiro Fujii and Hisao Tamaki},
title={TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors},
booktitle={Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU,},
year={2012},
pages={158-163},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003916701580163},
isbn={978-989-8565-06-8},
}


in Bibtex Style

@conference{csedu12,
author={Soichiro Fujii and Hisao Tamaki},
title={TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors},
booktitle={Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU,},
year={2012},
pages={158-163},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003916701580163},
isbn={978-989-8565-06-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU,
TI - TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors
SN - 978-989-8565-06-8
AU - Fujii S.
AU - Tamaki H.
PY - 2012
SP - 158
EP - 163
DO - 10.5220/0003916701580163


in EndNote Style

TY - CONF
JO - Proceedings of the 4th International Conference on Computer Supported Education - Volume 1: CSEDU,
TI - TRACESHEETS - Spreadsheets of Program Executions as a Common Ground between Learners and Instructors
SN - 978-989-8565-06-8
AU - Fujii S.
AU - Tamaki H.
PY - 2012
SP - 158
EP - 163
DO - 10.5220/0003916701580163