Aviation Management
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

General course introduction information

Course Code:

ISLT290

Course Name:

Advanced Excel Applications

Course Semester:

Spring

Course Credits:

Theoretical	Practical	Credit	ECTS
3	0	3	6

Language of instruction:

Course Requisites:

Does the Course Require Work Experience?:

Type of course:

Common Pool

Course Level:

Bachelor

TR-NQF-HE:6. Master`s Degree

QF-EHEA:First Cycle

EQF-LLL:6. Master`s Degree

Mode of Delivery:

Face to face

Course Coordinator :

Dr.Öğr.Üyesi İLKER CALAYOĞLU

Course Lecturer(s):

Dr.Öğr.Üyesi İLKER CALAYOĞLU

Course Assistants:

Course Objective and Content

Course Objectives:	The aim of this course is to enable students to gain the ability to calculate, report, summarize and analyze excel skills. Thus they will be more functional at the internship and at the workplace.
Course Content:	Basic Excel use; working with worksheets and books; working with data lists; conditional and unconditional formatting; working with graphics; logical and mathematical functions; statistical functions; financial functions; subtotals, preparing tables and summary table analysis; pivot tables; macros; data analysis.

Learning Outcomes

The students who have succeeded in this course;

Learning Outcomes

1 - Knowledge
Theoretical - Conceptual
1) • Manages Excel files.
2 - Skills
Cognitive - Practical
1) • Calculations numerical data
2) • Apply to graphics and tables.
3) • Filter through the mass data and analyze.
3 - Competences
Communication and Social Competence
Learning Competence
1) • Summarize data
Field Specific Competence
Competence to Work Independently and Take Responsibility

Lesson Plan

Week	Subject	Related Preparation
1)	• Describe to the course. • Define the course to the students • Syllabus • Discuss to course topics • Discuss to course outline
2)	• Saves the active document. • Change the type of file. • Recovery the Files • Document management • Saving types • Difference between save and save as
3)	• Conditional and unconditional cell formatting • Using of cell styles. • Working with name of cells • Adding, deleting and managing to row and columns • Adding, deleting and managing to worksheets • Formatting to cells • Formatting to worksheets • Data validation	Reads from book about cell and worksheet formatting.
4)	• Makes transaction between workbooks. • Manages the workbook view. • Works with windows. • Work with workbook • Build a bridge	Reads from book about workbook.
5)	• Sort and filter data. • Works with subtotals. • Data is grouped and leveling. • Transaction of database • Sort and filter data. • Get subtotals of data • Data grouping and leveling.	Reads from book about database
6)	• Draw graphics. • Set the graphic design. • Creates graphic labels. • Graphic formats. • Working with Graphics	reads from book about graphics
7)	• Creates pivot table • Filter Data • Creates alternative summary tables. • Creates pivot graph	Chapter 8 – Lecturing and practice
8)	midterm exam
9)	• Analyze statistical functions. • Analyze financial functions.	Chapter 9 – Lecturing and practice
10)	• Analyze the logical functions. • Analyze textual functions.	Reads from book about functions
11)	• Applies the image adding program. • Comments to Vector draws • Saves the SmartArt graphic. • Records to pictures and drawings.	Reads from book about pictures and drawings.
12)	• Creates a macro. • Make changes in the macro and comments. • Delete and rename to macro	Repeating what has been done
13)	• To share documents. • Monitoring changes in the shared workbook. • Protects and encrypts to documents	Reads from book about workbook sharing and its protection
14)	• General options • Formula options • Calculation options • Writing checking options • Save options • Advanced options • Customize the strip	Reads from book about to customize Excel 2010
15)	final exam

Sources

Course Notes / Textbooks:	Microsoft Excel 2010 Gürkan, Osman 2013 Nirvana Yayınları Published: 2013 ISBN: 978-975-8878-76-5
References:	Yok

Course-Program Learning Outcome Relationship

