COURSE UNIT TITLE

: INSDUSTRIAL COMPUTER APPLICATIONS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
END 3943 INSDUSTRIAL COMPUTER APPLICATIONS 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, DEU Industrial Engineering Department students will be introduced to basic office programs (MS Office) that they may need in their professional lives. Through these programs, it is aimed that students will develop their modeling, problem solving and analysis skills on different platforms as an alternative to basic industrial engineering software and obtain professional achievements suitable for the Industry 4.0 era we are in.

Learning Outcomes of the Course Unit

1   Understanding the importance of computer usage skills and programming
2   Understand the use of MS Office programs and their professional contributions
3   Ability to solve a problem with industry using MS Excel Solver
4   Database modeling and management with MS Access
5   Acquiring the skills to write and present a scientific report using MS Word, MS PowerPoint

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 General introduction to various computer applications and MS Office in industry
2 General introduction to MS Word
3 Preparing a presentation with MS PowerPoint
4 Creating a database with MS Access
5 Database management with MS Access
6 Database management with MS Access
7 MS Excel general introduction
8 MS Excel general introduction
9 MS Excel analysis and tests
10 MS Excel macro recording, editing and authoring (VBA) applications
11 MS Excel macro recording, editing and authoring (VBA) applications
12 MS Excel macro recording, editing and authoring (VBA) applications
13 Using MS Excel Solver
14 Using MS Excel Solver

Recomended or Required Reading

Frederick S. Hillier, Gerald J. Lieberman, Introduction to Operations Research,
Osman Gürkan, Microsoft Office 2016, Nirvana Yayınları.
Osman Gürkan, Microsoft Access 2016, Nirvana Yayınları.
Osman Gürkan, Microsoft Excel 2016, Nirvana Yayınları.

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

20% Midterm, 30% Project, 50% Final

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.11
LO.23
LO.3455
LO.423
LO.52

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