SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code	Course Name	Year	Semester	Theoretical	Practical	Credit	ECTS
50611YETOS-BIT2022	Information and Communication Technologies	1	Spring	2	0	2	3

Course Type :	University Elective
Cycle:	Associate      TQF-HE:5. Master`s Degree      QF-EHEA:Short Cycle      EQF-LLL:5. Master`s Degree
Language of Instruction:	Turkish
Prerequisities and Co-requisities:	N/A
Mode of Delivery:	E-Learning
Name of Coordinator:	Instructor STAFF
Dersin Öğretim Eleman(lar)ı:
Dersin Kategorisi:	Competency Development (University Elective)

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

Course Objectives:	This course includes basic computer concepts, keyboard / word processing program applications, spreadsheets and presentation applications to provide students with versatile information technology literacy. • To introduce the fundamentals of information technology and basic computer concepts • Word processing, spreadsheets and presentation
Course Content:	Introduction to computing; introduction to computer hardware and software; word processing, spreadsheet, presentation; web software tools.

Course Specific Rules

None

Course Learning Outcomes (CLOs)

Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:

Knowledge (Described as Theoritical and/or Factual Knowledge.)

Skills (Describe as Cognitive and/or Practical Skills.)

1) Prepares a document containing text, pictures and tables in the word processing program (Microsoft Word) and organizes this document according to its needs.

2) Applies effective presentation techniques through Microsoft Powerpoint program.

3) Prepares documents in spreadsheet (Microsoft Excel) program, can use functions in EXCEL program, makes graphical representation and data analysis.

Competences (Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)

Weekly Course Schedule

Week	Subject	Materials Sharing *
		Related Preparation	Further Study
1)	Introduction to the course and information about the processing Explanation of lesson plan and grade evaluation (Orientation) Basic concepts of Information Technologies Microsoft Office - Introduction to Word • Introducing the Word Interface • Using the Quick Access Toolbar Working with Document View Modes • Opening a New Document	None	None
2)	Microsoft Office Word– Text Formatting Operations • Editing Paragraph Settings • Editing Borders and Shading Options • Adding Bullets and Numbering	None	None
3)	Microsoft Office Word– Text Formatting Operations • Dividing the Text into Columns • Enlarging the Beginning Change Capital / Lower Case • Finding and Replacing Text • Adding Date and Time • Adding Page Number	None	None
4)	Microsoft Office Word - Working with Tables - Using Advanced Word Tools • Creating Tables • Adding and Deleting Rows, Columns • Applying Style to the Table • Convert Table to Text • Adding Page Break • Adding End of Section • Adding Hyperlink to Text	None	None
5)	Microsoft Office Excel- Data Entry / Cell and Table Formatting • Introduction of the Interface • Data input • Moving and Copying • Adding Comments • Cell Forming	None	None
6)	Microsoft Office Excel- Functions and Calculations • Conditional formatting • Formula Entry • Mathematical Functions	None	None
7)	Microsoft Office Excel- Functions and Calculations • Statistical Functions • Textual Functions • Sorting, Filtering	None	None
8)	midterm exam week	None	None
9)	Microsoft Office Excel- Data Processing • Pivot Table - Pivot Chart (Pivot Chart) • Data Validation • Removing Duplicate Data	None	None
10)	Microsoft Office Excel- Page Layout and Print Settings / Appearance Properties • Paper Size Selection • Setting Margins • Vertical / Horizontal Page Usage • Header / Footer Settings • Page Break Operations • Print Options • Appearance Settings	None	None
11)	Microsoft Office - Introduction to Powerpoint / Creating a New Presentation • Introduction of the Interface • Presentation and Slide Concepts Document View Modes • Creating a Presentation Using a Template • Adding and Editing Text • Saving Options Microsoft Office Powerpoint- Working with Slide Structure and Text Based Components • Choosing a Design Theme • Selecting Slide Layout • Working with Text Boxes • Formatting Text • Using Bullets and Numbering	None	None
12)	Microsoft Office Powerpoint- Slide Arrangements • Changing Slide Layouts • Copying and Deleting Slides • Hiding and Viewing Slides • Adding Slide Transition Effects • Adding Slides from Other Presentations Using the Find and Replace Tool	None	None
13)	Microsoft Office Powerpoint- Working with Pictures, Tables, Graphics • Adding Pictures to Slides • Grouping Objects • Adding Tables • Editing the Table Design • Adding and Deleting Cells, Rows, Columns • Aligning Text in Tables • Adding Graphics Formatting and Resizing the Chart	None	None
14)	Microsoft Office Powerpoint- Animations • Using the Animation Tab • Adding Input and Output Animations • Adding Emphasis • Using Motion Paths • Editing Animation Effects • Using Saved Templates	None	None

