1	Course Title:	ADVANCED EXCEL APPLICATIONS
2	Course Code:	OSPS051
3	Type of Course:	Optional
4	Level of Course:	Short Cycle
5	Year of Study:	2
6	Semester:	4
7	ECTS Credits Allocated:	3
8	Theoretical (hour/week):	1
9	Practice (hour/week) :	2
10	Laboratory (hour/week) :	0
11	Prerequisites:	None
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Öğr.Gör. Nilgün Özel
16	Course Lecturers:	Türkçe
17	Contactinformation of the Course Coordinator:	Öğr.Gör.Nilgün ÖZEL ozeln@uludag.edu.tr
18	Website:
19	Objective of the Course:	Aim of the advanced Excel lesson: processing and classifying data’s with Excel functions and representing on spreadsheets with charts by making advanced calculations. Increasing Excel efficiency.
20	Contribution of the Course to Professional Development

21

Learning Outcomes:

1 They can use fast moving methods on tables; 2 Using advanced Excel functions; 3 To be able to creating different reports and lists by using spreadsheets.; 4 To be able to use charts on different occasions by drawing a chart.; 5 To be able use to conditional formal, verifying data and scenario features.;

22	Course Content:

Week	Theoretical	Practical
1	Excel general study book, features of using and adding-editing studying	General Excel studying book applications
2	Applying conditional editing’s. Marking the most and the less values. Finding repetitive values on the list. Conditional editing	Conditional formatting applications
3	Sort lists by multiple quotations listing according to couple of conditions.	List sorting applications
4	Filtering the Excel lists, filtering with couple of conditions and listing filtered ones.	Apply filters to lists
5	Limiting, verifying and providing error warning of Excel app	Data validation
6	Using Excel’s frequently used functions(addition, the highest, the least, subtraction etc.)	verifying data applications
7	Functions of date and time(year,month,day,today,full work-day, a day of a week etc.)	Date and time function applications
8	Midterm exam	Applying Vertical And multiple
9	Other functions of Excel; Reaching the values as you wish by using Vertical If there is an error, hiding the errors in the Formula Getting more than one addition by using multiple	Subtotal function applications
10	Studying with subtotals and functions of subtotal	Making graphics
11	Making a chart and using its features	Studying with goal seek, building scenario and solver
12	Studying with goal seek, building scenario and solver	Text and data function applications
13	Using text with data functions (length, capital letter, right to left etc)	Spreadsheet applications
14	Spreadsheets and creating spreadsheet reports.

23	Textbooks, References and/or Other Materials:
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	30
Quiz	0	0
Homeworks, Performances	1	10
Final Exam	1	60
Total	3	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
Information

25

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical
Practicals/Labs
Self Study and Preparation
Homeworks, Performances	1
Projects
Field Studies
Midtermexams
Others
Final Exams
Total WorkLoad
Total workload/ 30 hr
ECTS Credit of the Course

26	CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS
PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10 PQ11 PQ12 LO1 0 0 0 0 0 0 0 0 0 0 0 0 LO2 0 0 0 0 0 0 0 0 0 0 0 0 LO3 0 0 0 0 0 0 0 0 0 0 0 0 LO4 0 0 0 0 0 0 0 0 0 0 0 0 LO5 0 0 0 0 0 0 0 0 0 0 0 0

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High