|
Type: |
OPT | Curs: |
1,2,3,4 | Period: |
S semester |
ECTS Credits: |
2 ECTS |
Group | Teacher | Department | Language |
---|---|---|---|
Year 1 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences | ENG |
Group | Teacher | Department | Language |
---|---|---|---|
Year 2 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences | ENG |
Group | Teacher | Department | Language |
---|---|---|---|
Year 3 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences | ENG |
Group | Teacher | Department | Language |
---|---|---|---|
Year 4 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences | ENG |
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 |
---|---|---|
Year 1 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Year 2 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Year 3 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |
Group | Teacher | Department |
---|---|---|
Year 4 | Francesc Alcaide Alcaide | Operaciones, Innovación y Data Sciences |