• 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 FSH 0048 EXCEL FOR BUSINESS WORLD ELECTIVE 2 0 0 2

Offered By

Faculty Of Science

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSISTANT PROFESSOR ALPER VAHAPLAR

Offered to

Chemistry Biology Computer Science Statistics Faculty Of Science Physics Mathematics

Course Objective

This course aims to learn students to use Excel effectively in data manipulation, tabulation and reporting.

Learning Outcomes of the Course Unit

1   Using data types and built-in Excel functions 2   Creating pivot tables and graphics 3   Using Excel worksheets as a database

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Using Excel applications; ribbon interface, shortcuts, file types 2 Formatting Cells, Data Types 3 Managing worksheets, data entry and formulae 4 Conditional expressions 5 Creating charts 6 Excel functions; math, statistical, date 7 List management and look up, text functions 8 Midterm Exam 9 Creating pivot tables 10 Pivot tables and graphs 11 Conditional Formatting 12 Using Excel as a Database, to sort data, to filter data 13 Data validation, data query 14 Data sharing with other applications

Recomended or Required Reading

Wayne L. Winston, Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Ed., Microsoft Press, 2011

Planned Learning Activities and Teaching Methods

Lecture, presentations, applications in computer lab.

Assessment Methods

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

Further Notes About Assessment Methods

None

Assessment Criteria

Evaluation of exams and homeworks

Language of Instruction

Turkish

Course Policies and Rules

Attending the 70% of the classes are mandatory

Contact Details for the Lecturer(s)

DEU Fen Fakültesi Bilgisayar Bilimleri Bölümü e-mail: alper.vahaplar@deu.edu.tr Tel: 0 232 301 8573

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 13 2 26 Preparations before/after weekly lectures 13 1 13 Preparation for midterm exam 1 4 4 Preparation for final exam 1 4 4 Midterm 1 1 1 Final 1 1 1 TOTAL WORKLOAD (hours) 49

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