COURSE SYLLABUS

ADVANCED EXCEL APPLICATIONS

1	Course Title:	ADVANCED EXCEL APPLICATIONS
2	Course Code:	OSPS048
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:	Meslek Yüksek okulları yönetim kurullarının görevlendirdiği öğretim elemanları.
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	Thanks to this course, students will be more competent in their profession.

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	Measurement and eyaluation is carried out according to the principles of Bursa Uludağ University Associate and Undergraduate Education Regulation.
Information	Results are determined with the tetter grade determined by the student automation system.

ECTS / WORK LOAD TABLE

CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High