Ders Planı

ISTANBUL AYDIN UNIVERSITY

CLASS 2

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

The student possess knowledge of theory, approaches, models, legislation, human behavior, human rights, human behaviors and social environment, social problems related to social work discipline; social welfare policies and services; social work administration, professional ethics, principles and values, and information of the applied fields of social work
The student possess knowledge of research methodologies and techniques, as well as of information technologies and establishing effective communication
The student possess the basic practical knowledge to accomplish social work intervention at individual, group, organization, and societal levels, and for varied counselees who have different characteristics in terms of the global
The student possess skills to make observations and conduct professional interviews at each stage of the social work, of reporting and, establishing written and oral communication, using communication mediums effectively in the context of application
The student possess skills to conduct social work research, utilize the findings of already conducted research, of using information and other technologies, interpreting the professional literature, critical thinking, making analysis and synthesis
The student possess skills to fulfil administrative duties by using contemporary administrative information and techniques, to create common services with leadership, cooperation among institutions, social dialogue understanding
Along with the social work application at generalist level with client groups, they possess skills to accomplish the planned intervention process
They possess skills to conduct intervention by acknowledging the positive value of difference
By using his/her accumulated knowledge related to social work fields, s/he conducts social work intervention independently or as a team member, and takes responsibility, as well plans and manages events regarding the development of employees working under his/her authority/responsibility
S/he assesses the acquired information and skills related to his/her field with a critical approach; as well uses the competency to learn foreign languages, information and communication technologies and embraces the understanding of life-long learning by constituting a role model for the society with her/his skills, abilities, values and attitudes
S/he monitors the developments in the field of social work locally and globally, informs the related institutions and individuals regarding these developments, shares her/his thoughts and solution offerings with his/her colleagues and professionals from other fields by supplementing his/her views with quantitative and qualitative findings, and accordingly, designs projects with social responsibility
S/he determines the duties, authorities, rights and responsibilities related to social work profession, supports the development of the profession, and acts in accordance with legislation, professional ethics, norms and standards, accreditation management and administration processes
S/he uses the information and skills peculiar to social work with a right-based and social justice-centered approach, as well as the planned change process in the cliental system, within the framing of societal, scientific, cultural, professional, and environmental values, by taking on the responsibilities and necessities required by the social work intervention, in working with individuals, families, organizations and macro-level applications with 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	Pencere İşlemleri (Pencereler arası geçiş yapılması, pencereleri düzenleme,yeni pencere oluşturma , pencere gizleme, büyüklüğünü değiştirmek, pencereleri bölme işlemi
10	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)
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	Sıralama , Verileri Filtreleme , grafikler(grafik türleri,grafik hazırlama), Genel Tekrar

Resources

1- Computer Common Course Coord. Notes Determined by

EUA Kurumsal Öz değerlendirme Programı İzleme Raporu