• Your selection is empty.

    Register the diplomas, courses or lessons of your choice.

IT tools

  • School / Prep

    ENSMAC

Internal code

PMT5-OUINF

Description


At the end of this TD cycle, apprentices will be able to:
- Use the basic functions of an MS Excel-type spreadsheet, as well as some more advanced functions (Solver, Macros, TCD)
- Present work done on an MS Excel-type spreadsheet to a colleague in a clear and precise manner
- Present the results of a scientific project orally to a colleague using a Power Point-type support
- Program in Python

Read more

Teaching hours

  • TDMMachine Tutorial40h

Mandatory prerequisites


The basics of using a microcomputer under Microsoft Windows operating system,
Good level in Mathematics.

Read more

Syllabus


Introduction to the Excel spreadsheet and independent processing of experimental data. (3 sessions of 4 hours)
The exercises proposed concern, for example, the identification of kinetic parameters (rate constants, reaction orders, etc.), thermo-physical quantities (thermodynamic model parameters, transfer coefficients) or controls (casting or operating temperature profiles), etc.
More in-depth knowledge of the Excel spreadsheet: macros and pivot tables. (3 sessions of 4 hours)

Introduction to Python programming for scientific computing (4 sessions of 4 h)

Read more

Further information

Engineering sciences and techniques

Read more

Bibliography

EXCEL, WORD and POWERPOINT online help

Read more

Assessment of knowledge

Initial assessment / Main session - Tests

Type of assessmentType of testDuration (in minutes)Number of testsTest coefficientEliminatory mark in the testRemarks
ProjectMinutes0.15Excell
ProjectDefense0.15Excell
Continuous controlContinuous control0.3Macros: handover of exercises at the end of the session
Final inspectionReport0.4Python

Second chance / Catch-up session - Tests

Type of assessmentType of testDuration (in minutes)Number of testsTest coefficientEliminatory mark in the testRemarks
ProjectMinutes0.15Excell
ProjectDefense0.15Excell
Final testReport0.4Python