Ders Bilgileri

#### Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
APPLIED FINANCE WITH COMPUTER EKO 358 6 2 + 0 2 5
 Dersin Dili Türkçe Dersin Seviyesi Lisans Dersin Türü SECMELI Dersin Koordinatörü Dersi Verenler Dersin Yardımcıları Dersin Kategorisi Dersin Amacı The aim of this lecture is to give analitical framework to students about analyzing data. Dersin İçeriği This course covers methods of data analysis. These methods are intended for use with the introduction and probability distributions.
 Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri 1 - to emphasize the importance of the lecture 4 - 12 - 13 - 15 - 16 - A - C - 2 - to gain the ability of bringing and measurement of data 4 - 12 - 13 - 15 - 16 - A - C - 3 - to gain the ability of forecasting 4 - 12 - 13 - 15 - 16 - A - C - 4 - to identify and describe the major theories of statistics, econometrics and finance 4 - 12 - 13 - 15 - 16 - A - C -
 Öğretim Yöntemleri: 4:Drilland Practice 12:Case Study 13:Lab / Workshop 15:Problem Solving 16:Project Based Learning Ölçme Yöntemleri: A:Testing C:Homework

#### Ders Akışı

Hafta Konular ÖnHazırlık
1 What is the purpose of developing an Excel program? Relevant part of the following sources will be read.
2 Excel is a general introduction to the basic applications quickly and -1 Relevant part of the following sources will be read.
3 Excel is a general introduction to the basic applications quickly and -2 Relevant part of the following sources will be read.
4 Financial reporting with Excel Relevant part of the following sources will be read.
5 Excel and fundamental analysis - technical analysis Relevant part of the following sources will be read.
6 Excel and interest calculations and annuity calculations, net present value-internal rate of return calculations Relevant part of the following sources will be read.
7 Excel and financial budgeting simulation and modeling-1 Relevant part of the following sources will be read.
8 Simulation and modeling of financial budgeting with Excel-2 Relevant part of the following sources will be read.
9 Mid-term exam Relevant part of the following sources will be read.
10 Improvement works on the cash budget with Excel modeling and model-1 Relevant part of the following sources will be read.
11 Improvement works on the cash budget with Excel modeling and model-2 Relevant part of the following sources will be read.
12 Establishing the valuation of investment projects with Excel, decision-making techniques and model-1 Relevant part of the following sources will be read.
13 Establishing the valuation of investment projects with Excel, decision-making techniques and model-2 Relevant part of the following sources will be read.
14 Final Repeat Relevant part of the following sources will be read.

#### Kaynaklar

Ders Notu Lecture notes
Ders Kaynakları Principles of Finance with Excel, Simon Benningg, Oxford University Press, 2006
Excel programı ile alakalı tüm kitaplar
Excel İle İşletme Analizi; Conrad Carlberg; Sistem yayıncılık;

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

No Program Öğrenme Çıktıları KatkıDüzeyi
1 2 3 4 5

#### Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 60
KisaSinav 1 10
Odev 1 30
Toplam 100
Yıliçinin Başarıya Oranı 50
Finalin Başarıya Oranı 50
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 4 64
Hours for off-the-classroom study (Pre-study, practice) 16 3 48
Mid-terms 1 10 10
Quiz 1 10 10
Assignment 1 10 10
Final examination 1 20 20
Toplam İş Yükü 162
Toplam İş Yükü /25(s) 6.48
Dersin AKTS Kredisi 6.48
; ;