cod. 1007254

Academic year 2021/22
1° year of course - First semester
- Matteo GOLDONI
Academic discipline
Informatica (INF/01)
Scienze propedeutiche
Type of training activity
14 hours
of face-to-face activities
2 credits
hub: PARMA
course unit

Integrated course unit module: EXPERIMENTAL PHYSICAL SCIENCES

Learning objectives

At the end of the curse, students should be able: - create and manage a database with Excel; - import Excel files on other statistical software and perform test of descriptive and inferential statistics; - create and handle an experimental database obtained by biomedical devices, controlling the factros that may induce a wrong analysis.



Course unit content

This course is strictly related to that of medical statistics.
Definition of “information”. The information in biomedical field. Software and information processing. Database definition. Excel: principles and operations. A database with Excel. Export a database to other statistical software. Database variables: numeric and grouping variables, strings. Operations among variables. Functions in Excel. Graphs in Excel. Principles on other statistical software: SPSS, freware software: OPENSTAT and VASSARSTAT.
Signal processing in biomedicine: the signal from spectroscopic devices. Direct application of the theory of errors. Calibration curves and the method of successive additions. Limit of Detection and Quantification. Processing of complex signals and Area Under Curve.
Note: we will use of the program Foglio_elettronico by Openoffice 4, but in the case of significant command variations, we will see also Excel 2013 or Excel 2016 inside Microsoft Office.

Full programme

- - -


Classroom slides (uploaded on Elly during the course) are the
reference point for the exam. Some further reference books: each book about data analysis with Excel/SPSS.

Teaching methods

During the classroom lectures the topics of the module program will be illustrated and commented. Each theory argument with mathematical formulae will be explained with the use of simple and practice examples,
so that the student can focus his/her attention on basic concepts more than the formulae themselves. Students can use software like Excel, SPSS and freeware software OPENSTAT and VASSARSTAT. They may analyze and correctly interpret experimental data based on some examples and simulations reported by the teacher.
The course will be held through lectures to Students either in the classroom (“in presenza”) or possibly in synchronous-streaming (“in telepresenza”) on the Teams platform. Therefore, the opportunity of Student/Teacher interaction will be preserved both face to face and remotely, by the simultaneous use of the Teams platform.
Lectures will be supported by slide presentations, which will be available to students on the Elly platform (

Assessment methods and criteria

The verification of the achievement of module objectives is a written test (in presence or remotely), mainly consisting of questions about the arguments treated during the lessons. The exam will be done together with that of medical statistics and experimental statistics. It will contain: multiple response quiz, exercises. The grade will be in 30/30 and its weight will be based on the credits of this module respect to those of the integrate course.
Students can perform the exam in pairs, if the exam will be performed in presence.

Other information

- - -