To provide students with advanced Excel tools such as Macros, VBA, functions, data analysis, user interface design that they will need at every stage of their career.
Prerequisite(s)
-
Corequisite(s)
-
Special Requisite(s)
-
Instructor(s)
Assoc. Prof. Fadime Üney Yüksektepe
Course Assistant(s)
-
Schedule
The course is not offered this semester.
Office Hour(s)
The course is not offered this semester.
Teaching Methods and Techniques
-Lecture, discussion, demonstration
Principle Sources
-Lecture Notes
Ekşioğlu, S.D., Şeref, M.M.H., Ahuja, R.K., Winston, W.L. (2011). Developing Spreadsheet-Based Decision Support Systems: Using Excel and VBA for Excel (2nd Edition). Dynamic Ideas, Belmont, Massachusetts.
Other Sources
-
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to Excel
Oral presentation
2. Week
Referencing, Formatting and Names
Oral presentation
3. Week
Functions and Formulas
Oral presentation
4. Week
Introduction to the Visual Basic Environment
Oral presentation
5. Week
Recording Macros
Oral presentation
6. Week
More on Objects
Oral presentation
7. Week
Midterm
8. Week
Variables
Oral presentation
9. Week
Sub Procedures and Function Procedures
Oral presentation
10. Week
Programming Structures
Oral presentation
11. Week
Mathematical Programming Revisited
Oral presentation
12. Week
Monte Carlo Simulation
Oral presentation
13. Week
Working with Large Data Using VBA
Oral presentation
14. Week
GUI Design
Oral presentation
15. Week
FINAL
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
35
Quizzes
3
15
Final Exam
1
50
Program Outcomes
PO-1
Knowledge about management processes and management skills
PO-2
Knowledge and application skills related to the methods and competencies required for solving engineering problems
PO-3
Knowledge about developing areas of manufacturing and service sectors
PO-4
Ability to work in multi-disciplinary engineering teams
PO-5
Experience and knowledge of scientific research and publishing within the frame of academic ethics