2022 Exercise on Information Processing

Font size  SML

Register update notification mail Add to favorite lecture list
Academic unit or major
Undergraduate major in Materials Science and Engineering
Ishikawa Ken  Kuboyama Keiichi  Harumoto Takashi  Takahashi Akira 
Class Format
Exercise    (HyFlex)
Media-enhanced courses
Day/Period(Room No.)
Mon5-8(情報ネットワーク演習室 第2演習室)  
Course number
Academic year
Offered quarter
Syllabus updated
Lecture notes updated
Language used
Access Index

Course description and aims

(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

Student learning outcomes

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

Competencies that will be developed

Specialist skills Intercultural skills Communication skills Critical thinking skills Practical and/or problem-solving skills

Class flow

Exercise class

Course schedule/Required learning

  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

Out-of-Class Study Time (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.


Original documents are available in advance via the OCW-i system.

Reference books, course materials, etc.


Assessment criteria and methods

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 (i.e., required knowledge, skills, courses, etc.)


Page Top