Design of Information Systems

Be able to use spreadsheet (Excel) for the calculation, formatting and presentation of data, in order to assist in their analysis. Be able to design algorithms for simple problems. Be able to implement algorithms designed in VBA. Be able to write Functions/Procedures/Macros in VBA.

Excel : 1- Management of sheets and workbooks, filtering and selection, conditional formatting, incremental filling... 2- Use of statistical, logical, research and complex formulas. "Target value" tool. 3- Relative and absolute references, pivot tables. 4- Generation of graphs

VBA programming :

1. Basics of algorithmics.
2. Sequential control structure.
3. Conditional control structure (If).
4. Iterative control structure (For -Do).
5. Recursion.
6. Input/output (input and display of user data).