• Your selection is empty.

    Register the diplomas, courses or lessons of your choice.

IT tools

  • 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.

Read more

Teaching hours

  • TDMMachine Tutorial28h

Mandatory prerequisites


The basics of using a microcomputer under Microsoft Windows operating system,
Good level in Mathematics.

Read more

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)

Read more

Further information

Engineering sciences and techniques

Read more

Bibliography

EXCEL, WORD and POWERPOINT online help

Read more

Assessment of knowledge

Initial assessment / Main session - Tests

Type of assessmentType of testDuration (in minutes)Number of testsTest coefficientEliminatory mark in the testRemarks
ProjectOral0.25
ProjectDefense0.25
Continuous controlContinuous control0.5

Second chance / Catch-up session - Tests

Type of assessmentType of testDuration (in minutes)Number of testsTest coefficientEliminatory mark in the testRemarks
ProjectOral0.25
ProjectDefense0.25