TÜRKÇE
ENGLISH
Information
| Unit | ADANA VOCATIONAL SCHOOL |
| Code | BPP114 |
| Name | Database-I |
| Term | 2019-2020 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. MESUT ÖZONUR |
| Course Instructor |
Doç. Dr. MESUT ÖZONUR
(Bahar)
(A Group)
(Ins. in Charge)
Doç. Dr. MESUT ÖZONUR (Bahar) (B Group) (Ins. in Charge) |
Course Goal / Objective
Comprehends database logic and makes database design.
Course Content
Database and Database Managemet Systems, Database Objects, Features of Database Field, Tables, Queries, Forms, Reports, Macros, Modules
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Have knowledge about database basics. |
| LO02 | Understands the importance of database in programming. |
| LO03 | Performs database applications. |
| LO04 | Manages database applications. |
| LO05 | Designs database applications on different subjects. |
| LO06 | Performs all kinds of data operations in the database. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explains computer software and hardware. | 0 |
| PLO01 | - | Explains computer software and hardware. | 0 |
| PLO02 | - | Define the data and hardware necessary for solving well-defined problems in Computer Technologies and Programming. | 4 |
| PLO02 | - | Define the data and hardware necessary for solving well-defined problems in Computer Technologies and Programming. | 0 |
| PLO03 | - | Evaluate the developments in computer and computer network using scientific methods and techniques. | 0 |
| PLO03 | - | Evaluate the developments in computer and computer network using scientific methods and techniques. | 0 |
| PLO04 | - | Explains the simple software and hardware failures encountered in the computer. | 0 |
| PLO04 | - | Explains the simple software and hardware failures encountered in the computer. | 0 |
| PLO05 | - | Explains the methods necessary for solving well-defined problems in Computer Technologies and Programming. | 0 |
| PLO05 | - | Explains the methods necessary for solving well-defined problems in Computer Technologies and Programming. | 0 |
| PLO06 | - | Explain the teaching methods, techniques and strategies of information technologies. | 0 |
| PLO06 | - | Explain the teaching methods, techniques and strategies of information technologies. | 0 |
| PLO07 | - | Use appropriate methods and techniques for the development of critical and creative thinking and problem solving skills. | 0 |
| PLO07 | - | Use appropriate methods and techniques for the development of critical and creative thinking and problem solving skills. | 4 |
| PLO08 | - | Plans simple software and hardware failures in the computer and solutions to non-specialist problems. | 0 |
| PLO08 | - | Plans simple software and hardware failures in the computer and solutions to non-specialist problems. | 4 |
| PLO09 | - | Use appropriate techniques with verbal, numerical and graphical expression. | 4 |
| PLO10 | - | Use information technologies effectively in learning and learning process. | 0 |
| PLO11 | - | To be able to know, edit and query data in computer environment. | 5 |
| PLO12 | - | Takes responsibility as an individual and as a team in solving the problems. | 3 |
| PLO13 | - | It becomes a responsible citizen against the public and private sectors. | 0 |
| PLO14 | - | Gains the ability of self-learning, critically evaluates the information learned. | 1 |
| PLO15 | - | Evaluates independently what they learn and learn in the field of Computer Technologies and Programming. | 0 |
| PLO16 | - | Communicates well with students, teachers, school management, employers and customers. | 2 |
| PLO17 | - | Use computer and communication technologies effectively. | 5 |
| PLO18 | - | It attempts to think and develop on its own professional performance. | 0 |
| PLO19 | - | It follows current scientific, professional and artistic events. | 1 |
| PLO20 | - | Express their ideas in a foreign language orally and in writing, read foreign professional resources. | 0 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Database and Database Management Systems | Reading and understanding of the issues before the course. | |
| 2 | Database Objects | Reading and understanding of the issues before the course. | |
| 3 | Database Field Properties | Reading and understanding of the issues before the course. | |
| 4 | Tables - General Tab | Reading and understanding of the issues before the course. | |
| 5 | Tables - Lookup Tab | Reading and understanding of the issues before the course. | |
| 6 | Queries | Reading and understanding of the issues before the course. | |
| 7 | Forms - Properties | Reading and understanding of the issues before the course. | |
| 8 | Mid-Term Exam | Multiple Choice, Text, True / False or Open Ended Exam | |
| 9 | Forms - Controls | Reading and understanding of the issues before the course. | |
| 10 | Forms - Wizards | Reading and understanding of the issues before the course. | |
| 11 | Reports - Sections | Reading and understanding of the issues before the course. | |
| 12 | Reports - Main/Sub Report | Reading and understanding of the issues before the course. | |
| 13 | Reports - Creating Graphic-Label | Reading and understanding of the issues before the course. | |
| 14 | Macros | Reading and understanding of the issues before the course. | |
| 15 | Modules | Reading and understanding of the issues before the course. | |
| 16 | Term Exams | Multiple Choice, Text, True / False or Open Ended Exam | |
| 17 | Term Exams | Multiple Choice, Text, True / False or Open Ended Exam |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 20 |
| General Assessment | ||
| Midterm / Year Total | 100 | 20 |
| 1. Final Exam | - | 80 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 5 | 5 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (Hour) | 85 | ||
| Total Workload / 25 (h) | 3,40 | ||
| ECTS | 3 ECTS | ||