[go: up one dir, main page]
More Web Proxy on the site http://driver.im/ skip to main content
10.1145/3134847.3134857acmotherconferencesArticle/Chapter ViewAbstractPublication PagesicdteConference Proceedingsconference-collections
research-article

A Case Study of Computer-based Problem Solving Skill Development by Using Spreadsheet Software

Published: 06 August 2017 Publication History

Abstract

Recently many enterprises are promoting their workers to gain advanced skills of using Excel in conjunction with Visual Basic Application (VBA, for short), which is a program development framework of Excel for creating VBA programs (called macros) that performs routine tasks automatically. In Japan there are many vocational schools providing Excel VBA training courses. However, these courses don't develop sufficient problem-solving skill which is essential for learners who want to develop Excel VBA based applications. The objective of this paper is to introduce an on-going education project that develops Excel VBA based problem-solving skill for students who are not major in computer science. The course design and education support of the project are discussed. Furthermore, experience learned from the project is also introduced.

References

[1]
Amazon. (2017). A List of Excel VBA Textbooks, https://www.amazon.co.jp/s/ref=sr_pg_3?rh=n%3A465392%2Ck%3Aexcel+vba&page=3&keywords=excel+vba&ie=UTF8&qid=1422765554, retrieved 2017/7/12.
[2]
Benfield, L. 2009. FMD: functional development in Excel. In Proceedings of the 2009 Video Workshop on Commercial Users of Functional Programming: Functional Programming As a Means, Not an End (CUFP '09). ACM, New York, NY, USA, pages.
[3]
Chatvichienchai. S. 2015. A Methodology of Employing Spreadsheet Software as a Tool for Integrating Web Services, In Int. Journal of Information and Education Technology, Vol.5 No.7, pp. 527--531.
[4]
Dix, A., Cowgill. R., Bashford, C., McVeigh, S. and Ridgewell, R. 2016. Spreadsheets as User Interfaces. In Proceedings of the International Working Conference on Advanced Visual Interfaces (AVI '16), Paolo Buono, Rosa Lanzilotti, and Maristella Matera (Eds.). ACM, New York, NY, USA, 192--195.
[5]
Hakimzadeh, H., Adaikkalavan, R. and Batzinger, R. 2011. Successful implementation of an active learning laboratory in computer science. In Proceedings of the 39th annual ACM SIGUCCS conference on User services (SIGUCCS '11). ACM, New York, NY, USA, 83--86. DOI=http://dx.doi.org/10.1145/2070364.2070386
[6]
Jeannette, M. W. 2006. Computational Thinking, Communications of the ACM, vol. 49(3), pp. 33--35.
[7]
Julitta, K. 2016. Microsoft Excel 2016 Programming by Example, Mercury Learning & Information.
[8]
Kongdenfha, W., Benatallah, B., Vayssière, J., Saint-Paul, R. and Casati, F. 2009. Rapid development of spreadsheet-based web mashups. In Proceedings of the 18th international conference on World wide web (WWW '09). ACM, New York, NY, USA, 851--860. DOI=http://dx.doi.org/10.1145/1526709.1526824
[9]
Lishinski,A., Yadav,A., Enbody, R. and Good, J. 2016. The Influence of Problem Solving Abilities on Students' Performance on Different Assessment Tasks in CS1. In Proceedings of the 47th ACM Technical Symposium on Computing Science Education (SIGCSE '16). ACM, New York, NY, USA, 329--334.
[10]
Talbot, R. 2009. Advantages of Using VBA in Excel 2007, http://ezinearticles.com/?Advantages-of-Using-VBA-in-Excel-2007&id=2347065, retrieved 2017/7/9.
[11]
Zhou, C. 2016. Handbook of Research on Creative Problem-Solving Skill Development in Higher Education (Advances in Higher Education and Professional Development) 1st Edition, IGI Global.

Cited By

View all

Index Terms

  1. A Case Study of Computer-based Problem Solving Skill Development by Using Spreadsheet Software

    Recommendations

    Comments

    Please enable JavaScript to view thecomments powered by Disqus.

    Information & Contributors

    Information

    Published In

    cover image ACM Other conferences
    ICDTE '17: Proceedings of the 1st International Conference on Digital Technology in Education
    August 2017
    94 pages
    ISBN:9781450352833
    DOI:10.1145/3134847
    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: 06 August 2017

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. Active learning
    2. Course Design
    3. Problem solving
    4. Spreadsheet Programming
    5. e-Book

    Qualifiers

    • Research-article
    • Research
    • Refereed limited

    Conference

    ICDTE '17

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • 0
      Total Citations
    • 119
      Total Downloads
    • Downloads (Last 12 months)5
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 20 Jan 2025

    Other Metrics

    Citations

    Cited By

    View all

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media