Undergraduate
Faculty of Economic and Administrative Sciences
Business Administration
Anlık RSS Bilgilendirmesi İçin Tıklayınız.Düzenli bilgilendirme E-Postaları almak için listemize kaydolabilirsiniz.


Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
//
Course Goals
The aim of this course is to teach students the data cleaning with Excel which is necessary for business skills.
Prerequisite(s)
Corequisite(s)
Special Requisite(s)
Instructor(s)
Course Assistant(s)
Schedule
Office Hour(s)
Teaching Methods and Techniques
Principle Sources
Other Sources
Course Schedules
Week Contents Learning Methods
1. Week Types of data quality problems Remote Education
2. Week Data profiling Remote Education
3. Week The benefits of tables Remote Education
4. Week Categorizing different data quality problems Remote Education
5. Week Exporting data from other files to excel Remote Education
6. Week Data cleaning tasks Remote Education
7. Week Removing non-printing characters, get rid of unnecessary spacing Remote Education
8. Week Midterm Exam Online Midterm Exam
9. Week Midterm Exam Online Midterm Exam
10. Week Conversion from text to number Remote Education
11. Week How to address missing data Remote Education
12. Week Find and replace, Spell check Remote Education
13. Week Getting rid of duplicates Remote Education
14. Week Exporting data from excel to other files Remote Education
15. Week Final Exam Online Final Exam
16. Week Final Exam Online Final Exam
17. Week Final Exam Online Final Exam
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 30
Homework / Term Projects / Presentations 1 10
Attendance 1 20
Final Exam 1 40


Program Outcomes
PO-1Demonstrates 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-2Applies mathematical, scientific, and social knowledge to business problems.
PO-3Demonstrates 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-4Determines how to use acquired theoretical and practical knowledge and skills related to business in application and field analysis and applies them.
PO-5Identifies and evaluates the relations in the field of business; describes the problems and presents analytical solutions through modeling and interpreting (critical thinking).
PO-6Designs a business process in any functional stage that complies with identified objectives.
PO-7Develop effective business communication skills (written-verbal/formal-informal).
PO-8Owns effective working skills individually or on a team in business and multidisciplinary fields.
PO-9Acts with a sense of professional and ethical responsibility.
PO-10Improves effective verbal and written communication skills in English, and acquires competence in a minimum of one foreign language.
PO-11Acquires basic knowledge about sustainable business understanding, sustainable business functions, and the concept of sustainability.
PO-12In 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-13Having 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-14Acquires knowledge and skills about current information systems and how to use these systems in business problems.
PO-15Gains 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-1Will be able to transfer data from different sources to Excel.
LO-2Learn the most common data problems that may occur during data transfer.
LO-3Learn the Excel tools used in data cleaning.
LO-4Will be able to transfer Excel files to other resources (systems).
LO-5Real life model finance and investment projects will be able to clear data.
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 
LO 1
LO 2
LO 3
LO 4
LO 5
LO 6
LO 7
LO 8
LO 9
LO 10
LO 11
LO 12
LO 13
LO 14
LO 15
LO 16
LO 17
LO 18
LO 19
LO 20
LO 21
LO 22
LO 23
LO 24
LO 25
LO 26
LO 27
LO 28
LO 29
LO 30
LO 31
LO 32
LO 33
LO 34
LO 35
LO 36
LO 37
LO 38
LO 39
LO 40
LO 41
LO 42
LO 43
LO 44
LO 45
LO 46
LO 47
LO 48
LO 49
LO 50