Hiroshima University Syllabus

Back to syllabus main page
Japanese
Academic Year 2021Year 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 KANEZASHI MASAKOTO,KOMAGUCHI KENJI,TAJIMA TAKAHISA
Instructor
(Katakana)
カネザシ マサコト,コマグチ ケンジ,タジマ タカヒサ
Campus Higashi-Hiroshima Semester/Term 2nd-Year,  First Semester,  1Term
Days, Periods, and Classrooms (1T) Weds3-6:ENG 113,ENG 115,ENG 116,ENG 117
Lesson Style Lecture Lesson Style
(More Details)
 
Lecture/Practical 
Credits 2.0 Class Hours/Week   Language on 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 2020
Keywords Computer, Windows, Excel, Spread sheet, Information technology, Programming 
Special Subject for Teacher Education   Special Subject  
Class Status
within Educational
Program
 
Criterion referenced
Evaluation
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 sheet
(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 original macro 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)
lesson 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)

Term-end exam will be held after the lesson 15 is finished. 
Text/Reference
Books,etc.
A text of this lecture will be distributed in the class. 
PC or AV used in
Class,etc.
 
(More Details) Please bring your laptop PC. The lecture will use the Microsoft ppt. 
Learning techniques to be incorporated  
Suggestions on
Preparation and
Review
The lecture will be performed along the lesson plan, and it is recommended to review the finished lessons and the next lesson. In addition, it is desirable to solve the chapter end problems during the review. 
Requirements  
Grading Method The achievement is evaluated by 100 points by the report and the chapter end problems  (40%),  the exercises and the term-end 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