Information Package / Course Catalogue
Advanced Office Applications
Course Code: ENF170
Course Type: Area Elective
Couse Group: First Cycle (Bachelor's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 2
Prt.: 0
Credit: 2
Lab: 0
ECTS: 4
Objectives of the Course

The aim of this course is; to enable students to use all the features of office software and to create macro software to gain skills

Course Content

Advanced Excel: Table and chart reports, formulas and graphics. Advanced Word: Reporting. Advanced Powerpoint: Presentation preparation and slide design

Name of Lecturer(s)
Learning Outcomes
1.Provide the ability to analyze and design a process for a defined goal
2.Gain the ability to make interdisciplinary and interdisciplinary teamwork
3.Analyze the data and interpret the results
4.Show oral and written contact information
5.They can act according to social, scientific and ethical values , while adapting their knowledge and skills to business life
6.Knows what social rights are in business life and can use these rights when necessary
7.Bring solutions to problems in business life, take responsibility as a team member
8.Adapt the acquired knowledge and skills to business life
9.Define the basic concepts and ideas
Recommended or Required Reading
1.Microsoft Office-Pusula Yayıncılık
Weekly Detailed Course Contents
Week 1 - Theoretical
Login, Introduction, Watch Course
Week 2 - Theoretical
Word Processor Software Footnote, Label, Source, Quote, Bibliography, Table of Contents Add
Week 3 - Theoretical
Word Processing Software Creating Custom Bulleted Lists, Adding Checkboxes and Text, Creating Templates, Adding Content Controls to a Template, and Protecting Content
Week 4 - Theoretical
Spreadsheet Software Data and Table Concept, Conditional Formatting, Special Selection and Copy Operations
Week 5 - Theoretical
Spreadsheet Software Creating and Using Styles and Templates, Page Setup Output Settings
Week 6 - Theoretical
Protection of Spreadsheet Software Workbooks, Encryption, Graphics, Customizing Graphics
Week 7 - Theoretical
Spreadsheet Software Operations and Creating Custom Formulas, Absolute Address Structure
Week 8 - Theoretical
Preliminary (Mid term exam)
Week 9 - Theoretical
Spreadsheet Software Functions
Week 10 - Theoretical
Spreadsheet Software Creating and Running Macro, Introduction to Macro Programming, Variables, Definitions, Condition Structures and Loops, Formatting and Applications
Week 11 - Theoretical
Spreadsheet Software Creating and Running Macro, Introduction to Macro Programming, Variables, Definitions, Condition Structures and Loops, Formatting and Applications
Week 12 - Theoretical
Spreadsheet Software Creating and Running Macro, Introduction to Macro Programming, Variables, Definitions, Condition Structures and Loops, Formatting and Applications
Week 13 - Theoretical
Templates and Creating New Templates in Presentation Preparation Software Design Programs
Week 14 - Theoretical
Presentation Preparation Software Styles and Templates, Impressive Presentation Creation Techniques
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory1141428
Lecture - Practice1141428
Assignment34218
Midterm Examination1718
Final Examination114115
TOTAL WORKLOAD (hours)97
Contribution of Learning Outcomes to Programme Outcomes