Information Systems and Data Management
Videos of practical part of exams
Warning: videos are large, be sure to have enough space and enough time available. Do not save them on your UNIBZ disk space or you will make your account go over quota! Right click the mouse button and choose Save Target As... and save them either on a USB pendrive on on your personal computer.
Compressed videos work fin on UNIBZ computers and on every standard Windows installation. In case they do not work correctly on your computer, download the very large and uncompressed version.
exam30.avi (38 MB) |
exam30.avi (uncompressed version 268 MB) |
Excel and Access solution. |
exam29.avi (45 MB) |
exam29.avi (uncompressed version 315 MB) |
Excel and Access solution. |
exam28.avi (80 MB) |
exam28.avi (uncompressed version 356 MB) |
Excel and Access solution. |
exam27.avi (69 MB) |
exam27.avi (uncompressed version 277 MB) |
Excel and Access solution. |
exam26A.avi (38 MB) |
exam26A.avi (uncompressed version 199 MB) |
Excel and Access solution. |
exam26B.avi (52 MB) |
exam26B.avi (uncompressed version 242 MB) |
Excel and Access solution. |
exam25A.avi (40 MB) |
exam25A.avi (uncompressed version 205 MB) |
Excel and Access solution. |
exam25B.avi (44 MB) |
exam25B.avi (uncompressed version 213 MB) |
Excel and Access solution. |
Videos of lessons
Warning: videos are large, be sure to have enough space and enough time available. Do not save them on your UNIBZ disk space or you will make your account go over quota! Right click the mouse button and choose Save Target As... and save them either on a USB pendrive on on your personal computer.
Compressed videos work fin on UNIBZ computers and on every standard Windows installation. In case they do not work correctly on your computer, download the very large and uncompressed version.
excel01.avi 20 MB |
excel01.avi (uncompressed version 184 MB) |
Microsoft Excel introduction, sheet and cells. Cells’ references, columns, rows, name box, formula bar, status bar with autocalculate, sheets tab. Move the pointer. Selection of rectangular and non rectangular areas. Data entry with arrows, with tab and enter. Data types. Force Excel to accept text |
excel02.avi 107 MB |
excel02.avi (uncompressed version 598 MB) |
Values: general, number, currency, date, time, percentage. Formulas. Text. Cell format dialog box. Data entry and conversion: problems with dates and with percentages. Autofill, autoincrement. Copy, paste, paste value only. Importing fixed fields tables, tab-delimited or character-delimited tables. Excel formulas: mathematical operations, typical errors. Cells references: relative, absolute, cell name, formula dragging. Functions and help on functions. Mathematical functions: LOG, LN, PI, SQRT, EXP, ABS, ROUND, ROUNDUP, ROUNDDOWN, MAX, MIN, RAND. |
excel03.avi 52 MB |
excel03.avi |
SUM, PRODUCT, conditional sum SUMIF. Logical functions: IF, AND, NOT, OR. Text functions: TRIM, LEN, RIGHT, LEFT, CONCATENATE, REPT. Date and time functions: date serial format, time decimal format, additions and subtractions, NOW, TODAY, WEEKDAY. |
excel04.avi 75 MB |
excel04.avi (uncompressed version 478 MB) |
Net present value XNPV and internal rate of return XIRR. Internal rate of return: examples of non existence and non uniqueness. Economical meaning of internal rate of return. TAEG and TAN. Mortgage loan with constant rate and constant payments: table, PMT, IPMT, RATE, NPER. |
excel05.avi 44 MB |
excel05.avi (uncompressed version 307 MB) |
Mortgage loan with variable rate: table, variable length, variable payments. Statistical functions: AVERAGE, MEDIAN, STDEV, NORMDIST, NORMINV. |
excel06.avi 134 MB |
excel06.avi (uncompressed version 606 MB) |
Multiple sheets references and multiple files references. Goal seek. Circular reference. Printing: Page setup, Orientation and scaling, Margins and centering, Header and footer, Printing area, Gridlines. Page breaks viewer. Document formats, producing and protecting PDF files. Column size calibration, column hiding and unhiding. Automatic styles. Conditional formatting, managing rules. |
producePDF.avi 8 MB |
producePDF.avi (uncompressed version 72 MB) |
Produce and protect PDF files with Acrobat X. |
excel07.avi 114 MB |
excel07.avi (uncompressed version 525 MB) |
Chart types: 1 data series (Histograms, Line and Area, Pie, Scatter), Multiple data series (Stacked histogram, Stacked lines, Scatter for 2 series, Stacked area). Difference between scatter plot and line plot. Producing charts, switch rows and columns, add and modify data, layout, style, location, plot area features, axis features. Inserting text box with arrow, titles, legend, gridlines and axis scale. Drawings: inserting shapes, green and yellow points, styles, shading, borders, shadow, 3-d effects, relative position, grouping. Sheet protection. Splitting and freezing panes. Inserting comments. Lists (small databases): sorting, filtering. Pictures. Hyperlinks. |
excel08.avi 48 MB |
excel08.avi (uncompressed version 208 MB) |
Pivot table, filtering, sorting, pivot chart. Analysis toolpak installation. Descriptive statistics, histograms, changing bins for histograms. |
access01.avi 63 MB |
access01.avi (uncompressed version 507 MB) |
Northwind database overview. Access overview, Saving operations. Tables, field types, primary key. Queries, query wizard, design view, sorting, criteria. |
access02.avi 65 MB |
access02.avi (uncompressed version 551 MB) |
Using other fields for criteria, asking for values, virtual fields, expression builder, functions DateDiff, DateAdd, Year, Between. |
access03.avi 54 MB |
access03.avi (uncompressed version 500 MB) |
Summary queries, examples, “where” and “group by” |
access04.avi 33 MB |
access04.avi (uncompressed version 398 MB) |
Tables: Fields and fields’ features. Validation rules, table validation rules. Like operator. |
access05.avi 59 MB |
access05.avi (uncompressed version 514 MB) |
Importing tables from Excel. Building new tables. Relations: relationships diagram, building relations, referential integrity, Lookup Wizard, mandatory and non-mandatory value lists. Forms: structure and examples, subform, locking form aand subform. |
Advanced Computer Skills
Videos of practical part of exams
Warning: videos are large, do not leave them on your UNIBZ disk space.
Be sure to right click the mouse button and choose Save Target As...
| exam21.avi | 279 MegaBytes | SPSS solution. |
| exam20.avi | 206 MegaBytes | SPSS solution. |
| exam19a.avi | 118 MegaBytes | SPSS solution. |
| exam19b.avi | 105 MegaBytes | SPSS solution. |
| exam18.avi | 140 MegaBytes | SPSS solution. |
| exam17.avi | 229 MegaBytes | SPSS solution. |
Warning: videos are very large. If you need them, the easiest way is to ask your colleagues. If you still want to download them, be sure to have enough space and enough time available. Do not save them on your UNIBZ disk space or you will make your account go over quota!
Be sure to right click the mouse button and choose Save Target As...
| spss01.avi | 570 MegaBytes |
Statistical tests. Questionnaire structure overview: open, closed, multiple closed answers, nominal, ordinal, scale variable, missing values. |
| spss02.avi | 899 MegaBytes |
SPSS program overview: data view and variable view, output window. SPSS variables: types (text, numerical, date), missing data, measures (scale, ordinal, nominal), variable labels, value labels, missing value label, missing values. Exercise: build variables for the whole example’s questionnaire. Missing data: subject’s missing data, system missing data. SPSS cases and variables, output window. Menus overview. Buttons overview. View labels. Importing data from Excel files, delimited text files, fixed text files. |
| spss03.avi | 683 MegaBytes |
Univariate analysis: frequencies, descriptive statistics, contingency tables and one-dimensional chi-square test, Student’s t test for one population, sign (binomial) test. Bivariate analysis techniques: comparing means, Student’s t test for two unpaired populations, analysis of variance, tests’ significance. |
| spss04.avi |
819 MegaBytes |
Difference between paired and not paired data. Pearson and Spearman’s bivariate correlation. Partial and spurious correlations. Student’s t test for paired data. |
| spss05.avi | 1050 MegaBytes |
Normality assumption and tests: histogram, skewness, kurtosis, Q-Q plot, Kolmogorov-Smirnov test. |
| spss06.avi | 991 MegaBytes
|
Usage of MISSING function. Count values. Exercises on variable calculation. Date and time operations. Missing values replacement. Weighted indexes, indexes for binary variables. Examples on index building with SPSS. |
| spss07.avi | 547 MegaBytes
|
Regression, linear regression, coefficients, R-square, residuals, residual histogram, graph in scatterplot. Non-linear regressions. Logistic regression. |
This page is mantained by Paolo Coletti.
Marisa Crucitti il teatro per ringiovanire Paolo Coletti personal page La stanza dell'arte Paolo Coletti Paolo Associazione culturale e ricreativa Kender Trento Bolzano La stanza dell'arte Marzia Centro Felix Trento Aarghen Thael Il Vecchio Continente GURPS Marisa Crucitti il teatro per ringiovanire Laboratorio d'arte Gabbana cornici Rovereto Nursing Up sindacato infermieri Bolzano ASL Italia Advanced Squad Leader Club scherma Bolzano Bozen Fecht club spada fioretto sciabola