TÜRKÇE
ENGLISH
Information
| Code | BPP202 |
| Name | Visual Programming -II |
| Term | 2022-2023 Academic Year |
| Semester | 4. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 4 ECTS |
| National Credit | 3.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör.Dr. MEHMET İSMAİL SOLMAZ |
| Course Instructor |
Öğr. Gör.Dr. MEHMET İSMAİL SOLMAZ
(A Group)
(Ins. in Charge)
Öğr. Gör.Dr. YILMAZ KOÇAK (B Group) (Ins. in Charge) |
Course Goal / Objective
creating a user interface using visual programming languages to solve a given problem
Course Content
Identification Database, Accessing, Reading, writing, writing about the updating of the sample program. SQL server applications.
Course Precondition
None
Resources
Lecture Note
Notes
https://www.btkakademi.gov.tr/portal/course/c-7008
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Writing visual programming codes |
| LO02 | designs user interfaces. |
| LO03 | to operate databases over networks |
| LO04 | to connect SQL server |
| LO05 | Performs basic operations in the database |
| LO06 | Make simple queries in SQL server |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Communicates effectively with all partners on a sectoral basis. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | has the basic knowledge necessary to develop computer software, to establish algorithm, sequential and simultaneous flow logic | |
| PLO03 | Yetkinlikler - Alana Özgü Yetkinlik | Designs systems for fundamental problems in microcontrollers, embedded systems and analog/digital electronics. | |
| PLO04 | Yetkinlikler - Alana Özgü Yetkinlik | Uses basic software related to information and communication technologies, specific to his profession. | |
| PLO05 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Applies the software and hardware developments in the field of Computer Programming independently. | |
| PLO06 | Bilgi - Kuramsal, Olgusal | Explains the necessary methods for solving well-defined problems in the field of Computer Technologies and Programming. | 3 |
| PLO07 | Bilgi - Kuramsal, Olgusal | Has the basic knowledge level required to develop software specific to web, mobile and other electronic platforms. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Develops software for desktop and other environments. | 5 |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Takes an active role in project development processes, independently or as part of a group, within a planned project. | |
| PLO10 | Bilgi - Kuramsal, Olgusal | Knows project planning, development and implementation processes. | |
| PLO11 | Yetkinlikler - Alana Özgü Yetkinlik | Performs data storage, editing, querying, etc. operations in computer and network environment. | 2 |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | It has the ability to solve unpredictable hardware and software problems. | |
| PLO13 | Beceriler - Bilişsel, Uygulamalı | Codes software components that have been analyzed and the algorithm has been prepared. | 3 |
| PLO14 | Bilgi - Kuramsal, Olgusal | Knows the methods to be used in software development. | 3 |
| PLO15 | Yetkinlikler - Öğrenme Yetkinliği | Constantly follows current innovations and developments in the field of information technologies. | |
| PLO16 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Communicates verbally and in writing in a foreign language. | |
| PLO17 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | It has the phenomenon of the necessity of moral and ethical behaviors related to the information technology profession. | |
| PLO18 | Yetkinlikler - Alana Özgü Yetkinlik | Has the necessary awareness of occupational safety in her field. | |
| PLO19 | Beceriler - Bilişsel, Uygulamalı | It uses operating systems with administrative features. | |
| PLO20 | Bilgi - Kuramsal, Olgusal | Has basic knowledge of entrepreneurship. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Connecting to database | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 2 | identification database, accessing, reading, writing, writing example about updating. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 3 | Access Database file applications | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 4 | SQL server applications. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 5 | To connect to a remote database and list data. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 6 | Make simple queries in SQL server -I | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 7 | Make simple queries in SQL server -II | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 8 | Mid-Term Exam | exam preparation | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Work with Office programs | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 10 | Database creation, add fields, delete and draw graphics. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 11 | Crystal Reports, Documents and take reports from database | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 12 | Working with basic components. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 13 | Create help files. | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 14 | Making-of Movable program -I | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 15 | Making-of Movable program -II | READS ON CONDITIONS | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 16 | Term Exams | exam preparation | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | exam preparation | Ölçme Yöntemleri: Yazılı Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 4 | 56 |
| 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 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 108 | ||
| Total Workload / 25 (h) | 4,32 | ||
| ECTS | 4 ECTS | ||