Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
? IKY 427 7 2 + 0 2 5
Ön Koşul Dersleri

No prerequisites

However, attendance is compulsary (%70) and will be strictly monitored

Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü SECMELI
Dersin Koordinatörü Dr.Öğr.Üyesi EMRULLAH TAN
Dersi Verenler Dr.Öğr.Üyesi EMRULLAH TAN
Dersin Yardımcıları
Dersin Kategorisi Alanına Uygun Öğretim
Dersin Amacı

This module has two main goals: generic (employability-related) and specific (HRM-related).

In respect to the generic employability-related goal, it has three main objectives. First, to equip students with the ability to classify and analyze information effectively. Secondly, to make sure that students have the sufficient presentation skills to get their message across efficiently by visual aids such as graphs and tables, which will be quite helpful to them in almost every phase of their academic and business careers. Finally, after graduation, Sakarya HRM graduates with their strong applied HR background will be equipped with invaluable marketable skills that will distinguish them from other univesities’ HRM graduates.  As a result of their Excel proficiency, they will gain a competitive advantage in the labor market.

In terms of HRM, the following reasons can be suggested. Excel is a software package that is often used by business analysts.  Likewise, in order to be a good HR analyst, a person should know how  to process information effectively.  In this regard, having an advanced Excel  skill will give students the ability to correctly analyse HR issues and provide solutions to them. With this module, students will have the opportunity to  use HR metrics, to create  employee reports and dashboard.  Thus, students will have the opportunity to learn how to analyze a company's HR data and how to report and present them  in a clear and concise way.

Dersin İçeriği

Excel intro;graphs; conditional formatting, if, sum if functions;pivot tables;HR Dashboard;KPI;HR metrics; userform

Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 - To be able to create the graphs and charts that HR specialists use frequently 1 - C -
2 - To be able to classify and analyse raw data 4 - D -
3 - To make concise and effective presentation skills with visual aids 8 - D -
4 - To be able cope with a huge amount of HR-related data 4 - A -
Öğretim Yöntemleri: 1:Lecture 4:Drilland Practice 8:Group Study
Ölçme Yöntemleri: C:Homework D:Project / Design A:Testing

Ders Akışı

Hafta Konular ÖnHazırlık
1 Excel intro Lecture notes
2 Various kinds of graphs designs Lecture notes
3 Conditional formatting Lecture notes
4 Excel functions: If functions Lecture notes
5 Vlookup and Hlookup Lecture notes
6 Pivot tables 1 Lecture notes
7 Pivot tables 2 Lecture notes
8 Mid-term exam
9 Constructing HR dashboard Lecture notes
10 Dates and time in Excel Lecture notes
11 Text functions in Excel Lecture notes
12 Userforms: Basic tools Lecture notes
13 Userforms: Building an exit survey Lecture notes
14 The use of google spreadsheet and a cloud-based shared team project Lecture notes


Ders Notu
Ders Kaynakları

Alexander, M. (2013). Excel Dashboards and Reports. New Jersey: John Wiley

Walkenbach, J. (2015). Excel 2016 Bible. USA: John Wiley & Sons

Harvey,G. (2017) Excel 2016: All-in-One For Dummies. UK: For Dummies

Walkenbach, J. (2014). Excel 2013 Power Programming with VBA. USA: John Wiley & Sons

Easton, T. (2018). Online PC learning. http://www.onlinepclearning.com

Treacy, M. (2018). My Online Training Hub. https://www.myonlinetraininghub.com/blog

Kumar, P. (2018). PK: AN EXCEL EXPERT. www.pk-anexcelexpert.com/ 

Döküman Paylaşımı

Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çıktıları KatkıDüzeyi
1 2 3 4 5
1 Having adequte scientific knowledge of Human Resources Management, basic business concepts and other social sciences
2 Thinking critically and analytically X
3 Having knowledge of communication and information technologies X
4 In-depth understanding of the research process and application of a range of research techniques into studies, researches and projects
5 In-depth understanding of usage of Human Resources Management and other social sciences theoretical and applied knowledge together.
6 Ability to interpret basic Business concepts from Human Resource Management perspective
7 Ability to implement basic HRM responsibilities in institutions such as HR Planning and staffing, labor relations, occupational healthy and safety, training planning, performance and rewards management, career planning, employment and interview techniques and legal HR issues
8 Implementing quality process approach into HRM process by considering institutional development, internal and external customer satisfaction; in case of need, having sense of responsibility making contribution for problem solving and continuous development and process excellence ability by problem identification, goal setting, reorganisation and change management skills
9 Management of resources and assets by considering budgetary, financial and legal issues; management of projects/operations with the ability of planning, implementation, and auditing; Having skills on management of self and other people
10 Enriching result oriented working approach with continous learning approach
11 Strong oral and written communication skills and ability to present ideas and information effectively X
12 Being good at one foreign language, ability to communicate written and orally
13 Ability to work with people of various cultural and educational background by valuing team work, developing emphathy and listening skills X
14 Being conscious on social, academic and professional ethical values
15 Development of critical theoretical appreciation of ´how´, ´why´ and ´where´ HRM contributes to and supports employee and societal development, and implementing these approach for applied and graduate projects and working life

Değerlendirme Sistemi

PerformansGoreviUygulama 1 15
PerformansGoreviUygulama 2 15
AraSinav 1 60
KisaSinav 1 10
Toplam 100
Yıliçinin Başarıya Oranı 50
Finalin Başarıya Oranı 50
Toplam 100

AKTS - İş Yükü

Etkinlik Sayısı Süresi(Saat) Toplam İş yükü(Saat)
Course Duration (Including the exam week: 16x Total course hours) 16 2 32
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 10 10
Quiz 1 5 5
Project / Design 1 10 10
Performance Task (Application) 2 10 20
Final examination 1 15 15
Toplam İş Yükü 124
Toplam İş Yükü /25(s) 4.96
Dersin AKTS Kredisi 4.96
; ;