• To provide students with knowledge about creating programs with Microsoft Office programs (Excel, Power Point, Word, Outlook), preparing presentations, writing in electronic environment, and mastering the e-mail culture.
• To inform students about how they can benefit from computers, spreadsheet software, word processing software, and presentation preparation software in school and business life.
• To touch on the development of computers, computer networks, information processing, CPU, memory, computer input/output and storage devices, software, operating systems, word processing programs.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
- Entry level computer usage qualification
- Entry level English
- Applications by using computers in laboratory
- Real business problems are created and solved by using computer
- Compulsory homeworks from lecture notes
Principle Sources
- Bilgisayar Kurs Kitabı, Arkadaş Yayınları, 2.BASKI
Other Sources
- Lecture Notes prepared by instructor
Course Schedules
Week
Contents
Learning Methods
1. Week
Interface-Sheet-Row-Cell
Formatting
Key Features
Table Structures
Oral presentation, Laboratory
2. Week
"Sort and Filter
Data Tools
Pivot Tables"
Oral presentation, Laboratory
3. Week
"Graphs
• Line Charts
• Pie Charts
• Column - Bar Charts
• Combo Charts"
Oral presentation, Laboratory
4. Week
"Introduction to Formulas
Functions
• SUM,AVERAGE,MIN,MAX
• IF,VLOOKUP,INDEX,MATCH"
Oral presentation, Laboratory
5. Week
Power Query 1
Oral presentation, Laboratory
6. Week
Power Query 2
Oral presentation, Laboratory
7. Week
Dashboard Development
Oral presentation, Laboratory
8. Week
Programming with Excel 1
Oral presentation, Laboratory
9. Week
Programming with Excel 2
Oral presentation, Laboratory
10. Week
Programming with Excel 3
Oral presentation, Laboratory
11. Week
Creating Slides
Oral presentation, Laboratory
12. Week
Advanced Slide Techniques
Oral presentation, Laboratory
13. Week
Learning MS Word
Oral presentation, Laboratory
14. Week
Mail Management with Outlook
Oral presentation, Laboratory
15. Week
Final Exam
Exam
16. Week
Final Exam
Exam
17. Week
Final Exam
Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
40
Homework / Term Projects / Presentations
1
0
Attendance / Participation
1
0
Final Exam
1
60
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 recognize basic hardware components of a computer and describe their functionallity
LO-2
- To be able to describe the difference between application softwares and system softwares
LO-3
- To describe Central Processing Unit (CPU) and computer Input/Output
LO-4
- To get general information about computer files, data storage, computer network, internet, software license, viruses, computer and healt
LO-5
- To be able to explain the importance of MS Office tools for academic and business life
LO-6
- To be able to use MS Word word processing tool for drawing objects, writing, formatting and creating tables.
LO-7
- To be able to have ability to use MS PowerPoint tool for creating and modifiying presentaions