Business & Excel Solutions Intermediate

General information

Type:	OPT	Curs:	1,2,3,4,5	Period:	S semester
ECTS Credits:	2 ECTS

Teaching Staff:

Group	Teacher	Department	Language
Year 1	Carlota Torrens Csonka	Esade	ENG

Group	Teacher	Department	Language
Year 2	Carlota Torrens Csonka	Esade	ENG

Group	Teacher	Department	Language
Year 3	Carlota Torrens Csonka	Esade	ENG

Group	Teacher	Department	Language
Year 4	Carlota Torrens Csonka	Esade	ENG

Group	Teacher	Department	Language
Year 5	Carlota Torrens Csonka	Esade	ENG

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 will then lead us 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

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 to use the spreadsheet tool. Class attendance and constant practice are decisive to successfully pass this course.

The course also includes learning capsules/pills with theoretical content related to the course's practical components so that students can work on their own, even online.

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.

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 mark ranging from A to D. The latter 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 2016. Similarly, there are numerous online resources available such as message boards and websites that offer free tutorials and video-tutorials.