|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction to MS Excel
|
R1-SECTION 1
|
|
2
|
Excel Applications in Chemical Engineering
|
R1-SECTION 2
|
|
3
|
Introduction to MS Excel Macros and Visual Basic Applications (VBA)
|
R1-SECTION 3
|
|
4
|
Creating functions of value assigning, deleting and finding
|
R1-SECTION 4
|
|
5
|
Creating functions of value assigning, deleting and finding
|
R1-SECTION 5
|
|
6
|
For-Next Cycle
|
R1-SECTION 6
|
|
7
|
For-Next Cycle
|
R1-SECTION 7
|
|
8
|
Macro Applications in Chemical Engineering
|
R1-SECTION 8
|
|
9
|
Macro Applications in Chemical Engineering
|
R1-SECTION 9
|
|
10
|
Macro Applications in Chemical Engineering
|
R1-SECTION 10
|
|
11
|
Macro Applications in Chemical Engineering
|
R2-SECTION 6
|
|
12
|
Macro Applications in Chemical Engineering
|
R2-SECTION 7
|
|
13
|
Macro Applications in Chemical Engineering
|
R2-SECTION 8
|
|
14
|
Macro Applications in Chemical Engineering
|
R2-SECTION 9
|
|
Prerequisites
|
-
|
|
Language of Instruction
|
Turkish
|
|
Responsible
|
Assist. Prof. Dr. Muhammed Bora AKIN
|
|
Instructors
|
-
|
|
Assistants
|
-
|
|
Resources
|
R1) Bağcı, Ö. (2020). İleri Düzey Excel 2019. (1. Baskı), Sekin Yayıncılık, Ankara.
R2) Halvorson, M. (1998). Microsoft® Visual Basic® Professional 6.0 Step by Step, Microsoft Press, USA
|
|
Supplementary Book
|
-
|
|
Goals
|
Providing the functional programming for Chemical Engineering by making the VBA programming of the existing macro features in MS Excel.
|
|
Content
|
Introduction to MS Excel, Excel Applications in Chemical Engineering, Introduction to MS Excel Macros and Visual Basic Applications (VBA), Creating functions of value assigning, deleting and finding, For-Next Cycles, Macro Applications in Chemical Engineering.
|
|
Program Learning Outcomes |
Level of Contribution |
|
1
|
To be able to apply mathematics, science and engineering theories and principles to Chemical Engineering problems.
|
4
|
|
2
|
To have the ability to define, model, and solve problems related to Chemical Engineering.
|
4
|
|
3
|
To be able to design and conduct experiments, as well as to analyze and interpret data.
|
-
|
|
4
|
To be able to design and analyze a process for a specific purpose within technical and economical limitations.
|
4
|
|
5
|
To be able to use modern techniques and calculation tools required for engineering applications.
|
4
|
|
6
|
To have the awareness of professional liabilities and ethics.
|
-
|
|
7
|
To be able to get involved in interdisciplined and multidisciplined team work.
|
4
|
|
8
|
To be able to declare his/her opinions orally or written in a clear, concise and brief manner.
|
-
|
|
9
|
To improve him/herself by following the developments in science, technology, modern issues, and know the importance of lifelong learning.
|
4
|
|
10
|
To be able to evaluate engineering solutions for the global and social problems especially for the health, safety, and environmental problems.
|
4
|
|
11
|
To have knowledge about of contemporary issues.
|
-
|