School / Prep
ENSMAC
Internal code
PB5TDEDE
Description
At the end of the training course, students will be able to process scientific data using a spreadsheet and its associated tools, to present and valorize their work, and to evaluate similar work.
This implies being able to:
- Format, find and validate a numerical solution to a scientific problem involving experimental data and models, using a spreadsheet and a solver.
- Prepare and give a convincing oral presentation, presenting and valorizing the context, the work carried out and the results obtained. Prepare and give a concise and convincing oral presentation, highlighting the context, the work carried out and the results obtained.
- Evaluate oral presentations of scientific work based on a grid of criteria, and providing explicit justifications and recommendations.
- Master EXCEL tools for measuring production activities and optimizing processes.
Teaching hours
- PRACTICAL WORKPractical work8h
- TDMMachine Tutorial2h
Mandatory prerequisites
Good level in Mathematics
Syllabus
The activities carried out by students during the course are as follows:
- Introduction (using a tutorial) to the use of the Microsoft Excel spreadsheet to solve scientific problems.
- Solving a scientific problem involving experimental data, with a different subject for each group (pairs), using the spreadsheet and solver.
- Preparing and giving an oral presentation (Microsoft PowerPoint) according to a set of specifications.
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 |
|---|---|---|---|---|---|---|
| Continuous control | Defense | 0.5 | ||||
| Continuous control | Continuous control | 0.5 |
