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 |
|---|---|---|---|---|---|---|---|
| 03831202 | Current technologies in computer | 2025 | Autumn | 3 | 2+2+0 | 5 | 5 |
| 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 | 1. Theoretical Lecture: Topics are explained theoretically within the scope of the course. Students listen to lectures to understand the basic concepts of programming and the logic of algorithms. 2. Practical Work: Students work with various examples under the mentorship of the course instructor to apply the topics explained theoretically. Efforts are made to achieve learning outcomes. 3. Step-by-Step Solution: Problems are solved step-by-step, and how each step works is explained. This method helps students gain a better understanding of the topics. 4. Real-Life Examples: Real-life examples and problem scenarios are presented to help students better understand the topics. This allows students to see how to use what they have learned in practice. 5. Laboratory Worksheets and Quizzes: Weekly laboratory worksheets and pre-exam quizzes are used to evaluate students' progress and monitor their understanding of the topics. |
| Mode of Delivery | Face to Face |
| Prerequisites | There are no prerequisites for the course. Instruction is provided to all students, starting from a basic level. |
| Coordinator | - |
| Instructor(s) | Lect. Uğur POLAT |
| Instructor Assistant(s) | - |
Course Instructor(s)
| Name and Surname | Room | E-Mail Address | Internal | Meeting Hours |
|---|---|---|---|---|
| Lect. Uğur POLAT | C-129 | [email protected] | 7860 | Thursday 14:00-16:00 |
Course Content
1. Computer Architecture and Basic Hardware
2. Operating Systems and Open Source Philosophy
3. Advanced Document Management in Word Processors
4. Academic and Technical Reporting Automation
5. Professional Text Formatting
6. Data and Formula Management in Spreadsheets
7. Logical Analysis in Spreadsheets
8. Data Analysis and Visual Formatting
9. Data Visualization and Charts
10. Centralized Management in Presentation Design
11. Effective Presentation Techniques
12. Information Security and Network Communication
2. Operating Systems and Open Source Philosophy
3. Advanced Document Management in Word Processors
4. Academic and Technical Reporting Automation
5. Professional Text Formatting
6. Data and Formula Management in Spreadsheets
7. Logical Analysis in Spreadsheets
8. Data Analysis and Visual Formatting
9. Data Visualization and Charts
10. Centralized Management in Presentation Design
11. Effective Presentation Techniques
12. Information Security and Network Communication
Objectives of the Course
The aim of this course is to provide students with a current, practical, and professional foundation in information technologies, spanning a wide spectrum from basic hardware architecture to modern cybersecurity tools. The course seeks to enable students to effectively utilize the software required for academic and professional tasks while upholding scientific, cultural, and ethical values during data collection and reporting processes.
The core competencies the course aims to instill in students are as follows:
Hardware and Operating System Awareness: Comprehending the computational architecture of the central processing unit (CPU and ALU); managing processes and resources within operating systems; understanding directory hierarchies and the logic of absolute versus relative file addressing; and analyzing the advantages of open-source software ecosystems.
Professional Reporting with Word Processors: Implementing advanced page numbering in academic or technical documents using section breaks; generating automated tables of contents by applying hierarchical heading styles; and professionally utilizing text alignment tools (such as tab stops).
Data Analysis and Logical Reasoning with Spreadsheets: Constructing dynamic algorithms using absolute and relative cell referencing; subjecting data to logical tests via conditional functions (IF); performing error detection (e.g., #DIV/0!); and visualizing data through conditional formatting and chart types that illustrate trends over time. Centralized and Effective Presentation Design: Designing corporate and cohesive presentation templates using Slide Master technology, and managing professional presentations by grasping the technical distinctions between slide transitions and object animations.
Fundamentals of Networking and Cybersecurity: Protecting corporate and personal data by understanding secure web traffic protocols (HTTPS, SSL/TLS, Port 443), integrating two-factor authentication (2FA/MFA) systems, and effectively utilizing Virtual Private Network (VPN) technologies—within ethical standards—to ensure data privacy on public networks.
The core competencies the course aims to instill in students are as follows:
Hardware and Operating System Awareness: Comprehending the computational architecture of the central processing unit (CPU and ALU); managing processes and resources within operating systems; understanding directory hierarchies and the logic of absolute versus relative file addressing; and analyzing the advantages of open-source software ecosystems.
Professional Reporting with Word Processors: Implementing advanced page numbering in academic or technical documents using section breaks; generating automated tables of contents by applying hierarchical heading styles; and professionally utilizing text alignment tools (such as tab stops).
Data Analysis and Logical Reasoning with Spreadsheets: Constructing dynamic algorithms using absolute and relative cell referencing; subjecting data to logical tests via conditional functions (IF); performing error detection (e.g., #DIV/0!); and visualizing data through conditional formatting and chart types that illustrate trends over time. Centralized and Effective Presentation Design: Designing corporate and cohesive presentation templates using Slide Master technology, and managing professional presentations by grasping the technical distinctions between slide transitions and object animations.
Fundamentals of Networking and Cybersecurity: Protecting corporate and personal data by understanding secure web traffic protocols (HTTPS, SSL/TLS, Port 443), integrating two-factor authentication (2FA/MFA) systems, and effectively utilizing Virtual Private Network (VPN) technologies—within ethical standards—to ensure data privacy on public networks.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | |
| Specialization / Field Courses | |
| Support Courses | |
| Transferable Skills Courses | X |
| 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 |
|---|---|---|
| P4 | Effectively uses information technologies (software, programs, animations, etc.) related to her/his profession. | 5 |
| P1 | He/she has basic, current and applied information about his/her profession. | 4 |
| P3 | He/She follows current developments and practices in his profession and uses them effectively. | 4 |
| P6 | Can present his/her thoughts effectively through written and verbal communication at the level of knowledge and skills and expresses them in an understandable manner. | 5 |
| P9 | It has social, scientific, cultural and ethical values in the stages of collecting data related to its field, applying it and announcing the results. | 2 |
| P11 | Creates algorithms and data structures and performs mathematical calculations. | 3 |
Course Learning Outcomes
| Upon the successful completion of this course, students will be able to: | |||
|---|---|---|---|
| No | Learning Outcomes | Outcome Relationship | Measurement Method ** |
| O1 | Knows the basic elements of a computer. | P.1.1 | 1,7 |
| O2 | Has knowledge about Computer and Security. | P.1.4 | 1,7 |
| O3 | Knows how to use at least one of the MS Office tools. | P.6.2 | 1,6,7 |
| O4 | Knows and uses current Information Technology platforms. | P.11.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 | Week 1: Computer Architecture and Basic Hardware: Processor (CPU) structure, Arithmetic Logic Unit (ALU) functions, and analysis of process/resource consumption via Task Manager. |
| 2 | Week 2: Operating Systems and Open Source Philosophy: Hierarchical (tree) directory structure, absolute and relative file paths, the function of file extensions, and the open source software ecosystem. |
| 3 | Week 3: Advanced Document Management in Word Processors: End-of-chapter exercises and differentiated page numbering techniques (Roman numerals and standard numerals) for academic texts. |
| 4 | Week 4: Academic and Technical Reporting Automation: Defining hierarchical heading styles and generating an automatic table of contents with a single click. |
| 5 | Week 5: Professional Text Formatting: Using tab stops via the Tab key, ruler alignment, and formatting formal texts. |
| 6 | Week 6: Data and Formula Management in Spreadsheets: Dynamic use of absolute and relative reference systems (=$A1*B$1) based on cell addressing logic. |
| 7 | Week 7: General Review with Pre-Exam Quiz and Group-of-Four Question Card Activities. |
| 8 | Week 8: Midterm exam |
| 9 | Week 9: Logical Analysis in Spreadsheets: Creating decision structures using conditional functions (IF) and detecting division errors (#DIV/0!). |
| 10 | Week 10: Data Analysis and Visual Formatting: Automatically highlighting cell data that meets specific criteria (e.g., scores below 50) using Conditional Formatting. |
| 11 | Week 11: Data Visualization and Charts: Use of line charts and other basic chart types to analyze changes and trends over time. |
| 12 | Week 12: Centralized Management in Presentation Design: Controlling font, logo, and background themes for all slides from a single central point using Slide Master technology. |
| 13 | Week 13: Effective Presentation Techniques: Hierarchical and technical differences between slide transitions and object animations; shortcuts for interactive presentations. |
| 14 | Week 14: Information Security and Network Communication: Encryption logic of HTTPS and TLS/SSL protocols, Two-Factor Authentication (2FA) mechanisms, and data privacy via VPN technology. |
| 15 | Week 15: General Review with Pre-Exam Quiz and Group-of-Four Question Card Activities. |
| 16 | Week 16: Final Exam |
Textbook or Material
| Resources | Computing Essentials 2024 (Authors: Timothy O'Leary, Linda O'Leary, Daniel O'Leary / Yayınevi: McGraw-Hill) |
| Basic Information Technologies I and II (Publisher: Anadolu University Open Education Faculty Publications) |
Evaluation Method and Passing Criteria
| In-Term Studies | Quantity | Percentage |
|---|---|---|
| Attendance | - | - |
| Laboratory | 14 | 20 (%) |
| Practice | - | - |
| Field Study | - | - |
| Course Specific Internship (If Any) | - | - |
| Homework | - | - |
| Presentation | - | - |
| Projects | - | - |
| Seminar | - | - |
| Quiz | 2 | 10 (%) |
| Listening | - | - |
| Midterms | 1 | 30 (%) |
| Final Exam | 1 | 40 (%) |
| 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 | 4 | 56 |
| Midterms | 1 | 14 | 14 |
| Quiz | 2 | 2 | 4 |
| Homework | 0 | 0 | 0 |
| Practice | 0 | 0 | 0 |
| Laboratory | 14 | 2 | 28 |
| Project | 0 | 0 | 0 |
| Workshop | 0 | 0 | 0 |
| Presentation/Seminar Preparation | 0 | 0 | 0 |
| Fieldwork | 0 | 0 | 0 |
| Final Exam | 1 | 20 | 20 |
| Other | 0 | 0 | 0 |
| Total Work Load: | 150 | ||
| Total Work Load / 30 | 5 | ||
| Course ECTS Credits: | 5 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P1 | P6 | P11 |
|---|---|---|---|---|
| O1 | Knows the basic elements of a computer. | 5 | 1 | 1 |
| O2 | Has knowledge about Computer and Security. | 5 | 1 | 2 |
| O3 | Knows how to use at least one of the MS Office tools. | 3 | 5 | 4 |
| O4 | Knows and uses current Information Technology platforms. | 4 | 3 | 5 |
