IMS419 Electronic charting in engineering

5 ECTS - 3-0 Duration (T+A)- 7. Semester- 3 National Credit

Information

Code IMS419
Name Electronic charting in engineering
Term 2024-2025 Academic Year
Semester 7. Semester
Duration (T+A) 3-0 (T-A) (17 Week)
ECTS 5 ECTS
National Credit 3 National Credit
Teaching Language Türkçe
Level Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Prof. Dr. ABDULAZİM YILDIZ
Course Instructor
1 2
Prof. Dr. ABDULAZİM YILDIZ (A Group) (Ins. in Charge)


Course Goal / Objective

To give information on the occupational health and safety procedures and practices in construction industry

Course Content

Occupational health and safety procedures and practices in construction industry

Course Precondition

None

Resources

An Introduction to EXCEL for Civil Engineers

Notes

Spreadsheets in Science and Engineering


Course Learning Outcomes

Order Course Learning Outcomes
LO01 To have mastered the basic concepts, theories and principles
LO02 Learning of spread sheet program
LO03 Learning graph in engineering problems
LO04 Learning visual basic program


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal Has the basic knowledge of math, science and civil engineering
PLO02 Bilgi - Kuramsal, Olgusal Has a good commman of basic concepts, theories and principles in civil engineering.
PLO03 Bilgi - Kuramsal, Olgusal Independently reviews and learns the applications, makes a critical assessment of the problems faced with, selects the proper technique to formulate problems and propose solutions
PLO04 Bilgi - Kuramsal, Olgusal Designs a system, a component or a process in order to meet the needs of various engineering problems within technical, economic, environmental, manufacturability, sustainability limitations. 4
PLO05 Bilgi - Kuramsal, Olgusal Selects and uses the modern techniques and tools necessary for engineering practice 3
PLO06 Bilgi - Kuramsal, Olgusal Designs and carries out experiments in the fields of civil engineering, and interprets the results and the data obtained from the experiments
PLO07 Bilgi - Kuramsal, Olgusal Gains the abiltiy to work effectively as a member in interdisciplinary teams
PLO08 Bilgi - Kuramsal, Olgusal Identifies proper sources of information and databases, reaches them and uses them efficiently. 3
PLO09 Bilgi - Kuramsal, Olgusal Follows the advancements in science and technology being aware of the necessity of lifelong learning and continuously improves her/himself. 4
PLO10 Bilgi - Kuramsal, Olgusal Uses the computers and information technologies related with civil engineering actively. 5
PLO11 Bilgi - Kuramsal, Olgusal Gains the ability to communicate effectively both orally and in writing.
PLO12 Bilgi - Kuramsal, Olgusal Communicates using technical drawing
PLO13 Bilgi - Kuramsal, Olgusal Constantly improves her/himself by identifying the training needs in scientific, cultural, artistic and social fields.
PLO14 Bilgi - Kuramsal, Olgusal Continuously improves her/himself by defining necessities in learning in scientific, social, cultural and artistic areas besides the occupational requirements.
PLO15 Bilgi - Kuramsal, Olgusal Has an understanding of entrepreneurship and innovation subjects, and is knowledgeable of contemporary issues.
PLO16 Bilgi - Kuramsal, Olgusal Has an awareness of professional and ethical responsibility
PLO17 Bilgi - Kuramsal, Olgusal Has the required knowledge in project management, workplace practices, employee health, environmental and occupational safety; and the legal implications of engineering applications.


Week Plan

Week Topic Preparation Methods
1 Basic of excel Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
2 Math and Trigonometry Functions Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
3 Engineering Drawing Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
4 Data Analysis Functions Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
5 Matrix functions Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
6 Pivot table Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
7 Logical and lookup functions Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
8 Mid-Term Exam Repeat the previous lesson Ölçme Yöntemleri:
Yazılı Sınav
9 Introduction to visual basic programming Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
10 VBA Programming examples Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
11 Userforms Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
12 Using If….Then….Else in Excel VBA Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
13 For……Next Loop Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
14 Excel VBA Project-1 Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
15 VBA variables Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
16 Working with Excel VBA Controls Lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
17 Term Exams Lecture notes Ölçme Yöntemleri:
Yazılı Sınav


Student Workload - ECTS

Works Number Time (Hour) Workload (Hour)
Course Related Works
Class Time (Exam weeks are excluded) 14 3 42
Out of Class Study (Preliminary Work, Practice) 14 3 42
Assesment Related Works
Homeworks, Projects, Others 0 0 0
Mid-term Exams (Written, Oral, etc.) 1 12 12
Final Exam 1 18 18
Total Workload (Hour) 114
Total Workload / 25 (h) 4,56
ECTS 5 ECTS

Update Time: 15.05.2024 08:28