School / Prep
ENSMAC
Internal code
PI5OINF1
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 a few more advanced functions (Solver, Macros, TCD)
- Present work carried out 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.
Teaching hours
- TDMMachine Tutorial28h
Mandatory prerequisites
The basics of using a microcomputer under Microsoft Windows operating system,
Good level in Mathematics.
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.
Presentation of the results of data processing in the form of a presentation using PowerPoint software. (1 session of 4 hours)
More in-depth knowledge of the Excel spreadsheet: macros and pivot tables. (3 sessions of 4 hours)
Further information
Engineering sciences and techniques
Bibliography
EXCEL, WORD and POWERPOINT online help
Assessment of knowledge
Initial assessment / Main session
| Type of assessment | Nature of assessment | Duration (in minutes) | Number of tests | Evaluation coefficient | Eliminatory evaluation mark | Remarks |
|---|---|---|---|---|---|---|
| Project | Oral | 0.25 | ||||
| Project | Defense | 0.25 | ||||
| Continuous control | Continuous control | 0.5 |
Second chance / Catch-up session
| Type of assessment | Nature of assessment | Duration (in minutes) | Number of tests | Evaluation coefficient | Eliminatory evaluation mark | Remarks |
|---|---|---|---|---|---|---|
| Project | Oral | 0.25 | ||||
| Project | Defense | 0.25 |
