|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction to Microsoft Excel
|
R1-Part 4
|
|
2
|
Selection operations, column operations, row operations, page operations
|
R1-Part 4
|
|
3
|
Data entry in cell, cell formatting, alignments, font, border, automatic cell format
|
R1-Part 4
|
|
4
|
Series and autofill, formula creation, formula copy, absolute cell addresses, using cell names from formulas
|
R1-Part 4
|
|
5
|
Using preset functions
|
R1-Part 4
|
|
6
|
Functions (sum, average, max, min, median, standard deviation, count_filled, If, If, If nested)
|
R1-Part 4
|
|
7
|
Add comment to cell, conditional formatting, sort data, filter data, create graphics
|
R1-Part 4
|
|
8
|
PowerPoint Introduction
|
R1-Part 5
|
|
9
|
Parts of the PowerPoint Window
|
R1-Part 5
|
|
10
|
Presentation Views
|
R1-Part 5
|
|
11
|
Using the automated content wizard
|
R1-Part 5
|
|
12
|
Creating a new presentation - using the drawing toolbar - adding icons to a slide, adding pictures, adding tables
|
R1-Part 5
|
|
13
|
Add graphics to slide, add animation and custom animations, slide design
|
R1-Part 5
|
|
14
|
Presentation applications
|
R1-Part 5
|
|
Prerequisites
|
-
|
|
Language of Instruction
|
Turkish
|
|
Responsible
|
Lecturer Şerife SALMAN
|
|
Instructors
|
-
|
|
Assistants
|
-
|
|
Resources
|
R1. Sökmen, A., Gündüz, O. (2008). Uygulumalı Örneklerle Bilgisayar Kullanımı. Ankara: Detay Yayıncılık.
|
|
Supplementary Book
|
SR1. Pala, Z. (2008a). Microsoft Office Excel 2007. İstanbul: Kitap Store.
|
|
Goals
|
The aim of this course; To understand presentation techniques, to prepare presentations, to prepare presentations, to prepare promotional materials, to make calculations in accounting programs, to create tables, to work with formulas,
|
|
Content
|
Basic concepts in Excel, data entry in excel, working with pages, making calculations, creating tables in excel, formatting tables in excel, working with graphics, using formulas, making advanced calculations with formulas, basic concepts of presentation program, preparing presentations, working with slides, making slide design, adding animation , adding visual content, working with custom animations, editing timed presentations
|
|
Program Learning Outcomes |
Level of Contribution |
|
1
|
Have good knowledge of Turkish language usage. Reads, understands, prepares and presents Turkish official and technical documents.
|
3
|
|
2
|
Use foreign language correctly. Reads and understands the technical documents written in a foreign language required by his / her professional field and establishes written and oral communication using the foreign language required by his / her field.
|
-
|
|
3
|
Uses office technologies and computer programs effectively for different purposes.
|
5
|
|
4
|
Republic of Turkey wins accurate information about the history and the Kemalist thought; Thinks in line with Atatürk`s principles and revolutions.
|
-
|
|
5
|
Makes the basic mathematical and scientific calculations required by the professional field.
|
2
|
|
6
|
Uses the ability to communicate effectively with the manager, employees and the environment.
|
2
|
|
7
|
Do the correspondence of the office and the manager.
|
5
|
|
8
|
Performs the filing system according to the technique.
|
-
|
|
9
|
Be polite in making appointments and accepting visitors.
|
-
|
|
10
|
Knows the rules of protocol to be followed in his office and applies them.
|
-
|
|
11
|
Assists the manager in the management and organization of the office.
|
-
|
|
12
|
Recognize the basic concepts and documents related to accounting.
|
-
|
|
13
|
Acts in accordance with total quality understanding, makes teamwork.
|
-
|
|
14
|
Learn the basic concepts of law, have basic knowledge of law.
|
-
|
|
15
|
Learns the basic concepts of business management.
|
3
|