| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BT207B3 | Visual Programming II | Compulsory | 2 | 3 | 5 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| With this course, it is aimed that the student can do industrial applications with visual programming languages. |
| Name of Lecturer(s) |
| Öğr. Gör. Eda SAKA ŞİMŞEK |
| Learning Outcomes |
| 1 | Designs and Uses Relational Database. | | 2 | Makes Query Between Tables Related to Each Other on Relational Databases. | | 3 | Uses Database in Visual Applications. | | 4 | Uses Report and Graphic Objects in Visual Applications. | | 5 | Creates Setup File. |
|
| Mode of Delivery |
| Normal Education |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| 1. Windows forms applications
2. Windows applications with menus
3. Connecting to the local database and listing the data
4. Process data in the local database
5. Reach the desired records in the local database
6. Connecting to the remote database and listing the data
7. Process data in the remote database
8. Making simple inquiries |
| Weekly Detailed Course Contents |
|
| 1 | Introduction of Database Management System and Relational Database Design | | | | 2 | Creating Database Tables and Basic Query Operations | | | | 3 | Using Database Library in Form Applications and Creating Connection Objects | | | | 4 | Datagridview Object Properties and Usage | | | | 5 | Datatable, DataReader, Dataset Creation and Connection Operation | | | | 6 | Basic Database Query Operations on Form Applications | | | | 7 | Advanced Database Query Operations on Form Applications | | | | 8 | Midterm | | | | 9 | Data Saving, Editing and Deleting Operations in Relational Database via Forms I | | | | 10 | Data Saving, Editing and Deleting Operations in Relational Database over Forms II | | | | 11 | Use of Query Objects Integrated in a Programming Language | | | | 12 | Reporting Objects Properties and Report Generation | | | | 13 | Chart Objects Properties and Chart Creation | | | | 14 | Error Checking on Visual Programming | | | | 15 | Creating and Using Installation Project | | | | 16 | Final exam | | |
|
| Recommended or Required Reading |
| Her Yönüyle C# - Sefer ALGAN |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| Midterm Examination | 1 | 100 | | SUM | 100 | |
| Final Examination | 1 | 100 | | SUM | 100 | | Term (or Year) Learning Activities | 40 | | End Of Term (or Year) Learning Activities | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | | None |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 1 | 1 |
| Attending Lectures | 14 | 4 | 56 |
| Practice | 14 | 2 | 28 |
| Individual Study for Mid term Examination | 4 | 8 | 32 |
| Individual Study for Final Examination | 4 | 8 | 32 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 5 | 5 | 4 | 3 | 5 | 5 | 1 | 3 | 5 | 5 | 1 | 5 | 1 | 1 | 1 | | LO2 | 5 | 5 | 4 | 3 | 5 | 5 | 1 | 3 | 5 | 5 | 1 | 5 | 1 | 1 | 1 | | LO3 | 5 | 5 | 4 | 3 | 5 | 3 | 1 | 3 | 4 | 5 | 1 | 5 | 1 | 1 | 1 | | LO4 | 5 | 5 | 4 | 3 | 5 | 3 | 1 | 3 | 4 | 5 | 1 | 5 | 1 | 1 | 1 | | LO5 | 5 | 5 | 5 | 5 | 5 | 3 | 1 | 3 | 4 | 3 | 1 | 5 | 1 | 1 | 1 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |