Information Package / Course Catalogue
Basic Office Programs II
Course Code: MVU140
Course Type: Area Elective
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 2
Prt.: 2
Credit: 3
Lab: 0
ECTS: 4
Objectives of the Course

To enable students to use Excel at an advanced level, develop data analysis and reporting skills, and acquire the ability to solve data-driven problems encountered in professional life.

Course Content

Advanced Excel formulas, data analysis tools, conditional operations, data visualization, pivot tables, charts, and introduction to basic macros.

Name of Lecturer(s)
Learning Outcomes
1.Perform complex calculations using advanced Excel formulas and functions.
2.Organize and interpret large datasets using data analysis tools.
3.Create dynamic and decision-based tables using conditional operations.
4.Analyze and visualize data effectively using pivot tables and charts.
5.Gain basic knowledge of Excel macros and automation tools and apply them.
Recommended or Required Reading
1.Books containing Excel can be used as resources.
Weekly Detailed Course Contents
Week 1 - Theoretical & Practice
Information about the definition and content of the course. Introduction to the Excel program.
Week 2 - Theoretical & Practice
Opening and reviewing an Excel workbook. Exploring rows and columns, using cells, and adding new sheets. Examining the formula bar.
Week 3 - Theoretical & Practice
Reviewing the File and Home tabs: Adjusting row-column widths, border settings, color-fill options, and text formatting.
Week 4 - Theoretical & Practice
Creating tables and charts. Making drawings.
Week 5 - Theoretical & Practice
Data filtering and conditional formatting operations.
Week 6 - Theoretical & Practice
Data Ribbon: Sorting, using data tools, and importing external data.
Week 7 - Theoretical & Practice
Using the View and Review options
Week 8 - Theoretical & Practice
Excel - Creating charts, Pivot Tables/Charts, chart features, and interpreting charts
Week 9 - Theoretical & Practice
Excel - Data analysis with Pivot Tables and Charts.
Week 10 - Theoretical & Practice
Excel and Word - Analysis and reporting
Week 11 - Theoretical & Practice
Introduction to formulas and functions, using logical formulas
Week 12 - Theoretical & Practice
Simple mathematical functions and writing equations.
Week 13 - Theoretical & Practice
Applications of statistical functions in spreadsheets.
Week 14 - Theoretical & Practice
Creating and editing regression equations.
Assessment Methods and Criteria
Type of AssessmentCountPercent
Attending Lectures1%10
Quiz1%10
Practice Examination1%20
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory141242
Lecture - Practice141242
Practice Examination1516
Final Examination1718
TOTAL WORKLOAD (hours)98
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
OÇ-1
1
5
2
4
5
4
4
4
2
3
OÇ-2
1
5
2
5
5
5
4
5
3
4
OÇ-3
1
5
2
4
5
5
4
5
3
4
OÇ-4
1
5
2
5
5
5
4
5
5
4
OÇ-5
2
4
2
3
5
4
4
5
2
4
Adnan Menderes University - Information Package / Course Catalogue
2026