| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Excel Vba Programmıng | YBS 253 | 3 | 1 + 1 | 2 | 5 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Lisans |
| Dersin Türü | Seçmeli |
| Dersin Koordinatörü | Doç.Dr. ÇAĞLA EDİZ |
| Dersi Verenler | Doç.Dr. ÇAĞLA EDİZ, |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Alanına Uygun Öğretim |
| Dersin Amacı | Gaining writing and reporting small-scale projects for businesses using excel vba applications |
| Dersin İçeriği | Macros,userforms and model implementations. |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | To have information about visual basic applications with using Excel | Lecture, Question-Answer, Discussion, Drilland Practice, Problem Solving, | Testing, Homework, |
| 2 | Question-Answer, | Homework, Testing, | |
| 3 | To have model implemenatations which can be developed in business organizations | Project Based Learning, Drilland Practice, Discussion, Question-Answer, Lecture, | Homework, Testing, Project / Design, |
| 4 | Project Based Learning, | Project / Design, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Functions in excel, | |
| 2 | Macros and userforms in excel, | |
| 3 | Comparing and combining two reports, | |
| 4 | Preparing customer cards automatically, | |
| 5 | Preparing supplier evaluation system, | |
| 6 | Preparing ordering system, | |
| 7 | Preparing work distribution according to production schedules | |
| 8 | Midterm | |
| 9 | Preparing inventory tracking program | |
| 10 | Tracking material from the production records | |
| 11 | MRP-1 | |
| 12 | MRP-2 | |
| 13 | Preparing graphical reports with macros | |
| 14 | Overall assesment |
| Kaynaklar | |
|---|---|
| Ders Notu | |
| Ders Kaynakları | |
| Sıra | Program Çıktıları | Katkı Düzeyi | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Can follow new and current technologies and evaluate them | ||||||
| 2 | Can understand the operation of Corporate Information Systems and use these systems at a basic level | X | |||||
| 3 | Constructs numerical models of basic business problems. | X | |||||
| 4 | Solves modeled business problems with the help of information technologies and interprets the solutions | X | |||||
| 5 | Contributes to informatics oriented projects as a member of the team | ||||||
| 6 | Effectively uses information technology tools that support teamwork in project management. | ||||||
| 7 | Master basic business functions and information technologies and establishes the link between them | ||||||
| 8 | Contributes to the design, development and implementation processes of corporate information systems. | X | |||||
| 9 | Can produce and present quality documentation for all kinds of projects, including entrepreneurship projects. | X | |||||
| 10 | Prepares informative, effective and interesting presentations and presents these presentations. | X | |||||
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 70 |
| 1. Ödev | 10 |
| 2. Ödev | 10 |
| 3. Ödev | 10 |
| Toplam | 100 |
| 1. Yıl İçinin Başarıya | 60 |
| 1. Final | 40 |
| Toplam | 100 |
| AKTS - İş Yükü Etkinlik | Sayı | Süre (Saat) | Toplam İş Yükü (Saat) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 3 | 48 |
| Mid-terms | 1 | 15 | 15 |
| Final examination | 1 | 25 | 25 |
| Toplam İş Yükü | 136 | ||
| Toplam İş Yükü / 25 (Saat) | 5,44 | ||
| Dersin AKTS Kredisi | 5 | ||