School / Prep
ENSMAC
Internal code
PA5EXCEL
Description
At the end of this TD cycle, apprentices will be able to :
- Use the basic functions of a spreadsheet program such as MS Excel, as well as a number of more advanced functions (Solver, Macros, TCD)
- Present work carried out on a spreadsheet program such as MS Excel to a colleague in a clear and precise manner
- Create and transmit to a colleague a scientific report of high quality, at least in terms of form, using a word processing program such as MS Word
- Master EXCEL tools for measuring production activities and optimizing processes.
Teaching hours
- TDMMachine Tutorial24h
Syllabus
The introductory Excel module comprises 2 parts:
I - Introduction to the Excel spreadsheet and getting to grips with it. Use of Excel in the form of projects based on experimental data: exercises concern the identification of kinetic parameters (rate constants, reaction orders), thermo-physical quantities (thermodynamic model parameters, transfer coefficients) or controls (casting or operating temperature profiles), etc... Rapid presentation of results directly on computer (Clémentine BOSCH-BOUJU, Adeline PERRO, 12h)
II - Macros and DCT (Clémentine BOSCH-BOUJU, Adeline PERRO, 12h)
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 |
---|---|---|---|---|---|---|
Continuous control | Minutes | 0.15 | ||||
Continuous control | Minutes | 0.5 | ||||
Project | Report | 0.35 |