| Course Name | Code | Semester | T+U Hours | Credit | ECTS |
|---|---|---|---|---|---|
| Computer Applications In Finance | EKO 554 | 0 | 3 + 0 | 3 | 6 |
| Precondition Courses | |
| Recommended Optional Courses | |
| Course Language | Turkish |
| Course Level | yuksek_lisans |
| Course Type | Optional |
| Course Coordinator | Doç.Dr. VELİ YILANCI |
| Course Lecturers | Doç.Dr. VELİ YILANCI, |
| Course Assistants | Arş. Gör. Gürkan Malcıoğlu |
| Course Category | Field Proper Education |
| Course Objective | Using this course the students develop basic financial and statistical information to MS Excel and SPSS programs. This aims to provide the ability to implement. |
| Course Content | To be able o make excel-based basic financial calculations and their analyses, to be able to develop the infrastructure through corporate finance and capital market-based case studies |
| # | Course Learning Outcomes | Teaching Methods | Assessment Methods |
|---|---|---|---|
| 1 | She/He sees the logic of the financial functions contained in Excel | Lecture, Question-Answer, Drilland Practice, | Testing, Homework, Performance Task, |
| 2 | She/He sees the logic of the statistical functions contained in Excel | Lecture, Question-Answer, Drilland Practice, | Testing, Homework, Performance Task, |
| 3 | She/He sees what way to use these functions. | Lecture, Question-Answer, Drilland Practice, | Testing, Homework, Performance Task, |
| 4 | She/He sees how adapt these functions to our business lives. | Lecture, Question-Answer, Drilland Practice, | Testing, Homework, Performance Task, |
| Week | Course Topics | Preliminary Preparation |
|---|---|---|
| 1 | Excel-based Interest Rate Calculations - Real / Nominal Interest - Simple / Compound Interest | |
| 2 | Excel-based F/X Rate Calculations I - Parity - Cross Rate - Spot and Derivative Markets | |
| 3 | Excel-based F/X Rate Calculaions II - Arbitration Scenarios | |
| 4 | Excel-based “Time Value of Money” Cases from Different Sectors I o Production | |
| 5 | Excel-based “Time Value of Money” Cases from Different Sectors II o Marketing and Sales | |
| 6 | Excel-based Expected Risk / Return Calculations based on Shares & Bonds | |
| 7 | General Review | |
| 8 | Mid-Term Exam | |
| 9 | Excel-based Portfolio Calculation Mehods II - Portfolio Performance Measuremen Techniques ; Sharpe, Treynor, Jensen | |
| 10 | Excel-based Case Studies on Capital Assets Pricing Model I | |
| 11 | Excel-based Case Studies on Capital Assets Pricing Model II | |
| 12 | Excel-based Applications on Efficient Market Hypothesis I - Strong / Semi Strong / Weak Types | |
| 13 | Excel-based Applications on Efficient Market Hypothesis II - Anomalies | |
| 14 | General Review |
| Resources | |
|---|---|
| Course Notes | <p>Lecture notes</p> |
| Course Resources | (1) Baştan Sona Excel, Pusula Yayıncılık. |
| Order | Program Outcomes | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Economic and financial issues in conjunction with the expansion and deepening of information by econometric analysis information to evaluate, interpret and apply | X | |||||
| 2 | Using the theoretical knowledge in finance and economics combine the ability to apply scientific methods and knowledge of econometric methods to analyze and interpret | X | |||||
| 3 | Problems experienced in the financial sector to analyze with scientific methods and solutions development | X | |||||
| 4 | The oral and visual way to transfer to Current developments in the financial sector, for the financial sector and outside groups as written | X | |||||
| 5 | Both public as well as how it should be in the private sector require highly skilled personnel; have the theoretical knowledge and practical advanced analysis capabilities in economic and financial matters | X | |||||
| 6 | At least one foreign language spoken and written communication having the ability ("European Language Portfolio Global Scale", Level B2 | X | |||||
| 7 | they internalize the knowledge and problem-solving skills, ability to apply interdisciplinary studies | X | |||||
| Evaluation System | |
|---|---|
| Semester Studies | Contribution Rate |
| 1. Ödev | 20 |
| 1. Kısa Sınav | 15 |
| 2. Kısa Sınav | 15 |
| 1. Ara Sınav | 50 |
| Total | 100 |
| 1. Final | 60 |
| 1. Yıl İçinin Başarıya | 40 |
| Total | 100 |
| ECTS - Workload Activity | Quantity | Time (Hours) | Total Workload (Hours) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 6 | 96 |
| Total Workload | 144 | ||
| Total Workload / 25 (Hours) | 5.76 | ||
| dersAKTSKredisi | 6 | ||