Ondokuz Mayıs Üniversitesi Bilgi Paketi - Ders Kataloğu

Description of Individual Course Units

Course Unit CodeCourse Unit TitleType of CourseYearSemesterECTS
İST479 Advanced Office Applications 927006 4 7 4
Level of Course Unit
First Cycle
Objectives of the Course
Teaching advanced applications with office programs
Name of Lecturer(s)
-Dr. Emre Dünder
Learning Outcomes
  1. MS Office programları tanıtılır.
  2. Excel’de tablo işlemleri anlatılır.
  3. Excel’de formüller anlatılır.
  4. Excel’de VBA makro işlemleri anlatılır.
  5. Access komutları anlatılır.
  6. Powerpoint ile görsel raporlama anlatılır.
  7. MS Office programs are introduced.
  8. The table operations are described in Excel.
  9. Formulas are described in Excel.
  10. VBA macro operations are described in Excel.
  11. Access commands are described.
  12. Visual reporting with Powerpoint is explained.
Mode of Delivery
Formal Education
Prerequisites and co-requisities
Recommended Optional Programme Components
Recommended or Required Reading
- Lambert, J., & Frye, C. (2015). Microsoft Office 2016 Step by Step. Microsoft Press.- Habraken, J. (2015). Office 2016 In Depth (includes Content Update Program). Que Publishing.-Walkenbach, J. (2010). Excel 2010 power programming with VBA (Vol. 6). John Wiley & Sons.-Harvey, G. (2015). Excel 2016 All-in-one for Dummies. John Wiley & Sons.
Planned Learning Activities and Teaching Methods
Language of Instruction
Work Placement(s)
Course Contents
Introduction to MS Office programs, formulas in Excel, VBA macros, advanced reporting with Powerpoint, Access commands
Weekly Detailed Course Contents
Week Theoretical Practice Laboratory
1.Introduction to MS Office programs
2.Basic Excel operations
3.Data and table operations with Excel
4.Introduction to formulas in Excel
5.Formulas and applications in Excel
6.Formulas and applications in Excel
7.Intoduction to macros in Excel
9.Macro operations in Excel
10.Macro operations in Excel
11.Basic Access operations
12.Database operations with Access commands
13.Database operations with Access commands
14.Visual reporting with Powerpoint program
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight (%)
Midterm Examination1100
End Of Term (or Year) Learning ActivitiesQuantityWeight (%)
Final Examination1100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
Workload Calculation
ActivitiesQuantityTime(hours)Total Workload(hours)
Midterm Examination122
Final Examination122
Attending Lectures13339
Problem Solving616
Self Study4312
Individual Study for Mid term Examination133
Individual Study for Final Examination144