TR EN

BİLGİSAYAR OFİS PROGRAMLARI COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
OPP210 BİLGİSAYAR OFİS PROGRAMLARI 3 2 2 4

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY

Week Preparatory Topics(Subjects) Method
1 - Computer Definition, History, Basic Features, Hardware and Software concepts -
2 - Introduction to Windows XP, File directory concept, Window properties, Creating a new folder, Cut-Copy-Paste, Shutting down the computer -
3 - Windows XP- Bilgisayarım, Geri dönüşüm kutusu, Kısayol oluşturma, Birlikte aç, Masaüstü özellikleri, Görev çubuğu, İletişim kutuları, Form elemanları, Başlat menüsü, Donatılar -
4 - Temel İnternet servisleri, İnternet tarayıcılar ve ayarları, Arama motorları -
5 - Temel İnternet servisleri, İnternet tarayıcılar ve ayarları, Arama motorları -
6 - MS Word MS Word screen, Toolbars and features, Save, Security options, Page Setup, Writing in Word, Font properties, Format painter, Paragraph properties, Tabs, Border and Shading, Columns, Bullets and numbering -
7 - MS Word Adding table and table toolbar, Adding drawing object, Templates, Autocorrect options, Paste special, Find-Replace-Go, Add thumbnail and picture, using picture toolbar -
8 - MID-TERM EXAM -
9 - MS Excel - Introduction to Excel, The Concept of Sheet and Cell, Cursor Types, Sheet Tabs, Cut-Copy-Paste, Row and Column Operations -
10 - MS Excel - Meeting Toolbars, Working with Files, Navigating the Worksheet -
11 - MS Excel - Operators, Formula Creation, Cell Formatting, Creating Drawing Objects, Graphics -
12 - MS Powerpoint - Create slide, Slide layout, Slide Design, Custom animation, add sound and start slide -
13 - MS Access and database basic concepts, Table Creation, Keys, relations -
14 - MS Access Data View Sheet, Form Creation, query creation -
15 - Creating and managing accounts with MS Outlook, e-mail transactions, creating and managing address book, Agenda management -
16 - FINAL EXAM -
17 - FINAL EXAM -