COURSE UNIT TITLE

: MANAGEMENT SCIENCE MODELING WITH SPREADSHEETS

DEGREE PROGRAMMES

Description of Individual Course Units

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

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, it is aimed to introduce the DSS applications that DEU Industrial Engineering Department students may need in their professional lives, in the MS Excel environment, to develop students' coding and MS Excel usage skills and to obtain professional achievements suitable for the Industry 4.0 era we are in.

Learning Outcomes of the Course Unit

1   Understanding decision support systems and their importance
2   Learning how to use MS Excel and the advantages it can provide in professional life
3   Gaining the ability to analyze and interpret various engineering problems with MS Excel Solver
4   Gaining the skills of recording, editing and coding macros for problem solving with Visual Basic Applications (VBA)
5   Ability to use MS Excel Solver autonomously or semi-autonomously via VBA
6   Ability to use Monte Carlo Simulation techniques with MS Excel and VBA.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Introduction to decision support systems: What is DSS, what are its uses
2 Introduction to MS Excel
3 Introduction to MS Excel functions and sample applications
4 Visual Basic programming language introduction and applications
5 Visual Basic programming language introduction and applications
6 Application and problem solving related to MS Excel Solver
7 MS Excel Macro recording, editing and coding (VBA) applications
8 MS Excel Macro recording, editing and coding (VBA) applications
9 MS Excel Macro recording, editing and coding (VBA) applications
10 Development of decision support system and sample applications with MS Excel and VBA
11 Development of decision support system and sample applications with MS Excel and VBA
12 Development of decision support system and sample applications with MS Excel and VBA
13 Monte Carlo Simulation with MS Excel
14 Monte Carlo Simulation with MS Excel

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

Inclass activities and applications

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


Further Notes About Assessment Methods

None

Assessment Criteria

Midterm (%20) + Project (%30) + Final Exam(%50)

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

burcin.ozsoydan@deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 3 42
Preparations before/after weekly lectures 14 2 28
Preparation for midterm exam 1 20 20
Preparation for final exam 1 20 20
Preparing presentations 1 15 15
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 129

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11
LO.14
LO.2445
LO.345
LO.45
LO.545
LO.6445

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS