|
Type: |
OP | Curs: |
2,3 | Period: |
S semester |
ECTS Credits: |
2 ECTS |
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 |
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 |
5 | 2 | 4 | 7 | 6 | 3 | |
Attendance and case studies | ||||||
Session summaries | ||||||
Final group project |
1. Introduction to modelling.1. Setting parameters2. Relative, absolute and mixed references 3. Using names 4. Dependent and independent variables 5. Using Excel functions 6. working with several sheets |
2. Advanced charts1. Basic charts2. Styles and conditional formats 3. Data table 4. Goal seek 5. Solver 6. Scenarios 7. Statistics. Data analysis 8. Advanced charts |
3. User interface1. Data validation2. Protection 3. Controls 4. Macros |
4. Database tables1. Importing external data2. Filters 3. Subtotals 4. Queries 5. Dynamic tables |
5. Risk management1. Calculating expectations and deviations2. Montecarlo simulation 3. @Risk 4. Decision-making |
6. Introduction to programming with VBA1. Object model2. Programming language 3. The development environment |
1 | 2 | 3 | 4 | 5 | 6 | |
Attendance and case studies | ||||||
Session summaries | ||||||
Final group project |
Description | % |
---|---|
Attendance and case studies | 25 |
Session summaries | 25 |
Final group project | 50 |
Group | Teacher | Department |
---|---|---|
Ed: 1 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Ed: 2 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Ed: 3 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Ed: 4 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |