| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Offıce Applıcatıon Development | BYP 202 | 4 | 1 + 1 | 2 | 3 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Ön Lisans |
| Dersin Türü | Zorunlu |
| Dersin Koordinatörü | Öğr.Gör. FATİH ALBAYRAK |
| Dersi Verenler | Doç.Dr. AHMET ÇAĞATAY ÇİLİNGİR, |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Diğer |
| Dersin Amacı | It is aim to make various applications by telling effective usage methods giving necessary softwares and properties to supply business efficiency, on the computer systems which used each field of modern companies and computer programmes working at this systems. |
| Dersin İçeriği | Forms on the Microsoft Word, electronics forms, usage of Excel at the decision problems, MS Access sample tables, Macros at the MS Excel/ to create macro |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | To create forms on the Microsoft Word | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 2 | To create electronics forms | Discussion, Self Study, Question-Answer, Lecture, | Homework, Testing, |
| 3 | To make mail merge | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 4 | To solve decision problems by MS Excel. | Discussion, Self Study, Question-Answer, Lecture, | Homework, Testing, |
| 5 | To describe basic level of database concept | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 6 | To create database by MS Access database application programme | Discussion, Self Study, Question-Answer, Lecture, | Homework, Testing, |
| 7 | To add table to the created database and define relations between tables | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 8 | To add datas to the tables, create table for data entry | Question-Answer, Discussion, Lecture, Self Study, | Homework, Testing, |
| 9 | To create macro | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 10 | To make macros made by MS Excel editor more effective by using Visual Basic editor | Discussion, Question-Answer, Self Study, Lecture, | Testing, Homework, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | To create forms on the Microsoft Word. | |
| 2 | To create electronics forms | |
| 3 | Mail merge | |
| 4 | Usage of Excel at the decision problems | |
| 5 | An example at the production purchasing decision making. | |
| 6 | MS Access and basic concepts of database | |
| 7 | To create table at the MS Access | |
| 8 | MS Access sample tables | |
| 9 | MS Access Keys, relations | |
| 10 | MS Access to create form | |
| 11 | Report preparation at the MS Access | |
| 12 | Inquiry creating at the MS Access. | |
| 13 | Macros at the MS Excel/ to create macro | |
| 14 | Visual basic editor |
| Kaynaklar | |
|---|---|
| Ders Notu | |
| Ders Kaynakları | |
| Sıra | Program Çıktıları | Katkı Düzeyi | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | |||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | |||||||
| 5 | X | ||||||
| 6 | |||||||
| 7 | |||||||
| 8 | X | ||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 50 |
| 1. Kısa Sınav | 15 |
| 1. Ödev | 20 |
| 2. Kısa Sınav | 15 |
| Toplam | 100 |
| 1. Yıl İçinin Başarıya | 20 |
| 1. Final | 80 |
| 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 | 2 | 32 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 1 | 16 |
| Mid-terms | 1 | 4 | 4 |
| Quiz | 2 | 5 | 10 |
| Assignment | 1 | 15 | 15 |
| Final examination | 1 | 10 | 10 |
| Toplam İş Yükü | 87 | ||
| Toplam İş Yükü / 25 (Saat) | 3,48 | ||
| Dersin AKTS Kredisi | 3 | ||