Warning: this course in Bruneck does not exist anymore!!! The website is ONLY for the exam. This is not 27000, not 27006, not 27324.

Study resources

Topic
Lessons’ slides
Exercises’ slides
Videos
Books
Theory

– Computer introduction


– Precourse


– Computer networks

– Cryptocurrencies and blockchain technology

 

Precourse video below

Cryptocurrencies video below

Dark web video below

for the rest of this part use the book on the side

Basic Information Systems book
Excel

Excel

Files for lessons

Excel function translation for those who have Excel in German or Italian

All material

Go below for lessons videos

Go below for exercises videos

 
Relational databases
Relational databases

Relational databases and
Solutions

Go below here

 
Access
Access

Databases

Go below here

 

Videos of lessons

Video Title
Link
Description
precourse 01
YouTube Precourse for Windows 10 on unibz network and file handling, first part.
precourse 02
YouTube Precourse for Windows 10 on unibz network and file handling, second part.
precourse Mac 01
YouTube Precourse for Mac on unibz network and file handling, first part.
precourse Mac 02
YouTube Precourse for Mac on unibz network and file handling, second part.
cryptocurrencies and blockchain technology
YouTube A decentralised currency, basic cryptography, Bitcoin history and technology, blockchain technology, advantages and criticisms
A dive into the Dark Web
YouTube Video for educational purposes only. I forbid you from doing illegal activities.
excel 01
YouTube How to activate files’ extensions. How to set decimal and list separator for Windows and for Excel. Microsoft Excel introduction, sheet and cells. Cells’ references, columns, rows, name box, formula bar, status bar with autocalculate, sheets tab, sheets operations. Selection of rectangular and non rectangular areas. Data types. Force Excel to accept text. 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 02
YouTube Excel formulas: mathematical operations, typical errors. Cells references: relative, absolute, formula dragging. Functions and help on functions. Mathematical functions: LOG, LN, PI, SQRT, EXP, ABS, ROUND, ROUNDUP, ROUNDDOWN, RAND, RANDBETWEEN. MAX, MIN, SUM.
excel exercises 01
YouTube 00:00 basic Excel; 04:40 file types; 08:00 importing text files; 23:20 automatic series. Video by CZ
excel exercises 02
YouTube

00:00 references; 02:20 functions; 04:15 mathematical functions; 14:50 relative and absolute references; 26:55 references from other sheets. Video by CZ

excel03
YouTube AVERAGE, SUMIF, COUNTIF, AVERAGEIF. Logical functions: IF, AND, NOT, OR. Text functions: LEN, RIGHT, LEFT, CONCATENATE, REPT.
excel exercises 03
YouTube 00:00 logical functions; 23:00 aggregate functions SUMIF COUNTIF AVERAGEIF. Video by CZ
excel04
YouTube

Date and time functions: date serial format, time decimal format, additions and subtractions, NOW, TODAY, WEEKDAY, DAY, MONTH, YEAR, DATE, DATEDIF.

