Office Applications aims to teach students to use word processors, spreadsheets and presentation programs effectively and efficiently, and to help develop skills for both academic and professional endeavours.
-Gürkan, O. (2016). Microsoft Office 2016. Ankara: Nirvana Yayınları
Lambert, J. (2019). Microsoft Word 2019 Step by Step. Pearson Education
Yıldız, B. (2017). Office 2016 Türkçe (7. bs.). İstanbul: Kodlab Yayın Dağıtım
Gookin, D. (2019). Microsoft Word 2019 for Dummies. New Jersey: John Wiley & Sons
Milli Eğitim Bakanlığı (2020). OFİS UYGULAMALARI. Devlet Kitapları
Tutorials Point (2018). Pwerpoint 2010. Tutorials Point (I) Pvt. Ltd.
Andrea Philo, Angstadt (2020). MICROSOFT WORD 2016: STEP-BY-STEP GUIDE . MC-NPL Computer Lab
CustomGuide (2010). Microsoft Office Word 2010. CustomGuide, Inc.
CustomGuide (2010). Microsoft Office Excel 2010. CustomGuide, Inc.
Other Sources
-
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to Office Applications II
presentation, Computer Laboratory, Application
2. Week
Common features of Office Programs and automation
presentation, Computer Laboratory, Application
3. Week
Intro to functions, domain/codomain, input/output data types
presentation, Computer Laboratory, Application
4. Week
Excel functions, formulas, operators, data types
presentation, Computer Laboratory, Application
5. Week
A tour of Excel, examples of commonly used features
presentation, Computer Laboratory, Application
6. Week
Tables, Charts, Pivot Tables, Pivot Charts
presentation, Computer Laboratory, Application
7. Week
Sort, Filter, Conditional Formatting
presentation, Computer Laboratory, Application
8. Week
Data Processing
presentation, Computer Laboratory, Application
9. Week
Data Processing
presentation, Computer Laboratory, Application
10. Week
Data Validation, Function reference and Function Translator add-in
presentation, Computer Laboratory, Application
11. Week
Data lookup and references, Lookup, Index, Match family of functions
presentation, Computer Laboratory, Application
12. Week
Selected topics in Excel
presentation, Computer Laboratory, Application
13. Week
Selected topics in Excel
presentation, Computer Laboratory, Application
14. Week
Selected topics in Excel
presentation, Computer Laboratory, Application
15. Week
Final
Final
16. Week
Final
Final
17. Week
Final
Final
Assessments
Evaluation tools
Quantity
Weight(%)
Homework / Term Projects / Presentations
4
60
Final Exam
1
40
Program Outcomes
PO-1
Comprehends both theoretical and applied subjects in international trade at the advanced level, and uses his/her knowledge when necessary.
PO-2
Analyses basic concepts and data related to International Trade and Economics by scientific methods, interprets those with analytically, and evaluates those with regard to economic issues.
PO-3
Express his/her thoughts, comments and evaluations related to International Trade discipline both in written and oral forms.
PO-4
Defines current problems, and proposes solutions which are supported by evidence and research based quantitative and qualitative data.
PO-5
Inspects how public and private sector enterprises engaged in trade activities operates in practice, and evaluates the continuities and the dynamism in these sectors.
PO-6
Defines and tracks local, regional (such as European Union or Middle East) and global issues from the point of political economics, and relates these issues to each other.
PO-7
Possesses sufficient knowledge in other disciplines related to International Trade (such as Economics, Finance, International Business and Law), and reports this information.
PO-8
Follows publications and research in International Trade, Globalisation and Financial Systems in the English language, and communicates with his/her colleagues internationally.
PO-9
Uses a second language (Russian, Chinese, etc.) at the intermediate level.
PO-10
Possesses ethical principles and scientific values in collection, interpretation and release of data.
Learning Outcomes
LO-1
Can use the internet effectively/effectively
LO-2
Can use word processors effectively/effectively
LO-3
Can use presentation tools effectively/effectively