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 - Tests
Type of assessment | Type of test | Duration (in minutes) | Number of tests | Test coefficient | Eliminatory mark in the test | Remarks |
---|---|---|---|---|---|---|
Project | Oral | 0.25 | ||||
Project | Defense | 0.25 | ||||
Continuous control | Continuous control | 0.5 |
Second chance / Catch-up session - Tests
Type of assessment | Type of test | Duration (in minutes) | Number of tests | Test coefficient | Eliminatory mark in the test | Remarks |
---|---|---|---|---|---|---|
Project | Oral | 0.25 | ||||
Project | Defense | 0.25 |