|
|
| TBIL2011 | Visual Programming II | 3+1+0 | ECTS:4 | | Year / Semester | Fall Semester | | Level of Course | Short Cycle | | Status | Compulsory | | Department | DEPARTMENT of COMPUTER TECHNOLOGIES | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face, Lab work , Practical | | Contact Hours | 14 weeks - 3 hours of lectures and 1 hour of practicals per week | | Lecturer | Dr. Öğr. Üyesi Ercüment YILMAZ | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | With this course the student will gain, developing visual programming and database applications, preparation of application deployment packages |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Work with local and remote database | 1 - 2 - 3 - 6 - 8 | 1,6 | | LO - 2 : | Make Advanced Applications | 1 - 2 - 3 - 6 - 8 | 1,6 | | LO - 3 : | Prepare Setup Package | 1 - 2 - 3 - 6 - 8 | 1,6 | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Contact the local data base and data list, the local database, data processing, the local database, the requested record / records, access, connect to a remote database and the data list, the remote database, manipulate data, do simple queries, statistical queries, to get graphics from a database, database reporting, Component to create and add the Help files to prepare, prepare a set of database installation, the installation kit to prepare the program |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Connecting local database and listing data | | | Week 2 | Processing data in local database | | | Week 3 | Accessing data/data's in local database | | | Week 4 | Connecting remote database and listing data | | | Week 5 | Processing data from remote database | | | Week 6 | Making simple queries | | | Week 7 | Making simple queries
Making Statistically queries
| | | Week 8 | Making Statistically queries
Getting Graphics from Database | | | Week 9 | Midterm Exam Week | | | Week 10 | Getting Graphics from Database
Reporting from database | | | Week 11 | Reporting from database | | | Week 12 | Making and Adding Components | | | Week 13 | Preparing Help Files | | | Week 14 | Preparing Database Setup Package | | | Week 15 | Preparing Program Setup Package | | | Week 16 | Final Exam | | | |
| 1 | Nihat Demirli, Feyzi Akar; Microsoft C Sharp dot NET 2010, Palme Yayıncılık, Ankara | | | |
| 1 | Watson, K. 2008; C Sharp ile Veritabanı Uygulamaları, Bilge Adam Yayınları, İstanbul | | | 2 | Taşdelen, A. 2010; C Sharp ile Veritabanı Programlama ve ADO. NET, Pusula Yayıncılık, İstanbul | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | 1 | 50 | | End-of-term exam | 16 | | 1 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 3 | 14 | 42 | | Sınıf dışı çalışma | 1 | 6 | 6 | | Arasınav için hazırlık | 3 | 8 | 24 | | Arasınav | 1 | 1 | 1 | | Uygulama | 1 | 12 | 12 | | Dönem sonu sınavı için hazırlık | 1 | 14 | 14 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 100 |
|