• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS END 4918 MANAGEMENT SCIENCE MODELING WITH SPREADSHEETS ELECTIVE 3 0 0 4

Offered By

Industrial Engineering

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR FEHMI BURÇIN ÖZSOYDAN

Offered to

Industrial Engineering

Course Objective

With this course, by introducing MS Excel program practically, it is aimed to develop the coding and MS Excel using skills of the students through DSS applications, which they may need in their professional life, and to make students gain professional skills in accordance with the era of Industry 4.0.

Learning Outcomes of the Course Unit

1   Learning DSS and their importance 2   Learning use of MS Excel and its benefits in professional life 3   To be able to solve and interpret various engineering problems by using MS Excel solver 4   To be able to record, to edit and to create macros via Visual Basic Applications (VBA) to solve problems 5   To be able to use MS Excel solver by macros autonomously or semi-autonomously 6   Being able to obtain knowledge from information and information from data via database management techniques 7   Achieving the skills that are required to design and to managing a DSS

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Introduction to DSS: what is DSS and what are the purposes of DSSs 2 Use of MS Excel through an application 3 Use of MS Excel through an application 4 Use of MS Excel through an application 5 Problem solving via MS Excel Solver and an application 6 Problem solving via MS Excel Solver and an application 7 Midterm exam 8 Macro recording, editing and coding (Visual Basic Applications-VBA) via MS Excel 9 Macro recording, editing and coding (Visual Basic Applications-VBA) via MS Excel 10 Macro recording, editing and coding (Visual Basic Applications-VBA) via MS Excel 11 Using MS Excel Solver via codes and VBA 12 Database management via MS Excel 13 Database management via MS Excel 14 Term project presentations

Recomended or Required Reading

1) Kapanoğlu, M., Saraç, T., Orhan, I., Karar destek sistemleri, Anadolu Üniversitesi Yayınları, ISBN: 978-975-06-2077-5 2) Business Intelligence and Analytics Sysmtes for Decision Support, Ramesh Sharda, Dursun Delen, Efraim Turban, 10th Ed., Pearson, ISBN: 1-292-00920-9

Planned Learning Activities and Teaching Methods

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 MTE MIDTERM EXAM 2 ASG ASSIGNMENT 3 FIN FINAL EXAM 4 FCG FINAL COURSE GRADE MTE * 0.20 + ASG * 0.30 + FIN * 0.50 5 RST RESIT 6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + ASG * 0.30 + RST * 0.50 *** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

burcin.ozsoydan@deu.edu.tr, Tel. +90-232-3017630

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 12 3 36 Preparations before/after weekly lectures 12 2 24 Preparation for midterm exam 1 7 7 Preparation for final exam 1 7 7 Preparing group assignments 5 3 15 Final 1 2 2 Midterm 1 2 2 Presentations 2 4 8 TOTAL WORKLOAD (hours) 101

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 LO.1 5 LO.2 LO.3 LO.4 LO.5 LO.6 LO.7