1. Eğitim Bilgi Sistemi
  2. Ekonometri Bölümü
  3. Applıed Fınance Wıth Computer (2020 - 2021)
Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Applıed Fınance Wıth Computer EKO 358 6 2 + 0 2 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü Seçmeli
Dersin Koordinatörü Doç.Dr. MÜCAHİT AYDIN
Dersi Verenler
Dersin Yardımcıları
Dersin Kategorisi Diğer
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.
# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 to emphasize the importance of the lecture Drilland Practice, Case Study, Lab / Workshop, Problem Solving, Project Based Learning, Testing, Homework,
2 to gain the ability of bringing and measurement of data Drilland Practice, Case Study, Lab / Workshop, Problem Solving, Project Based Learning, Testing, Homework,
3 to gain the ability of forecasting Drilland Practice, Case Study, Lab / Workshop, Problem Solving, Project Based Learning, Testing, Homework,
4 to identify and describe the major theories of statistics, econometrics and finance Drilland Practice, Case Study, Lab / Workshop, Problem Solving, Project Based Learning, Testing, Homework,
5
Hafta Ders Konuları Ön Hazı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;
Sıra Program Çıktıları Katkı Düzeyi
1 2 3 4 5
1
2
3
4
5
6
7
8
9
10
11
12
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 60
1. Kısa Sınav 10
1. Ödev 30
Toplam 100
1. Yıl İçinin Başarıya 50
1. Final 50
Toplam 100
AKTS - İş Yükü Etkinlik Sayı Süre (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 (Saat) 6,48
Dersin AKTS Kredisi 5