K0285030 Basic Engineering Computer Programming

Hiroshima University Syllabus

Japanese

Academic Year 2024Year School/Graduate School School of Engineering

Lecture Code K0285030 Subject Classification Specialized Education

Subject Name 工学プログラミング基礎

Subject Name
（Katakana）コウガクプログラミングキソ

Subject Name in
English Basic Engineering Computer Programming

Instructor KOMAGUCHI KENJI,ISHIGAMI TORU,IKEDA TAKESHI

Instructor
(Katakana) コマグチ　ケンジ,イシガミ　トオル,イケダ　タケシ

Campus Higashi-Hiroshima Semester/Term 2nd-Year,  First Semester,  1Term

Days, Periods, and Classrooms (1T) Weds3-6：ENG 115,ENG 116,ENG 117

Lesson Style Lecture Lesson Style
(More Details) 　

Lecture/Practical

Credits 2.0 Class Hours/Week 　 Language of Instruction B : Japanese／English

Course Level 2 : Undergraduate Low-Intermediate

Course Area（Area） 25 : Science and Technology

Course Area（Discipline） 02 : Information Science

Eligible Students Undergraduate students in Cluster III enrolled in 2023

Keywords Computer, Windows, Excel, Spread sheet, Information technology, Programming

Special Subject for Teacher Education 　 Special Subject 　

Class Status
within Educational
Program
(Applicable only to targeted subjects for undergraduate students)
Criterion referenced
Evaluation
(Applicable only to targeted subjects for undergraduate students) Program of Mechanical Systems Engineering
（Knowledge and Understanding）
・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically.

Program of Transportation Systems
（Knowledge and Understanding）
・Information engineering subjects: To acquire understanding and basic knowledge required for engineers and researchers.
（Abilities and Skills）
・Information engineering subjects: Information processing ability based on mathematics and mechanics.

Program of Material Processing
（Knowledge and Understanding）
・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically.

Program of Energy Transform Engineering
（Knowledge and Understanding）
・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically.

Program of Applied Chemistry
（Knowledge and Understanding）
・Wide range of basic knowledge on liberal arts and specialized education, and professional basic knowledge on chemistry.
・Advanced technical knowledge of applied chemistry.
・The conception ability based on logical thinking supported by basic and technical knowledge.

Program of Chemical Engineering
（Abilities and Skills）
・Definite learning of basic chemistry and chemical engineering and cultivation of application ability
engineering basis.
（Comprehensive Abilities）
・Improvement of  presentation and communication ability and cultivation of application ability to high informatization.

Program of Biotechnology
（Knowledge and Understanding）
・Acquisition of basic and advanced knowledge relating to biotechnology and life science. (Target/Lecture class)

Program of Civil and Environmental Engineering
（Abilities and Skills）
・Ability to analyze  problems
（Comprehensive Abilities）
・Abbility of communication
・Ability to achieve and ability to solve the problem

Program of Architecture and Building Engineering
（Knowledge and Understanding）
・Understanding on learning basic engineering knowledge. (Being able to explain basic contents of mathematics, physics and information technology.  Being able to apply the basic contents to architecture and building engineering)

Class Objectives
/Class Outline The objective of this class is to obtain the following knowledges and abilities by using Microsoft Excel(Visual Basic for Applications) as a platform of programming language on Windows OS,
(1) Basic knowledge for PC
(2) Understanding the concept of spread sheets
(3) Handling data on a spread sheet; setting format, making a graph, and drawing adjusted curves
(4) To be able to use goal seeking and sover functions on Excel
(5) Understanding numerical solutions of equation, and making an original macro for the solution and using it on Excel
(6) Understanding macro programming using Visual Basic editor
(7) Making and using User-Defined Functions and Sub Procedures

Class Schedule Lesson 1: On demand lecture 1 (Orientation, chapter 1, 2)
Lesson 2: On demand lecture 2 (Chapter 3) in basic of spread sheet and worksheet functions (SUM, AVERAGE, IF etc.)
Lesson 3: Drill in basic operation of spread sheet
Lesson 4: Drill in making graph and adjusting curve
Lesson 5: Drill in goal seeking and solver
Lesson 6: Exercise in spread sheet and worksheet functions (Ex.1-3), Exercise in goal seeking and solver (Ex.4-8)
vesson 7: On demand lecture in problems 3-2 and 4-1
Lesson 8: On demand lecture 3 (Chapter 6) in numerical solution of equation, macro and user defined function
Lesson 9: Drill in numerical solution of equation, macro and user defined function
Lesson 10: Exercise in macro and user defined function (Ex. 9)
Lesson 11: On demand lecture 4 (Chapter 7) in VBA macroprogramming
Lesson 12: On demand lecture in problem 6-1
Lesson 13: Drill in VBA macroprogramming
Lesson 14: Exercise in VBA macroprogramming (Ex. 10)
Lesson 15: Integrated exercise (Ex. 1-10)

An end-of-term exam will be given after Lesson 15

Text/Reference
Books,etc. An original text (vol.1-3) will be distributed in the class.

PC or AV used in
Class,etc. 　

(More Details) Please bring your laptop PC. The class will be conducted using PowerPoint slides.

Learning techniques to be incorporated 　

Suggestions on
Preparation and
Review The lecture will be performed along the schedule, and it is recommended to prepare and review them according the class contents. In addition, it is desirable to solve the end-of-chapter problems for self-study.

Requirements

Grading Method The achievement is evaluated by 100 points by the report and the chapter end problems  (40%),  the exercises and the end-of-term exam (60%), and pass more than 60 points.

Practical Experience

Summary of Practical Experience and Class Contents based on it

Message

Other

