>
Course Unit Title Course Unit Code Type of Course Unit Level of Course Unit Year of Study Semester ECTS Credits
Computerized Office Programs OMP204 Elective Associate degree 2 Spring 4

Name of Lecturer(s)

Associate Prof. Dr. Hacer GÜMÜŞ
Associate Prof. Dr. Serdar SOLAK
Lecturer Tayfun KONAK
Lecturer Birsen KÖSELE BAYHAN
Lecturer Güray YAMAN

Learning Outcomes of the Course Unit

1) Explain the basic concepts of computer-related.
1) Explain the basic concepts of computer-related.
2) Define the basic concepts with electronic spreadsheet.
2) Define the basic concepts with electronic spreadsheet.
3) Make up the applications using electronic spreadsheet.
3) Make up the applications using electronic spreadsheet.
4) Make up the graphical operations using electronic spreadsheet.
4) Make up the graphical operations using electronic spreadsheet.
5) Explain the basic concepts of the database.
5) Explain the basic concepts of the database.
6) Design the simple database application.
6) Design the simple database application.

Program Competencies-Learning Outcomes Relation

  Program Competencies
1 2 3 4 5 6 7 8 9 10 11 12
Learning Outcomes
1 Middle High High High Middle High High Middle High High Middle Middle
1 Middle Middle High Middle High High High High High High Middle Middle
2 Middle High High High High High Middle Middle Middle Middle Middle Middle
2 High High Middle Middle Middle Middle Middle Middle Middle Middle Middle Middle
3 Middle Middle Middle High Middle Middle High High Middle High Middle High
3 Middle Middle High Middle Middle High Middle High Middle High High Middle
4 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation
4 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation
5 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation
5 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation
6 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation
6 No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation No relation

Mode of Delivery

Face to Face

Prerequisites and Co-Requisites

None

Recommended Optional Programme Components

1)COMPUTER 2)WORD 3)EXCEL 4)ACCESS POİNT

Course Contents

1.General concepts related to Computer 2.Electronics Computing Software 3.Database Software 4.Information and Communication

Weekly Schedule

1) Basic Consept of Informatin Teknologies
2) Basic Consept of Informatin Teknologies
3) Introduction to Electronic Spreadsheet Program
4) Usage of mathematical operators and functions at the electronic spreadsheet program
5) Usage of Logical Functions at Electronic Calculator and Spreadsheet Program
6) Usage of statistical functions
7) Usage statistical and financial formulas within spreadsheet programs
8) Usage statistical and financial formulas within spreadsheet programs
9) Introduction to MS Access Program
10) make transactions using with SQL
11) SQL Command
12) Creating the sample Database
13) Form and reports objects
14) Creating the sample Database
15) Communication and Information
16) Final Exam

Recommended or Required Reading

1- Funda Dağ,Umut Altınışık,Serdar Solak,Uğur Yıldız,"Bilgi Teknolojiler",2008, Umuttepe Yayınları
2- http://eds.kocaeli.edu.tr
3- http://old.cba.ua.edu/~jomason/ac289/289OtherFiles.html
4- http://eds.kocaeli.edu.tr
5- http://eds.kocaeli.edu.tr
6- http://eds.kocaeli.edu.tr
7- http://eds.kocaeli.edu.tr
8- http://eds.kocaeli.edu.tr
9- http://eds.kocaeli.edu.tr

Planned Learning Activities and Teaching Methods

1) Lecture
2) Question-Answer
3) Drill and Practice
4) Demonstration
5) Lab / Workshop
6) Self Study
7) Problem Solving


Assessment Methods and Criteria

Contribution of Semester Studies to Course Grade

20%

 

Number

Percentage

Semester Studies

Midterm Examination

1

60%

Short Exam / Quiz

2

40%

 

Contribution of Final Examination to Course Grade

80%

Total

100%

Language of Instruction

Turkish

Work Placement(s)

Not Required