*These fields provides students with course materials for their pre- and further study before and after the course delivered.

Recommended or Required Reading & Other Learning Resources/Tools

Course Notes / Textbooks:	Word Test soruları Power Point Test soruları Excel Test soruları
References:	Hızlı Ve Kolay Office Kodlab Yayınları Mehmet Gülmez Office 2016 Abaküs Yayıncılık Mehmet Gülmez Bilgisayar Ve Ofis Programları Kullanımı Alfa Aktüel Yayınları Office 2016 Abaküs Kitap Cenk İltir

Level of Contribution of the Course to PLOs

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

	Programme Learning Outcomes	Contribution Level (from 1 to 5)
1)	Ability to work in a planned and disciplined manner, time management, problem solving and proactive thinking and acting skills and may have the skills of team work , empathy and listening.
1)	Implementation of necessary safety and security measures and provision of passenger comfort in passenger transport aircraft. Maybe able to explain both basic, theorical and practical knowledge about national and international civil aviation.
2)	May be able to acquire the ability to use theoretical and practical knowledge in the fields of Civil Aviation, Transportation Management, Cabin Services and other social sciences. May be able to responsibilitiy in a team and have the ability to take part in team work .
3)	May be able to have general information about airport ground handling operations.May be to do both check - in and bording .
4)	May be able to communicate effectively with experts and non-experts within the aviation industry. M ay be to apply the knowledge learned in businnes life for a semester , May be to follow literature and progresses about Air Transport closely .
5)	May be able to acquire the competencies defined as the institutional outcomes of Beykoz University on the basic level, inline with the expectations of business world and the society. May be to show entrepeneurial about passenger services in terminal buildings.
6)	May be able to determine vocational and personal learning requirements and to have sustainable development by using life long learning possibilities. An may be able to understand passenger service processes from beginning to end and implement them at the airport and on board .
7)	May be able to have the ability of applying the theorical knowledge about customer relations and communication.
8)	May be able to lead people under his/her responsiblity for determining and providing their personal learning reqirements and for their career development.
9)	May be able to explain projects, opinions and solution offers of the problems that are performed about the Aviation to the experts and nonexperts by using written, verbal and visual communication instruments.
10)	May be able to follow information on the area and communicate with the colleagues by using a foreign language (English) minimum on A2 level of European Language Portfolio.
11)	May be able to use mother language on the C1 level of European Language Portfolio.
12)	May be able to participate and support projects and activities for the social enviroment with the social responsibility awareness.
13)	May be able to apply occupational health and safety, environmental protection, quality and continous improvement processes that are considered necessary for Civil Aviation Cabin Crew Service.
14)	May be able to have enough awareness on the subjects of universalism of social rights, social justice, and cultural values, and to respect the cultural differences.
15)	May have the knowledge about national and international civil aviation authorities.

SECTION IV: TEACHING-LEARNING & ASSESMENT-EVALUATION METHODS OF THE COURSE

Teaching & Learning Methods of the Course

(All teaching and learning methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Teaching and Learning Methods defined at the Programme Level	Teaching and Learning Methods Defined for the Course
Lectures
Demonstration
Laboratory
Homework

Assessment & Evaluation Methods of the Course

(All assessment and evaluation methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Aassessment and evaluation Methods defined at the Programme Level	Assessment and Evaluation Methods defined for the Course
Midterm
Final Exam
Quiz

Contribution of Assesment & Evalution Activities to Final Grade of the Course

Measurement and Evaluation Methods	# of practice per semester	Level of Contribution
Quizzes	2	% 20.00
Midterms	1	% 30.00
Semester Final Exam	1	% 50.00
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
Total		% 100

SECTION V: WORKLOAD & ECTS CREDITS ALLOCATED FOR THE COURSE

WORKLOAD OF TEACHING & LEARNING ACTIVITIES
Teaching & Learning Activities	# of Activities per semester	Duration (hour)	Total Workload
Course	14	3	42
Laboratory	0	0	0
Application	0	0	0
Special Course Internship (Work Placement)	0	0	0
Field Work	0	0	0
Study Hours Out of Class	0	0	0
Presentations / Seminar	0	0	0
Project	0	0	0
Homework Assignments	1	5	5
Total Workload of Teaching & Learning Activities	-	-	47
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES
Assesment & Evaluation Activities	# of Activities per semester	Duration (hour)	Total Workload
Quizzes	2	10	20
Midterms	1	5	5
Semester Final Exam	1	10	10
Total Workload of Assesment & Evaluation Activities	-	-	35
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities)			82
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h)			3