Course Name Code Semester T+U Hours Credit ECTS
Applied Finance With Computer EKO 358 6 2 + 0 2 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator
Course Lecturers
Course Assistants
Course Category
Course Objective The aim of this lecture is to give analitical framework to students about analyzing data.
Course Content This course covers methods of data analysis. These methods are intended for use with the introduction and probability distributions.
# Course Learning Outcomes Teaching Methods Assessment Methods
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,
Week Course Topics Preliminary Preparation
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.
Resources
Course Notes Lecture notes
Course Resources 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;
Order Program Outcomes Level of Contribution
1 2 3 4 5
1
2
3
4
5
6
7
8
9
10
11
12
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 60
1. Kısa Sınav 10
1. Ödev 30
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
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
Total Workload 162
Total Workload / 25 (Hours) 6.48
dersAKTSKredisi 5