Undergraduate
Faculty of Economic and Administrative Sciences
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
IIBF0104 2/0/0 DE 4
Course Goals
The aim of this course is to teach students the data cleaning with Excel which is necessary for business skills.
Prerequisite(s) To have basic knowledge of Excel.
Corequisite(s) None
Special Requisite(s) None
Instructor(s) Professor Mehmet Özer
Course Assistant(s) None
Schedule This course was not opened in the 2022-2023 academic year...
Office Hour(s) m.ozer@iku.edu.tr
Teaching Methods and Techniques - Remote Education
Principle Sources - Lecture notes 

- Chris Rafter, Guide to Cleaning Data with Excel and Google Sheets, DSM Media, 2019
Other Sources - Advanced Excel and Data Analysis Books.
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-1Define the concept and types of entrepreneurship in historical development within the framework of entrepreneurship theory.
PO-2Develop awareness about ways to improve personal and corporate innovation and creativity
PO-3Distinguish the different aspects of SME management and its problems from SME management and its problems
PO-4Design a business plan to start a new business
PO-5Assess the institutionalization process of newly established businesses
PO-6Employ the information and skill that is related to entrepreneurship in the career life and apply it to the workplace environment.
PO-7Explain new business in social environment with social capital and communication competence
PO-8Interpret knowledge of innovation and the importance of innovation that learned during education life with up-to-date information and adopt it to business life
PO-9Identify how to reach entrepreneurship supports thanks to the basic and up-to-date information gained on entrepreneurship and estimates about the change and paradigm shifts in the entrepreneurship ecosystem.
PO-10Compose the conceptual and cognitive knowledge with expert knowledge required by business life
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
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10
LO 1
LO 2
LO 3
LO 4
LO 5