Contactar Esade

GSI: Business & Excel Solutions Advanced (BBA11000)

General information

Type:

OP

Curs:

2,3

Period:

S semester

ECTS Credits:

2 ECTS

Teaching Staff:

Group Teacher Department Language
Ed: 1 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ESP

Group Teacher Department Language
Ed: 2 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ENG

Group Teacher Department Language
Ed: 3 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ESP

Group Teacher Department Language
Ed: 4 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences ENG

Prerequisites

None

Previous Knowledge

It is advisable for students to have prior experience using spreadsheets.

Workload distribution


- Lectures and participatory sessions: 18 hours
- Independent study: 16 hours
- Group work: 14 hours
- Tutorials/feedback: 2 hours

COURSE CONTRIBUTION TO PROGRAM


A) Achieve an advanced level of use in budget management and organisational information systems. For this we aim to instil in students an in-depth knowledge of the fundamental management concepts and tools linked to this area.

B) Develop the skills students need to endow them with a holistic, general and, of course, a functional view of how to manage spreadsheets for different ends.

Course Learning Objectives


The primary objective of this course is for students to become advanced users of spreadsheets for their general use in the business area and for their professional activity.

Based on this aim, we will attempt to achieve a series of specific objectives regarding different competencies:

A. Sufficient skills to enable the excellent development of financial models, serving as a differentiating factor (competitive advantage) in the professional realm and as a highly productive tool during students' academic career.
B. Apply the concepts and models presented in class to concrete situations.
C. Introduce students to reference frameworks as well as the keys for their use in analysing varied situations and proposing solutions to improve them.

Competences

5. Ability for continuous learning/Ability to learn continually
2. Application of knowledge to achieve results
4. Conveying information and/or knowledge
7. Comprehension of the complexity of the local and global contexts
6. Strategic thought, systematic thought
3. Taking decisions / making judgments

Relation between Activities and Competences

5 2 4 7 6 3
Attendance and case studies            
Session summaries            
Final group project            

CONTENT

1. Introduction to modelling.

Setting parameters, using names, working with several sheets.

2. Advanced graphs

Working with different types of graphs and optimal selection criteria.

3. Recording macros

Introduction to macros.

4. User interface

Using controls and other features to improve the user experience.

5. Simulation tools

Using different simulation tools.

6. Statistical analysis

Introduction to the different statistical analysis tools that spreadsheets offer.

7. Data tables and analysis

Working with data tables and their tools to extract information and analyse it.

8. Risk management

Using the simulation with the Monte Carlo method to manage uncertainty in the models.

9. Programming with VBA

Introduction to programming with Visual Basic for Applications

Relation between Activities and Contents

1 2 3 4 5 6 7 8 9
Attendance and case studies                  
Session summaries                  
Final group project                  

Methodology

ASSESSMENT

ASSESSMENT BREAKDOWN

Description %
Attendance and case studies 25
Session summaries 25
Final group project 50

Assessment criteria

The basic content detailed in the summary of activities shall be subject to assessment upon being handed-in.

Marks for this course will take into account how well students have achieved the established learning objectives. They will receive a mark from 0 to 10. How well students achieve the competencies established for the course may also be reflected in the 0 to 10 mark.

Bibliography

There is no required reading for this course.

Reference bibliography:

- Excel® Workbook For Dummies, Greg Harvey, Wiley Publishing, Inc., ISBN-13: 978-0470489604, ISBN-10: 047048960X.

- Excel 2013 Bible, John Walkenbach, Wiley Publishing, Inc., ISBN-13: 978-1118490365, ISBN-10: 1118490363.

- Show me the numbers. Designing Tables and Graphs to Enlighten, Stephen Few, Analytics Press, ISBN-13: 978-0970601971, ISBN-10: 0970601972.

- Microsoft isual Basic 2013 Step by Step (Step by Step Developer), Michael Halvorson, Zyg Group, LLC, ISBN-13: 978-0735667044, ISBN-10: 0735667047.

- Financial Models using Simulation and Optimization, Wayne Winston, Palisade Corporation, ISBN: 1-893281-03-5.

- Excel 2013 VBA and Macros (MrExcel Library), Bill Jelen and Tracy Syrstad, Pearson Education, Inc., ISBN-13: 978-0789748614, ISBN-10: 0789748614.

Timetable and sections

Group Teacher Department
Ed: 1 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 1

From 2017/10/2 to 2017/11/20:
Each Monday from 14:00 to 17:00. (Except: 2017/10/16 and 2017/11/13)

Group Teacher Department
Ed: 2 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 2

From 2018/1/22 to 2018/2/2:
Monday, Wednesday and Friday from 14:00 to 17:00.

Group Teacher Department
Ed: 3 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 3

From 2018/2/5 to 2018/3/5:
Each Monday from 11:00 to 14:00.

Monday 2018/4/9 from 11:00 to 14:00.

Group Teacher Department
Ed: 4 Francesc Alcaide Alcaide Operaciones, Innovación y Data Sciences

Timetable Ed: 4

From 2018/6/18 to 2018/6/29:
Monday, Wednesday, Thursday and Friday from 11:00 to 14:00. (Except: 2018/6/22 and 2018/6/28)

Monday 2018/7/16 from 9:00 to 11:30.