1	Course Title:	ADVANCED EXCEL
2	Course Code:	EKO3010
3	Type of Course:	Optional
4	Level of Course:	First Cycle
5	Year of Study:	3
6	Semester:	6
7	ECTS Credits Allocated:	5
8	Theoretical (hour/week):	3
9	Practice (hour/week) :	0
10	Laboratory (hour/week) :	0
11	Prerequisites:	No
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Prof. Dr. ERKAN IŞIGIÇOK
16	Course Lecturers:	Prof. Dr. Erkan IŞIĞIÇOK
17	Contactinformation of the Course Coordinator:	E-posta : eris@uludag.edu.tr Telefon: 0 224 29 41101 Adres: Bursa Uludağ Üniversitesi, İktisadi ve İdari Bilimler Fakültesi, Ekonometri Bölümü,16059, Görükle/Bursa.
18	Website:
19	Objective of the Course:	The aim of the course is to develope used in daily life and work of mathematical, statistical and financial-related programs (software) and execute advanced automatic-analysis with macro operations.
20	Contribution of the Course to Professional Development	Methods and techniques of education is to give the students can apply to their fields.

21

Learning Outcomes:

1 To be able to use effectively the Excel program menus.; 2 To be able to use effectively the Excel program commands.; 3 To be able to execute advanced calculations in Excel program.; 4 To be able to calculate descriptive statistics in Excel program.; 5 To be able to calculate inferential statistics in Excel program.; 6 To be able to run macro operations in Excel program.; 7 To be able to management of database in Excel program. ; 8 To be able to develop programs (software) mathematical, statistical and financial-related in Excel. ;

22	Course Content:

Week	Theoretical	Practical
1	General features of the Excel program
2	Menus, commands, and use of formula of the Excel program
3	Linear algebra applications with Excel
4	Solutions to systems of equations with multiple variables in Excel
5	Descriptive statistics applications in Excel
6	Inferential statistics applications in Excel
7	Statistical (Shewhart) control charts applications with Excel
8	Macro procedures and practices in Excel
9	Advanced automatically analyses in Excel program
10	Management of database in Excel program
11	Data query and sort in Excel
12	Data summarizing operations in Excel program
13	Programs (software) development mathematical, statistical and financial-related
14	Regression and correlation analysis applications in Excel

23	Textbooks, References and/or Other Materials:	1. Erkan IŞIĞIÇOK, Uygulamalı Bilgisayar 2, Marmara Kitabevi, 2001, Bursa.
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	40
Quiz	0	0
Homeworks, Performances	0	0
Final Exam	1	60
Total	2	100
Contribution of Term (Year) Learning Activities to Success Grade		40
Contribution of Final Exam to Success Grade		60
Total		100
Measurement and Evaluation Techniques Used in the Course	Multiple choice test questions and written questions
Information	This course is evaluated with a relative evaluation system.

25

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical	14	3	42
Practicals/Labs	0	0	0
Self Study and Preparation	14	2	28
Homeworks, Performances	0	0	0
Projects	0	0	0
Field Studies	0	0	0
Midtermexams	1	40	40
Others	0	0	0
Final Exams	1	40	40
Total WorkLoad			150
Total workload/ 30 hr			5
ECTS Credit of the Course			5

26	CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS
PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10 LO1 1 2 1 4 1 1 4 3 5 4 LO2 1 2 2 4 1 1 4 3 4 4 LO3 1 2 2 3 1 1 4 4 4 4 LO4 1 2 1 5 1 1 5 4 5 4 LO5 1 2 1 5 1 1 4 4 5 4 LO6 2 2 1 4 1 1 4 4 4 5 LO7 1 2 1 5 1 1 4 5 5 4 LO8 1 1 1 5 1 1 4 4 5 4

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High