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: 3
Prt.: 0
Credit: 3
Lab: 0
ECTS: 4
Objectives of the Course

To develop and enhance the student's ability to use office programs.

Course Content

The ability to create tables, perform mathematical calculations on tables, create and manage databases, and harmonize text files with table files.

Name of Lecturer(s)
Ins. Halil TEKATLI
Learning Outcomes
1.Performs data entry and data evaluation processes.
2.Can create electronic spreadsheets and charts.
3.Can perform calculations
4.Can use basic formulas
5.Can make reports.
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
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory202160
Lecture - Practice141128
Midterm Examination1516
Final Examination1516
TOTAL WORKLOAD (hours)100
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
PÇ-14
OÇ-1
5
5
5
5
4
4
4
3
3
3
2
2
1
1
OÇ-2
5
3
3
3
4
4
4
5
5
5
4
3
3
3
OÇ-3
5
5
5
4
4
3
2
5
2
2
2
3
4
4
OÇ-4
5
5
5
5
4
4
3
3
3
2
2
2
3
3
OÇ-5
3
3
3
4
4
5
5
5
5
3
3
3
4
4
Adnan Menderes University - Information Package / Course Catalogue
2026