• 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 UAT 4054 ADVANCED EXCEL APPLICATIONS ELECTIVE 1 2 0 5

Offered By

International Trade

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR HAKAN ÖZKAYA

Offered to

International Trade

Course Objective

Effective use of Excel program functions and add-ins for data handling, analysis and presentation.

Learning Outcomes of the Course Unit

1   To be able to write formulas 2   To be able to use the right functions with the right parameters 3   To be able to import data in different formats. 4   To be able to make analyzes by organizing the data 5   To be able to report analysis results

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Basic functions and formulas 2 Cell addresses in formulas 3 Logical functions 4 Search and reference functions 5 Financial functions 6 Statistical functions 7 Statistical functions 8 Midterm exam 9 Text functions 10 Import and transformation of data 11 Data tools functions 12 Pivot Tables 13 Goal seeker, scenarios and solver 14 Macros 15 Macros 16 Final exam 17 Final exam

Recomended or Required Reading

Ileri Seviye Excel, Serdar Özbay, Sıfırbir Yayınevi

Planned Learning Activities and Teaching Methods

Lecturing, question-answers, cases and application

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 MTE MIDTERM EXAM 2 FIN FINAL EXAM 3 FCG FINAL COURSE GRADE MTE * 0.40 + FIN * 0.60 4 RST RESIT 5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + RST * 0.60

Further Notes About Assessment Methods

None

Assessment Criteria

Ability to solve problems through midterm and final exams, ability to apply.

Language of Instruction

Turkish

Course Policies and Rules

Dokuz Eylul University Associate's Degree and Bachelor's Degree Education and Examination Regulations School of Applied Sciences Education and Examination Application Principles

Contact Details for the Lecturer(s)

hakan.ozkaya@deu.edu.tr

Office Hours

To be announced

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 14 1 14 Tutorials 14 2 28 Preparations before/after weekly lectures 14 4 56 Preparation for midterm exam 1 5 5 Preparation for final exam 1 8 8 Final 1 1 1 Midterm 1 1 1 TOTAL WORKLOAD (hours) 113

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