TYPE OF COURSE UNIT	Compulsory Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	1
SEMESTER	Second Term (Spring)
NUMBER OF ECTS CREDITS ALLOCATED	9
NAME OF LECTURER(S)	Associate Professor Emine Cabı
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Will be able to form database from scratch using table relations, 2) Will be able to comprehend data types and apply validation rules and input masks, 3) Will be able to create tables with visual basic coding, 4) Will be able to get different outputs, updating, deleting and adding using sql statements, 5) Will be able to create forms and reports for databases, 6) Will be able to comprehend parts of a web page and create web pages using HTML.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	None
COURSE DEFINITION	Database applications, database design, data types, relational database, data query (SQL), MS Access forms and macros, HTML-DHTML, editing web sites, creating web sites, FTP, E-mail programs. Health and ergonometric issues in computer usage.
COURSE CONTENTS	WEEK TOPICS 1st Week Database structures and data types (Access, Mysql, XML, SQL Server examples) 2nd Week Search, sort, data arrangements and browsing 3rd Week Data protection, authorization rules, Input masks 4th Week Table relations, creating sql statements 5th Week Data Analysis and Reports 6th Week Forms and Macros 7th Week Extended coding, data import and export 8th Week Midterm Exam 9th Week HTML and web design software 10th Week File operations, menu, properties of menü and usage, using predefined themes in web pages 11th Week Putting symbols, animations, images and clipart, using frame structure in web pages 12th Week Usage of javascript (button, menu scripts,text and image efects etc.) in web pages 13th Week Publishing web pages by ftp. 14th Week General Rehearsal
RECOMENDED OR REQUIRED READING	1) Lecture Notes 2) Köseoğlu, K. (2007). Veritabanı mantığı. Pusula Yayıncılık. 3) Gürkan, O., Microsoft Access XP, Nirvana Yayınları, Ankara, 2005. 4) Karahoca D., Karahoca A., Yönetim Bilişim sistemleri ve Uygulamaları, Beta Basım Yayım ve A.Ş., 1998, İstanbul. 5) Yarman-Vural F. T., Erten Y. M., Bilgisayar Sistemleri, Akademi Yayıncılık, Ankara, 2000. 6) Rockoff, L. (2011). Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence. Nelson Education.
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Presentation,Project,Other
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 20 Assignment 2 10 Project 1 30 Attendance 1 10 Total(%) 70 Contribution of In-term Studies to Overall Grade(%) 70 Contribution of Final Examination to Overall Grade(%) 30 Total(%) 100
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No