Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| OFFICE TECHNOLOGIES AND DATA MANAGEMENT PR. | |
| Code | OVS217 |
| Name | Web Based Applications |
| Term | 2026-2027 Academic Year |
| Semester | 3. Semester |
| Duration (T+A) | 1-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 1.5 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Dr. ADNAN GÖKTEN |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
Course Goal / Objective
To equip students with the skills to develop dynamic, database-connected, and user-interactive web applications using web technologies.
Course Content
The Web-Based Applications course begins with the client-server architecture and HTTP protocol, which form the basis of web technologies, and covers the creation of static web pages with HTML and CSS, user interaction with JavaScript, and the development of dynamic structures. The course includes interface design using Bootstrap, server-side application development with PHP or Node.js, data management with MySQL databases, form processing, and CRUD applications. Basic web security topics and the process of publishing developed applications are also covered.
Course Precondition
none
Resources
HTML and CSS: Design and Build Websites
Notes
Visual Studio Code
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Explains the client–server architecture and HTTP protocol that form the basis of web technologies. |
| LO02 | Designs basic and responsive web pages using HTML and CSS. |
| LO03 | Develops dynamic and interactive web interfaces using JavaScript. |
| LO04 | Creates user-friendly interfaces using tools such as Bootstrap. |
| LO05 | Develops server-side applications using PHP or Node.js. |
| LO06 | Performs CRUD operations using MySQL database. |
| LO07 | Applies form handling and data validation processes in web applications. |
| LO08 | Identifies basic web security risks and takes precautions. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Have basic knowledge and concepts about Office Technologies and Data Management. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Knows problem solving methods and techniques related to Office Technologies and Data Management. | |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | Performs applications with basic knowledge and concepts in the field of Office Technologies and Data Management. | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | Has the ability to use the theoretical and practical knowledge acquired in the field of Office Technologies and Data Management. | |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Explains and evaluates the basic knowledge and concepts on Office Technologies and Data Management. | |
| PLO06 | Yetkinlikler - Öğrenme Yetkinliği | Identifies problems by using basic knowledge and skills in their field. | |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Analyze problems and develop solutions in the area. | |
| PLO08 | Bilgi - Kuramsal, Olgusal | Explains designs and applications related to Office Technologies and Data Management to subordinates and superiors as necessary. | |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | In the framework given at the basic level, you can function and take responsibility independently of the issues related to the field given to you. | 5 |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic skills and knowledge of the area should be able to transfer effectively through written and oral communication. | 5 |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Knowledge and skills to critically evaluate own learning and identify needs. | |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | By following the developments on the field of the profession,may point to a more advanced level. | 4 |
| PLO13 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | A1-A2-level Foreign Language(English) knows,can communicate in the foreign language relevant to the profession | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic computer operating systems,Office applications, and knows how to use the keyboard. | |
| PLO15 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | In accordance with the rules of Turkish language,written and oral communication effectively may establish. | |
| PLO16 | Bilgi - Kuramsal, Olgusal | Have sufficient awareness about Ataturk´s principles and revolutions. | 4 |
| PLO17 | Beceriler - Bilişsel, Uygulamalı | Professional, ethical, scientific and social values | |
| PLO18 | Yetkinlikler - Alana Özgü Yetkinlik | Global and social values within the framework of occupational health,safety and environmental is aware of the value. | 4 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Web, client-server architecture | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 2 | HTTP/HTTPS protocol, browsers | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 3 | Basic HTML tags | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | HTML forms and tables | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 5 | Basic CSS properties | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 6 | CSS Flexbox and Grid | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 7 | Responsive design | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Reviewing the topic from resources and lecture notes. | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Introduction to JavaScript | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | JavaScript DOM and events | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | UI development with Bootstrap | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Server-side programming (PHP/Node.js) | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Database and MySQL operations | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | Web security and form handling | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | Project development and deployment | Basic computer skills, internet technologies, and knowledge of office software are required. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Reviewing the topic from resources and lecture notes. | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Reviewing the topic from resources and lecture notes. | Ö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 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 1 | 1 |
| Final Exam | 1 | 1 | 1 |
| Total Workload (Hour) | 86 | ||
| Total Workload / 25 (h) | 3,44 | ||
| ECTS | 3 ECTS | ||