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.
Prerequisite(s)
-
Corequisite(s)
-
Special Requisite(s)
Entry level for computer usage
Entry level for MS Office tools
Instructor(s)
Assist. Prof. Dr. Gürsel Hacıbekiroğlu
Course Assistant(s)
-
Schedule
Friday, 14:00-16:50, Online
Office Hour(s)
Friday, 10:30-11:00, Basın Ekspres Campus, 8th Floor, Office Number: 06
Teaching Methods and Techniques
Teaching methods that depend on theoric explanation and practicing with computer application projects.
Principle Sources
• Presentation notes will be delivered during course.
• 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 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)
Overall review and examples of real life business problems by using MS Excel utilities – 1
Oral presentation, Laboratory
7. Week
Midterm Week (Not clear yet)
Oral presentation, Laboratory
8. Week
Midterm Week (Not clear yet)
Oral presentation, Laboratory
9. Week
Presentations
Oral presentation, Laboratory
10. Week
Presentations
Oral presentation, Laboratory
11. Week
Presentations
Oral presentation, Laboratory
12. Week
Presentations
Oral presentation, Laboratory
13. Week
Presentations
Oral presentation, Laboratory
14. Week
Presentations
Oral presentation, Laboratory
15. Week
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Homework / Term Projects / Presentations
1
40
Final Exam
1
60
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, behavioral 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 modeling and interpreting (critical thinking).
PO-6
Designs a business process in any functional stage that complies with identified objectives.
PO-7
Develop 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 a minimum of one foreign language.
PO-11
Acquires basic knowledge about sustainable business understanding, sustainable business functions, and the concept of sustainability.
PO-12
In line with the requirements of the digital age, they gain experience and knowledge to see and analyze the business as a whole, analyze market behavior, sales, and planning, budget management, financing, create a strategy, read competitor strategies, construct scenarios and performance evaluation skills through teamwork on a virtual simulation program.
PO-13
Having both basic computer usage knowledge and advanced Excel usage knowledge required by the business world for writing formulas, data analysis, modeling, and using macros.
PO-14
Acquires knowledge and skills about current information systems and how to use these systems in business problems.
PO-15
Gains the competence to use an ERP-based computer software in the field of accounting and to apply financial accounting transactions digitally on this software.
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
