1 |
Course Title: |
OFFICE PROGRAMS AND ACCOUNT STATEMENTS |
2 |
Course Code: |
OSPS048 |
3 |
Type of Course: |
Compulsory |
4 |
Level of Course: |
Short Cycle |
5 |
Year of Study: |
1 |
6 |
Semester: |
2 |
7 |
ECTS Credits Allocated: |
3 |
8 |
Theoretical (hour/week): |
2 |
9 |
Practice (hour/week) : |
0 |
10 |
Laboratory (hour/week) : |
1 |
11 |
Prerequisites: |
None |
12 |
Recommended optional programme components: |
None |
13 |
Language: |
Turkish |
14 |
Mode of Delivery: |
Face to face |
15 |
Course Coordinator: |
Öğr.Gör. AKIN ÖLMEZ |
16 |
Course Lecturers: |
Meslek Yüksek okulları yönetim kurullarının görevlendirdiği öğretim elemanları. |
17 |
Contactinformation of the Course Coordinator: |
Öğr. Gör. Akın ÖLMEZ B.U.Ü. Orhaneli Meslek Yüksekokulu 0 (224) 294 26 86 - 62431 |
18 |
Website: |
|
19 |
Objective of the Course: |
To improve the ability of students to use office software (such as Word, Powerpoint and Excel), to ensure that they can use spreadsheets effectively in the field of Accounting and Tax Practice |
20 |
Contribution of the Course to Professional Development |
Will be able to realize the reporting requests needed in the professional field with the ability to use office software (such as Word, Powerpoint and Excel). |
Week |
Theoretical |
Practical |
1 |
Basic computer concepts |
Recognize Hardware, Software and User definitions and functions |
2 |
Operating Systems Concepts and Windows operating system |
Recognition of personal and multi-user operating systems other than MS, including GNU licensed ones, and knowledge of their functions |
3 |
Word processor (Ms Word) |
In MS Word program, opening, editing, formatting, etc. documents, using the standard toolbar and menus. |
4 |
Word processor (Ms Word) |
In MS Word program, find-and-replace, page layout, inserting pictures, tables, etc., working with columns, working with footers and headers, etc. |
5 |
Word processor (Ms Word) |
To make a magazine work using many functions in MS Word program |
6 |
Presentation Programs (MS Powerpoint) |
Using the Add New Slide, Delete, Duplicate and Standard Formatting Tools in MS Powerpoint program |
7 |
Presentation Programs (MS Powerpoint) |
Using Slide Design, Transitions, Animations in MS Powerpoint program |
8 |
Presentation Programs (MS Powerpoint) |
To prepare a timed rehearsed presentation on a selected topic using MS Powerpoint program and using the topics mentioned in the previous weeks |
9 |
Spreadsheets (Ms Excel) |
In MS Excel program, Row, Column, Cell concepts and standard formatting operations, preparing simple tables and arithmetic operators with 4 operations and percentage calculations |
10 |
Spreadsheets (Ms Excel) |
In MS Excel program, recognize the formula bar and functions and use simple functions on tables |
11 |
Spreadsheets (Ms Excel) |
Using sorting, filter, etc. features in MS Excel program, using functions in the data menu |
12 |
Spreadsheets (Ms Excel) |
In MS Excel program, perform operations between multiple sheets, create formatted tables and graphs |
13 |
Spreadsheets (Ms Excel) |
To make operations and calculations on the prepared Balance Sheet and Income Statement |
14 |
Spreadsheets (Ms Excel) |
Performing operations and calculations on other prepared financial statements |