Information Package / Course Catalogue
Calculation and Tabulation Programs
Course Code: ULT432
Course Type: Area Elective
Couse Group: First Cycle (Bachelor's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 0
Credit: 3
Lab: 0
ECTS: 6
Objectives of the Course

The objective of the 'Computational and Tabulation Programs' course is to equip logistics management students with computational and data analysis skills, enabling them to apply these skills in the context of strategic decision-making and efficiency enhancement within logistics operations. Students will use tabulation programs to perform hands-on exercises on real-world data sets, thereby developing their analytical thinking capabilities.

Course Content

This course introduces logistics management students to essential computation and tabulation skills necessary for analyzing real-world data and improving operational efficiency. Through hands-on exercises using tabulation programs, students will learn to process and analyze data, applying their findings to make strategic decisions in logistics settings. The course will cover data collection, cleaning, statistical analysis, and data visualization, enhancing students' ability to think analytically and tackle complex problems.

Name of Lecturer(s)
Assoc. Prof. Algın OKURSOY
Learning Outcomes
1.Students will be able to collect, clean, and prepare data from logistics operations, making it suitable for analysis.
2.Students will master basic statistical concepts and apply statistical methods such as hypothesis testing, regression analysis, and time series analysis to logistics datasets.
3.Students will develop mathematical models for route optimization, inventory management, and resource allocation in logistics networks, producing effective solutions.
4.Students will be able to visualize data sets in clear graphs and tables and present information using visual data analysis techniques.
5.Students will develop practical problem-solving skills by conducting applied projects, case study analyses, and scenario-based simulations on real-world data sets.
6.Students will acquire critical thinking and analytical decision-making skills to analyze complex problems in the logistics sector, make strategic decisions, and produce effective solutions to challenges.
Recommended or Required Reading
1.Excel 2013, 2016 Ve Office 365 Excel Uyumlu İleri Düzey Excel 2019 Veri Analizi – Formüller Ve İşlevler Dashboard Raporlama – Query (Sorgu) Ekranları, Ömer Bağcı, 2020, Seçkin Yayıncılık.
Weekly Detailed Course Contents
Week 1 - Theoretical
Introduction to Computational and Tabulation Programs
Week 2 - Theoretical
Data Cleaning, Processing, Editing, and Interface Operations
Week 3 - Theoretical
Logical Functions, Lookup Functions, and Conditional Operations
Week 4 - Theoretical
Logical Functions, Lookup Functions, and Conditional Operations
Week 5 - Theoretical
Tabulation and Graphs for Data Analysis
Week 6 - Theoretical
Pivot Tables and Charts for Data Analysis
Week 7 - Theoretical
Application of Descriptive and Inferential Statistical Methods
Week 8 - Theoretical
Application of Descriptive and Inferential Statistical Methods
Week 9 - Theoretical
Decision Analysis with Computational and Tabulation Programs
Week 10 - Theoretical
Decision Analysis with Computational and Tabulation Programs
Week 11 - Theoretical
Linear Programming with Computational and Tabulation Programs
Week 12 - Theoretical
Linear Programming with Computational and Tabulation Programs
Week 13 - Theoretical
Forecasting with Computational and Tabulation Programs
Week 14 - Theoretical
Forecasting with Computational and Tabulation Programs
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory142370
Reading72014
Individual Work56030
Midterm Examination115116
Final Examination119120
TOTAL WORKLOAD (hours)150
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
PÇ-11
PÇ-12
PÇ-13
OÇ-1
3
3
3
3
3
4
4
3
3
OÇ-2
3
3
2
3
2
5
4
3
OÇ-3
4
3
2
2
3
2
3
2
OÇ-4
3
3
2
2
3
3
3
3
3
5
OÇ-5
3
2
3
2
3
2
3
OÇ-6
3
4
4
3
3
3
2
2
1
1
2
3
3
Adnan Menderes University - Information Package / Course Catalogue
2026