This course provides an overview of the Excel functions mostly used by daily routines of management departments such as data management, project evaluation, workforce planning, customer loyalty and retention analysis, demand forecast, inventory management etc.
This course focus on cell formatting, worksheet formatting, conditional formatting, graphics, functions, pivot table, solver applications, histogram – Pareto Analysis, regression analysis, demand forecast applications, inventory management, production management, finance, marketing, and human resources management applications.
Vertical Tabs
Course Learning Outcomes
Learning Outcomes | Program Learning Outcomes | Teaching Methods | Assessment Methods |
Formats Excel cells, and worksheets. | 2 | 1, 2, 3 | A,B,C |
Use Excel functions important in daily business life. | 3,7 | 1, 2, 3 | A,B,C |
Analyze and report using Excel functions. | 4,12 | 1, 2, 3 | A,B,C |
Visualize the analysis and reports using Excel graphics. | 2 | 1, 2, 3 | A,B,C |
Solve different business function problems through Excel applications. | 6,8 | 1, 2, 3 | A,B,C |
Course Flow
Week |
Topics |
Study Materials |
1 |
Cell formatting |
--- |
2 |
Worksheet formatting |
Textbook |
3 |
Conditional formatting |
Textbook |
4 |
Graphics |
Textbook |
5 |
Functions |
Textbook |
6 |
Pivot table |
Textbook |
7 |
Solver applications |
Textbook |
8 |
Histogram – Pareto Analysis, Regression Analysis |
Textbook |
9 |
Demand forecast applications |
Textbook |
10 |
Inventory management applications |
Textbook |
11 |
Production management applications |
Textbook |
12 |
Finance applications |
Textbook |
13 |
Marketing applications |
Textbook |
14 |
Human resources management applications |
--- |
15 |
Revision |
--- |
16 |
Final Exam |
--- |
Recommended Sources
Textbook |
Wissenschaftlich mit Excel arbeiten, Tobias Ravens, 2. Auflage, Pearson Studium, 2004 |
Additional Resources |
Marktforschung und Datenanalyse mit Excel, Gerhard Reiter – Wolf-Gert Matthaeus, Oldenburg, 2000. |
Material Sharing
Documents |
Applications |
Assignments |
|
Exams |
Assessment
IN-TERM STUDIES |
NUMBER |
PERCENTAGE |
Mid-terms |
1 |
50 |
Quizzes |
- |
|
Assignment |
5 |
50 |
Total |
100 |
|
Contribution of final examination to overall grade |
40 |
|
Contribution of in-term studies to overall grade |
60 |
|
Total |
100 |
COURSE CATEGORY |
Expertise/Field Courses |
Course’s Contribution to Program
No |
Program Learning Outcomes |
Contribution |
||||
1 |
2 |
3 |
4 |
5 |
||
1 |
Students should be able to use basic knowledge of International Business Management theoretically and practically for identification, modeling and solving of problems for businesses operating on a global scale. |
X |
||||
2 |
Students should possess the essential body of knowledge related to International Business Management including the state-of-the art concepts, theories and models, historical evolution of that discipline, the scientific methodology in general, and the research tools and techniques utilized in that discipline, in particular. |
X |
||||
3 |
Students should understand the core competences of juridical, political, social, and economic psychological dimensions related to International Business Management. |
X |
||||
4 |
Students should be able to conduct independent research in their discipline by specifying information needs for investigating a topic-of interest, accessing the appropriate sources of knowledge, and preparing a comprehensive report. |
X |
||||
5 |
Students should understand the interdependency and interrelationship among disciplines should be able to relate and synthesize International Business Management knowledge with diverse disciplines, and generate new information accordingly. |
X |
||||
6 |
Students should be able to fulfill their responsibility as team leader or team member in project implementations or applied studies that are related to International Business Management. |
X |
||||
7 |
Students should be able to design and plan projects to achieve organizational goals and objectives setted or to improve organizational performance. |
X |
||||
8 |
Students should be able to critically evaluate the knowledge in the area of International Business Management, assess self-competency and direct self-learning efforts accordingly. |
X |
||||
9 |
Students should understand the importance of life-long learning and self-assessment to maintain their personal and professional development. |
X |
||||
10 |
By rapidly changing global circumstances, students should be able to show that they understand the importance of flexibility in thinking and generating creative solutions in order to succeed in professional life. |
X |
||||
11 |
Students should be able to effectively communicate in written and oral German on a corporate level with people from diverse backgrounds. |
|
|
X |
|
|
12 |
Students should have the German proficiency to be able to follow and interpret the global dynamics that shape their discipline. |
|
|
X |
|
|
13 |
Students should indicate, express and present their knowledge in in national/international interdisciplinary academic and professional settings, should offer and make comments about the results of the works to other people from not only their field, but also from any other disciplines by clearly expressing in Turkish and German via using right data. |
|
|
|
X |
|
14 |
Students should evaluate the differences between cultures and individuals by being aware of importance of respect for individual and cultural diversity, should be able to emphatically interact with individuals from diverse cultural backgrounds in social and professional settings and should contribute to the team works as a team coordinator or a team member. |
X |
|
|
|
|
15 |
Students should use effectively widespread and valid information technologies in their field. |
|
|
|
|
X |
16 |
Students should understand personal, professional and social ethics, should evaluate the ethical implications of various practices related to social and professional life, should be aware of the importance how these ethical behavior add value to the society. |
X |
|
|
|
|
17 |
Students should know the concept of social responsibility on individual, social and ecological dimensions should indicate active citizenship for him-/herself within that frame. |
X |
|
|
|
|
18 |
Students should grasp the importance of the scientific point of view for social development and global competitiveness as well as social rights and social justice, which are the basis of modern societies. |
X |
|
|
|
|
19 |
Students should grasp the importance of quality management, health and safety, corporate social responsibility, professional and cultural respect and principles of corporate ethics for corporate sustainability. |
X |
|
|
|
|
20 |
Students should evaluate the contribution of basic business solutions to management and financial problems within a global and social framework. |
|
|
|
X |
|
ECTS
Activities |
Quantity |
Duration |
Total |
Course Duration (Including the exam week: 14x Total course hours) |
16 |
3 |
48 |
Hours for off-the-classroom study (Pre-study, practice) |
16 |
3 |
48 |
Mid-terms |
1 |
10 |
10 |
Homework |
5 |
2 |
10 |
Final examination |
1 |
10 |
10 |
Total Work Load |
|
|
126 |
Total Work Load / 25 (h) |
|
|
5,06 |
ECTS Credit of the Course |
|
|
5 |