| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Spreadsheets | BYP 102 | 2 | 2 + 1 | 3 | 5 |
| Ö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ı | MS Office Excel Programme provides records which are used by various firms commonly, learning, arranging as data lists, abstract, comparing and presentation as a graphic making by various applications to the students who are responsible with this course. |
| Dersin İçeriği | Icons and their missions, various work pages, connection between cells/pages with formulas, conditional table and abstract tables, analysises, syntax rule of functions and working with formulas which appeared in the MS Office Excel Programme |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | Datas can be kept by saving. | Lecture, Question-Answer, Self Study, Discussion, | Testing, Homework, |
| 2 | Tables can be gained Professional view. | Lecture, Discussion, Question-Answer, Self Study, | Homework, Testing, |
| 3 | Tables can be gained Professional view. | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 4 | Datas can be used active and quick. | Discussion, Question-Answer, Self Study, Lecture, | Homework, Testing, |
| 5 | Abstact can be obtained from tables. | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| 6 | Functions can be prepared by using formulas easily and in a litttle while. | Discussion, Question-Answer, Self Study, Lecture, | Homework, Testing, |
| 7 | Knowledge can be shared with sources in the firm and out of the firm. | Lecture, Self Study, Question-Answer, Discussion, | Testing, Homework, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Major icons and missions which appeared in the Office button. | |
| 2 | Working with various work book, page tabs, cell processes, raw and column processes, shortcut in the Excel and function buttons. | |
| 3 | Cell format, data entry, using filling handle to fill cells. | |
| 4 | Knowledge structure at the cells, adding explanation to the cells, general view to the formulas, formula elements, procedure at the formulas. | |
| 5 | Working with formula pallete, arranging formulas, to find out failure value, possible reasons of failure messages and proposed actions. | |
| 6 | Working with tables, working with conditional forming, cell form applications by using color scalas, clean of conditional forming. | |
| 7 | Working with graphics (1), creating a new graphic, determining graphic type, changing graphics view. | |
| 8 | Working with graphics (2), graphic type | |
| 9 | Working with graphics (3), changing order and style of graphic, changing order of graphic element by hand, changing style of graphic element by hand, saving a graphic as a graphic template, remove or clean of a graphic template. | |
| 10 | Working with functions (1), logical functions, usage of and, if function, examples. | |
| 11 | Working with functions (2), usage of merge, capital, lower case, change, liras, convert to text, identical functions. | |
| 12 | Working with functions (3), usage of to the left, to the right, length, righting order, replace, refresh functions. | |
| 13 | Example | |
| 14 | Solution of example |
| Kaynaklar | |
|---|---|
| Ders Notu | |
| Ders Kaynakları | |
| Sıra | Program Çıktıları | Katkı Düzeyi | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | X | ||||||
| 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) |
|---|---|---|---|
| Mid-terms | 1 | 10 | 10 |
| Quiz | 2 | 5 | 10 |
| Assignment | 1 | 10 | 10 |
| Final examination | 1 | 10 | 10 |
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 4 | 64 |
| Toplam İş Yükü | 152 | ||
| Toplam İş Yükü / 25 (Saat) | 6,08 | ||
| Dersin AKTS Kredisi | 5 | ||