Information Package / Course Catalogue
| Course Code | : MVU200 |
| Course Type | : Area Elective |
| Couse Group | : Short Cycle (Associate's Degree) |
| Education Language | : Turkish |
| Work Placement | : N/A |
| Theory | : 2 |
| Prt. | : 1 |
| Credit | : 3 |
| Lab | : 0 |
| ECTS | : 2 |
To enable students to use Excel effectively in finance and accounting applications and to develop practical skills in financial data analysis, reporting, and decision support.
Financial functions in Excel, cash flow statements, budgeting, interest and loan calculations, depreciation calculations, financial analysis, charts, pivot tables, and financial reporting applications.
| 1. | Use Excel effectively in finance and accounting applications. |
| 2. | Apply Excel financial functions to perform interest, loan, and depreciation calculations. |
| 3. | Organize, analyze, and report financial data using charts and pivot tables. |
| 4. | Prepare and interpret budgets and cash flow statements in Excel. |
| 5. | Develop Excel-based analyses and reports to support financial decision-making processes. |
| 1. | Finance with Excel - Assoc. Prof. Dr. Metin COŞKUN |
| 2. | Lecture notes |
| Type of Assessment | Count | Percent |
|---|---|---|
| Attending Lectures | 1 | %10 |
| Quiz | 1 | %10 |
| Practice Examination | 1 | %20 |
| Final Examination | 1 | %60 |
| Activities | Count | Preparation | Time | Total Work Load (hours) |
|---|---|---|---|---|
| Lecture - Theory | 14 | 0 | 2 | 28 |
| Lecture - Practice | 14 | 0 | 1 | 14 |
| Practice Examination | 1 | 3 | 1 | 4 |
| Quiz | 1 | 1 | 1 | 2 |
| Final Examination | 1 | 5 | 1 | 6 |
| TOTAL WORKLOAD (hours) | 54 | |||
PÇ-1 | PÇ-2 | PÇ-3 | PÇ-4 | PÇ-5 | PÇ-6 | PÇ-7 | PÇ-8 | PÇ-9 | PÇ-10 | |
OÇ-1 | 1 | 5 | 2 | 4 | 5 | 4 | 4 | 4 | 2 | 3 |
OÇ-2 | 1 | 5 | 3 | 5 | 5 | 5 | 4 | 5 | 2 | 4 |
OÇ-3 | 1 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 4 |
OÇ-4 | 1 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 4 | 4 |
OÇ-5 | 2 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |