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
