COURSE UNIT TITLE

: ADVANCED SPREADSHEET TOOLS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
SSD 2018 ADVANCED SPREADSHEET TOOLS ELECTIVE 1 1 0 2

Offered By

Drilling Technology

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

ALI EMIR INCE

Offered to

Natural Building Stones Technology
Welding Technology
Industrial Glass and Ceramics
GEOTECHNICS
Mining Technology
Civil Defense And Firefighting Programme
Drilling Technology

Course Objective

The aim of this course is to enable individuals working in technical fields to use Excel
program at an advanced level; to gain effective skills in data editing, analysis, reporting and
visualization. Thanks to this course, students will be able to perform data-oriented tasks that
they will encounter in business life in a practical and effective way.

Learning Outcomes of the Course Unit

1   Uses the basic structure and functions of the Excel program effectively.
2   Applies conditional formatting and data validation techniques.
3   Analyzes data with advanced functions (logical, text, date, financial).
4   Creates summary and dynamic reports with pivot tables.
5   Analyzes data with decision support tools (Scenario Manager, Goal Search, Solver).
6   Develops the ability to work with multi-page data and make connections between pages.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Spreadsheet - Introduction Basic structure of Excel, interface introduction, usage areas
2 Cell, Row, Column Operations-Data types, data entry, cell editing and formatting
3 Basic Functions-SUM, AVERAGE, MAX, MIN, IF, AND/OR functions
4 Conditional Formatting-Cell colors according to criteria, data highlighting
5 Data Validation-Data entry rules, drop-down list creation, entry restrictions
6 Text Functions-LEFT, RIGHT, PART, LENGTH etc.
7 Midterm exam.
8 Date and Time Functions - TODAY, NOW, DAY, MONTH, YEAR, date calculations
9 Logical and Search Functions - VALUE, Nested IF, VLOOKUP, HORIZONTAL, RUNNING
10 Financial and Mathematical Functions - INTEREST, PAYMENT, ROUND, SMALL, LARGE
11 Advanced Sorting and Filtering - Custom filters, filter by multiple criteria
12 Graphic Creation-Graphic types, graphic editing, visualization techniques
13 Pivot Tables-Summary table creation, field management, calculated field
14 Decision Support Tools-Scenario manager, Goal Search, Calculations with Solver

Recomended or Required Reading

Lambert, J., & Frye, C. (2022). Microsoft Excel step by step: (Office 2021 and Microsoft 365). Pearson Education, Inc.

Planned Learning Activities and Teaching Methods

group work, computer assisted learning, presentation technique, case study, problem based learning, brainstorming.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 PRC PRACTICE
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.25 +PRC * 0.25 + FIN * 0.50
5 RST RESIT
6 FCG FINAL COURSE GRADE MTE * 0.25 + PRC * 0.25 + RST * 0.50


Further Notes About Assessment Methods

None

Assessment Criteria

Meaningful learning of the basic concepts given in the courses, associating the concepts with each
other, establishing cause-effect relationships, interpreting and commenting on questions or
problems using their existing knowledge and evaluating the production of ideas will be realized by
midterm, final exam and prectice.
I. Midterm exam: 25%
II. Prectice Exam: 25%
III. Final exam: 50%
IV. Make-up exam

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Öğr. Gör. Ali Emir INCE
Aliemir.ince@deu.edu.tr

Office Hours

Weekdays, 09:00-17:00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 1 14
Tutorials 14 1 14
Preparations before/after weekly lectures 13 1 13
Preparation for midterm exam 1 3 3
Preparation for tutorial exam 1 5 5
Preparation for final exam 1 3 3
Midterm 1 1 1
Practical exam 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 55

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.155
LO.255
LO.355
LO.455
LO.555
LO.655

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