2019/2020

2019/2020

DM270

INF/01 (COMPUTER SCIENCE)

DEPARTMENT OF CLINICAL-SURGICAL, DIAGNOSTIC AND PEDIATRIC SCIENCES

MIDWIFERY

PERCORSO COMUNE

1°

1st semester (01/10/2019 - 15/01/2020)

2

30 lesson hours

WRITTEN TEST

VERRI ANNA - 2 ECTS

=

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.

- 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;
- Application of unpaired t test for equal or unequal variance by means of the command Data Analysis and interpretation of the test results;
- Application of the independence test (chi-square) through the use of functions: TEST.CHI.QUAD and DISTRIB.CHI.QUAD.DS and interpretation of the test result.

The course is divided into lectures and exercises through the use of multimedia platform Kiro UNIPV (e.learning platform of the University of Pavia), regarding the use of Excel tools for the application of medical statistics.
Specifically, students will attend lectures at one of the computer rooms made available by the University and secondarily must register for the course on structured teaching portal using the content made available (quizzes and exercises).
The tutor, assigned to the course, will take care of the correction of exercises and evaluation.

Excel & Statistica Medica di S.Villani e P.Borrelli, Ed. MEDEA 2013

Examination through the multimedia platform Kiro UNIPV, divided into two parts:
1) quiz of 10 questions about program structure and commands;
2) analysis of a data matrix according to the proposed questions.

Hours of tutoring available to students for any questions about the lessons, to the tests and the management of this course on Kiro UNIPV platform.
The meetings will be scheduled by appointment. Teacher contacts: anna.verri@unipv.it