Associate Degree Programs
Vocational School of Bussiness Administration
Business Management
Anlık RSS Bilgilendirmesi İçin Tıklayınız.Düzenli bilgilendirme E-Postaları almak için listemize kaydolabilirsiniz.


COMPUTER APPLICATIONS

Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
ISY0679 COMPUTER APPLICATIONS 2/0/0 DE 2
Course Goals
The aim of this course is to teach students the basic knowledge of Excel and prepare content within the office.
Prerequisite(s) None
Corequisite(s) None
Special Requisite(s) None
Instructor(s) Lecturer Muharrem Altunışık
Course Assistant(s) None
Schedule The course has not been opened this semester
Office Hour(s) Tuesday, 10:30, İncirli 5. Kat B Kor. PC Lab. 4
Teaching Methods and Techniques Presentation and applications
Principle Sources Basic Excel Training Books
Other Sources Excel Easy, www.excel-easy.com/
Course Schedules
Week Contents Learning Methods
1. Week Introduction to Microsoft Excel. Presentation and applications
2. Week Cell Formatting Presentation and applications
3. Week Cell and Table Formatting Presentation and applications
4. Week Functions and Calculations Presentation and applications
5. Week Functions and Calculations Presentation and applications
6. Week Data Analysis Tools Presentation and applications
7. Week Data Analysis Tools Presentation and applications
8. Week PivotTable and PivotChart Presentation and applications
9. Week Midterm Exam Midterm Exam
10. Week Midterm Exam Midterm Exam
11. Week Appearance Features Presentation and applications
12. Week Workbook Control Presentation and applications
13. Week Macro Operations Presentation and applications
14. Week Macro Operations Presentation and applications
15. Week Final Exam Final Exam
16. Week Final Exam Final Exam
17. Week Final Exam Final Exam
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 50
Final Exam 1 50


Program Outcomes
PO-1PO 1. To have a basic knowledge in the field of Business Management
PO-2PO 2. To know organizational structure in the way of planning, organization, leadership and control mechanisms
PO-3PO 3. Recognizing human resources management and labor and social security legislations
PO-4PO 4. To be master in the legislations related to the business and take legal responsibility by taking basic legislations which shapes the regulatory framework of the business into account
PO-5PO 5. To take advantage of data collection techniques for problem solving and decision making
PO-6PO 6. To have a knowledge about basic methods used in accounting and business practices of these methods
PO-7PO 7. Identify the functions and implementations of marketing in business life, be able to conduct market research and use the marketing communication as required
PO-8PO 8. To have the knowledge about computers and relevant programs needed
PO-9PO 9. To be able to apply business processes and basic principles of project management techniques
PO-10PO 10. To have the ability of effective communication skills both orally and written
PO-11PO 11. To be able to make quality-oriented plans within business structure
PO-12PO 12. To be able to develop business analysis for targeting appropriate investments and follow-up
PO-13PO 13. To be able to take advantage of financial analysis techniques within business environment
PO-14PO 14. To be able to benefit from major numerical analysis methods and their implementations in business
PO-15PO 15. To follow the basic legislation related to the business and have a knowledge on basic law
PO-16PO 16. To have knowledge about Ataturk's Principles and Revolution History
PO-17PO 17. Recognize the basic principals and processes of production and sales management
PO-18PO 18. To have vocational knowledge of English in Business and Management
Learning Outcomes
LO-1Students will learn the basic four operations and the use of simple Excel formulas.
LO-2Students will obtain a visual result by learning graphic creation and editing at a basic level.
LO-3Students will learn table and cell formatting.
LO-4Students will learn how to move, copy and delete worksheets.
LO-5Students will learn mathematical, statistical, textual and logical functions.
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15PO 16PO 17PO 18
LO 1
LO 2
LO 3
LO 4
LO 5