1. Eğitim Bilgi Sistemi
  2. Mühendislik Yönetimi Pr. (Yl) (Uzaktan)
  3. Electronıc Table Applıcatıons In Engıneerıng (2020 - 2021)
Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Electronıc Table Applıcatıons In Engıneerıng MYU 509 0 3 + 0 3 6
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi YUKSEK_LISANS
Dersin Türü Seçmeli
Dersin Koordinatörü Doç.Dr. GÜLTEKİN ÇAĞIL
Dersi Verenler Doç.Dr. GÜLTEKİN ÇAĞIL,
Dersin Yardımcıları

Res.Asst. M. Bilgehan Erdem
Dersin Kategorisi Alanına Uygun Öğretim
Dersin Amacı

A lot of studies show that the engineers in working environments mostly use spreadsheet programs. Therefore, the scope of this course to explain the features of a spreadsheet software used in engineering.
Dersin İçeriği

Introduction of Spreadsheet softwares and MS-Excel, sharing Excel datas with others software, writing simple codes with Excel Macro programming language.
# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 can use MS-Excel Lecture, Question-Answer, Drilland Practice, Motivations to Show, Testing, Homework, Project / Design,
2 can use conditional formatting technique Motivations to Show, Drilland Practice, Question-Answer, Lecture, Project / Design, Homework, Testing,
3 can use data verification technique Lecture, Question-Answer, Drilland Practice, Motivations to Show, Testing, Homework, Project / Design,
4 can use and search MS-Excel functions Drilland Practice, Question-Answer, Lecture, Self Study, Project / Design, Homework, Testing,
5 can write user defined functions Lecture, Case Study, Drilland Practice, Testing, Homework, Project / Design,
6 can write macro code in MS-Excel Drilland Practice, Motivations to Show, Group Study, Project Based Learning, Lecture, Case Study, Project / Design, Homework, Testing,
7 can intervene to a macro code that written in MS-Excel Lab / Workshop, Problem Solving, Project Based Learning, Case Study, Lecture, Discussion, Testing, Project / Design, Homework,
Hafta Ders Konuları Ön Hazırlık
1 Genaral information about Spreadsheet software
2 Genaral information about Ms-Excel
3 Fonctions in MS-Excel
4 Conditional formatting, Naive Bayes technique
5 Data Verification
6 Visual Basic/Programming in MS-Excel
7 Fundamentals of programming with Visual Basic - 1
8 Fundamentals of programming with Visual Basic - 2
9 User Defined Functions
10 Fundamentals of Macro programming in MS-Excel
11 Running of executable software with Macro codes
12 Using of MS-Excel Functions with Macro codes
13 Special procedures for Workbook and Worksheet
14 Special macros for Workbook and Worksheet
Kaynaklar
Ders Notu

www.gultekincagil.com
Ders Kaynakları

1. VBA Makrolar, M. Kemal Korkmaz,
2. Adım Adım Microsoft Excel XP 2002, Curtis Frye, Arkadaş Yayınları
3. Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets by Jinjer Simon, Hungry Minds Inc., 2002
4. Excel 2003 Bible, John Walkenbach, Wiley Publishing Inc., 2003
5. Microsoft Excel 2000, İhsan Karagülle, Osman Gürkan, Zeydin Pala, Türkmen Kitabevi, 1999
Sıra Program Çıktıları Katkı Düzeyi
1 2 3 4 5
1
2
3
4
5
6
7
8
9
10
11
12
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 40
1. Ödev 60
1. Ara Sınav 25
1. Ödev 37
2. Ödev 38
Toplam 200
1. Final 60
1. Yıl İçinin Başarıya 40
1. Final 80
1. Yıl İçinin Başarıya 20
Toplam 200
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 10 10
Quiz 1 10 10
Assignment 1 20 20
Performance Task (Laboratory) 1 15 15
Toplam İş Yükü 151
Toplam İş Yükü / 25 (Saat) 6,04
Dersin AKTS Kredisi 6