Course Name Code Semester T+U Hours Credit ECTS
Macro Programming ENM 413 7 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
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
Course Category
Course Objective

Providing spreadsheet softwares and ability to write a programme with Microsoft Excel

Course Content

Describing Microsoft Excel software that one of the spreadsheet softwares and able to write macro programme with Microsoft Excel

# Course Learning Outcomes Teaching Methods Assessment Methods
1 Comprehending main specifications of spreadsheet softwares Lecture, Case Study, Lab / Workshop, Drilland Practice, Self Study, Problem Solving, Question-Answer, Discussion, Testing, Homework,
2 Comprehending what we obtain and what we can do with spreadsheet softwares Discussion, Drilland Practice, Problem Solving, Question-Answer, Lab / Workshop, Self Study, Lecture, Case Study, Testing, Homework,
Week Course Topics Preliminary Preparation
1 General informations about Microsoft Excel, cell concept, copy-paste and special paste in excel
2 Absolute and relative references and range concept in excel
3 Function concept in excel
4 Conditional formatting
5 Data validation
6 Relations between Excel and Visual Basic
7 General informations about Visual Basic
8 User Defined Functions in excel
9 Range concept in User Defined Functions
10 Basic operations in Excel Visual Basic Editor
11 Working with macro recording
12 Function and graphics operatins with macro programming
13 Sample applications
14 Industrial aplications with macro programming
Resources
Course Notes <p>I http://www.gultekincagil.co</p> <p>lecture notes published on this&nbsp;link</p>
Course Resources

1. The VBA Macros, M. Kemal Korkmaz,
2. "Step by Step" Microsoft Excel XP 2002, Curtis Frye, Arkadaş Publications

Order Program Outcomes Level of Contribution
1 2 3 4 5
1 Engineering graduates with sufficient knowledge background on science and engineering subjects of their related area, and who are skillful in implementing theoretical and practical knowledge for modelling and solving engineering problems. X
2 Engineering graduates with skills in identifying, describing, formulating and solving complex engineering problems, and thus,deciding and implementing appropriate methods for analyzing and modelling. X
3 Engineering graduates with skills in designing a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; for this purpose, skills in implementing modern design methods. X
4 Engineering graduates with skills in developing, selecting and implementing modern techniques and tools required for engineering applications as well as with skills in using information technologies effectively. X
5 Engineering graduates with skills in designing and conducting experiments, collecting data, analyzing and interpreting the results in order to evaluate engineering problems. X
6 Engineering graduates who are able to work within a one discipline or multi-discipline team,as well as who are able to work individually X
7 Engineering graduates who are able to effectively communicate orally and officially in Turkish Language as well as who knows at least one foreign language
8 Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology X
9 Engineering graduates with well-structured responsibilities in profession and ethics
10 Engineering graduates having knowledge about practices in professional life such as project management, risk management and change management, and who are aware of innovation and sustainable development. X
11 Engineering graduates having knowledge about universal and social effects of engineering applications on health, environment and safety, as well as having awareness for juridical consequences of engineering solutions.
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 10
1. Ödev 30
2. Kısa Sınav 10
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100
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 2 32
Mid-terms 1 8 8
Assignment 1 10 10
Performance Task (Laboratory) 1 16 16
Total Workload 114
Total Workload / 25 (Hours) 4.56
dersAKTSKredisi 5