Undergraduate
Faculty of Economic and Administrative Sciences
International Trade
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-1OP-1. Comprehends both theoretical and applied subjects in international trade at the advanced level, and uses his/her knowledge when necessary.
PO-2OP-2. Analyses basic concepts and data related to International Trade and Economics by scientific methods, interprets those with analytically, and evaluates those with regard to economic issues.
PO-3OP-3. Express his/her thoughts, comments and evaluations related to International Trade discipline both in written and oral forms.
PO-4OP-4. Defines current problems, and proposes solutions which are supported by evidence and research based quantitative and qualitative data.
PO-5OP-5. Inspects how public and private sector enterprises engaged in trade activities operates in practice, and evaluates the continuities and the dynamism in these sectors.
PO-6OP-6. Defines and tracks local, regional (such as European Union or Middle East) and global issues from the point of political economics, and relates these issues to each other.
PO-7OP-7. Possesses sufficient knowledge in other disciplines related to International Trade (such as Economics, Finance, International Business and Law), and reports this information.
PO-8OP-8. Follows publications and research in International Trade, Globalisation and Financial Systems in the English language, and communicates with his/her colleagues internationally.
PO-9OP-9. Uses a second language (Russian, Chinese, etc.) at the intermediate level.
PO-10OP-10. Possesses ethical principles and scientific values in collection, interpretation and release of data.
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