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.
(2) SPSS Uygulamalı Çok Değişkenli İstatistik Teknikleri, Şeref Kalaycı, Asil Yayınevi

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