Home - Log in

Scientific calculation with Excel

1MAG2 Scientific calculation with Excel Materials and Mechanics - Apprenticeship S6
Lessons : 10 h TD : 10 h TP : 0 h Project : 0 h Total : 20 h
Co-ordinator : Julien Mahier
Prerequisite
Know how to use a computer
Scientific calculation (algebra and analysis)
Course Objectives
Give students the basics of using Excel.
Understand the different tools for problem solving and formatting information.
Know how to build a mechanically oriented data processing and visualization sheet
Syllabus
Chapters of the lecture:
------------------------
Presentation of Excel
Presentation of the interface
Basics of spreadsheet calculation
Formulas and functions
Import and analyze data
Scientific calculation

Implementation:
---------------
Each chapter is composed of simple exercises of implementation
3 more consistent exercises validate knowledge
1 synthesis exercise makes it possible to apply the knowledge to the mechanical domain
Practical work (TD or TP)
Non renseigné
Acquired skills
Know how to use Excel to solve and visualize scientific problems
Bibliography
Non renseigné

© 2024 - ENSICAEN ( Legal Notices - Credits )