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, access.
Prerequisite(s)
Corequisite(s)
Special Requisite(s)
Instructor(s)
Course Assistant(s)
Schedule
Office Hour(s)
Teaching Methods and Techniques
Principle Sources
Other Sources
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to Microsoft Excel. Tables, insert function; sum, average, charts.
Lectures and application, Oral Presentation.
2. Week
Functions; Count, Max, Min, Countif, if.
Lectures and application, Oral Presentation.
3. Week
PivotChart.
Lectures and application, Oral Presentation.
4. Week
Form controls; Group Box, Option Button, combo box, spin button.
Lectures and application, Oral Presentation.
5. Week
Contitional formating, Data Validation, $ operator.
Now, Option, Vlookup, Hlookup, Combo Box and applications.
Lectures and application, Oral Presentation.
12. Week
Access database. Objects, table, Form ve Report.
Lectures and application, Oral Presentation.
13. Week
Creating a data base. OLE Object, Text Object, Report. Queries.
Lectures and application, Oral Presentation.
14. Week
Work with multiple tables, queries, and create tables and Access application.
Lectures and application, Oral Presentation.
15. Week
Final
16. Week
Final
17. Week
Final
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
20
Final Exam
1
80
Program Outcomes
PO-1
To identify and use theoretical and practical knowledge in International Relations.
PO-2
To express ideas and assessments about contemporary debates in International Relations.
PO-3
To acknowledge ethical and scientific responsibilities of data collection, evaluation and publication.
PO-4
To monitor and interpret published studies in International Relations.
PO-5
To use a second language at an intermediate level.
PO-6
To analyze, compare and relate different local, regional and global developments in International Relations.
PO-7
To analyze, compare and relate International Relations with theories and practices of different associate departments and their sub-fields and to offer suggestions by combining these fields.
PO-8
To present substantial knowledge for various public, private and academic career positions.
PO-9
To analyze the emergence and functions of prominent regional and local actors and to make future projections about their actions.
PO-10
To theoretically and practically examine different events and facts in International Relations and Foreign Policy and to interpret their past, present, and future through a scientific perspective.
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 have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions.
LO-4
Excel; file, home, insert, page layout, formulas, data, review, developer ve view tabs, operations, functions, form controls.
LO-5
Work with multiple tables, queries, and create tables and Access application.