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
Instructor(s)
Assist. Prof. Dr. Onur YONTAR
Course Assistant(s)
Schedule
Tuesday, 13:00-16:50, Basın Ekspres Lounge PC Lab
Office Hour(s)
Barış Safran, Wednesday, İncirli, 3A04
Teaching Methods and Techniques
- 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
40
Attendance
1
10
Final Exam
1
50
Program Outcomes
PO-1
Demonstrates a basic level of understanding in related disciplines (such as economics, sociology, psychology, quantitative sciences, etc.) that form a foundation for business administration, and makes use of and applies them to the field of business.
PO-2
Applies mathematical, scientific and social knowledge to business problems.
PO-3
Demonstrates a basic level of understanding in business functions and management (such as management, production, marketing, accounting, finance, human resources, behavioural sciences, etc.) and interprets the theoretical arguments focusing on interactions between the actors and the cultures in the field.
PO-4
Determines how to use acquired theoretical and practical knowledge and skills related to business in application and field analysis and applies them.
PO-5
Identifies and evaluates the relations in the field of business; describes the problems and presents analytical solutions through modelling and interpreting (critical thinking).
PO-6
Designs a business process in any functional stage that complies with identified objectives.
PO-7
Develops effective business communication skills (written-verbal/formal-informal).
PO-8
Owns effective working skills individually or on a team in business and multidisciplinary fields.
PO-9
Acts with a sense of professional and ethical responsibility.
PO-10
Improves effective verbal and written communication skills in English, and acquires competence in minimum one foreign language.
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
