Ders Planı

CLASS 1

CLASS 2

CLASS 3

CLASS 4

Lesson plan /

Lesson Information

Course Credit
Course ECTS Credit
Teaching Language of Instruction	Türkçe
Level of Course	Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course
Mode of Delivery	Face-to-face
Does the course require compulsory or optional work experience?
Course Coordinator
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course	Advanced use of Excel, working with formulas and using them where necessary, creating tables and graphs
Course Content	Advanced use of MS Excel

Learning Outcomes

Having theoretical and practical knowledge about economics, business administration, accounting, law, finance, finance and management science sufficient to comprehend, evaluate and direct the functioning of the health system.
To have knowledge about interpreting the components of national and international health systems and health policies.
To know the sub-departments of health system organization and the employees in these departments, to have knowledge about the duties, authorities and responsibilities of the employees.
To have knowledge about social, environmental and behavioral factors that are related to the improvement of community and individual health.
To improve his knowledge and skills in the management of health institutions, management, production, human resources, finance, accounting, marketing, patient and public relations, quality and patient safety, occupational health and safety, information technologies, health insurance, etc. To gain application skills in their fields.
Gaining the ability to use scientific methods and techniques in critical and creative thinking, decision-making and problem-solving in problems arising in the process of health care management.
To gain the ability to analyze, evaluate and interpret data related to the field of health management.
Developing strategies and suggestions on the management of health institutions and services.
Multi-faceted examination and evaluation of developments related to the management of healthcare institutions using scientific methods and techniques.
To show leadership and leadership characteristics in line with the goals of the institution by evaluating the personality, culture and behavioral characteristics of employees in health institutions.
Demonstrate the ability to take responsibility individually and as a team member to solve problems encountered in healthcare management practices.
On the basis of lifelong learning philosophy, to gain the ability to constantly renew oneself by determining learning needs, to follow current developments in science and technology in multidisciplinary and interdisciplinary fields.
To acquire a foreign language that will follow the basic and professional developments in the field.
To have the competence of using the correct and proper grammar and terminology used in health institutions in written and verbal communication.
Sharing their thoughts and solution suggestions on issues related to the management of health institutions in written and verbal form with the relevant parties inside and outside the institution.
To gain the ability to use information and communication technologies, equipment such as photography and video in professional field, media and social media for the purpose and desired result.
To gain the awareness of social responsibility and to be able to demonstrate their knowledge on this subject with practice in the field.
Reflecting the management philosophy and management functions in management practices in accordance with each unit.
As an individual, his appearance is an example to the institution with his positive attitude and behavior; being open to continuous improvement and change.
To be sensitive to general health problems in the country or the world, to interpret and evaluate solutions.
To act in accordance with the legal regulations related to the field and social, scientific and professional ethical principles.
Gaining the ability to conduct multidisciplinary teamwork effectively, efficiently and in line with ethical principles.
The ability to use health resources correctly by increasing the health literacy level of the society.

Weekly Course Subjects

1	Excel Overview (Workbook, Worksheet, Cells, Toolbars)
2	Selection Operations (Selection of a single cell, multiple cells, non-consecutive cells, rows and columns), Data Entry (Data entry into a single cell, multiple cells, creating data arrays)
3	Working on Data (Correcting, deleting data, undoing operations, copying and moving cells, moving with the mouse. Adding and deleting cells, adding and deleting rows, adding and deleting columns), Row and Column Formatting (Setting row height and column width )
4	Working on Data (Correcting, deleting data, undoing operations, copying and moving cells, moving with the mouse. Adding and deleting cells, adding and deleting rows, adding and deleting columns), Row and Column Formatting (Setting row height and column width )
5	Formatting Cells (Formatting text, adding borders to cells, adding patterns, formatting cells, adding borders and patterns with toolbars, aligning data in cells, formatting numbers, formatting date and time, automatic formatting
6	Formatting Cells (Formatting text, adding borders to cells, adding patterns, formatting cells, adding borders and patterns with toolbars, aligning data in cells, formatting numbers, formatting date and time, automatic formatting
7	Worksheets (changing the active worksheet, adding and removing new pages, naming and selecting pages, copying or moving, hiding pages) Filing Operations (save, save as, open, new, close, page structure, print area determination, print preview, printing worksheets, closing excel)
8	Worksheets (changing the active worksheet, adding and removing new pages, naming and selecting pages, copying or moving, hiding pages) Filing Operations (save, save as, open, new, close, page structure, print area determination, print preview, printing worksheets, closing excel)
9	Window Operations (Switching between windows, arranging windows, creating a new window, hiding a window, changing its size, splitting windows)
10	Window Operations (Switching between windows, editing windows, Formula Operations on Tables (Arithmetic operation operators, formula entries and corrections, using cell names in formulas, calculating the sum of rows and columns, copying formulas), creating a new window, hiding a window, resizing, resizing windows division
11	Formula Operations on Tables (Arithmetic operation operators, formula entries and corrections, using cell names in formulas, calculating the sum of rows and columns, copying formulas)
12	Ready-made Functions (add, product, round, round down, round up, even, odd, integer, absolute, square root, average, min, max, big, small and , or, if, if, count, search, date and time functions,
13	Ready-made Functions (add, product, round, round down, round up, even, odd, integer, absolute, square root, average, min, max, big, small and , or, if, if, count, search, date and time functions,
14	Sorting, Filtering Data, charts (chart types, chart preparation), General Repetition

Resources

1-Grades Determined by the Computer Joint Course Coordinatorship

CLASS 1

CLASS 2

CLASS 3

CLASS 4

Lesson Information

Purpose and Content

Learning Outcomes

Weekly Course Subjects

Resources

ABOUT IAU

COMMITTEE

PUBLICATIONS

MEDIA CENTER