TecnoCampus Foundation
eCampus
University Business
eCampus

What are you looking for?

General information

Subject type: Optional

Coordinator: Enric Camón Luis

Trimester: Second term

Credits: 6

Teaching staff: 

Axel Ehberger

Teaching languages

  • English

Classes and teaching material are in English. Linguistic doubts will be resolved in class.

Skills

Basic skills

  • B2_That students know how to apply their knowledge to their job or vocation in a professional way and have the skills that need to be demonstrated through the elaboration and defense of arguments and the resolution of problems within their area of ​​study

  • B4_That students can convey information, ideas, problems and solutions to both specialized and non-specialized audiences

     

Transversal competences

  • T4_Domain the computer tools and their main applications for the ordinary academic and professional activity

Description

Today, companies assume that their employees have a very good command of spreadsheet programs. Excel helps to solve many different problems and is relatively simple, you can quickly reach a result for common analyzes in the company.

In this subject, the most useful applications of the Excel tool are taught in a practical way, always with examples, in the broad context of Management Control (Controlling). The knowledge acquired can also be applied in other spreadsheet programs such as Google Sheets or OpenOffice Calc. This course is of interest to those who want to make useful use of data and turn it into information.

Contents

The general learning objectives can be summarized as follows:

• Know the structure of the 'Excel' application.

• Know and learn in a structured way the most useful tools in the context of Controlling (management control).

• Learn to use tables and dynamic tables in the context of Controlling (Structure data appropriately for analysis and/or the preparation of reports and graphs).

• Apply recommended rules for creating tables and graphs in terms of structure and display.

• Use the Excel tool in the context of reporting.

• Know and learn to use more sophisticated Excel functions and tools.

• Prepare a control chart, taking into account the Controlling processes.

• Know 'tips and tricks' of practice.

Evaluation system

Resolution of 2 exercises (50% of the grade, 25% each exercise).

Final theoretical and practical exam (50% of the mark).

To pass the subject you must obtain a minimum of 5 points in the final theoretical-practical exam. The final mark of the subject will be configured as follows:
- If the average of the grades obtained in all the activities proposed in the continuous assessment is approved, this will be the final grade of the subject.
- if the grade point average is not passed and/or the final theoretical-practical exam is lower than 5 points, the student must take the mandatory retake exam.

Make-up exam: if the subject has not been passed through continuous assessment, the student can take the make-up test. In the make-up exam, only the theoretical and practical exam can be made up. In this case, the grades of the other items will be saved and cannot be retrieved. To pass the subject, the grade in the remedial exam must be at least 5 points and the final average of the grades must be approved.
A student who has not applied for the first call CANNOT apply for recovery.

REFERENCES

Basic

International Business Communication Standards (IBCS®)

Article in Spanish: https://www.ibcs.com/resource/revista-de-contabilidad-y-direccion-vol-24-ano-2017-pp-81-109/

Standards (English Edition):

IBCS Standards 1.2 • IBCS - International Business Communication Standards

Standards (Spanish Edition):

IBCS Standards 1.2 (es) • IBCS - International Business Communication Standards

Video:

IBCS - Fostering understanding • IBCS - International Business Communication Standards

Summary guide of the contents of each subject.