Course objectives:
|
Microsoft Excel is the basic tool for all business economists. The aim of this course is to teach students how to use this program for solving tasks in various business departments: marketing, finance, human resources, accounting ...
|
Requirements on student
|
To obtain the credit, it is necessary to actively participate in the exercises and pass the credit test at least 60%.
|
Content
|
Introduction of the course
Import and checking of the input data
Work with lists
Contingency table
Sensitivity analysis
Simulation
Macros
Economic functions
Comprehensive sample
|
Activities
|
|
Fields of study
|
e-learning (Moodle)
|
Guarantors and lecturers
|
|
Literature
|
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Preparation for comprehensive test (10-40)
|
35
|
Contact hours
|
26
|
E-learning [dáno e-learningovým kurzem]
|
40
|
Total
|
101
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
Control basic knowledge of MS office. |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
Master the basics of working in MS Office. |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
Gain advanced knowledge of MS Excel software. |
Skills - skills resulting from the course: |
Solve economic tasks in MS office. |
Competences - competences resulting from the course: |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Skills demonstration during practicum |
Seminar work |
Skills - skills achieved by taking this course are verified by the following means: |
Seminar work |
Competences - competence achieved by taking this course are verified by the following means: |
Seminar work |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Practicum |
Skills - the following training methods are used to achieve the required skills: |
Practicum |
Competences - the following training methods are used to achieve the required competences: |
Practicum |
|