Contactar esade

GSI: Business & Excel Solutions Intermediate (18BBA11018)

General information

Type:

OP

Curs:

2,3

Period:

S semester

ECTS Credits:

2 ECTS

Teaching Staff:

Group Teacher Department Language
Ed: 1 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences ESP

Group Teacher Department Language
Ed: 2 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences ESP

Group Teacher Department Language
Ed: 3 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences ESP

Group Teacher Department Language
Ed: 4 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences ESP

Workload distribution

Workload distribution:

Lectures and participatory sessions: 18 hours
Independent study: 20 hours
Group work: 10 hours
Tutorials/feedback: 2 hours

COURSE CONTRIBUTION TO PROGRAM

A) Students will gain important knowledge regarding budget management and IT systems in organisations, implying an in-depth understanding of the essential management concepts and tools associated to this area.
B) They will develop the necessary skills to have a holistic, general and, of course, functional view of how to manage calculation tools for different ends.

Course Learning Objectives

We will begin with skills related to the use of computer-based tools to prepare budgets and general financial management processes. This objective to the second, namely, understanding the value of IT systems in companies.

Based on the above global objectives, this course also has a series of other objectives linked to specific competencies:
A. Familiarise students with the different tools and their possibilities.
B. Apply the concepts and models studied in class to concrete situations.
C. Have clear reference frameworks as well as keys for their use to analyse diverse situations and propose solutions to improve them.

CONTENT

1. Introduction. Spreadsheet concepts.

2. Basic functions. Formats.

3. Relative and absolute references.

4. Defining parameters.

5. Advanced functions.

6. Searching for data in tables.

7. Financial functions. Goal Seek.

8. Graphs.

9. Hypothesis tables.

10. Incorporating external data. Filters.

11. Dynamic tables.

12. Scenarios

Relation between Activities and Contents

1 2 3 4 5 6 7 8 9 10 11 12
Practical case studies                        
Teamwork                        

Methodology

This course is fundamentally practical in focus given its instrumental nature. For this reason, students are divided into groups for practical sessions in the CPD classrooms to be able to constantly use the spreadsheet tool. Class attendance is a decisive element to successfully pass this course.

The course also includes educational "capsules" with theoretical content related to the course's practical components.

The course website is also a highly important tool within the course. Consequently, we recommend students visit the website as frequently as possible to stay abreast of the course and deadlines.

ASSESSMENT

ASSESSMENT BREAKDOWN

Description %
Practical case studies 40
Teamwork 60

Assessment criteria

Students' assessment will bear in mind how well they acquire the learning objectives described above. These marks will range for 0 to 10. In addition, faculty may assess the competencies worked on in this course and incorporate those marks into the 0 to 10 mark for the class. They will also assign those competencies an independent indicator ranging from A to D. This indicator is assigned in the different courses students take and serves to indicate students' progress throughout the entire programme.

Bibliography

Short bibliography:

All the theoretical content presented in class will be complemented by PowerPoint presentations available on the course website. Faculty will post these presentations after the corresponding sessions.

Should students wish to consult additional texts, there are numerous manuals available for Excel 2010 and 2013. Similarly, there are numerous web resources available such as messageboards and websites that offer free tutorials and video-tutorials.

Timetable and sections

Group Teacher Department
Ed: 1 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences

Timetable Ed: 1

Group Teacher Department
Ed: 2 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences

Timetable Ed: 2

Group Teacher Department
Ed: 3 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences

Timetable Ed: 3

Group Teacher Department
Ed: 4 Jordi Ferrer Guillen Operaciones, Innovación y Data Sciences

Timetable Ed: 4