## Learning objectives

Initially the course aims to illustrate the use of the Microsoft Excel © computer tool, through the practical use of this software the students will learn how to organize and analyze a real set of data and present the main concepts of statistical reasoning first in the context of descriptive and then inductive logic through practical examples. Finally, with the introduction of statistical inference, elements of probability calculation and theory of random variables will be shown for the purpose of validating them.

## Prerequisites

The only useful prerequisite, not mandatory, is related to the knowledge of the use of the PC, mainly as regards the file's creation of file's management regards that will be produced in the classroom.

## Course unit content

With the course "LABORATORIO DI INFORMATICA APPLICATO ALLA RICERCA INFERMIERISTICA E OSTETRICA", students have the opportunity to concretize and deepen those statistical knowledge which, in the professional scenario, will allow to face and solve simple and complex problems. These concepts will be familiarized through learning and deepening of the Microsoft Excel © computer tool.

## Full programme

What is Excel

Understanding worksheets and spreadsheets

Knowing software interface

Work with rows, columns, cells, ranges and tables

References: relative and absolute

Import data into Excel from external sources

Format the data

Knowing and use the formula bar

How to build a formula

Nesting of functions and use of parentheses

Choose the right function and insert a function

Use functions with and without arguments

Use rows, columns, cells (with A / R references), ranges and tables

Enter formulas using the formula bar

Enter formulas manually in the formula bar or cells

What is arrays are and how are they used in formulas

Working with functions that return an array as a result

Find errors in formulas

Avoid common mistakes: circular reference, broken link, etc.

Using the "Error Checking" function

Available formats in Excel (predefined and customizable)

Test on a condition

Logical operators

Using the NOT function

Using the AND and OR function

Using the XOR function

Using the ADDRESS function

Using the ROW, ROWS, COLUMN REF and COLUMNS functions

Using the REJECT function

Using the HORIZLOOK and VLOOKUP functions

Using the COMPARE and INDEX functions

Using the TEXT.FORMULA function

Using the NUMBERVALUE function

Using the CELL function

Information about Excel and the PC where you work

Using the IS function

Using the functions: ISERR, ISERROR, and ISNONDISP

Using the functions: ISBLANK, ISNOTTEXT, ISTEXT and ISNUMBER

Use of text

Text alignment

Calculating the length of text with the LENGTH function

Join text with the CONCATENATE function

Use of fonts

Convert numbers to text

Repeat some text

Exchange some text

Cut out some text

Compare, find and measure text

Using the EXACT function

Find and replace

Order of operators

View the formulas

Arrange the formulas

Activation Calc

Using area names

Using formula auditing

Using conditional formatting

Use of data validation

Create custom functions

Apply security features

Use data between tables in different sheets / folders

Export tables / graphs in word

Insert the data into a database structure

Working with database functions

Definition of the criteria area

Improved criteria with AND and OR

Use of database functions: DB.SUM, DB.MEDIA, DB.CCOUNT.NUMERS, DB.MIN, DB.MAX, DB.VALUES and DB.PRODUCT

Import data from a database

Create pivot tables from a database

Use the SUM function to add more data

Rounding

Use of the INT and TRUNK functions to eliminate all or part of the decimals

Ignore the signs: yes / no

Use of advanced mathematical formulas

Generate random numbers with the RANDOM function

Generate random numbers from a number set with the RAND.TRA function

Sorting of elements

Combination of elements

Using the SUBTOTAL function

Using the SUMPRODUCT function

Using the SUMIF and SUMIFS function

Basic terminology of statistics

Use of the MEDIA, MEDIAN and MODE functions

Deviation from the mean

Measurement of variance

Anal of the deviation

Normal distribution

Distributions, skewness and Kurtosis

Distribution t

Standard error

Distortion

Comparison of data sets

Data analysis with percentiles and containers

Using the functions: QUARTILE.INC, QUARTILE.EXC, PERCENTILE.INC and PERCENTILE.EXC

Using the functions: RANK, PERCENT RANK, FREQUENCY, MIN, MAX, LARGE and SMALL

Use of the functions: COUNT.NUMERS and COUNTIF

T test

T-test for independent and paired samples

Comparison of the results with an estimate

Chi square distribution

Analysis of variance, factorial and with repeated measures

Correlation and covariance

Linear regression

Binomial distribution

Fisher's exact test

Poisson distribution

Modeling

Linear model

Exponential model

Use the functions: SLOPE and INTERCEPT to describe linear data

Use the functions: FORECAST, TREND and GROWTH to make predictions

Use the functions: NORM.DIST and POISSON to determine the probabilities

Pivot tables

Convert data from one format to another (wide-long)

## Bibliography

Course's Slides

The following texts are to be considered optional as a verification and in-depth analysis of what is covered in class and on the course slides:

1 -

Analisi statistiche con Excel

di F.Borazzo, P.Perchinunno

Editore : Pearson

Lingua : Italiano

ISBN-10 : 8871923332

ISBN-13 : 978-8871923338

2 -

Excel & statistica medica. Guida pratica per le professioni sanitarie

di S.Villani, P.Borrelli

Editore : Medea

Lingua : Italiano

ISBN-10 : 8866930482

ISBN-13 : 978-8866930488

3 -

Excel 2019 Bible

di M.Alexander, Dick Kusleika

Editore : John Wiley & Sons Inc

Lingua : Inglese

ISBN-10 : 9781119514787

ISBN-13 : 978-1119514787

## Teaching methods

The teaching will take place using mainly practical teaching methods (essential for a good applied computer science laboratory). There will be interactivity and the involvement of students, who are asked to actively participate in order to improve the concrete approach of the course.

we will start from the main concepts of the Spreadsheet and then deepen all the functions and features.

Therefore, through a parallel theory / exercises approach, we will move from the formal aspect of the formula or the statistical model to its algorithmic conversion to end with the use of the most appropriate algorithm based on the context of the available data.

Particular attention will also be made to the presentation and description of the processed data, relevant aspect for the production of an effective analysis report (presentation or article).

Lectures will be held on-site in compliance with safety standards, provided that further instructions on the ongoing health emergency are not implemented. Supporting material will be available on the specific, student-reserved platform (Elly) and will include slide presentations, audio-video aids or video-recording of the lectures.

## Assessment methods and criteria

Learning and the degree of preparation achieved is verified through a practical test using the PC and Microsoft Excel® software. All topics covered during the cycle of lessons are the subject of the test.

During the cycle of lessons, practical exercises will be performed in order to bring out any need for further study (it is strongly recommended that additional exercises carried out individually to increase awareness and learning of the topics).

## Other information

NA