Please fill in the class improvement questionnaire which is carried out on all classes.
Instructors will reflect on your feedback and utilize the information for improving their teaching.

Academic Year	2024Year	School/Graduate School	School of Engineering
Lecture Code	K0285030	Subject Classification	Specialized Education
Subject Name	工学プログラミング基礎
Subject Name （Katakana）	コウガクプログラミングキソ
Subject Name in English	Basic Engineering Computer Programming
Instructor	KOMAGUCHI KENJI,ISHIGAMI TORU,IKEDA TAKESHI
Instructor (Katakana)	コマグチ　ケンジ,イシガミ　トオル,イケダ　タケシ
Campus	Higashi-Hiroshima	Semester/Term	2nd-Year, First Semester, 1Term
Days, Periods, and Classrooms	(1T) Weds3-6：ENG 115,ENG 116,ENG 117
Lesson Style	Lecture	Lesson Style (More Details)
Lecture/Practical
Credits	2.0	Class Hours/Week		Language of Instruction	B : Japanese／English
Course Level	2 : Undergraduate Low-Intermediate
Course Area（Area）	25 : Science and Technology
Course Area（Discipline）	02 : Information Science
Eligible Students	Undergraduate students in Cluster III enrolled in 2023
Keywords	Computer, Windows, Excel, Spread sheet, Information technology, Programming
Special Subject for Teacher Education		Special Subject
Class Status within Educational Program (Applicable only to targeted subjects for undergraduate students)
Criterion referenced Evaluation (Applicable only to targeted subjects for undergraduate students)	Program of Mechanical Systems Engineering （Knowledge and Understanding）・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically. Program of Transportation Systems （Knowledge and Understanding）・Information engineering subjects: To acquire understanding and basic knowledge required for engineers and researchers. （Abilities and Skills）・Information engineering subjects: Information processing ability based on mathematics and mechanics. Program of Material Processing （Knowledge and Understanding）・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically. Program of Energy Transform Engineering （Knowledge and Understanding）・Acquiring necessary basic knowledge for an engineer and developing the ability to consider logically. Program of Applied Chemistry （Knowledge and Understanding）・Wide range of basic knowledge on liberal arts and specialized education, and professional basic knowledge on chemistry. ・Advanced technical knowledge of applied chemistry. ・The conception ability based on logical thinking supported by basic and technical knowledge. Program of Chemical Engineering （Abilities and Skills）・Definite learning of basic chemistry and chemical engineering and cultivation of application ability engineering basis. （Comprehensive Abilities）・Improvement of presentation and communication ability and cultivation of application ability to high informatization. Program of Biotechnology （Knowledge and Understanding）・Acquisition of basic and advanced knowledge relating to biotechnology and life science. (Target/Lecture class) Program of Civil and Environmental Engineering （Abilities and Skills）・Ability to analyze problems （Comprehensive Abilities）・Abbility of communication ・Ability to achieve and ability to solve the problem Program of Architecture and Building Engineering （Knowledge and Understanding）・Understanding on learning basic engineering knowledge. (Being able to explain basic contents of mathematics, physics and information technology. Being able to apply the basic contents to architecture and building engineering)
Class Objectives /Class Outline	The objective of this class is to obtain the following knowledges and abilities by using Microsoft Excel(Visual Basic for Applications) as a platform of programming language on Windows OS, (1) Basic knowledge for PC (2) Understanding the concept of spread sheets (3) Handling data on a spread sheet; setting format, making a graph, and drawing adjusted curves (4) To be able to use goal seeking and sover functions on Excel (5) Understanding numerical solutions of equation, and making an original macro for the solution and using it on Excel (6) Understanding macro programming using Visual Basic editor (7) Making and using User-Defined Functions and Sub Procedures
Class Schedule	Lesson 1: On demand lecture 1 (Orientation, chapter 1, 2) Lesson 2: On demand lecture 2 (Chapter 3) in basic of spread sheet and worksheet functions (SUM, AVERAGE, IF etc.) Lesson 3: Drill in basic operation of spread sheet Lesson 4: Drill in making graph and adjusting curve Lesson 5: Drill in goal seeking and solver Lesson 6: Exercise in spread sheet and worksheet functions (Ex.1-3), Exercise in goal seeking and solver (Ex.4-8) vesson 7: On demand lecture in problems 3-2 and 4-1 Lesson 8: On demand lecture 3 (Chapter 6) in numerical solution of equation, macro and user defined function Lesson 9: Drill in numerical solution of equation, macro and user defined function Lesson 10: Exercise in macro and user defined function (Ex. 9) Lesson 11: On demand lecture 4 (Chapter 7) in VBA macroprogramming Lesson 12: On demand lecture in problem 6-1 Lesson 13: Drill in VBA macroprogramming Lesson 14: Exercise in VBA macroprogramming (Ex. 10) Lesson 15: Integrated exercise (Ex. 1-10) An end-of-term exam will be given after Lesson 15
Text/Reference Books,etc.	An original text (vol.1-3) will be distributed in the class.
PC or AV used in Class,etc.
(More Details)	Please bring your laptop PC. The class will be conducted using PowerPoint slides.
Learning techniques to be incorporated
Suggestions on Preparation and Review	The lecture will be performed along the schedule, and it is recommended to prepare and review them according the class contents. In addition, it is desirable to solve the end-of-chapter problems for self-study.
Requirements
Grading Method	The achievement is evaluated by 100 points by the report and the chapter end problems (40%), the exercises and the end-of-term exam (60%), and pass more than 60 points.
Practical Experience
Summary of Practical Experience and Class Contents based on it
Message
Other
Please fill in the class improvement questionnaire which is carried out on all classes. Instructors will reflect on your feedback and utilize the information for improving their teaching.

Back to syllabus main page