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

Economics Main Page / Program Curriculum / Data Cleaning with Excel

Data Cleaning with Excel

Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
IIBF0104 Data Cleaning with Excel 2/0/0 DE Turkish 4
Course Goals
The aim of this course is to provide students with knowledge of data cleaning with Excel, which is necessary for business life.
Prerequisite(s) To have basic knowledge of Excel.
Corequisite(s) None
Special Requisite(s) None
Instructor(s) Professor Mehmet Özer
Course Assistant(s) Res. Asst. İsmail Ertek
Schedule Monday 17:00-18:50, Remote Education (via CATS)
Office Hour(s) m.ozer@iku.edu.tr i.ertek@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 Conversion from text to number Remote Education
9. Week Midterm Exam Week Assessment
10. Week Midterm Exam Week Assessment
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 Week Assessment
16. Week Final Exam Week Assessment
17. Week Final Exam Week Assessment
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 40
Homework / Term Projects / Presentations 2 20
Final Exam 1 40


Program Outcomes
PO-1To define his/her competencies using the theoretical and practical knowledge he/she acquired in the field of Economics and to use these competencies in practice.
PO-2To discuss concepts and ideas in the field of Economics with scientific methods, to develop hypotheses, to interpret and evaluate the data obtained.
PO-3To develop solution suggestions for complex and/or unpredictable problems encountered in practice, to report and present these suggestions in accordance with the academic publication rules.
PO-4To identify regional and global issues/problems, to perform analyses based on scientific data and research, and to develop solution suggestions.
PO-5To determine the learning needs in the field of Economics, to evaluate the acquired knowledge and skills with a critical approach, and to use this knowledge and skills to develop economic policies.
PO-6To inform relevant people and institutions on issues related to the field of Economics and to gain the ability to convey written and verbal solutions to problems.
PO-7To convey his/her thoughts and suggestions in the field of Economics to experts and non-experts by supporting them with quantitative and qualitative data, to discuss and to contribute to the development of new policies by revising suggestions according to the feedback he/she receives.
PO-8To benefit from other disciplines that form the basis of the field of Economics, to develop multidisciplinary approaches by associating these disciplines with his/her knowledge in the field of Economics, to produce project and publications.
PO-9To define the differences and relationships between classical and modern theories of economics and to observe the distinctions between classical and modern economic policies and to evaluate the compatibility of these policies with economic and social issues.
PO-10To read and comprehend foreing news sources about economics being fluent in a foreign language, to scan the economic literature and to follow the most current approaches in this field.
PO-11To take into account scientific and ethical values in the stages of collecting, interpreting and announcing economic data and carrying out statistical/econometric studies using these data, and also to carry out the publication process in accordance with academic publishing principles.
Learning Outcomes
LO-1To transfer data from different sources to Excel.
LO-2To understand the most common data problems that may occur during data transfer.
LO-3To recognize the Excel tools used in data cleaning.
LO-4To transfer Excel files to other resources (systems).
LO-5To gain the ability to clean up real-life financial and investment project data.
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11
LO 1
LO 2
LO 3
LO 4
LO 5