TÜRKÇE
ENGLISH
Information
| Unit | |
| Code | SD0439 |
| Name | Data analysis and reporting |
| Term | 2020-2021 Academic Year |
| Term | Fall and Spring |
| Duration (T+A) | 2-0 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Label | NFE Non-Field Elective Courses (University) UCC University Common Course |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. MEHMET TEKDAL |
| Course Instructor |
Doç. Dr. MEHMET TEKDAL
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Veri analizi ve raporlama
Course Content
Introduction, Basic concepts, Functions, Data Analysis, Excel VBA, Advanced applications
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to the course | ||
| 2 | Temel Bilgiler: Ribon-Workbook-Worksheets-Format Cells | ||
| 3 | Basics: Format Cells-Find and Select-Templates-Data Validation | ||
| 4 | Basics: Keyboard shortcuts-Print-Share-Protect | ||
| 5 | Functions-1 | ||
| 6 | Functions-2 | ||
| 7 | Functions-3 | ||
| 8 | Mid-Term Exam | ||
| 9 | Data Analysis-1 | ||
| 10 | Data Analysis-2 | ||
| 11 | Data Analysis-3 | ||
| 12 | Data Analysis-4 | ||
| 13 | Data Analysis-5 | ||
| 14 | Excel VBA-1 | ||
| 15 | Excel VBA-2 | ||
| 16 | Term Exams | ||
| 17 | Term Exams |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |