TÜRKÇE
ENGLISH
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 |
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 | ||