(1) Understanding computer system used in this class
(2) Learning how to use application softwares
(3) Learning program construct
(4) Learning program structure
(5) Processing of a large amount of data
In these years, necessity of programming by using a programming language has been reduced compared to the past because of improvement of various application softwares. In contrast with it, the skills to use a macro language built into an application software and to process a large amount of data effectively have come to be required. In this course, students will learn how to use a macro programming language in an application software and a basic programming method required for data processing.
programming, data processing
Specialist skills | Intercultural skills | Communication skills | Critical thinking skills | ✔ Practical and/or problem-solving skills |
Exercise class
Course schedule | Required learning | |
---|---|---|
Class 1 | Guidance and interpretation of system used in this course | Learn basic grammar of a programming language and program for data processing |
Class 2 | Import of text file into application software and utilization of macro function | |
Class 3 | VBA Programming (I): Four arithmetic operations and variables | |
Class 4 | VBA Programming (II): Control structures(1) | |
Class 5 | VBA Programming (III): Arrays | |
Class 6 | midterm test | |
Class 7 | VBA Programming (IV): Subroutines | |
Class 8 | VBA Programming (V): Function procedure | |
Class 9 | VBA Programming (VI): Control structures(2) | |
Class 10 | VBA Programming (VII): Reading data from file | |
Class 11 | VBA Programming (VIII): Writing data to file | |
Class 12 | VBA Programming (IX): Reading and writing data files | |
Class 13 | VBA Programming (X): General exercises | |
Class 14 | final examination |
To enhance effective learning, students are encouraged to spend approximately 100 minutes preparing for class and another 100 minutes reviewing class content afterwards (including assignments) for each class.
They should do so by referring to textbooks and other course material.
Original documents are available in advance via the OCW-i system.
None
Learning achievement is evaluated by general exercises and exercises about each topic.
None.