Ders Bilgileri

#### Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
COMPUTER APPLICATIONS IN FINANCE EKO 554 0 3 + 0 3 6
 Dersin Dili Türkçe Dersin Seviyesi Yüksek Lisans Dersin Türü SECMELI Dersin Koordinatörü Dr.Öğr.Üyesi ÇİSEM BEKTUR Dersi Verenler Dersin Yardımcıları Arş. Gör. Gürkan Malcıoğlu Dersin Kategorisi Alanına Uygun Öğretim Dersin Amacı 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. Dersin İçeriği 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
 Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri 1 - She/He sees the logic of the financial functions contained in Excel 1 - 2 - 4 - A - C - F - 2 - She/He sees the logic of the statistical functions contained in Excel 1 - 2 - 4 - A - C - F - 3 - She/He sees what way to use these functions. 1 - 2 - 4 - A - C - F - 4 - She/He sees how adapt these functions to our business lives. 1 - 2 - 4 - A - C - F -
 Öğretim Yöntemleri: 1:Lecture 2:Question-Answer 4:Drilland Practice Ölçme Yöntemleri: A:Testing C:Homework F:Performance Task

#### Ders Akışı

Hafta Konular ÖnHazırlık
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

#### Kaynaklar

Ders Notu

Lecture notes

Ders Kaynakları

(1) Baştan Sona Excel, Pusula Yayıncılık.
(2) SPSS Uygulamalı Çok Değişkenli İstatistik Teknikleri, Şeref Kalaycı, Asil Yayınevi

#### Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çıktıları KatkıDüzeyi
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

#### Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 60
KisaSinav 1 10
KisaSinav 2 10
Odev 1 20
Toplam 100
Yıliçinin Başarıya Oranı 40
Finalin Başarıya Oranı 60
Toplam 100

#### AKTS - İş Yükü

Etkinlik Sayısı Süresi(Saat) Toplam İş yükü(Saat)
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
Toplam İş Yükü 144
Toplam İş Yükü /25(s) 5.76
Dersin AKTS Kredisi 5.76
; ;