| 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 | |||
| # | Ders Öğrenme Çıktılarının Program Çıktılarına Katkısı |
|---|---|
| 1 | to emphasize the importance of the lecture |
| 2 | to gain the ability of bringing and measurement of data |
| 3 | to gain the ability of forecasting |
| 4 | to identify and describe the major theories of statistics, econometrics and finance |
| 5 |
| 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 | ||
| dersAKTSKredisi | 5 | ||