Somchai Chatvichienchai
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.
- 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.Google Scholar
- 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. DOI: https://doi.org/10.1145/1668113.1668121Google ScholarDigital Library
- 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. Google ScholarCross Ref
- 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. DOI: https://doi.org/10.1145/2909132.2909271Google ScholarDigital Library
- 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 Google ScholarDigital Library
- Jeannette, M. W. 2006. Computational Thinking, Communications of the ACM, vol. 49(3), pp. 33--35. Google ScholarDigital Library
- Julitta, K. 2016. Microsoft Excel 2016 Programming by Example, Mercury Learning & Information.Google Scholar
- 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 Google ScholarDigital Library
- 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. DOI: https://doi.org/10.1145/2839509.2844596Google ScholarDigital Library
- 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.Google Scholar
- 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.Google Scholar
Index Terms
- A Case Study of Computer-based Problem Solving Skill Development by Using Spreadsheet Software
Recommendations
Using POGIL to teach students to be better problem solvers (abstract only)
SIGCSE '12: Proceedings of the 43rd ACM technical symposium on Computer Science EducationPOGIL is a learning method that encourages students to learn coursework material in cooperative groups. Instead of passively listening to a traditional lecture, POGIL students work together on activities that guide students to discover programming ...
Inquiry-Based Learning in Computer Science Classroom
Informatics in Schools. New Ideas in School InformaticsAbstractInquiry-based learning in Slovak schools is still considered to be an innovative approach to teaching based on the active exploration of new knowledge by pupils themselves. It allows deeper involvement of pupils in the learning process, encourages ...
Scaffolding problem solving in technology-enhanced learning environments (TELEs): Bridging research and theory with practice
With the expanding availability and capability of varied technologies, classroom-based problem solving has become an increasingly attainable, yet still elusive, goal. Evidence of technology-enhanced problem-solving teaching and learning in schools has ...
Comments