Information Package / Course Catalogue
| Course Code | : ZTY540 |
| Course Type | : Area Elective |
| Couse Group | : Second Cycle (Master's Degree) |
| Education Language | : Turkish |
| Work Placement | : N/A |
| Theory | : 2 |
| Prt. | : 2 |
| Credit | : 3 |
| Lab | : 0 |
| ECTS | : 6 |
Students will learn the fundamentals of using EXCEL, the functions commonly used by engineers, evaluation of the data obtained using these functions
Intorduction of EXCEL, graphical solutions with spreadsheets, EXCEL functions for mathematics, statistics. Curve fitting, matrix operations, linear equations, linear regression with EXCEL, optimization with Solver, macro techniques and VBA, numerical integration techniques, Runge-kutte methods.
| 1. | Students can use, explain and able to discuss Excel software |
| 2. | Be able to prepare a graphic chart |
| 3. | Be able to apply numerical decision making techniques by Excel |
| 4. | Can explain and discuss basic operations, various functions and form control elements |
| 5. | Be able to apply the knowledge gained in the course to culturtechnique applications |
| 1. | Engineering with Excel Ronald W. Larsen |
| Type of Assessment | Count | Percent |
|---|---|---|
| Attending Lectures | 1 | %5 |
| Practice Examination | 1 | %5 |
| Midterm Examination | 1 | %20 |
| Final Examination | 1 | %70 |
| Activities | Count | Preparation | Time | Total Work Load (hours) |
|---|---|---|---|---|
| Lecture - Theory | 14 | 1 | 2 | 42 |
| Lecture - Practice | 14 | 1 | 2 | 42 |
| Practice Examination | 1 | 15 | 2 | 17 |
| Midterm Examination | 1 | 20 | 2 | 22 |
| Final Examination | 1 | 25 | 2 | 27 |
| TOTAL WORKLOAD (hours) | 150 | |||
PÇ-1 | PÇ-2 | PÇ-3 | PÇ-4 | PÇ-5 | PÇ-6 | PÇ-7 | PÇ-8 | |
OÇ-1 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 |
OÇ-2 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 3 |
OÇ-3 | 5 | 5 | 4 | 4 | 4 | 3 | 3 | 3 |
OÇ-4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
OÇ-5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |