COURSE UNIT TITLE

: LEADERSHIP AND PLANNING IN INSTRUCTIONAL TECNOLOGIES

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
TEK 4005 LEADERSHIP AND PLANNING IN INSTRUCTIONAL TECNOLOGIES COMPULSORY 3 0 0 3

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR BAHAR BARAN

Offered to

Computer and Instructional Technologies Teacher Education

Course Objective

In this course, students are aimed to gain knowledge, skills and competence about basic database concepts; data and data models; relational database design; SQL structured query language; basic SQL commands; SQL functions; grouping; combining; SQL administrative functions; multiple table usage; SQL programming and function; Transaction and error conditions in SQL program; DBMS setup and administrative operations; SQL queries on the database management system.

Learning Outcomes of the Course Unit

1   To explain basic database concepts.
2   To design relational database.
3   To use SQL structured query language.
4   To setup database management system.
5   To administrative database management system.
6   To run SQL queries on the database management system.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Basic database concepts
2 Data and data models
3 Relational database design
4 SQL structured query language
5 Basic SQL commands
6 SQL functions; grouping; combining
7 Mid-term
8 SQL administrative functions
9 Multiple table usage
10 SQL programming and function
11 Transaction and error conditions in SQL program
12 DBMS setup
13 DBMS administrative operations
14 SQL queries on the database management system
15 Final

Recomended or Required Reading

Connolly, T. & Begg, C. (2014). Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson.
Gözüdeli, Y. (2014). Yazılımcılar için SQL Server 2014 & Veritabanı Programlama. Seçkin Yayıncılık.
Kellegöz, T. & Çetinyokuş, T. (2017). Veritabanı Sistemleri. Nobel Yayıncılık.
Köseoğlu, K. (2016). Veritabanı Mantığı. Pusula Yayıncılık.
Ramakrishnan, R. & Gehrke, J. (2002). Database Management Systems. McGraw-Hill.

Planned Learning Activities and Teaching Methods

Lecture, question-answer

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE Midterm Exam
2 DTK Other Activity
3 FN Semester final exam
4 BNS BNS Student examVZ * 0.30 + Student examDTK * 0.10 + FN * 0.60
5 BUT Make- up note
6 BBN End of make-up grade Student examVZ * 0.30 +Student examDTK * 0.10 + BUT * 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Lecturer Ferit Serkan AKDOĞAN
Dokuz Eylul University
Faculty of Education
Department of Computer Education and Instructional Technology
35160 Buca/Izmir/ TURKEY
ferit.akdogan@gmail.com

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 13 6 78
Preparation for midterm exam 1 10 10
Preparation for final exam 1 10 10
Final 1 4 4
Midterm 1 4 4
Project Assignment 1 10 10
TOTAL WORKLOAD (hours) 155

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.11125551112
LO.21125551112
LO.31125551112
LO.41125551112
LO.51125551112
LO.61125551112

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS