Level of Education
4-year college degree
ECTS
3 credits
Training Structure
College of Sciences
Number of hours
24h
Description
Knowing how to collect and process data are essential skills in a scientific and/or technical professional setting. The objective of this course is to address, as effectively as possible, three types of standard professional skills:
· Advanced use of spreadsheets and graphing software (MS Excel, LO-CALC) for scientific and technical purposes
· Network interconnections: infrastructure, the TCP/IP protocol suite, security
· Introduction to relational databases (MS Access, LO-BASE) – concepts and terminology, creating queries, graphical reports, forms.
Objectives
Upon completion of this course, students will be able to:
· To effectively process data using one of the most widely used tools in the professional world: the spreadsheet program. To this end, the most advanced features of MS-EXCEL and LO-CALC (array formulas, Solver, pivot tables and charts, support for complex numbers, etc.) are presented through concrete examples: Curve fitting, regression, numerical derivatives and integrals, filtering using the Fast Fourier Transform, analysis of data extracted from databases, and extending native functionality using VBA or LO-BASIC…
· To install and configure equipment (computers and other devices in a data acquisition and processing system) within an intranet-type network infrastructure.
· Extract, analyze, and format information from a relational database.
o Creating different types of queries and an introduction to SQL
o Creating forms, reports, charts, and pivot tables
Mandatory Prerequisites
Basics of Spreadsheet and Graphing Tools
Recommended prerequisites:
Basics of Object-Oriented Programming Languages
Knowledge Assessment
CCI
Course Outline
There are many data processing solutions available, ranging from general-purpose to highly specialized, but some are considered industry standards, and it is advisable to master them if you hope to establish yourself professionally and become productive quickly. This is the case with spreadsheet and graphing tools.
Furthermore, a solid 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 data acquisition chain involving scientific and technical instruments that offer Ethernet-type interfaces.
Finally, in an industrial setting 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 successfully carry out an analysis.
Upon completion of this course, students will be able to:
· To effectively process data using one of the most widely used tools in the professional world: the spreadsheet program. To this end, the most advanced features of MS-EXCEL and LO-CALC (array formulas, Solver, pivot tables and charts, support for complex numbers, etc.) are presented through concrete examples: Curve fitting, regression, numerical derivatives and integrals, filtering using the Fast Fourier Transform, analysis of data extracted from databases, and extending native functionality using VBA or LO-BASIC…
· To install and configure equipment (computers and other devices in a data acquisition and processing system) within an intranet-type network infrastructure.
· Extract, analyze, and format information from a relational database.
o Creating different types of queries and an introduction to SQL
o Creating forms, reports, charts, and pivot tables