To give the ability for using any kind of chart processing and presentation softwares for their academic or business life. Students will learn how the computers are used in business graphics program and the most important futures of excel processing and presentation softwares.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
None
Instructor(s)
Lecturer Erdem Yücesan, Lecturer Erdem Yücesan
Course Assistant(s)
None
Schedule
Monday, 09:00, İncirli Campus, Comp.Lab. 5B04
Office Hour(s)
Lec. Nahid Tekin, Monday, 13:00, İncirli Campus
Teaching Methods and Techniques
-Theoretical Teaching in classroom.
Applications by using computers in laboratory.
Problems are created and solved by using computer.
Compulsory homeworks from lecture notes.
Principle Sources
-Office, ingilizce sürüm, N.Tekin, M.Tekin, İstanbul Kültür Üniversitesi, 2011.
Other Sources
-Microsoft Excel 2010 In Depth by Bill Jelen (Jul 5, 2010)
Microsoft Excel 2010 Inside Out by Mark Dodge and Craig Stinson Douglas (Sep 2, 2010)
Microsoft Office 2010 In Depth by Joseph W. Habraken (Nov 10, 2010)
Microsoft Office Professional 2010 Step by Step (Step by Step (Microsoft)) by Joan Lambert III, Joyce Cox and Curtis Frye D. (Sep 10, 2010)
Course Schedules
Week
Contents
Learning Methods
1. Week
Charts
Lectures and application, Oral Presentation, Laboratory.
2. Week
Functions
Lectures and application, Oral Presentation, Laboratory.
3. Week
Sheets
Lectures and application, Oral Presentation, Laboratory.
4. Week
Chart tools
Lectures and application, Oral Presentation, Laboratory.
5. Week
Chart Tools, layout tabs; chart, axis title, legend, data labels, data tables, plot area.
Lectures and application, Oral Presentation, Laboratory.
Lectures and application, Oral Presentation, Laboratory.
8. Week
Chart Tools; design and format.
Lectures and application, Oral Presentation, Laboratory.
9. Week
Developer tabs; insert, form controls.
Lectures and application, Oral Presentation, Laboratory.
10. Week
Column, line, pie, bar, area, scatter and charts.
Lectures and application, Oral Presentation, Laboratory.
11. Week
Laboratory; charts.
Lectures and application, Oral Presentation, Laboratory.
12. Week
Macros
Lectures and application, Oral Presentation, Laboratory.
13. Week
Professional excel files
Lectures and application, Oral Presentation, Laboratory.
14. Week
Power point and excel
Lectures and application, Oral Presentation, Laboratory.
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
30
Quizzes
1
30
Final Exam
1
40
Program Outcomes
PO-1
To know the responsibility about the position of their job in the field of banks and insurance companies.
PO-2
To explain the importance of research and development issues of their related field by means of individual or group studies.
PO-3
To understand the importance of follow-up the legislation in the field of profession.
PO-4
To express the importance of the banking for national economy and businesses.
PO-5
To do work of their related field by using computer. Store information and using stored information.
PO-6
To take responsibility in the management levels.
PO-7
Finding practical solutions against the problems to business activities and giving the right decision.
PO-8
Assuming responsibility in finance and banking sector and after providing legal terms opened his/her own office on behalf of, train qualified manpower.
PO-9
Analysis and interpretation balance sheet and income statement of a business.
PO-10
To make Bank and insurance accounting.
PO-11
Equipped in terms of customer relations and human resources
PO-12
To receive general information in banking and insurance and be informed about the bank and insurance law.
PO-13
To know camputer programmes well about of the profession.
PO-14
To have knowledge about professional English in banking and insurance.
Learning Outcomes
LO-1
To be able to use MS excel processing tool for drawing objects, writing, formatting and creating tables.
LO-2
To be able to produce graphs on MS Excel software
LO-3
To be able to produce graphs on MS Excel software
LO-4
To be able to have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions.