Studying at the University of Verona

Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.

The Study Plan includes all modules, teaching and learning activities that each student will need to undertake during their time at the University.
Please select your Study Plan based on your enrollment year.

Legend | Type of training activity (TTA)

TAF (Type of Educational Activity) All courses and activities are classified into different types of educational activities, indicated by a letter.




S Placements in companies, public or private institutions and professional associations

Teaching code

4S000206

Credits

2

Language

Italian

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

Period

TERP ROV 2^ ANNO - 2^ SEMESTRE dal Mar 13, 2017 al May 19, 2017.

To show the organization of the course that includes this module, follow this link:  Course organization

Learning outcomes

To create and manage a database through the Excel program with the aim of identifying the most appropriate statistical analysis according to the type of available variables and the field of research. To manage descriptive and bivariate statistical instruments (tables and graphs) and indicators with Excel. Basic knowledge of epidemiology.

Program

Type of statistical variables. Input of data in a dataset (coding), data cleaning and preparation of the work file.
Frequency distribution and graphical representations of the frequencies (absolute and percentage) through the use of pivot tables and some of the data analysis tools in Excel.
Calculation of the main measures of central tendency and variability with Excel functions.
Variables transformation.
Crosstabs and Chi-square test. Signs on Regression and Correlation (Pearson's coefficient).
Epidemiology: number of cases expressed as prevalence and incidence rate ratios or as statistical odds (exercises with Excel). Calculation of relative risk and odds ratio with examples in Excel. Sensitivity and specificity of a diagnostic test.

Examination Methods

Practical exam on PC with Excel: three exercises to solve.

Students with disabilities or specific learning disorders (SLD), who intend to request the adaptation of the exam, must follow the instructions given HERE