Arborescence des pages
ConfigureOutils de l'espace
Aller directement à la fin des métadonnées
Aller au début des métadonnées


Tools and methods to design Decision Support Systems

ECTS Credits : 4

Duration : 36 hours

Semester : S8

Person in charge:

Henri AMET, Associate professor,


Simulating, decision taking, computerised systems, VBA 

Prerequisites: Programming, operational research

Goal: Choose the best tool to solve decision taking problems

Program and contents :

The engineer must have at his disposal a wide array of tools and methods to tackle decision taking issues that are frequent in the industry and services. Gaining command over specialised tools, like discrete events simulation, systems dynamics, linear programming solvers both quadratic and stochastic and many more completes the theoretical background previously acquired (mathematics, operational research). These tools are most times deployed within the framework of a programming language or spreadsheets. VBA Excel, widely used in enterprises, will serve as a programming environment for implementing the numerical simulation methods (Surbooking optimization for an airline or study of the distribution of a profit function for example). There are many types of applications : production, ecology, finance and more. The ultimate goal is to enlarge the scope of methods available without focalising on any one approach. Mathematica will be used regularly for its quality of representation and its effectiveness.

the program carries on the following points:

  • Discrete events simulation. Use of Extend software
  • System dynamics. Use of Stella software
  • VBA Language. communicating between sheets and files. Key commands
  • Application development under VBA/Excel. Sectors : Resource management, production, finance. Application to decision taking in a fundamentally uncertain world.


Abilities : 


Description and operational vocabulary


Know the best tools and methods to resolve decision taking problems


Know the pros and cons of the different approaches


Know to implement the methods in given computer environments


Identify data, results. Know how to breakdown a model in logical units





Evaluation :

  • Written test
  • Continuous assessment
  • Oral presentation
  • Project
  • Written report
  • Aucune étiquette