Course Detail

Course Description

CourseCodeSemesterT+P (Hour)CreditECTS
INFORMATION TECHNOLOGYAVM1224520Spring Semester2+025
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of CourseEnglish
Course LevelFirst Cycle (Bachelor's Degree)
Course TypeRequired
Course CoordinatorAssist.Prof. Recep ÖZSÜRÜNÇ
Name of Lecturer(s)Assist.Prof. Recep ÖZSÜRÜNÇ
Assistant(s)
AimTo teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels.
Course ContentThis course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations.
Course Learning OutcomesTeaching MethodsAssessment Methods
5.Will be able to use presentation programs.12, 14, 16, 4, 6, 9A, E, G
1. will be able to explains the basic concepts of information technology.16, 9A, E
1.1 Explains the general concepts.
1.2 Displays hardware components.
1.3 Explains the concept of software, examples of software types.
2. Will be able to apply computer usage and file management.16, 8, 9A, E
2.1 Turns on the computer device.
2.2 Explains the concept of the desktop.
2.3 Describes how to perform file management.
3. Will be able to express how the word processor program is used.12, 14, 16, 9A, E, G
3.1. Describes usage of the application.
3.2. Explains Basic Operations.
3.3. Explains formatting methods.
4. Will be able to use a spreadsheet program.12, 14, 16, 4, 9A, E, G
4.1. Describes the usage of the application.
4.2. Explains cell concept.
4.3. Describes the concept of the worksheet.
4.4. Uses Formulas and Functions.
4.5. Describes the types of formatting.
4.6. Describes the use of graphics.
5.1. Describes usage of the application.
5.2. Describes creating a presentation.
5.3. opens Text and Views .
5.4. applies the use of Graphics and Drawing Objects (Auto Shape).
5.5. Uses Screen Display Effects.
Teaching Methods:12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method
Assessment Methods:A: Traditional Written Exam, E: Homework, G: Quiz

Course Outline

OrderSubjectsPreliminary Work
1History of Computer and Introduction to Office ProgramsRelated chapter in the course book should be read.
2Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
3Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
4Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
5Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
6Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
7Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
8Creating Documents with Microsoft WordRelated chapter in the course book should be read.
9Creating Documents with Microsoft WordRelated chapter in the course book should be read.
10Creating Cover Letters and Using Tables to Create ResumesRelated chapter in the course book should be read.
11Creating Cover Letters and Using Tables to Create ResumesRelated chapter in the course book should be read.
12Getting Started with Microsoft PowerPointRelated chapter in the course book should be read.
13Getting Started with Microsoft PowerPointRelated chapter in the course book should be read.
14Formatting PowerPoint PresentationsRelated chapter in the course book should be read.
Resources
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson.
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform

Course Contribution to Program Qualifications

Course Contribution to Program Qualifications
NoProgram QualificationContribution Level
12345
1
Defines the theoretical knowledge in the field of aviation management.
2
Explains the necessary of mathematical and statistical methods in the field of aviation management.
3
Uses at least one computer program required in the field of aviation management.
4
Demonstrates proficiency in foreign language proficiency required in the field of aviation management.
5
Prepares projects about his field and manages team works.
6
It critically evaluates the knowledge and skills that it constantly renews and acquires by following the developments in the field of Aviation management with the awareness of lifelong learning in the professional field.
7
Uses theoretical and practical information in the field of aviation management.
8
Follows up to date technologies and communicates verbally/writing using a foreign language at least A2 level.
9
Adopts and uses organizational / corporate, business and social ethical values.
10
It adopts social responsibility principles and takes initiative when necessary, within the framework of public service sensitivity.
11
In order to carry out interdisciplinary studies, analyze basic information and data in different disciplines and use them in the field.
12
It offers appropriate suggestions in both micro and macro frameworks in the face of problems in the aviation management sectors.

Assessment Methods

Contribution LevelAbsolute Evaluation
Rate of Midterm Exam to Success 40
Rate of Final Exam to Success 60
Total 100
ECTS / Workload Table
ActivitiesNumber ofDuration(Hour)Total Workload(Hour)
Course Hours14228
Guided Problem Solving3721
Resolution of Homework Problems and Submission as a Report21632
Term Project000
Presentation of Project / Seminar7535
Quiz133
Midterm Exam177
General Exam11414
Performance Task, Maintenance Plan000
Total Workload(Hour)140
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(140/30)5
ECTS of the course: 30 hours of work is counted as 1 ECTS credit.

Detail Informations of the Course

Course Description

CourseCodeSemesterT+P (Hour)CreditECTS
INFORMATION TECHNOLOGYAVM1224520Spring Semester2+025
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of CourseEnglish
Course LevelFirst Cycle (Bachelor's Degree)
Course TypeRequired
Course CoordinatorAssist.Prof. Recep ÖZSÜRÜNÇ
Name of Lecturer(s)Assist.Prof. Recep ÖZSÜRÜNÇ
Assistant(s)
AimTo teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels.
Course ContentThis course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations.
Course Learning OutcomesTeaching MethodsAssessment Methods
5.Will be able to use presentation programs.12, 14, 16, 4, 6, 9A, E, G
1. will be able to explains the basic concepts of information technology.16, 9A, E
1.1 Explains the general concepts.
1.2 Displays hardware components.
1.3 Explains the concept of software, examples of software types.
2. Will be able to apply computer usage and file management.16, 8, 9A, E
2.1 Turns on the computer device.
2.2 Explains the concept of the desktop.
2.3 Describes how to perform file management.
3. Will be able to express how the word processor program is used.12, 14, 16, 9A, E, G
3.1. Describes usage of the application.
3.2. Explains Basic Operations.
3.3. Explains formatting methods.
4. Will be able to use a spreadsheet program.12, 14, 16, 4, 9A, E, G
4.1. Describes the usage of the application.
4.2. Explains cell concept.
4.3. Describes the concept of the worksheet.
4.4. Uses Formulas and Functions.
4.5. Describes the types of formatting.
4.6. Describes the use of graphics.
5.1. Describes usage of the application.
5.2. Describes creating a presentation.
5.3. opens Text and Views .
5.4. applies the use of Graphics and Drawing Objects (Auto Shape).
5.5. Uses Screen Display Effects.
Teaching Methods:12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method
Assessment Methods:A: Traditional Written Exam, E: Homework, G: Quiz

Course Outline

OrderSubjectsPreliminary Work
1History of Computer and Introduction to Office ProgramsRelated chapter in the course book should be read.
2Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
3Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
4Creating a Worksheet and Charting Data in ExcelRelated chapter in the course book should be read.
5Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
6Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
7Using Functions, Creating Tables, and Managing Large Workbooks in ExcelRelated chapter in the course book should be read.
8Creating Documents with Microsoft WordRelated chapter in the course book should be read.
9Creating Documents with Microsoft WordRelated chapter in the course book should be read.
10Creating Cover Letters and Using Tables to Create ResumesRelated chapter in the course book should be read.
11Creating Cover Letters and Using Tables to Create ResumesRelated chapter in the course book should be read.
12Getting Started with Microsoft PowerPointRelated chapter in the course book should be read.
13Getting Started with Microsoft PowerPointRelated chapter in the course book should be read.
14Formatting PowerPoint PresentationsRelated chapter in the course book should be read.
Resources
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson.
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform

Course Contribution to Program Qualifications

Course Contribution to Program Qualifications
NoProgram QualificationContribution Level
12345
1
Defines the theoretical knowledge in the field of aviation management.
2
Explains the necessary of mathematical and statistical methods in the field of aviation management.
3
Uses at least one computer program required in the field of aviation management.
4
Demonstrates proficiency in foreign language proficiency required in the field of aviation management.
5
Prepares projects about his field and manages team works.
6
It critically evaluates the knowledge and skills that it constantly renews and acquires by following the developments in the field of Aviation management with the awareness of lifelong learning in the professional field.
7
Uses theoretical and practical information in the field of aviation management.
8
Follows up to date technologies and communicates verbally/writing using a foreign language at least A2 level.
9
Adopts and uses organizational / corporate, business and social ethical values.
10
It adopts social responsibility principles and takes initiative when necessary, within the framework of public service sensitivity.
11
In order to carry out interdisciplinary studies, analyze basic information and data in different disciplines and use them in the field.
12
It offers appropriate suggestions in both micro and macro frameworks in the face of problems in the aviation management sectors.

Assessment Methods

Contribution LevelAbsolute Evaluation
Rate of Midterm Exam to Success 40
Rate of Final Exam to Success 60
Total 100

Numerical Data

Publication Date: 07/10/2026 - 11:31Last Update : 07/10/2026 - 11:31
×

What did you search?

 
  • A-Z Programs
  • Undergraduate
  • Graduate
  • Academic Calendar
  • Double Major & Minor Programs
  • Erasmus
  • Prospective Students
  • Registration
  • Re-Enrolment
  • Fees
  • Directorate of Registrar’s Office
  • FAQ
  • Accommodation
  • Scholarships
  • Lateral and Vertical Transfer
  • Summer School
  • Preparation
  • Transportation

Knowledge / Support Button