Faculty of Business and Management Sciences · International Trade and Finance (English) · Undergraduate
ECTS: 5 T+P+L: 1+0+2 Compulsory
Coordinator: Dr. Öğr. Üyesi Cemil Faruk DURMAZ
Instructors: Dr. Öğr. Üyesi Cemil Faruk DURMAZ, Dr. Öğr. Üyesi Hüseyin İÇEN
Course Objective
This course is designed to introduce the essential functions and features of the key Microsoft Office applications. Students will learn foundational skills for word processing with Word, spreadsheet management with Excel and presentation design with PowerPoint.
Course Content
The course covers three most essential Microsoft office tools: Word, Excel and PowerPoint. The students will prepare country reports using all three applications.
Core Area Distribution
(34) Business and Administration%20 (46) Mathematics and Statistics%20 (48) Computing%60
Teaching Methods
ExpressionExercise and Practice
Assessment & Evaluation
Performance Assignment ( Lab / Workshop / Field Work / Seminar / Presentation / Completion Study / ThesisTesting (Essay / Tests: True-Falls, multiple-choice, short answer, matching)
ECTS / Workload
| Activity | Quantity | Duration (h) | Total Workload |
|---|---|---|---|
| Course Duration (Including Exam Week) | 16 | 3 | 48 |
| Out of Class Study Period | 16 | 1 | 16 |
| Midterm | 1 | 1 | 1 |
| Quiz | 0 | 0 | 0 |
| Assignment | 0 | 0 | 0 |
| Practice | 0 | 0 | 0 |
| Final | 1 | 1 | 1 |
Course Schedule
| Week | Subject | Preparation |
|---|---|---|
| 1 | Introduction to the Course Reviewing the Course Outline and Resources | None |
| 2 | Explore Office; Create and manage files | Part 1: Office |
| 3 | Getting Started with Word Character Formatting Paragraph Formatting | Part 2: Microsoft Word |
| 4 | Managing Lists Tables Styles | Part 2: Microsoft Word |
| 5 | Controlling Page Appearance Sectioning Graphics | Part 2: Microsoft Word |
| 6 | Sectioning | Part 2: Microsoft Word |
| 7 | Intro to Excel Creating Workbooks Saving Workbooks Navigating Workbooks | Part 3: Excel |
| 8 | Exam Practice | Exam Practice |
| 9 | Midterm | Midterm |
| 10 | Page Setup & Print Options Working with Rows, Columns and Cells Moving Data Formulas & Functions | Part 3: Excel |
| 11 | Working with Sheets Formatting Worksheets Charts Working with Names Sorting and Filtering Advanced Functions | Part 3: Excel |
| 12 | Overview Getting Started Text and Bullet Editing Options Adding Graphics Working with Objects Editing Pictures | Part 4: PowerPoint |
| 13 | Working with SmartArt Working with Tables Working with Charts Adding Media Working with Transitions Slideshow Options | Part 4: PowerPoint |
| 14 | Exam Practice | Exam Practice |
| 15 | Blank Holiday | Blank Holiday |
| 16 | Final Exam | Final Sınavı |