The aim of this course is to provide the students with the ability to make analyzes and to prepare and present reports in order to obtain meaningful and effective results from the data by using the advanced features of Excel in order to make a difference in business life.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
None
Instructor(s)
Dr. Gürsel Hacıbekiroğlu
Course Assistant(s)
None
Schedule
Monday 09:00 - 10:50; Monday 11:00-12:50
Office Hour(s)
m.ozer@iku.edu.tr
Teaching Methods and Techniques
Lecture (verbal and written), lab
Principle Sources
- Basic Excel Training Books.
Other Sources
- Excel Easy, www.excel-easy.com/
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to Microsoft Excel
Lecture, Lab
2. Week
Methods of Working with Data
Lecture, Lab
3. Week
Data analysis
Lecture, Lab
4. Week
Solver
Lecture, Lab
5. Week
Working with Tables
Lecture, Lab
6. Week
Data Visualization and Graphics
Lecture, Lab
7. Week
Working with Formulas
Lecture, Lab
8. Week
Midterm Exam Week
Assessment
9. Week
Midterm Exam Week
Assessment
10. Week
Modeling with Excel (Economics Models)
Lecture, Lab
11. Week
Modeling with Excel (Economics Models)
Lecture, Lab
12. Week
Modeling with Excel (Economics Models)
Lecture, Lab
13. Week
Modeling with Excel (Economics Models)
Lecture, Lab
14. Week
Modeling with Excel (Economics Models)
Lecture, Lab
15. Week
Final Exam
Assessment
16. Week
Final Exam
Assessment
17. Week
Final Exam
Assessment
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
50
Final Exam
1
50
Program Outcomes
PO-1
To 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-2
To discuss concepts and ideas in the field of Economics with scientific methods, to develop hypotheses, to interpret and evaluate the data obtained.
PO-3
To 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-4
To identify regional and global issues/problems, to perform analyses based on scientific data and research, and to develop solution suggestions.
PO-5
To 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-6
To 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-7
To 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-8
To 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-9
To 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-10
To 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-11
To 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-1
Students will be able to do the calculations quickly.
LO-2
Students will gain the necessary experience to be able to use the formula, data analysis tool.
LO-3
Students will be able to provide visual output with tools such as PivotTable and PivotChart.
LO-4
Students will learn how to model with Excel.
LO-5
Students will learn many examples of Excel data analysis tools that are already in use and make things easier.