Associate Degree Programs
Vocational School of Bussiness Administration
Business Management
Anlık RSS Bilgilendirmesi İçin Tıklayınız.Düzenli bilgilendirme E-Postaları almak için listemize kaydolabilirsiniz.


ADVANCED EXCEL

Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
ISY0584 ADVANCED EXCEL 1/1/0 DE 2
Course Goals
Course Objectives It is aimed that managers and employees who want to make a difference in business life will gain the skills to make analysis and prepare and present reports in order to obtain meaningful and effective results from the data by using Excel's advanced features.
Prerequisite(s) None
Corequisite(s) None
Special Requisite(s) None
Instructor(s) Lecturer Muharrem ALTUNIŞIK
Course Assistant(s) None
Schedule Thursday / 09.00-10.50 / Incirli Campus 5th Floor B Corridor 5B06 (İKLAB 5B06)
Office Hour(s) Thursday / 11.00-12.50 / Incirli Campus 1st Floor A Corridor Room No. 09 (1A09)
Teaching Methods and Techniques Presentation and applications.
Principle Sources Excel Training Books.
Other Sources Excel Education Web Sites.
Course Schedules
Week Contents Learning Methods
1. Week Introduction Presentation and application on computer
2. Week Logic Functions (IF - AND - OR) Presentation and application on computer
3. Week SUMIF - SUMIFS - COUNTIF Functions Presentation and application on computer
4. Week Mathematical Functions Presentation and application on computer
5. Week Find & Replace and VLOOKUP Functions Presentation and application on computer
6. Week Sorting and Filtering Presentation and application on computer
7. Week Midterm Exam Midterm Exam
8. Week Conditional formatting Presentation and application on computer
9. Week Visualizing Data and Graphs Presentation and application on computer
10. Week PivotTables and PivotChart Presentation and application on computer
11. Week Data Cleaning 1 Presentation and application on computer
12. Week Data Cleaning 2 Presentation and application on computer
13. Week Data Analysis 1 Presentation and application on computer
14. Week Data Analysis 2 Presentation and application on computer
15. Week Final Exam Final Exam
16. Week Final Exam Final Exam
17. Week Final Exam Final Exam
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 30
Homework / Term Projects / Presentations 1 20
Final Exam 1 50


Program Outcomes
PO-1PO 1. To have a basic knowledge in the field of Business Management
PO-2PO 2. To know organizational structure in the way of planning, organization, leadership and control mechanisms
PO-3PO 3. Recognizing human resources management and labor and social security legislations
PO-4PO 4. To be master in the legislations related to the business and take legal responsibility by taking basic legislations which shapes the regulatory framework of the business into account
PO-5PO 5. To take advantage of data collection techniques for problem solving and decision making
PO-6PO 6. To have a knowledge about basic methods used in accounting and business practices of these methods
PO-7PO 7. Identify the functions and implementations of marketing in business life, be able to conduct market research and use the marketing communication as required
PO-8PO 8. To have the knowledge about computers and relevant programs needed
PO-9PO 9. To be able to apply business processes and basic principles of project management techniques
PO-10PO 10. To have the ability of effective communication skills both orally and written
PO-11PO 11. To be able to make quality-oriented plans within business structure
PO-12PO 12. To be able to develop business analysis for targeting appropriate investments and follow-up
PO-13PO 13. To be able to take advantage of financial analysis techniques within business environment
PO-14PO 14. To be able to benefit from major numerical analysis methods and their implementations in business
PO-15PO 15. To follow the basic legislation related to the business and have a knowledge on basic law
PO-16PO 16. To have knowledge about Ataturk's Principles and Revolution History
PO-17PO 17. Recognize the basic principals and processes of production and sales management
PO-18PO 18. To have vocational knowledge of English in Business and Management
Learning Outcomes
LO-1Students completing this course successfully will be able to: Data
LO-2Students completing this course successfully will be able to: Data cleansing
LO-3Students completing this course successfully will be able to: Data analysis
LO-4Students completing this course successfully will be able to: Data visualization and graphs
LO-5Students completing this course successfully will be able to: Modeling with Excel
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15PO 16PO 17PO 18
LO 1
LO 2
LO 3
LO 4
LO 5