TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| CIVIL ENGINEERING PR. | |
| Code | IMS419 |
| Name | Electronic charting in engineering |
| Term | 2025-2026 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 |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Prof. Dr. ABDULAZİM YILDIZ |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
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 | “Sufficient knowledge in mathematics, science, and discipline-specific topics in Civil Engineering; the ability to use theoretical and applied knowledge in these fields to solve complex engineering problems.” | |
| PLO02 | Bilgi - Kuramsal, Olgusal | “The ability to identify, formulate, and solve complex Civil Engineering problems; and the ability to select and apply appropriate analysis and modeling methods for this purpose.” | |
| PLO03 | Bilgi - Kuramsal, Olgusal | “The ability to design a complex system, process, device, or product to meet specified requirements under realistic constraints and conditions; and the ability to apply modern design methods for this purpose.” | |
| PLO04 | Bilgi - Kuramsal, Olgusal | “The ability to select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in Civil Engineering applications; and the ability to use information technologies effectively.” | 4 |
| PLO05 | Bilgi - Kuramsal, Olgusal | “The ability to design experiments, conduct experiments, collect data, and analyze and interpret results for the investigation of complex Civil Engineering problems or discipline-specific research topics.” | 3 |
| PLO06 | Bilgi - Kuramsal, Olgusal | “The ability to work effectively in intra-disciplinary and multidisciplinary teams; and the ability to work independently.” | |
| PLO07 | Bilgi - Kuramsal, Olgusal | “The ability to communicate effectively in both oral and written form; proficiency in at least one foreign language; the ability to write effective reports and understand written reports, prepare design and production reports, deliver effective presentations, and give and receive clear and understandable instructions.” | |
| PLO08 | Bilgi - Kuramsal, Olgusal | “Awareness of the necessity of lifelong learning; the ability to access information, follow developments in science and technology, and continuously improve oneself.” | 3 |
| PLO09 | Bilgi - Kuramsal, Olgusal | “Acting in accordance with ethical principles, having professional and ethical responsibility, and having knowledge of the standards used in engineering practices.” | 4 |
| PLO10 | Bilgi - Kuramsal, Olgusal | “Knowledge of business-life practices such as project management, risk management, and change management; awareness of entrepreneurship and innovation; and knowledge about sustainable development.” | 5 |
| PLO11 | Bilgi - Kuramsal, Olgusal | “Knowledge of the universal and social impacts of Civil Engineering practices on health, environment, and safety, as well as the contemporary issues reflected in the field of engineering; and awareness of the legal consequences of engineering solutions.” |
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 | ||