Learning Outcomes	1	2	4	5	3
Program Outcomes
1) He/she has in-depth information required by the legal, social and environmental framework in which all transportation operations, especially aviation, are involved.
2) He/she has advanced theoretical and practical knowledge, supported by books, equipment and other sources containing up-to-date information on air transportation / logistics.
3) He/she has sufficient knowledge for the technical aspects of air transportation and logistics.
4) He/she has sufficient legal knowledge on basic issues related to international trade and business.
5) He/she uses theoretical and practical knowledge in aviation business management, logistics, transportation and business management solutions together.
6) He/she uses theoretical and applied knowledge in mathematics, science and transportation together to solve operational problems.
7) He/she identifies, defines, formulates and solves basic problems related to the field of air transportation / logistics. For this purpose, he/she selects and applies appropriate analytical methods and modeling techniques.
8) He/she analyzes a system, system component or process and designs it under realistic constraints to meet desired requirements; applies modern design methods accordingly.
9) He/she selects and uses modern and technical tools required for basic applications in air transportation / logistics.
10) He/she independently conducts a comprehensive advanced level study in air transportation / logistics.
11) He/she accesses information by doing research, uses databases and other information resources.
12) He/she works effectively in multidisciplinary teams and takes responsibility.
13) He/she plans project development studies in the field and manages related activities.
14) He/she organizes, plans and directs teamwork in air transportation / logistics related comprehensive projects.
15) With the awareness of the necessity of life-long learning, he/she follows science and technology developments in aviation management, logistics and transportation and renews himself/herself constantly. He/she also evaluates the knowledge / skills acquired in the field with a critical thinking.
16) He/she works individually and in multi-disciplinary teams in aviation management, national and international transportation and logistics environments both in theoretical and applied fields.
17) He/she selects and uses modern and technical tools necessary for air transport / logistics applications.
18) He/she communicates effectively with relevant people and institutions, being aware of the universal and social effects of applications and solutions in the aviation field.
19) He/she develops solutions to problems and shares his ideas in writing and verbally, supporting them with quantitative and qualitative data.
20) He/she has a comprehensive understanding about management of aviation companies, safety and security issues in aviation, air law, airport operations and technical aspects of aviation specific applications.
21) He/she is aware of the aviation principles and values. He/she has professional and ethical responsibility.

Course - Learning Outcome Relationship

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	He/she has in-depth information required by the legal, social and environmental framework in which all transportation operations, especially aviation, are involved.
2)	He/she has advanced theoretical and practical knowledge, supported by books, equipment and other sources containing up-to-date information on air transportation / logistics.
3)	He/she has sufficient knowledge for the technical aspects of air transportation and logistics.
4)	He/she has sufficient legal knowledge on basic issues related to international trade and business.
5)	He/she uses theoretical and practical knowledge in aviation business management, logistics, transportation and business management solutions together.
6)	He/she uses theoretical and applied knowledge in mathematics, science and transportation together to solve operational problems.
7)	He/she identifies, defines, formulates and solves basic problems related to the field of air transportation / logistics. For this purpose, he/she selects and applies appropriate analytical methods and modeling techniques.
8)	He/she analyzes a system, system component or process and designs it under realistic constraints to meet desired requirements; applies modern design methods accordingly.
9)	He/she selects and uses modern and technical tools required for basic applications in air transportation / logistics.
10)	He/she independently conducts a comprehensive advanced level study in air transportation / logistics.
11)	He/she accesses information by doing research, uses databases and other information resources.
12)	He/she works effectively in multidisciplinary teams and takes responsibility.
13)	He/she plans project development studies in the field and manages related activities.
14)	He/she organizes, plans and directs teamwork in air transportation / logistics related comprehensive projects.
15)	With the awareness of the necessity of life-long learning, he/she follows science and technology developments in aviation management, logistics and transportation and renews himself/herself constantly. He/she also evaluates the knowledge / skills acquired in the field with a critical thinking.
16)	He/she works individually and in multi-disciplinary teams in aviation management, national and international transportation and logistics environments both in theoretical and applied fields.
17)	He/she selects and uses modern and technical tools necessary for air transport / logistics applications.
18)	He/she communicates effectively with relevant people and institutions, being aware of the universal and social effects of applications and solutions in the aviation field.
19)	He/she develops solutions to problems and shares his ideas in writing and verbally, supporting them with quantitative and qualitative data.
20)	He/she has a comprehensive understanding about management of aviation companies, safety and security issues in aviation, air law, airport operations and technical aspects of aviation specific applications.
21)	He/she is aware of the aviation principles and values. He/she has professional and ethical responsibility.

Learning Activity and Teaching Methods

Field Study
Peer Review
Expression
Lesson
Lab
Homework
Problem Solving
Report Writing

Assessment & Grading Methods and Criteria

Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing)
Homework
Application
Observation
Presentation
Reporting
Bilgisayar Destekli Sunum

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
Attendance	14	% 10
Midterms	1	% 40
Final	1	% 50
total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
total		% 100

Workload and ECTS Credit Grading

Activities	Number of Activities	Workload
Course Hours	13	39
Study Hours Out of Class	13	94
Midterms	1	14
Final	1	18
Total Workload		165