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 - Tests
Type of assessment | Type of test | Duration (in minutes) | Number of tests | Test coefficient | Eliminatory mark in the test | Remarks |
---|---|---|---|---|---|---|
Continuous control | Defense | 0.5 | ||||
Continuous control | Continuous control | 0.5 |