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 | Uzaktan Öğretim |
| Catalog Information Coordinator | Öğr. Gör.Dr. MEHMET İSMAİL SOLMAZ |
| Course Instructor |
Öğr. Gör.Dr. YILMAZ KOÇAK
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Learn coding with visual program
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 | Performs basic operations in the database |
| LO04 | to connect SQL server |
| LO05 | to operate databases over networks |
| 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 | ommunicates 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 | ||