Advanced applications of word processor and spreadsheets, introduction to office automation systems and their applications, introduction to their connection with database systems.
Application: Students will develop applications with Microsoft Excel (spreadsheet)
Helping students understand how they can make use of computer software during their academic and business life.
Be familiar with using spreadsheets to solve problems - including relative/absolute cell referencing, Boolean logic, reference functions and financial functions
Application: Students will develop applications with Microsoft Excel (spreadsheet)
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
Entry level for computer usage
Entry level for English
Entry level for MS Office tools
- Theoretical teaching in classroom
- Laboratory applications
- Teaching methods that depend on theoric explanation and practicing with computer application projects.
- Lectures work best (and are most fun) when they are highly interactive, so your participation is important and strongly encouraged. Remember that asking questions both in class and in office hours is a sign of engagement in the material and not an expression of weakness!
- There will be at least 3 pop-up quizzes during class hours. These will not be announced before, so it’s highly recommended to attend and participate in classes.
- During class hours, according to answering the questions, students can gain extra points, so it’s highly recommended to attend and participate in classes.
Principle Sources
- Presentation notes will be delivered during course.
- Students will be responsible from the entire official and unofficial (spoken during class hours) lecture notes. So, it’s highly recommended to attend and participate in classes-
- Lecture notes, slides, exercises and all the other announcements will be transmitted over CATS (You are all responsible for checking CATS folders of this course)-
- Any textbook for Microsoft Office 2013 applications.
Other Sources
- Text book : Yöneticiler İçin Bilgisayar Destekli Karar Modelleri: Excel İle Modelleme ve Çözüm Uygulamaları (H.Öner Esen, Published 1.1.2008,ISBN:9754360721)
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to Microsoft Excel
Oral presentation, Laboratory
2. Week
Building a Spreadsheet Model: Cell Addressing in Excel
Oral presentation, Laboratory
3. Week
Using Functions in Excel (Mathematical and Text Functions)
Oral presentation, Laboratory
4. Week
Microsoft Excel Charts
Oral presentation, Laboratory
5. Week
Effective Workbook Design for Large Problems
Oral presentation, Laboratory
6. Week
Microsoft Excel Logical Functions
Oral presentation, Laboratory
7. Week
IFs and Nested IFs in Excel
Oral presentation, Laboratory
8. Week
Microsoft Excel Reference Functions
Oral presentation, Laboratory
9. Week
Midterm Week (Subject to change)
Written Exam
10. Week
Microsoft Excel Financial Functions
Oral presentation, Laboratory
11. Week
Microsoft Excel Additional Problems
Oral presentation, Laboratory
12. Week
Overall review and examples of real life business problems by using MS Excel utilities – 1
Oral presentation, Laboratory
13. Week
Overall review and examples of real life business problems by using MS Excel utilities – 2
Oral presentation, Laboratory
14. Week
Overall review and examples of real life business problems by using MS Excel utilities – 3
Oral presentation, Laboratory
15. Week
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
30
Quizzes
3
20
Final Exam
1
50
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
At education and business life, to be able to explain importance of Microsoft Office applications and make use of them
LO-2
To be able to describe purpose and usage areas of spreadsheet programs
LO-3
To be able to use and construct spreadsheets on MS Excel software
LO-4
To be able to produce graphs on MS Excel software
LO-5
To be able to define formula with basic functions on MS Excel software
LO-6
To be able to filter data and get sub total reports on MS Excel software
LO-7
To be able to generate and comment on summary reports and pivot tables on MS Excel software
LO-8
To be able to validate data and to make data consolidation on MS Excel software
LO-9
To be able to import data from database application into MS Excel spreadsheets
LO-10
To be able to generate and comment on scenarios for supporting decision alternatives on MS Excel software
LO-11
To be able to model information systems for business functions by using MS Excel software