Industrial Engineering
Course Details
KTO KARATAY UNIVERSITY
Mühendislik ve Doğa Bilimleri Fakültesi
Programme of Industrial Engineering
Course Details
Mühendislik ve Doğa Bilimleri Fakültesi
Programme of Industrial Engineering
Course Details
| Course Code | Course Name | Year | Period | Semester | T+A+L | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| 15281842 | Excel-Based Business Analytics | 3 | Autumn | 5 | 3+0+0 | 3 | 5 |
| Course Type | Elective |
| Course Cycle | Bachelor's (First Cycle) (TQF-HE: Level 6 / QF-EHEA: Level 1 / EQF-LLL: Level 6) |
| Course Language | Turkish |
| Methods and Techniques | - |
| Mode of Delivery | Face to Face |
| Prerequisites | - |
| Coordinator | Prof. Murat DARÇIN |
| Instructor(s) | - |
| Instructor Assistant(s) | - |
Course Content
Lecture, Demonstration, Discussion, Question and Answer, Project Development, Problem Solving
Objectives of the Course
To improve the basic and advanced level of use of Microsoft Excel program, to increase productivity and to ensure effective use of excel.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | |
| Specialization / Field Courses | X |
| Support Courses | |
| Transferable Skills Courses | |
| Humanities, Communication and Management Skills Courses |
Relationships between Course Learning Outcomes and Program Outcomes
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Program Learning Outcomes | Level |
|---|---|---|
| P4 | Ability to select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in Industrial Engineering applications; Ability to use information technologies effectively | 5 |
Course Learning Outcomes
| Upon the successful completion of this course, students will be able to: | |||
|---|---|---|---|
| No | Learning Outcomes | Outcome Relationship | Measurement Method ** |
| O1 | İleri düzey excel fonksiyonlarini kullanabilir. | P.4.35 | 1 |
| O2 | Excel makrolari ile programlama yapabilir. | P.4.36 | 1 |
| O3 | Excel programına başka programlardan veri aktarıp/güncellemeyi gerçekleştirebilir. | P.4.37 | 1 |
| O4 | Excel Solver ile çözümleme yapabilir. | P.4.38 | 1 |
| ** Written Exam: 1, Oral Exam: 2, Homework: 3, Lab./Exam: 4, Seminar/Presentation: 5, Term Paper: 6, Application: 7 | |||
Weekly Detailed Course Contents
| Week | Topics |
|---|---|
| 1 | Introduction |
| 2 | Advanced Formula Usage |
| 3 | Use of Scenarios |
| 4 | Pivot Tables |
| 5 | Protection of Excel Files |
| 6 | Excel and Databases |
| 7 | Excel and Databases |
| 8 | Midterm |
| 9 | Using Excel Add-ins |
| 10 | Using Excel Add-ins |
| 11 | Macros |
| 12 | Macros |
| 13 | Visual Basic for Applications (VBA) and Excel |
| 14 | Visual Basic for Applications (VBA) and Excel |
| 15 | Final Sınavına Hazırlık |
Textbook or Material
| Resources | Practical management science : spreadsheet modeling and applications / Wayne L. Winston, S. Christian Albright with case studies by Mark Broadie. |
Evaluation Method and Passing Criteria
| In-Term Studies | Quantity | Percentage |
|---|---|---|
| Attendance | - | - |
| Laboratory | - | - |
| Practice | - | - |
| Field Study | - | - |
| Course Specific Internship (If Any) | - | - |
| Homework | - | - |
| Presentation | - | - |
| Projects | - | - |
| Seminar | - | - |
| Quiz | - | - |
| Listening | - | - |
| Midterms | 1 | 40 (%) |
| Final Exam | 1 | 60 (%) |
| Total | 100 (%) | |
ECTS / Working Load Table
| Quantity | Duration | Total Work Load | |
|---|---|---|---|
| Course Week Number and Time | 14 | 3 | 42 |
| Out-of-Class Study Time (Pre-study, Library, Reinforcement) | 14 | 3 | 42 |
| Midterms | 1 | 30 | 30 |
| Quiz | 0 | 0 | 0 |
| Homework | 0 | 0 | 0 |
| Practice | 0 | 0 | 0 |
| Laboratory | 0 | 0 | 0 |
| Project | 0 | 0 | 0 |
| Workshop | 0 | 0 | 0 |
| Presentation/Seminar Preparation | 0 | 0 | 0 |
| Fieldwork | 0 | 0 | 0 |
| Final Exam | 1 | 36 | 36 |
| Other | 0 | 0 | 0 |
| Total Work Load: | 150 | ||
| Total Work Load / 30 | 5 | ||
| Course ECTS Credits: | 5 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P4 |
|---|---|---|
| O1 | İleri düzey excel fonksiyonlarini kullanabilir. | 5 |
| O2 | Excel makrolari ile programlama yapabilir. | 5 |
| O3 | Excel programına başka programlardan veri aktarıp/güncellemeyi gerçekleştirebilir. | 5 |
| O4 | Excel Solver ile çözümleme yapabilir. | 5 |