• 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 3902 INSDUSTRIAL COMPUTER APPLICATIONS 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 proposed course, DEU Industrial Engineering Department students will be introduced to the basic office programs (MS Office) that they may need in their professional life. Through these programs, it is aimed to develop students' modeling, problem solving and analysis skills on different platforms as an alternative to industrial engineering basic software, and to achieve professional gains suitable for the Industry 4.0 era we live in.

Learning Outcomes of the Course Unit

1   Comprehension of computer skills and importance of programming 2   Understanding the use of MS Office programs and their professional contributions 3   Solving a problem with industry by using MS Excel Solver (solver) 4   Modeling and managing database with MS Access 5   To be able to write and present a scientific report with 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 Overview of various computer applications and MS Office in industry 2 General introduction to MS Word 3 Preparing presentations with MS PowerPoint 4 Creating a database with MS Access 5 Database management with MS Access 6 Database management with MS Access 7 Overview of MS Excel 8 Overview of MS Excel 9 MS Excel analysis and tests 10 MS Excel macro recording, editing and writing (VBA) applications 11 Use of MS Excel Solver (solver) 12 Database management with MS Excel 13 MS Access communication with MS Excel 14 Project presentations

Recomended or Required Reading

Osman Gürkan, Microsoft Office 2016, Nirvana Yayınları. Osman Gürkan, Microsoft Access 2016, Nirvana Yayınları.

Planned Learning Activities and Teaching Methods

Presentation + Application + Scientific Discussion

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.30 + ASG * 0.20 + FIN * 0.50 5 RST RESIT 6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.30 + ASG * 0.20 + RST * 0.50

Further Notes About Assessment Methods

None

Assessment Criteria

Midterm (%30) + Project (%20) + Final (%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 12 3 36 Preparations before/after weekly lectures 12 1 12 Preparation for midterm exam 1 15 15 Preparation for final exam 1 20 20 Preparing presentations 1 15 15 Final 1 2 2 Midterm 1 2 2 TOTAL WORKLOAD (hours) 102

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 LO.1 5 3 LO.2 4 2 4 3 LO.3 5 5 4 4 5 3 LO.4 5 2 3 3 LO.5 5 5 3 5 4