Information Package / Course Catalogue
Advance Office Applications
Course Code: ÜKK110
Course Type: Area Elective
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 2
Prt.: 0
Credit: 2
Lab: 0
ECTS: 2
Objectives of the Course

The objective of this course is to develop students' proficiency in utilizing office software applications (advanced Excel, Word, PowerPoint, and database tools) that are heavily employed in the manufacturing and quality control industries at a professional level. The course is entirely application-oriented, aiming to equip students with hands-on, computer-based experience in analyzing manufacturing process data through advanced formulas, pivot tables, macros, and charts; establishing technical report and documentation templates aligned with international standards; and digitally tracking quality control processes with high precision.

Course Content

Advanced Excel functions (logical, lookup, text, and statistical formulas); data validation and dynamic form design; analysis of production data using Pivot Tables and Pivot Charts; introduction to Excel Macros and automation of data analytics; generating large-scale technical reports, procedures, and structured documentation hierarchies using Advanced Word; developing dynamic and professional quality performance presentations using Advanced PowerPoint; cloud-based collaborative tools integration (Google Workspace / MS Office 365).

Name of Lecturer(s)