Course Name Code Semester T+U Hours Credit ECTS
Electronic Table Applications In Engineering MYU 509 0 3 + 0 3 6
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level yuksek_lisans
Course Type Optional
Course Coordinator Dr.Öğr.Üyesi GÜLTEKİN ÇAĞIL
Course Lecturers Dr.Öğr.Üyesi GÜLTEKİN ÇAĞIL,
Course Assistants

Res.Asst. M. Bilgehan Erdem

Course Category Field Proper Education
Course Objective

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.

Course Content

Introduction of Spreadsheet softwares and MS-Excel, sharing Excel datas with others software, writing simple codes with Excel Macro programming language.

# Course Learning Outcomes Teaching Methods Assessment Methods
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,
Week Course Topics Preliminary Preparation
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
Resources
Course Notes <p>www.gultekincagil.com</p>
Course Resources

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

Order Program Outcomes Level of Contribution
1 2 3 4 5
1
2
3
4
5
6
7
8
9
10
11
12
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 40
1. Ödev 60
1. Ara Sınav 25
1. Ödev 37
2. Ödev 38
Total 200
1. Final 60
1. Yıl İçinin Başarıya 40
1. Final 80
1. Yıl İçinin Başarıya 20
Total 200
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
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
Total Workload 151
Total Workload / 25 (Hours) 6.04
dersAKTSKredisi 6