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.
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.