Computer Programming
Course Details
KTO KARATAY UNIVERSITY
Trade and Industry Vocational School
Programme of Computer Programming
Course Details
Trade and Industry Vocational School
Programme of Computer Programming
Course Details
| Course Code | Course Name | Year | Period | Semester | T+A+L | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| 03831193 | Web Programming | 2 | Autumn | 3 | 2+1+0 | 4 | 4 |
| Course Type | Elective |
| Course Cycle | Associate (Short Cycle) (TQF-HE: Level 5 / QF-EHEA: Short Cycle / EQF-LLL: Level 5) |
| Course Language | Turkish |
| Methods and Techniques | - |
| Mode of Delivery | Face to Face |
| Prerequisites | - |
| Coordinator | - |
| Instructor(s) | Lect. Abubakar MAYANJA |
| Instructor Assistant(s) | - |
Course Content
Implementation of responsive design with CSS, responsive design with Flexbox, basic Bootstrap elements, Bootstrap components, to run SELECT-INSERT-UPDATE-DELETE queries and to work with scalar data by establishing a connection between MySQL and Visual Studio, concept and installation of server, installations of databases and adding table in MySQL, basic SQL queries, MySQL database management, MySQL queries in advanced level, database connection of MSSQL and MySQL, concept of provider/driver, retrieving data, transfer of the data with objects, practice for final.
Objectives of the Course
To provide a basis about backend programming for Web sites.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | |
| Specialization / Field Courses | X |
| Support Courses | |
| Transferable Skills Courses | |
| Humanities, Communication and Management Skills Courses |
Relationships between Course Learning Outcomes and Program Outcomes
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Program Learning Outcomes | Level |
|---|---|---|
| P1 | He/she has basic, current and applied information about his/her profession. | 5 |
| P11 | Creates algorithms and data structures and performs mathematical calculations. | 4 |
| P12 | Explains and applies web programming technologies. | 5 |
| P13 | Performs database design and management. | 4 |
Course Learning Outcomes
| Upon the successful completion of this course, students will be able to: | |||
|---|---|---|---|
| No | Learning Outcomes | Outcome Relationship | Measurement Method ** |
| O1 | Knows how to develop algorithms and creates a data structure suitable for the algorithm. | P.4.1 | 1,7 |
| O2 | Knows the basic elements of a computer. | P.1.1 | 1,7 |
| O3 | Has knowledge of Web Programming development languages. | P.12.1 | 1,7 |
| O4 | Knows and uses Web Programming development platforms. | P.12.2 | 1,7 |
| ** Written Exam: 1, Oral Exam: 2, Homework: 3, Lab./Exam: 4, Seminar/Presentation: 5, Term Paper: 6, Application: 7 | |||
Weekly Detailed Course Contents
| Week | Topics |
|---|---|
| 1 | Implementation of responsive design with CSS |
| 2 | responsive design with Flexbox |
| 3 | basic Bootstrap elements |
| 4 | Bootstrap components |
| 5 | to run SELECT-INSERT-UPDATE-DELETE queries and to work with scalar data by establishing a connection between MySQL and Visual Studio |
| 6 | concept and installation of server |
| 7 | installations of databases and adding table in MySQL |
| 8 | basic SQL queries |
| 9 | MySQL database management |
| 10 | MySQL queries in advanced level |
| 11 | database connection of MSSQL and MySQL |
| 12 | concept of provider/driver and retrieving data |
| 13 | transfer of the data with objects |
| 14 | practice for final |
Textbook or Material
| Resources | Web Tasarımı ve Web Programlama, Uğur Gelişken, Level Kitap |
| Web Tasarımı ve Web Programlama, Uğur Gelişken, Level Kitap | |
| Web Tasarımı ve Web Programlama, Uğur Gelişken, Level Kitap |
Evaluation Method and Passing Criteria
| In-Term Studies | Quantity | Percentage |
|---|---|---|
| Attendance | - | - |
| Laboratory | - | - |
| Practice | - | - |
| Field Study | - | - |
| Course Specific Internship (If Any) | - | - |
| Homework | - | - |
| Presentation | - | - |
| Projects | - | - |
| Seminar | - | - |
| Quiz | - | - |
| Listening | - | - |
| Midterms | 1 | 40 (%) |
| Final Exam | 1 | 60 (%) |
| Total | 100 (%) | |
ECTS / Working Load Table
| Quantity | Duration | Total Work Load | |
|---|---|---|---|
| Course Week Number and Time | 14 | 2 | 28 |
| Out-of-Class Study Time (Pre-study, Library, Reinforcement) | 14 | 1 | 14 |
| Midterms | 1 | 14 | 14 |
| Quiz | 0 | 0 | 0 |
| Homework | 0 | 0 | 0 |
| Practice | 14 | 1 | 14 |
| Laboratory | 14 | 1 | 14 |
| Project | 0 | 0 | 0 |
| Workshop | 0 | 0 | 0 |
| Presentation/Seminar Preparation | 0 | 0 | 0 |
| Fieldwork | 0 | 0 | 0 |
| Final Exam | 1 | 14 | 14 |
| Other | 0 | 0 | 0 |
| Total Work Load: | 98 | ||
| Total Work Load / 30 | 3,27 | ||
| Course ECTS Credits: | 3 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P1 | P4 | P12 |
|---|---|---|---|---|
| O1 | Knows the basic elements of a computer. | 4 | - | - |
| O2 | Knows how to develop algorithms and creates a data structure suitable for the algorithm. | - | 5 | - |
| O3 | Has knowledge of Web Programming development languages. | - | - | 5 |
| O4 | Knows and uses Web Programming development platforms. | - | - | 5 |