Excel creates tables by using data, draws graphs of the results in these tables, creates problem solutions with the help of formulas and functions, makes the analysis.
Prerequisite(s)
Course Code Course Name…
Corequisite(s)
Course Code Course Name…
Special Requisite(s)
The minimum qualifications that are expected from the students who want to attend the course.(Examples: Foreign language level, attendance, known theoretical pre-qualifications, etc.)
-- Computer-aided visual expression in the computer laboratory. In the applications, samples are selected which will be useful for the department and each student is allowed to make sample applications on his own.
Principle Sources
--Office 2007, Cenk İltir, Pusula Publishing, 2008, Istanbul
Other Sources
-Windows 7, Joan Preppernau, Joyce Cox, Translated by Erdem Kamil Yildirim, Neslihan Altunel, Friend Publishing, July 2010
- Microsoft Office 2007, Osman Gürkan, Nirvana Publications, February 2008
Course Schedules
Week
Contents
Learning Methods
1. Week
Information and Communication Technology Concepts The physical structure of a personal computer is related to the basic concepts related to data storage, memory, software applications that are widely used in the community and the use of computer networks. In addition, daily use of information technologies are also discussed.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
2. Week
Using the Computer and File Management It is about using the basic functions of a personal computer and the operating system. The objectives of this module are; To understand the desktop environment and to edit files, directories / folders, how to copy, move and delete them. In addition, working with desktop symbols and windows to manage, operating system within the search and correction tools to use the printing functions.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
3. Week
Word Processing It is about using a word processor application on a personal computer. Preparation of a professional text in Microsoft Wrord. Text (Contents), Table of Contents, column (Columns) to create, drop cap, add clip art, footnote, (footnote), to prepare index.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
4. Week
Preparing the contents for graphics, tables, pictures. Insert the tab, prepare the TextBox. Font and Paragraph settings. Numbering.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
5. Week
Working with tables in the text application.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
6. Week
Preparing presentations in Microsoft Power Point.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
7. Week
To prepare graphics in text applications.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
8. Week
Midterm
9. Week
Creating bibliography in professional texts.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
10. Week
Review tab, Translate, Language, Word Count.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
11. Week
Insert tab, cover page. Page Layout tab, Themes.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
12. Week
Prepare SmartArt.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
13. Week
Header, Footer, Page Number. Create WordArt.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
14. Week
Equation, use Hyperlink. Template word files to use.
Oral presentation, laboratory, application, discussion, problem solutions, research, presentations
15. Week
Final Exams
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Program Outcomes
PO-1
Having the necessary equipment for aircraft weight and balance
PO-2
Having basic Civil Aviation knowledge
PO-3
Having knowledge about Flight Operations Management
PO-4
Having knowledge about national aviation organizations
PO-5
To have the terminology used in the field of civil aviation
PO-6
Having knowledge about aircraft basic structure
PO-7
Having knowledge about the operational operation which is in charge at every stage of the flight
PO-8
Having knowledge about aircraft aerodynamics
PO-9
A detailed learning of aircraft navigation systems
PO-10
To have information about the science of meteorology and to examine the effect of meterology on flight operations
PO-11
Having knowledge about aviation communication and navigation systems
PO-12
Having knowledge about air traffic management
PO-13
Being aware of the importance of safety in aviation
Learning Outcomes
LO-1
Learns computer history and its development, the working principles and structure of the computer and how to explain the operations on the computer.
LO-2
Word learns to file, edit and document data through the word processing program.
LO-3
Through the Power Point presentation program, the student learns to prepare audio and animated presentations that interpret the data and show statistical results
LO-4
Excel creates tables by using data, draws graphs of the results in these tables, creates problem solutions with the help of formulas and functions, makes the analysis.
LO-5
Through the Power Point presentation program, the student learns to prepare audio and animated presentations that interpret the data and show statistical results.
LO-6
Thanks to the Internet, it makes communication with e-mail and social networking sites in the fastest and easiest way, and it becomes aware of all developments in the world and examines them