Data acquisition and processing 1

Knowing how to acquire and process data are essential skills in a scientific and/or technical professional context. The objective of this course is to address three types of standard skills in the professional environment:

· Advanced use of spreadsheets/graphing software (MS EXCEL, LO-CALC) for scientific and technical purposes

· Network interconnections: infrastructure, TCP/IP protocol suite, security

· Introduction to relational databases (MS ACCESS, LO-BASE) – concepts & vocabulary, creating queries, graphical reports, forms.

Upon completion of this course, students will be able to:

· Effectively process data using one of the most widely used tools in the professional world: the spreadsheet program. To do this, the most advanced features of MS-EXCEL and LO-CALC (matrix formulas, solver, pivot tables and charts, support for complex numbers, etc.) are presented using concrete examples: Curve fitting, regression, numerical derivatives and integrations, filtering by fast Fourier transform, analysis of information extracted from databases, extension of native features using VBA or LO-BASIC, etc.

· Insert and configure equipment (computers and other instruments in a data acquisition and processing chain) into an intranet-type network infrastructure.

· Extract, analyze, and format information from a relational database.

o Creating different types of queries and introduction to SQL language

o Creation of forms, reports, graphs, and pivot tables

Basic concepts of spreadsheet/charting tools

Recommended prerequisites:

Basic concepts in object-oriented programming language

CCI

There are many data processing solutions available, some more specialized than others, but certain ones are considered standard and it is advisable to master them in order to quickly become effective in the workplace. This is the case with spreadsheet/graphing tools.

On the other hand, having a good understanding of network infrastructure is proving increasingly useful in the field of instrumentation. For example, when developing or maintaining an experimental setup, it is now common to set up a functional acquisition chain involving scientific and technical instruments with Ethernet-type interfaces.

Finally, in an industrial context where the volume of data collected is very large, this data is very often centralized in database-type systems. It is therefore important to know how to access this information efficiently in order to carry out analysis work successfully.

Upon completion of this course, students will be able to:

· Effectively process data using one of the most widely used tools in the professional world: the spreadsheet program. To do this, the most advanced features of MS-EXCEL and LO-CALC (matrix formulas, solver, pivot tables and charts, support for complex numbers, etc.) are presented using concrete examples: Curve fitting, regression, numerical derivatives and integrations, filtering by fast Fourier transform, analysis of information extracted from databases, extension of native features using VBA or LO-BASIC, etc.

· Insert and configure equipment (computers and other instruments in a data acquisition and processing chain) into an intranet-type network infrastructure.

· Extract, analyze, and format information from a relational database.

o Creating different types of queries and introduction to SQL language

o Creation of forms, reports, graphs, and pivot tables