Course Name Code Semester T+U Hours Credit ECTS
Basic Computer Science ENF 104 2 2 + 1 3 4
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level onlisans
Course Type Compulsory
Course Coordinator Doç.Dr. AHMET ÇAĞATAY ÇİLİNGİR
Course Lecturers Dr.Öğr.Üyesi OSMAN HAMDİ METE,
Course Assistants
Course Category
Course Objective Aim is to bring in abilities in followings;
1. Advanced level usage of MS Word and Excel which are office application programmes
2. Basic concepts of database,
3. Usage of MS Access in basic level,
4. Usage of MS Outlook,
5. Protect methods against destructive programme
Course Content Advanced level usage of MS Word and MS Excel, Basic Concept of Database, Utilization of MS Access and MS Outlook, protect of computer against destructive programme
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Students can change page layout of document created MS Word application programme, make listing transactions, achieve references, and achieve privatization Self Study, Lecture, Question-Answer, Discussion, Testing, Homework,
2 They can create advanced level formulas in work book formed MS Excel application programme, modify this formulas, constitute private data access components, and order and fitler these data Discussion, Question-Answer, Lecture, Self Study, Homework, Testing,
3 They know basic level concept of database Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
4 They can create database by using MS Access data application programme, add tablet o this database, illustrate relationships between tables, add data to table, create form for data Access and develop query on data. Discussion, Self Study, Question-Answer, Lecture, Homework, Testing,
5 They can order e-post and dates with MS Outlook, send and accept e-post, set MS Outlook Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
6 They can secure computer against destructive programme by using different software programmes. Discussion, Self Study, Question-Answer, Lecture, Testing, Homework,
Week Course Topics Preliminary Preparation
1 MS Word- Adding graph, header/footer, page number, reference, footnote, and objects
2 MS Word- Following changes, Creating equation, Adding audit
3 MS Word- Creating styles, table of contens, and bibliography, Combining adresse and letter
4 MS Excel- Defining cell interval, Adding function, Using function within other, Application of function to other page and books
5 MS Excel-Study with data (ordering, filtering, and creating form), Creating private lists, transaction of page defending
6 MS Excel- Application of advanced function to section (statistic, mats, etc.)
7 MS Access- Introduction to MS Access and Basic Concepts of Database
8 MS Access-Creating Table
9 MS Access-Keys and Relationships
10 MS Access- Data View page
11 MS Access-Creating Form
12 MS Access-Creating Query
13 MS Outlook- Creating and managing account, Transactions of e-post, Creating and managing address book, Agenda Management
14 Protect Methods against Virus, Worm, SPAM
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1
2
3
4
5
6
7
8 X
9
10
11
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 15
1. Ödev 20
2. Kısa Sınav 15
Total 100
1. Yıl İçinin Başarıya 20
1. Final 80
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 3 3
Quiz 2 10 20
Assignment 1 10 10
Total Workload 113
Total Workload / 25 (Hours) 4.52
dersAKTSKredisi 4