Excel Business Applications

Course Code: 
MAN 427
Course Type: 
Area Elective
P: 
3
Application: 
0
Credits: 
3
ECTS: 
5
Course Language: 
Almanca
Course Objectives: 
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.
Course Content: 

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.

Course Methodology: 
1: Lecture, 2: Question-Answer, 3: Discussion
Course Evaluation Methods: 
A: Testing, B: Homework, C: Performance

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
(Hour)

Total
Workload
(Hour)

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