Course Code	Semester	Course Name	LE/RC/LA	Course Type	Language of Instruction	ECTS
BİL2001	2	INTRODUCTION TO COMPUTER II	4/0/0	CC	Türkçe	4

Course Goals	The aim of this course is to provide the students with the basic concepts of spreadsheets and the ability to work with spreadsheets on the personal computer. Using graphic and presentation programs to make their research into professional files and to produce presentation file, to transfer their knowledge, to find solutions to the problems they face. To understand what the database is and how it is organized, to create a database and to make queries and to obtain reports.
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.)
Instructor(s)	Lecturer Erdem Yücesan
Course Assistant(s)
Schedule	distance education
Office Hour(s)	distance education
Teaching Methods and Techniques	-use of visual presentation applications in lecture. Application of the topics described in the computer environment. Students will do research on selected topics
Principle Sources	-Students make the text and presentation of the topics they research. Basic Resources Office, English version, N.Tekin, M.Tekin, Istanbul Kultur University, 2011. Other Resources Microsoft Office Professional 2010 Step by Step (Microsoft)) by Joan Lambert III, Joyce Cox and Curtis Frye D. (Sep 10, 2010)
Other Sources	-Microsoft Word 2010 Step by Step (Step by Step (Microsoft)) by Joyce Cox and Joan Lambert III (Jun 23, 2010)   Introduction to Computer, Faruk Çubukçu, Gama Press Release Distribution, Publication Year: 2011; 726sayf to.   Windows 7 and Ms Office 2010, Hayrettin Third, Alfa Publications, Istanbul, 2011. Introduction to Computer, Faruk Çubukçu, Gama Press Release Distribution, Publication Year: 2011; 726sayf to.   Teach Yourself VISUALLY Office 2013 (Teach Yourself VISUALLY (Tech)) by Elaine Marmel (Mar 18, 2013)   Introduction to Computers (Shelley Cashman Series) by Gary B. Shelly, Steven M. Freund and Misty E. Vermaat (Jun 18, 2010)

Course Schedules
Week	Contents	Learning Methods
1. Week	ıntroduction to Microsoft Excel. Basic operations in Excel applications. Table preparation, arithmetic operations, sum function and graphics to create.	Course presentation files, textbook, computer studies, researches
2. Week	Function use; Count, Max, Min, Countif, if functions.	Course presentation files, textbook, computer studies, researches
3. Week	Create PivotChart.	Course presentation files, textbook, computer studies, researches
4. Week	Use of form control elements. Group Box, Option Button.	Course presentation files, textbook, computer studies, researches
5. Week	Contitional formating, Data Validation, $ operator.	Course presentation files, textbook, computer studies, researches
6. Week	Insert Function, Forecast, Date, Today, Time, Int, Round, Pmt, Product, Rand, RandBetween functions.	Course presentation files, textbook, computer studies, researches
7. Week	Matrix operations, equation solutions with many unknowns	Course presentation files, textbook, computer studies, researches
8. Week	Midterm
9. Week	Working in different sheets, conditional formating, data filter.	Course presentation files, textbook, computer studies, researches
10. Week	Add tables from SQL server, add tables from Access, excel in Visual Basic applications, macro, loop.	Course presentation files, textbook, computer studies, researches
11. Week	Now, Option, Vlookup, Hlookup, Combo Box and applications.	Course presentation files, textbook, computer studies, researches
12. Week	Access to the Access database. Create Objects, Table, Form and Report.	Course presentation files, textbook, computer studies, researches
13. Week	Create a database, OLE Object, Text Object, Report. Using SQL codes in queries, transfer table to excel.	Course presentation files, textbook, computer studies, researches
14. Week	Work with multiple tables, create tables with query and Access application.	Course presentation files, textbook, computer studies, researches
15. Week	final exam
16. Week	final exam
17. Week	final exam

Assessments
Evaluation tools	Quantity	Weight(%)
Midterm(s)	1	40
Final Exam	1	60

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 Office applications; can use excel and access software, produce, discuss and discuss professional applications in electronic environment. LO-2 Learn the basic concepts of spreadsheets and gain the ability to work with spreadsheets on the personal computer. LO-3 Using graphic and presentation programs, he / she can make his / her research professional files and find solutions to the problems he / she faces LO-4 Can understand and discuss what is the database and how it is organized LO-5 Can present and discuss the spreadsheet and database applications

Course Assessment Matrix:

PO 1

PO 2

PO 3

PO 4

PO 5

PO 6

PO 7

PO 8

PO 9

PO 10

PO 11

PO 12

PO 13

LO 1

LO 2

LO 3

LO 4

LO 5