Enrollment year
2021/2022
Academic discipline
INF/01 (COMPUTER SCIENCE)
Department
DEPARTMENT OF CLINICAL-SURGICAL, DIAGNOSTIC AND PEDIATRIC SCIENCES
Course
IMAGING AND RADIOTHERAPY TECHNIQUES
Curriculum
PERCORSO COMUNE
Period
(04/10/2021 - 21/01/2022)
Lesson hours
8 lesson hours
Activity type
WRITTEN TEST
Learning outcomes
The course is aimed at realization of the main methods of statistical
analysis using a common program such as Microsoft Excel (2010 version).
At the end of the course the student will have learned the elements for:
Learn how to build a data matrix; Build graphical representations;
Analyze the data both from descriptive point of view that analytical; The
interpretation of the results.
Course contents
Definition of electronic spreadsheet; Programme and toolbar structure;
Creation a data matrix; Introduction to the functions for the main
descriptive statistics: Count cells: CONTA (); Sum: SOMMA (); Minimum:
MIN (); Maximum: MAX (); Mean: MEDIA (); Mode: MODA (); Median:
MEDIANA (); SD: DEV.ST (); Variance: VAR (); Range: MAX () - MIN ();
Coefficient of variation: DEV.ST () / MEDIA (); Using the command Data
Analysis for the analysis of descriptive statistics; Pivot tables in single
and double entry, creation of classes for quantitative variables with data
display: Normal; Percentage of the total; Average; Standard deviation; Pivot Charts for qualitative variables (bars and aerogramma) and
quantitative (histogram) with an explanation of the design and the layout
(title, axes, legend, data labels); Application of the correlation Pearson's
test through the Data Analysis command and creation of scatter plot.
Teaching methods
The course is based on taught lessons and practical applications through pc with resolution of statistical problem using excel
In particular students will have to attend taught lessons at one of the computerized classroom of the University.
Reccomended or required readings
Excel & Statistica Medica di S.Villani e P.Borrelli, Ed. MEDEA 2013
Assessment methods
Examination will carry out using pc: analysis of a data set and resolving the statistical problems
Further information
To contact the teacher using mail:
anna.verri@unipv.it
Sustainable development goals - Agenda 2030