| TYPE OF COURSE UNIT | Elective Course |
| LEVEL OF COURSE UNIT | Bachelor's Degree |
| YEAR OF STUDY | - |
| SEMESTER | - |
| NUMBER OF ECTS CREDITS ALLOCATED | 5 |
| NAME OF LECTURER(S) | -
|
| LEARNING OUTCOMES OF THE COURSE UNIT |
At the end of this course, the students;
1) Identify the importance of ICT in business.
2) Distinguish between spreadsheets and databases.
3) Model a practical economic or business problem in a spreadsheet.
4) Develop a spreadsheet model for optimization and simulation.
5) Implement and query a small database
6) Present data analysis through a report
|
| MODE OF DELIVERY | Face to face |
| PRE-REQUISITES OF THE COURSE | No |
| RECOMMENDED OPTIONAL PROGRAMME COMPONENT | ECON217, ECON218 |
| COURSE DEFINITION | By teaching the basic concepts and methods of data analysis necessary for economists, to perform financial, statistical analysis and interpretation of data with Excel. To teach the reporting of these analyzes. |
| COURSE CONTENTS | | WEEK | TOPICS |
|---|
| 1st Week | Fundamental Concepts | | 2nd Week | A Brief Introduction to Spreadsheets | | 3rd Week | Excel Basics | | 4th Week | Excel Basics | | 5th Week | Making Table and Sorting | | 6th Week | Financial, Lookup and Statistical functions | | 7th Week | If functions | | 8th Week | Mid Term | | 9th Week | Pivot Table and Charts | | 10th Week | What if Analysis | | 11th Week | What if Analysis | | 12th Week | Solver | | 13th Week | Combining Excel and other soft wares | | 14th Week | Reporting and Desktop publishing |
|
| RECOMENDED OR REQUIRED READING | Excel 2016 Bible. ISBN:9781119067511. This book is a comprehensive reference work and also contains a lot of material on topics that are beyond the scope of this book. |
| PLANNED LEARNING ACTIVITIES AND TEACHING METHODS | Questions/Answers,Lecture,Discussion |
| ASSESSMENT METHODS AND CRITERIA | | | Quantity | Percentage(%) |
|---|
| Mid-term | 1 | 40 | | Assignment | 2 | 10 | | Attendance | 1 | 10 | | Total(%) | | 60 | | Contribution of In-term Studies to Overall Grade(%) | | 60 | | Contribution of Final Examination to Overall Grade(%) | | 40 | | Total(%) | | 100 |
|
| ECTS WORKLOAD |
| Activities |
Number |
Hours |
Workload |
| Midterm exam | 1 | 2 | 2 | | Preparation for Quiz | 3 | 1 | 3 | | Individual or group work | 14 | 3 | 42 | | Preparation for Final exam | 1 | 2 | 2 | | Course hours | 14 | 3 | 42 | | Preparation for Midterm exam | 1 | 60 | 60 | | Laboratory (including preparation) | 5 | 4 | 20 | | Final exam | 1 | 2 | 2 | | Homework | 1 | 55 | 55 | | Total Workload | | | 228 |
|---|
| Total Workload / 30 | | | 7,6 |
|---|
| ECTS Credits of the Course | | | 5 |
|---|
|
| LANGUAGE OF INSTRUCTION | Turkish |
| WORK PLACEMENT(S) | No |
| | |
