2024 Faculty Courses School of Materials and Chemical Technology Undergraduate major in Materials Science and Engineering
Exercise on Information Processing
- Academic unit or major
- Undergraduate major in Materials Science and Engineering
- Instructor(s)
- Takashi Iwahashi / Massimilia Zamengo / Yuhei Hayamizu / Keiichi Kuboyama / Takashi Harumoto / Akira Takahashi
- Class Format
- Exercise (Face-to-face)
- Media-enhanced courses
- -
- Day of week/Period
(Classrooms) - 5-8 Mon
- Class
- -
- Course Code
- MAT.A205
- Number of credits
- 020
- Course offered
- 2024
- Offered quarter
- 1Q
- Syllabus updated
- Mar 17, 2025
- Language
- Japanese
Syllabus
Course overview and goals
(1) Learning how to use application software (Excel)
(2) Learning program construct (VBA)
(3) Learning program structure
(4) Processing of data
Course description and aims
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.
Keywords
programming, data processing
Competencies
- Specialist skills
- Intercultural skills
- Communication skills
- Critical thinking skills
- Practical and/or problem-solving skills
Class flow
Exercise class
Course schedule/Objectives
| Course schedule | Objectives | |
|---|---|---|
| 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 |
Study advice (preparation and review)
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.
Textbook(s)
Original documents are available in advance via the OCW-i system.
Reference books, course materials, etc.
None
Evaluation methods and criteria
Learning achievement is evaluated by general exercises and exercises about each topic.
Related courses
- MAT.A250 ： Materials Science Laboratory I
- MAT.A251 ： Materials Science Laboratory II
- MAT.A252 ： Materials Science Laboratory III
Prerequisites
None.