article

Free access

Excel as an algorithm animation environment

Authors:

E. Rautama,

E. Sutinen,

J. TarhioAuthors Info & Claims

ACM SIGCSE Bulletin, Volume 29, Issue 3

Pages 24 - 26

https://doi.org/10.1145/268809.268829

Published: 04 June 1997 Publication History

PDF eReader

Abstract

Understanding of fundamental algorithms and designing algorithms for a novel problem are basic skills in Computer Science. Animation is a useful aid in both these areas. We show how to animate algorithms with Microsoft Excel using data visualization and macro programming features of Excel. The user writes an algorithm using the Visual Basic programming language of Excel and defines charts visualizing dynamically the data structures of the algorithm. This approach is suitable especially for small-scale animation, e.g. for course assignments in Computer Science.

References

[1]

Brown, M. Algorithm Animation. MIT Press, 1988.

Digital Library

Google Scholar

[2]

Lahtinen, S.-P., Lamminjoki, T., Sutinen, E. Tuovinen, A.- P. and Tarhio, J. Towards automated animation of algorithms. In: Proceedings of Fourth International Conference in Central Europe on Computer Graphics and Visualization 96 (ed. N. Thalmann and V. Skala). University of West Bohemia, Department of Computer Science, 1996, 150-161.

Google Scholar

[3]

London, R. and Duisberg, R. Animating programs using Smalltalk. Computer 18, 8, (1985), 61-71.

Digital Library

Google Scholar

[4]

Myers, B. Taxonomies of visual programming and program visualization. Journal of Visual Languages and Computing, 1, 1990, 97-123.

Digital Library

Google Scholar

[5]

Sedgewick, R. Algorithms. Second edition, Addison- Wesley, 1988, 198-201.

Digital Library

Google Scholar

[6]

Silva, A. Simulating electrical circuits with an electronic spreadsheet. Computers & Education, 22, 4 (1994), 345-353.

Digital Library

Google Scholar

[7]

Stasko, J. Using student-built algorithm animations as learning aids. Technical Report GIT-GVU-96-19, Graphics, Visualization, and Usability Center, Georgia Institute of Technology, 1996. Also to appear in Proc. SIGCSE '97.

Digital Library

Google Scholar

Cited By

View all

Tyszkiewicz J(2020)The Power of Spreadsheet ComputationsFields of Logic and Computation III10.1007/978-3-030-48006-6_20(305-322)Online publication date: 23-May-2020
https://doi.org/10.1007/978-3-030-48006-6_20
Ellis ACarswell LBernat ADeveaux DFrison PMeisalo VMeyer JNulden URugelj JTarhio J(1998)Resources, tools, and techniques for problem based learning in computingWorking Group reports of the 3rd annual SIGCSE/SIGCUE ITiCSE conference on Integrating technology into computer science education10.1145/316572.358296(41-56)Online publication date: 1-Dec-1998
https://dl.acm.org/doi/10.1145/316572.358296
Dybdahl ASutinen ETarhio J(1998)On animation features of ExcelACM SIGCSE Bulletin10.1145/290320.28303430:3(77-80)Online publication date: 1-Aug-1998
https://dl.acm.org/doi/10.1145/290320.283034
Show More Cited By

Index Terms

Excel as an algorithm animation environment

Recommendations

Excel as an algorithm animation environment
ITiCSE '97: Proceedings of the 2nd conference on Integrating technology into computer science education

Understanding of fundamental algorithms and designing algorithms for a novel problem are basic skills in Computer Science. Animation is a useful aid in both these areas. We show how to animate algorithms with Microsoft Excel using data visualization and ...
Excel Pivot Tables: Easy practical guide for everyone
Writing Excel Macros with VBA

Comments

Information & Contributors

Information

Published In

ACM SIGCSE Bulletin Volume 29, Issue 3

Sept. 1997

143 pages

ISSN:0097-8418

DOI:10.1145/268809

Chairmen:
Lillian N. Cassel
National Science Foundation, Arlington, VA
,
Mats Daniels
Uppsala Univ. Sweden
,
Editors:
James E. Miller
Univ. of mississippi, Hattiesburg
,
Gordon Davies
Open Univ., Milton Keynes, England, UK

Issue’s Table of Contents

ITiCSE '97: Proceedings of the 2nd conference on Integrating technology into computer science education
June 1997
147 pages
ISBN:0897919238
DOI:10.1145/268819
Chairmen:
Lillian N. Cassel
National Science Foundation, Arlington, VA
,
Mats Daniels
Uppsala Univ. Sweden
,
Editors:
James E. Miller
Univ. of Southern Mississippi, Hattiesburg, MS
,
Gordon Davies
Open Univ., Milton Keynes, England, UK

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 04 June 1997

Published in SIGCSE Volume 29, Issue 3

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
758
Total Downloads

Downloads (Last 12 months)43
Downloads (Last 6 weeks)6

Reflects downloads up to 11 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Tyszkiewicz J(2020)The Power of Spreadsheet ComputationsFields of Logic and Computation III10.1007/978-3-030-48006-6_20(305-322)Online publication date: 23-May-2020
https://doi.org/10.1007/978-3-030-48006-6_20
Ellis ACarswell LBernat ADeveaux DFrison PMeisalo VMeyer JNulden URugelj JTarhio J(1998)Resources, tools, and techniques for problem based learning in computingWorking Group reports of the 3rd annual SIGCSE/SIGCUE ITiCSE conference on Integrating technology into computer science education10.1145/316572.358296(41-56)Online publication date: 1-Dec-1998
https://dl.acm.org/doi/10.1145/316572.358296
Dybdahl ASutinen ETarhio J(1998)On animation features of ExcelACM SIGCSE Bulletin10.1145/290320.28303430:3(77-80)Online publication date: 1-Aug-1998
https://dl.acm.org/doi/10.1145/290320.283034
Dybdahl ASutinen ETarhio JDavies GÓΉigeartaigh M(1998)On animation features of ExcelProceedings of the 6th annual conference on the teaching of computing and the 3rd annual conference on Integrating technology into computer science education: Changing the delivery of computer science education10.1145/282991.283034(77-80)Online publication date: 1-Aug-1998
https://dl.acm.org/doi/10.1145/282991.283034

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations