BNK 291 | Course Introduction and Application Information - Department of Banking and Insurance (Turkish)

Course Name

Data Analysis

Code	Semester	Theory (hour/week)	Application/Lab (hour/week)	Local Credits	ECTS
BNK 291	Fall	1	2	2	4

Prerequisites	None
Course Language
Course Type	Required
Course Level	Short Cycle
Mode of Delivery	-
Teaching Methods and Techniques of the Course	Case Study Application: Experiment / Laboratory / Workshop Lecture / Presentation
National Occupation Classification	-
Course Coordinator	Öğr. Gör. Dr. Gönül AYRANCI
Course Lecturer(s)	Öğr. Gör. Dr. Gönül AYRANCI
Assistant(s)	-

Course Objectives

This course aims to equip students with skills in data organization, analysis, visualization, and reporting using the MS Excel software effectively.

Learning Outcomes

The students who succeeded in this course;

Will be able to identify the usage areas of MS Excel in professional life.
Will be able to utilize functions and formulas in MS Excel.
Will be able to create charts and tables in MS Excel.
Will be able to select appropriate analysis methods based on data types and characteristics.
Will be able to enhance presentation and reporting skills with MS Excel.

Course Description

This course includes methods and tools to enable students to use MS Excel effectively, along with techniques for data analysis, data visualization, and reporting.

Course Category	Core Courses	X
	Major Area Courses
	Supportive Courses
	Media and Management Skills Courses
	Transferable Skill Courses

Week	Subjects	Related Preparation	Learning Outcome
1	Introduction and Basic Concepts: Fundamental usage and interface of Excel
2	Excel Data Entry and Editing, Data Types, and Formatting	https://support.microsoft.com/tr-tr/office/excel-video-e%C4%9Fitimi-9bc05390-e94c-46af-a5b3-d7c22f6990bb
3	Basic Formulas and Functions in Excel, Data Filtering, and Sorting	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 2, 31-49
4	Data Collection and Sampling Methods, Sample and Population, Parameters and Statistics, Frequency Distribution	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 2, 31-49, Bölüm 1, 21-29
5	Visualization of Data, Creating Charts with Excel	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 2, 31-49, Bölüm 4, 61-75
6	Calculation of Measures of Central Tendency (Mean, Median, Mode, etc.)	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 2, 31-49, Bölüm 5-6, 77-92
7	Calculation of Measures of Variability (Variance, Standard Deviation, Coefficient of Variation, etc.)	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 7, 31-49, Bölüm 5, 95-103
8	Midterm Exam
9	Data Classification, Histogram	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 9, 117-121, Bölüm 5, 95-103
10	Creating Summary Tables (Pivot Tables)	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 9, 117-121, Bölüm 12, 143-156
11	Reporting Techniques	İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802, Bölüm 18
12	Case Study in Excel
13	Student Presentations
14	Student Presentations
15	Semester Review
16	Final Exam

Course Notes/Textbooks

İltir, C. (2019). Excel ile İstatistiksel Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750254802

Suggested Readings/Materials

Books:

● Çilingirtürk, A. M. (2011). İstatistiksel Karar Almada Veri Analizi. Ankara: Seçkin Yayıncılık. ISBN: 9789750216107

● Çubukçu, F. (2021). Excel 365 ile Veri Analizi ve İş Uygulamaları. İstanbul: KODLAB Yayın Dağıtım Yazılım ve Eğitim Hizmetleri San. ve Tic. Ltd. Şti. ISBN: 978-625-7440-22-6

Data:

● https://data.tuik.gov.tr/

● https://www.tcmb.gov.tr/wps/wcm/connect/TR/TCMB+TR/Main+Menu/Istatistikler/Bankacilik+Verileri

● https://www.tsb.org.tr/tr/istatistik/genel-sigorta-verileri/prim-adet

● https://www.tusaf.org.tr/index.php/istatistikler/genel-sigorta-verileri.html

Microsoft Support Excel Video Training:

https://support.microsoft.com/tr-tr/office/excel-video-e%C4%9Fitimi-9bc05390-e94c-46af-a5b3-d7c22f6990bb

Semester Activities	Number	Weigthing
Participation
Laboratory / Application	1	20
Field Work
Quizzes / Studio Critiques
Portfolio
Homework / Assignments
Presentation / Jury
Project	1	30
Seminar / Workshop
Oral Exams
Midterm	1	20
Final Exam	1	30
Total

Weighting of Semester Activities on the Final Grade	3	70
Weighting of End-of-Semester Activities on the Final Grade	1	30
Total

Semester Activities	Number	Duration (Hours)	Workload
Theoretical Course Hours (Including exam week: 16 x total hours)	16	1	16
Laboratory / Application Hours (Including exam week: '.16.' x total hours)	16	2	32
Study Hours Out of Class	14	2	28
Field Work			0
Quizzes / Studio Critiques			0
Portfolio			0
Homework / Assignments			0
Presentation / Jury			0
Project	1	15	15
Seminar / Workshop			0
Oral Exam			0
Midterms	1	10	10
Final Exam	1	15	15
		Total	116

#	PC Sub	Program Competencies/Outcomes	* Contribution Level
#	PC Sub	Program Competencies/Outcomes	1	2	3	4	5
1	To be able to develop themselves in the subjects of obtaining the financial resources necessary for the activities of individuals and enterprises under the most favorable conditions and examining the use of the accumulated funds.		-	-	-	-	-
2	To be able to discuss the role, importance and functions of the institutions providing banking and insurance services in the economic system		-	-	-	-	-
3	To be able to evaluate the organizational structure, business processes, and service portfolios of banks, insurance companies, and other financial institutions operating in the sector.		-	-	-	-	-
4	To be able to develop skills in identifying, measuring, and assessing financial and operational risks, and to acquire fundamental knowledge to understand and apply insurance products against these risks.		-	-	X	-	-
5	To be able to recognize financial products offered in the banking and insurance sector, and to gain skills in effective marketing and sales, as well as managing long-term customer relationships.		-	-	-	-	-
6	To be able to possess basic legal knowledge and closely monitor legislative changes relevant to the field.		-	-	-	-	-
7	To be able to possess basic knowledge of accounting and analyze financial statements to evaluate the financial status of businesses.		-	-	-	-	-
8	To be able to follow technological innovations in the financial sector and acquire knowledge about the role of blockchain and artificial intelligence applications in the industry.		-	X	-	-	-
9	To be able to make decisions based on the principles of professional ethics, accountability and responsibility		-	-	-	-	-
10	To be able to follow international financial markets and global economic indicators by using English at least at the A2 level of the "European Language Portfolio"		-	-	-	-	-
11	To be able to analyze and interpret banking and insurance data, and to develop data-driven strategies for financial decision-making.		-	-	-	-	X
12	To be able to acquire knowledge about the components of national and international systems and the implementation of sector policies.		-	-	-	-	-
13	To be able to direct his/her education to a further level of education		-	-	-	-	-

BNK 291 | Course Introduction and Application Information

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

EVALUATION SYSTEM

ECTS / WORKLOAD TABLE

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

NEWSALL NEWS

NEW GÜZELBAHÇE CAMPUS

GLOBAL CAREER

CONTRIBUTION TO SCIENCE

VALUING PEOPLE

BENEFIT TO SOCIETY