Computer Knowledge and E-Skills

Unit of computer science
Microsoft Office Word (word processing):
Basic Concepts: The MS Office Word program (editors of text); program layout and display; opening, writing, saving, and document management; exporting .doc(x) document to other formats (.pdf); page setup (margins, orientation, binding); header, footer, and page body; printing document;
Text formatting and display: font formatting (type, style, size, color, effects); inserting special characters; paragraph format (alignment, indentation, spacing, line spacing); bulleted and numbered list; borders and background; styles; breaks, text in column; tabs; display mode (normal, print layout); document layout for printing; print preview and print document;
Object insertion: image insertion, editing and layout; table insertion and formatting;
Tools: spell-check; suggested synonyms; "find and replace" command; "review" mode.
Microsoft Office Excel (Calculation and Data Analysis):
Basic concepts: The MS Office Excel program and spreadsheets; program layout and display; opening, saving and managing spreadsheet; export spreadsheet .xls(x) to other formats (.pdf); spreadsheet structure (rows, columns, cells); cell formatting (font, background, borders, alignment, data format);
Functions and data and information management: logical functions (example: AND, OR, IF, PLUS.IF; IF.ERROR), search and reference (example: SEARCH.VERT; SEARCH.ORIZZ; COMPARE; INDEX); mathematical and trigonometric (example: SUM.IF; SUM.PLUS.IF); relative and absolute references; conditional formatting; sorting data according to criteria; filters; dependent cell search, error checking, validation, group, separate and subtotal tools;
Graphs: choice of graph type and its customization.
PowerPoint (Presentations):
Basic concepts: The MS Office Power Point program and presentations; program layout and display; opening, saving and document management; exporting .ppt(x) document to other formats (.pdf);
Slide management and object insertion: layout, sorting and slide display mode; image insertion from file/clipart; inserting and editing diagrams and organization charts;
Animated presentations: inserting and editing slide transition effects; inserting and editing object animations in slides; trigger methods for transitions and animations; "presentation" mode; saving pptx file as presentation only;
Microsoft Office Access (database preparation and management) - hints:
Tables, queries, tabs, reports.
Tools for searching, storing and sharing data.
Searching bibliographic sources (example: Mendeley, Zotero);
Data storage and sharing (example: Dropbox, Google drive).

Unit of statistics
Introduction to statistics
Definition, usefulness and uses of statistics;
Basic concepts (population, sample, variable);
Statistical language;
Data handling
How to organize data;
Secondary data and sources;
Primary data and sampling;
Survey techniques;
Datasets, tables and graphs;
Data analysis
Data distribution;
Qualitative data organization;
Quantitative data organization;
The data central position indices (mean, median and mode);
The scatter indices (range, mean absolute deviation, variance, standard deviation, interquartile range, properties of typical intervals)
The shape indices for unit data and data grouped into classes (Pearson skewness index, first and second Pearson skewness coefficient, Fisher skewness index, Pearson-Fisher skewness coefficient, kurtosis index);
The non-central position indices (z-scores, quartiles);
Outliers;
Univariate Analysis-The Exploratory Data Analysis (boxplot, five-number synthesis);
Univariate Analysis - How to describe a distribution;
Bivariate Analysis - The Correlation;
Bivariate Analysis - The simple linear regression.
Probability and normal distribution;
Multivariate data analysis, basic concepts. Principal component analysis (PCA);
Software di programmazione utili per la gestione, l'elaborazione, l'automazione, l'archiviazione la rappresentazione dei dati.