| Course label : | Python - Excel |
|---|---|
| Teaching departement : | CMA / |
| Teaching manager : | Mister LUDOVIC THUINET |
| Education language : | |
| Potential ects : | 0 |
| Results grid : | |
| Code and label (hp) : | ENSCL_CI_M5_4_3 - Python - Excel |
Education team
Teachers : Mister LUDOVIC THUINET / Mister JEREMIE BOUQUEREL
External contributors (business, research, secondary education): various temporary teachers
Summary
This course is aimed at students already familiar with the use of a programming language and also constitutes an introduction to the use of a spreadsheet (Excel). Its objective is to allow students to perfect their practice in these different tools by applying them to exercises of increasing complexity and by learning more advanced options.
Educational goals
At the end of this course, the student must: 1/ Know the syntax and method of organizing data associated with a spreadsheet 2/ Know how to use a spreadsheet to calculate and analyze data 3/ Know how to use a spreadsheet to deal with numerical problems involving a large number of parameters and complicated equations 4/ Know how to imagine and implement simple algorithms using Python 5/ Know how to implement a logical approach allowing you to detect possible errors in equations and algorithms
Sustainable development goals
Knowledge control procedures
Continuous Assessment
Comments: Final written exam (duration: 1h45)
Online resources
1 Excel usage handout 1 course handout “Programming in Python” Worksheets to process on Excel and Python
Pedagogy
This course takes place only in the form of tutorials on a computer station. 1/ Use of Excel: general presentation of the Excel software (format of cells, insertion of formula, incremented copies, absolute references/relative references), drawing of graphs in Excel (creation of a graph, exploitation of a graph, bar uncertainty, trend lines, linear regression) 2/ Deepening the use of Excel: using the forms toolbar and ergonomic tools, using the Target Value and Solver tools, recording a series of instructions using a macro, using dynamical tables, use of statistical functions 3/ Application of the Python programming language to creating games or solving problems commonly encountered in chemistry
Sequencing / learning methods
| Number of hours - Lectures : | 0 |
|---|---|
| Number of hours - Tutorial : | 9 |
| Number of hours - Practical work : | 0 |
| Number of hours - Seminar : | 0 |
| Number of hours - Half-group seminar : | 0 |
| Number of student hours in TEA (Autonomous learning) : | 0 |
| Number of student hours in TNE (Non-supervised activities) : | 0 |
| Number of hours in CB (Fixed exams) : | 0 |
| Number of student hours in PER (Personal work) : | 0 |
| Number of hours - Projects : | 0 |
Prerequisites
Already have experience using a spreadsheet and a programming language, for example by having followed the “Excel-Python for beginners” course.