Course Name Code Semester T+U Hours Credit ECTS
Insan Kaynaklarinda Excel Uygulamalari IKY 427 7 2 + 0 2 5
Precondition Courses <p>No prerequisites</p> <p>However, attendance is compulsary (%70) and will be strictly monitored</p>
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator Dr.Öğr.Üyesi EMRULLAH TAN
Course Lecturers Dr.Öğr.Üyesi EMRULLAH TAN,
Course Assistants
Course Category Field Proper Education
Course Objective

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.

Course Content

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

# Course Learning Outcomes Teaching Methods Assessment Methods
1 To be able to create the graphs and charts that HR specialists use frequently Lecture, Homework,
2 To be able to classify and analyse raw data Drilland Practice, Project / Design,
3 To make concise and effective presentation skills with visual aids Group Study, Project / Design,
4 To be able cope with a huge amount of HR-related data Drilland Practice, Testing,
Week Course Topics Preliminary Preparation
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
Course Notes
Course Resources

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.

Treacy, M. (2018). My Online Training Hub.

Kumar, P. (2018). PK: AN EXCEL EXPERT. 

Order Program Outcomes Level of Contribution
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
Evaluation System
Semester Studies Contribution Rate
1. Performans Görevi (Uygulama) 10
2. Performans Görevi (Uygulama) 10
1. Ara Sınav 70
1. Kısa Sınav 10
Total 100
1. Final 50
1. Yıl İçinin Başarıya 50
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 2 32
Mid-terms 1 10 10
Project / Design 1 10 10
Quiz 1 5 5
Performance Task (Application) 2 10 20
Final examination 1 15 15
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Total Workload 124
Total Workload / 25 (Hours) 4.96
dersAKTSKredisi 5