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
None
Recommended Optional Programme Components
None
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
Turkish
Work Placement(s)
None
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
8.Midterm
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
15.
16.
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight (%)
Midterm Examination1100
SUM100
End Of Term (or Year) Learning ActivitiesQuantityWeight (%)
Final Examination1100
SUM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
SUM100
Workload Calculation
ActivitiesQuantityTime(hours)Total Workload(hours)
Midterm Examination122
Final Examination122
Attending Lectures13339
Practice7214
Problem Solving616
Question-Answer428
Self Study4312
Individual Study for Mid term Examination133
Individual Study for Final Examination144
Homework339
SUM99