excel exercises 04
YouTube 00:00 text functions; 04:50 date functions, 18:50 DATEDIF function; 25:20 statistical functions. Video by CZ
excel05
YouTube 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. Mortgage loan with variable rate: table, variable length, variable payments.
excel exercises 05 (finance)
YouTube 00:00 financial functions, 17:54 mortgage loans, 31:50 adjustable mortgage loan. Video by AB
vba01
YouTube Visual Basic for Applications user-defined functions. Function declaration, optional parameters, comments, MsgBox, If Then Else, ElseIf, Nested Ifs. n Internal functions: Ucase , Left, Sqr.
vba02
YouTube Range as parameter, .Cells.Count, .Rows.Count .Columns.Count, For Each Next, Summing
VBA exercises
YouTube Video by AB
excel06
YouTube Statistical functions: STDEV.S, VAR.S, NORM.DIST, NORM.INV. Multiple sheets references and multiple files references. Goal seek. Scenario manager. Assigning cell’s name. Sensitivity analysis with data table. Excel solver. Printing: Page setup, Orientation and scaling, Margins and centering, Header and footer, Printing area, Gridlines. Page breaks viewer.
excel exercises 06
YouTube 00:00 Scenario Manager, 13:48 Datatable, 27:58 Goal Seek. Video by AB
excel07
YouTube Document formats, PDF files. Column size calibration, column hiding and unhiding. Automatic styles. Conditional formatting, managing rules.
excel08
YouTube Charts: chart wizard, selecting non-rectangular areas, changing data range and custom series, add and modify data, layout, style, location, plot area features. Axis features, legend, titles, labels, pie chart features.
Chart types for 1 data series: column, bar, line, area, pie. Multiple data series: selecting non-rectangular areas, clustered and stacked column/bar/line/area, scatterplot, bubble. Difference between scatter plot and line plot. Selection of non-rectangular areas. Illustrations’ shapes: non transparent text box, arrow.
excel exercises 07
YouTube Charts. Video by AB
excel exercises 08 (solver)
YouTube Video by AB
excel09
YouTube

Sheet protection. Splitting and freezing panes. Inserting comments.
Lists (small databases): sorting, filtering. Pictures. Hyperlinks.
Pivot table, filtering, sorting, pivot chart, grouping.
Analysis toolpak installation. Descriptive statistics, histograms, changing bins for histograms.

excel exercises 09 (solver 3.3 and 3.6 )
YouTube Solution of extra exercises 3.3 and 3.6. Video by AB
excel exercises 10
YouTube 00:00 statistics with Excel, 07:12 Pivot table, 15:40 Tax exercise, 28:00 data table on tax exercise. Video by AB
databases01
YouTube

Single table database in normal form, primary key, information redundancy, empty fields, one-to-many and many-to-one relations, foreign key.

databases02
YouTube

One-to-one relations, many-to-many relations, junction table, temporal databases.

databases03
YouTube

Junction tables for more relations, details table, foreign keys with more relations, orphans and referential integrity, hierarchical structure, process structure. Suggestions for database design.

access01
YouTube

Northwind database overview. Access overview, Saving operations. Tables, field types, primary key. Queries, query wizard, design view, sorting, criteria.

access02
YouTube

Using other fields for criteria, asking for values, virtual fields, expression builder, functions DateDiff, DateAdd, Year, Between.

access03
YouTube

Summary queries, examples, “where” and “group by”
Reports: structure and examples. Exporting and printing reports.
Tables: Fields and fields’ features. Validation rules, table validation rules. Like operator.
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 and subform.

Access exercise 6.1
YouTube  
Access exercise 6.2
YouTube  
Access exercise 6.3
YouTube  

 

Session
Exam link
Solution link
Video solution
Autumn 2021 – 80
YouTube
Summer 2021 – 78
Winter 2019 – 67
YouTube
September 2018 – 64
YouTube
Summer 2018 – 63
Mid-terms 2018 – 62
YouTube   BYouTube
Winter 2018 – 61
YouTube
September 2017 – 58
YouTube
July 2017 – 57
Mid-term 2017 – 56
Winter 2017 – 55
YouTube
Autumn 2016 – 51
YouTube
Summer 2016 – 50
Winter 2016 – 48
YouTube
Autumn 2015 – 45
YouTube
Summer 2015 – 43
Winter 2015 – 42
YouTube
Autumn 2014 – 40
YouTube
Summer 2014 – 38
Autumn 2013 – 35
YouTube
Summer 2013 – 34
YouTube
autumn 2012 – 32
YouTube
spring 2012 – 31
autumn 2011 – 30
YouTube
autumn 2011 – 29
YouTube
summer 2011 – 28
YouTube
summer 2011 – 27
YouTube
spring 2011 – 26
spring 2011 – 25

Powered by Paolo Coletti

2022 All right reserved