Information Systems and Data Management course - code 27006

Important warning: this is ISDM course code 27006, for students enrolled to Economics and Management, second semester, first year.

Try the new unibz WMWare: https://desktop.scientificnet.org/ . Further explanations in the FAQ below.

Before the exam:

  1. if you use your own computer, make sure that it works perfectly and everything is installed. If you are using a virtual machine remember to update it the day before, as they usually are switched down for long times: turn it on and press Windows+I -> Update and Security -> Update Now.
  2. check that you are able to locate \\ubz01fst.unibz.it\Courses directory. You will not be helped during the exam on this topic;
  3. if you are using unibz computer and even if you are using your own computer, make sure that you are able to us the computers in classroom A518 and that your unibz account is properly configured and working correctly, in particolar that you are able to save correctly files on your Desktop. Some of you are over quota (see Basic Computer course book in section 2.3.5 if you do not understand what I am talking about) and this can prevent you from saving files on your Desktop. Coming to one of my office hours before the exam can be helpful if you are not sure of this;
  4. do not come to the practical test without having ever logged on your account to check everything.

Mid-term results: insert here your student number

If you wish NOT to use any of your positive grades for the exam, you MUST write to Dr. Paolo Coletti AT LEAST 7 days before your exam.

Lecturer: Dr. Paolo Coletti Paolo.Colettiunibz.it Office E203 - Office hours: www.paolocoletti.it/timetable
Teaching assistant: Dr. Alessio Brutti Alessio.Bruttiunibz.it
Teaching assistant: Dott. Christian Zieger Christian.Ziegerunibz.it
Website: www.paolocoletti.it/informationsystems27006

Course

ISDM27006 course syllabus A.Y. 2016/17.
ISDM27006 course content A.Y. 2016/17.

Prerequisites

In order to correctly follow this course each student is required previous knowledge on these topics:

A detailed list of prerequisites is here. In any case, the teaching assistant will dedicate its first lessons to a precourse on these prerequisites.

Course content

Organization

Hours in standard classroom are unique. Hours in computer room are repeated twice in exactly the same way.

Dr. Coletti is in charge of:

The teaching assistants are in charge of:

How to study for this course

This course is different from the majority of courses you are used to. This course is much more technical than theoretical and it is strictly sequential. This means that you have to adapt your study strategy. First of all, you either attend all the lessons (or compensate for missing lessons watching immediately the corresponding videos or reading the book) or it is really not worth coming to the next one, you will disturb your neighbours asking for help not realizing that your lack of understanding is due to your missing knowledge and not my speed. Moreover, after each practical lesson you must repeat slowly on your own the examples done in class in order to be sure to have fully graped the explained concepts before the next lesson. This is also true for the lessons on database theory, for which the concepts in the first lesson are crucial to understand the next one.

For the exam the main difference with respect to other courses is that you have to train much more than studying. The content of this course is easy and does not need extensive study, however it is only with practice that you become skilled enough.

Exam

Exam is divided into two parts.

The first part is held in a standard classroom all students together. This part's time is 45 minutes, but may vary according to the complexity of exercises. This part is completely on paper and "closed book": no paper nor electronic help or tool is allowed. It consists in

The second part is held in computer room in turns of 25 students each. Turns will appear on this website as soon as enrollment is closed. This part's time is 45 minutes, but may vary according to the complexity of exercises. If you have specific timetable's needs, please write an email to Dr. Coletti as soon as possible, before the timetable appears. This part is totally open books: you may use any written or electronic document (including books, previous exams with solutions, your personal handwritten or electronic notes and my slides). You may not, however, use any communication program or device. This part consists in

Important warning: the crucial point of second part of exam (and of the second mid-term) is time. If you never practice with Access and Excel, you will still be able to do the exam but you will waste a lot of time looking for the commands and you will not finish it in time. Only with exercises will you be fast enough to complete it in the indicated time. It is a good idea to practice with a clock on the previous exams that you find below.

First mid-term: the first mid-term is on the theoretical questions and it is done at the end of basic computer classes (currently planned on 6 March 2017 14:00, but may change in case of problems). It is identical to an exam's exercise. This mid-term is totally closed books, no dictionary, no calculator. The students who reach at least 60% use this grade to skip the theoretical questions at the exam and have the right to do the other mid-terms. Students who do not participate or who do not reach 60% may not participate in the other mid-terms, no exceptions.

Second mid-term: the second mid-term is an Excel exercise (no Access, which everybody will do at exam), identical to an exam's Excel exercise and it is done at the end of Excel classes (currently planned on 21 April 2017, 16-20 in turns, but may change in case of problems). Only students who got at least 60% on the first mid-term may participate. This mid-term is totally open books: you may use any written or electronic document (including books, previous exams with solutions, your personal handwritten or electronic notes and my slides). You may not, however, use any communication program or device. The students who reach at least 60% use this grade to skip the Excel exercise at the exam.

Third mid-term: the third mid-term is a database exercise, identical to an exam's database exercise and it is done at the end of databases classes (currently planned on 4 May 2017 16:00, but may change in case of emergency). Only students who got at least 60% on the first mid-term may participate. This mid-term is totally closed books, no dictionary, no calculator. The students who reach at least 60% use this grade to skip the database exercise at the exam.

Mid-terms are independent, you do not need to pass all of them. The only constraint is to pass the first one, otherwise you may not participate in the other ones.
Your mid-terms grades will last until the last session of current A.Y., even if you fail an exam. If you do NOT want to use one of your mid-terms grades in an exam because it is too low for you, you MUST write an email to dr. Paolo Coletti AT LEAST 7 days before the exam.

There is no 60% minimum per exercise at the exams, this rules applies only to mid-terms. Mid-terms attempts do not count as exam's attempts towards the limit of two exams per year (if regulations do not change).

Differences from A.Y. 2015/16

Please, if you followed the course in A.Y. 2015/16 take note of these important differences:

Study resources

Topic
Lessons' slides
Exercises' slides
Videos as alternative to attendance
Books as alternative to attendance
Theory

- Computer introduction
- Windows
- Computer networks

 

Precourse video down here

(for the rest of this part use the book)

Basic Information Systems book
Excel
Excel

Excel

Extra exercises on data analysis

Exercise book and its solutions

Go down here for lessons videos

Videos of some exercises classes are also available

Financial Functions course book
Both these:
- Excel 2007 for Dummies: Chapters 2-5, 6 (pages 209-215, 227-229), 7 (pages 231-240), 8, 9, 10 (pages 287-308), 11 (pages 329-332)
- Excel 2007 Data Analysis for Dummies: Chapters 2 (pages 37-44), 3 (pages 66-71), 4-7, 9 (183, 185, 188, 195, 197, 199-202), 10 (223-231), 12 (263-274)

Relational databases
Relational databases

Relational databases and
Solutions

Go down here

Databases course book
Access
Access

(no slides)

Exercise book (same as above)

Go down here

 

Files used in class

All files in one package (excluding slides)

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

Videos of lessons

Warning: videos are large, your best choice is watching them online from YouTube.

If you really 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! Right click the mouse button and choose Save Target As... and save them either on a USB pendrive on your personal computer. If you have a Mac and the video does not open with QuickTime, try to install and use program VLC http://www.videolan.org/vlc/download-macosx.html

precourse.avi
97 MB
YouTube Precourse for Windows 10 on unibz network and file handling, first part.
precourse 02.avi
74 MB
YouTube Precourse for Windows 10 on unibz network and file handling, second part.
precourse Mac 01
176 MB
YouTube Precourse for Mac on unibz network and file handling, first part.
precourse Mac 02
173 MB
YouTube Precourse for Mac on unibz network and file handling, second part.
excel01.avi
65 MB
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.
excel02.avi
158 MB
YouTube 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, formula dragging. Functions and help on functions. Mathematical functions: LOG, LN, PI, SQRT, EXP, ABS, ROUND, ROUNDUP, ROUNDDOWN, RAND, RANDBETWEEN. MAX, MIN, SUM.
excel03.avi
104 MB
YouTube AVERAGE, SUMIF, COUNTIF, AVERAGEIF. Logical functions: IF, AND, NOT, OR. Text functions: LEN, RIGHT, LEFT, CONCATENATE, REPT.
YouTube

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

excel05.avi
100 MB
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.
vba01.avi
69 MB
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.avi
36 MB
YouTube Range as parameter, .Cells.Count, .Rows.Count .Columns.Count, For Each Next, Summing
excel06.avi
156 MB
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.
excel07.avi
73 MB
YouTube Document formats, PDF files. Column size calibration, column hiding and unhiding. Automatic styles. Conditional formatting, managing rules.
excel08.avi
79 MB
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.
excel09.avi
152 MB
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.

databases01.avi
107 MB
YouTube

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

databases02.avi
83 MB
YouTube

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

databases03.avi
122 MB
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.avi
63 MB
YouTube

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

access02.avi
65 MB
YouTube

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

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.

YouTube

This short video illustrates how to reach unibz network folder \\ubz01fst (which contains course_coletti and your own personal stuff) using VPN when you are connected from outside university or when you are connected using wifi.
This procedure is not part of exam's stuff.

excel exercises 01
141 MB
YouTube 00:00 basic Excel; 04:40 file types; 08:00 importing text files; 23:20 automatic series. Video by CZ
excel exercises 02
161 MB
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

excel exercises 03
142 MB
YouTube 00:00 logical functions; 23:00 aggregate functions SUMIF COUNTIF AVERAGEIF. Video by CZ
excel exercises 04
156 MB
YouTube 00:00 text functions; 04:50 date functions, ONLY for ISDM 27006; 18:50 DATEDIF function, ONLY for ISDM 27006; 25:20 statistical functions. Video by CZ
excel exercises 05
173 MB
YouTube Charts

Exam

Before the exam or the practical mid-term:

  1. if you use your own computer, make sure that it works perfectly and everything is installed;
  2. check that you are able to locate \\ubz01fst.unibz.it\Courses directory. You will not be helped during the exam on this topic;
  3. if you are using unibz computer and even if you are using your own computer, make sure that you are able to us the computers in classroom A518 and that your unibz account is properly configured and working correctly, in particolar that you are able to save correctly files on your Desktop. Some of you are over quota (see Basic Computer course book in section 2.3.5 if you do not understand what I am talking about) and this can prevent you from saving files on your Desktop. Coming to one of my office hours before the exam can be helpful if you are not sure of this;
  4. do not come to the practical test without having ever logged on your account to check everything.

Frequently Asked Questions

Q: I have a Windows notebook. What do I need to attend this course and take the exam?
A:
You have several options. Solutions 1 and 4 are my favourite ones.
1) Install everything in English on your computer. You can download 7-Zip from www.7-zip.org for free. You can get Windows 10 (in case you need it, but Windows 8 and 7 are fine) from http://knowledge.scientificnet.org/software entering with your UNIBZ login and legally install it on your own computer. For Office 2016 for Windows, follow the installation instructions on http://knowledge.scientificnet.org/software for Office 365 and then you will find a link to install Office 2016 on your computer. If you already have Office 2013 or 2010 in English they are just fine, you will have some menus slightly different.
2) Keep what you have in your own language. For Windows or 7-Zip (or anyother good compression program) another language is just fine. For Office you will have menus and dialogues in another language, which can be annoying, but in particular all Excel functions will have completely different name. Attend the lessons with the Excel function translation printed next to you and become familiar with your functions' names for the exam. If you have an edition of Office without Access, you can use Access through the following solutions.
3) Use VMware via web. Go here https://desktop.scientificnet.org , choose the HTML access and enter with your unibz login. You will have Windows Labs, which is a virtualized Windows computer, with all the course's programs installed. Alternatively you can use each specific program alone, without the burden of Windows. Pay attention that in this way you will have access only to the \\ubz01fst network disk (My PC or Local Disks are the unibz ones, not yours), not to your own computer's disks. There won't be any problems for the exam nor for attending the course, but it can be annoying.
4) Use VMware via client. Go here https://desktop.scientificnet.org and choose to install the VMware client and choose desktop.scientificnet.org when it asks you the server address. From Settings -> Options Tab -> Shared Folders you can enable access to local disks. The rest is as the previous solution, with the big advantage of speed and access also to your own computer's files.

Q: I have a Mac notebook. What do I need to attend this course and take the exam?
A:
You have several options. Solutions 1, 4 and 6 are my favourite ones.
1) Install almost everything in English on your computer. You can download compression program Keka from www.kekaosx.com/en/ for free. You can get Office 2016 from http://knowledge.scientificnet.org/software entering with your UNIBZ login and legally install it on your own computer. If you already have Office 2013 or 2011 in English they are just fine. In this case you must write me an email at least 7 days before the exam, as I have to check that your exercise works fine on Excel for Mac. For Access, which does not exist for Mac, you will need to use solution 4, 5 or 6 (5 is my suggested one, in this case).
2) Keep what you have in your own language. For the operating system and Keka (or anyother good compression program) another language is just fine. For Office you will have menus and dialogues in another language, which can be annoying, but in particular all Excel functions will have completely different name. Attend the lessons with the Excel function translation printed next to you and become familiar with your functions' names for the exam. In this case you must write me an email at least 7 days before the exam, as I have to check that your exercise works fine on Excel for Mac. For Access, which does not exist for Mac, you will need to use solution 4, 5 or 6 (5 is my suggested one, in this case).
3) You can partition your hard disk in two parts and install Windows in the other part. There are many tutorials on the web how to do it, for example see http://support.apple.com/kb/ht1461. The ISO image for Windows and Office with unibz license are here: http://knowledge.scientificnet.org/software . In this way you will have a perfect copy of Windows and Office, including Access, installed at unibz.
4) You can install Windows on a virtual machine using free program VirtulBox which is free. In case you are interested, here are the instructions: https://www.howtogeek.com/186907/how-to-install-windows-on-a-mac-with-boot-camp/ , and here you get the ISO image for Windows and Office with unibz license here: http://knowledge.scientificnet.org/software .
5) Use VMware via web. Go here https://desktop.scientificnet.org , choose the HTML access and enter with your unibz login. You will have Windows Labs, which is a virtualized Windows computer, with all the course's programs installed. Alternatively you can use each specific program alone, without the burden of Windows. Pay attention that in this way you will have access only to the \\ubz01fst network disk (My PC or Local Disks are the unibz ones, not yours), not to your own computer's disks. There won't be any problems for the exam nor for attending the course, but it can be annoying.
6) Use VMware via client. Go here https://desktop.scientificnet.org and choose to install the VMware client and choose desktop.scientificnet.org when it asks you the server address. From Preferences -> Sharing you can enable access to local disks. The rest is as the previous solution, with the big advantage of speed and access also to your own computer's files.

Q: I have a Linux notebook. What do I need to attend this course and take the exam?
A:
You have few options. Solution 2 is my favourite one.
1) Use VMware via web. Go here https://desktop.scientificnet.org , choose the HTML access and enter with your unibz login. You will have Windows Labs, which is a virtualized Windows computer, with all the course's programs installed. Alternatively you can use each specific program alone, without the burden of Windows. Pay attention that in this way you will have access only to the \\ubz01fst network disk (My PC or Local Disks are the unibz ones, not yours), not to your own computer's disks. There won't be any problems for the exam nor for attending the course, but it can be annoying.
2) Use VMware via client. Go here https://desktop.scientificnet.org and choose to install the VMware client and choose desktop.scientificnet.org when it asks you the server address. From the settings you can enable access to local disks. The rest is as the previous solution, with the big advantage of speed and access also to your own computer's files.

Q: I have no notebook. What do I need to attend this course and take the exam?
A:
You can use the computer of the exam room for the exam and borrow a notebook from unibz library for the course. Alternatively, if you have a large tablet, you can try one of these solutions (2 is my favourite) for attendance only.
1) Use VMware via web. Go here https://desktop.scientificnet.org , choose the HTML access and enter with your unibz login. You will have Windows Labs, which is a virtualized Windows computer, with all the course's programs installed. Alternatively you can use each specific program alone, without the burden of Windows. Pay attention that in this way you will have access only to the \\ubz01fst network disk (My PC or Local Disks are the unibz ones, not yours), not to your own computer's disks. There won't be any problems for the exam nor for attending the course, but it can be annoying.
2) Use VMware via client. Go here https://desktop.scientificnet.org and choose to install the VMware client and choose desktop.scientificnet.org when it asks you the server address. From the settings you can enable access to local disks. The rest is as the previous solution, with the big advantage of speed and access also to your own tablet's files.

Q: How can I reach network folder \\ubz01fst from outside unibz or connected via wifi?
A: For Windows users: if you are connected to wifi ScientificNetwork try to digit in any explorer address bar \\ubz01fst.unibz.it and see whether you reach it. You need to provide your login and password, but you need to tell to your computer that you are using a different domain and then you have to type unibz\loginname instead of simply loginname. If this fails or if you are no connected to ScientificNetwork, then you need to install VPN. There is a specific video up here.
For Mac users: if you are connected to wifi ScientificNetwork, Finder -> Go -> Connect to server -> smb://ubz01fst.unibz.it . You need to provide your login and password, but you need to tell to your computer that you are using a different domain and then you have to type unibz\loginname instead of simply loginname.

Q: May I fix an appointment to talk with you?
A: I do not fix personal appointments. I have office hours explicitely dedicated to this task, which I try to scatter evenly during the semester with a higher frequency before exams. In any case all the office hours are open to everybody, so you may come also to office hours of my other courses, see list on www.paolocoletti.it/timetable. Obviously you may always ask me questions via email (please, state clearly which course are you talking about and what is your problem).

Q: When will the next exam be? Can you give me a hint on the exam's date because I have to catch a plane? Can you move the exam's date? Can you fix the exam's date on the week I suggest?
A: Please stop writing me emails on this topic. Exam date appears on your timetable as soon as it is official. If you have something to say about it, contact your students' speaker who is the only one who can submit requests on students' behalf.

Q: May I take 27000 exam as part of 27006 exam? May I take 27000 exam at the day of 27006 exam? May I take 27006 exam instead of 27000 exam? May I take 27006 exam at the day of 27000 exam?
A: No, no, no, no. Even though 27000 and 27006 have partly a similar content, the two courses are different, with different content, with two different exams done with different procedures in (usually) different days and sessions. You may not come to the other exam nor you may do a part of your exam during the day of the other one. Please, consider these two exams as if they had completely different names. Discover exactly what your exam is, checking carefully your study plan and asking to the secretary in case of doubt. The right lessons and exams should appear in your timetable. I do not take any responsibility if you attend the wrong course or, even worse, if you show up at the wrong exam.

Q: I may not enrol online for technical or administrative reasons or I forgot to enrol or it is my third attempt and I cannot enrol. Can I do the exam anyway?
A: No, I may not let non-enrolled students take part of the exam. Do not ask me to do illegal things! Ask the secretary whether there is something they can do.

Q: May I do the exam with my computer?
A: Sure. But beware: (1) you must be able to navigate the Internet and to enter directory \\ubz01fst.unibz.it\Courses\Course_Coletti. Do not wait for the day before the exam to check it. (2) You are responsible for your programs and configurations and for the absence on your computer of specific programs.
In any case you will have a unibz desktop computer in front of you.

Q: Will the exam be similar to the previous ones?
A: Sure, but every year I add the new topics and do not ask topics which were removed from the syllabus. These parts usually appear as stricken out in the exam's text and appear always in the solution and videosolution.

Q: I am a student of course XYZ. Which exam do I have to take?
A:
Some situations are very complex, therefore the only place which you must trust is your student's portal. You should see there all your exams and their respective code and you should see lessons and exams on your timetable. In case of doubt, ask the secretary. Please discover exactly which one is your exam. I do not take any responsibility if you attend the wrong course or, even worse, if you show up at the wrong exam.

Q: Help me! I can not save my files.
A: Before the exam you must empty your email folders of all the big stuff you have inside. Moreover go to \\ubz01fst\students, locate your directory, and searching through all your subdirectories delete all the big or not necessary files. In this way you will have enough space to save everything. If you cannot save due to a shortage of disk space, we can not and will not do anything to help you.

Q: I lost a file during the exam because I did not save it correctly. What may you do?
A: Absolutely nothing. With time spent on exercises you should know the unreliability level of your programs, and how often you have to save.

Q: My files were not copied correctly at the end of the exam. What may I do?
A: Checking that the copy is correct, and practising file copy even during the exam, is your task and is official part of the evaluation for this course.

Q: Hey, exam's time is not enough! I could not even finish it. If I only had other 5 minutes I would have done it much better!
A: Sorry but you are wrong, as I calculate more than twice the needed time. Look at the important warning after exam's explanation: the fact that for you exam's time was not enough is instead an indication that you must do many more exercises to be efficient and fast enough. On the other hand, if you have documented medical problems that slow your operations, write an email to me to have more time.

Previous exams

Warning: videos are large, your best choice is watching them online from YouTube.

Session
Exam link
Solution link
Video solution
Video solution
September 2017 - 58
exam
suggested solution
YouTube
July 2017 - 57
exam
suggested solution
A YouTube B YouTube C Access only YouTube
Mid-term 2017 - 56
exam
suggested solution
A YouTube A for Mac YouTube B YouTube C YouTube
Winter 2017 - 55
exam
suggested solution
YouTube

 

Autumn 2016 - 51
exam
suggested solution
YouTube

 

Summer 2016 - 50
exam
suggested solution
A YouTube B YouTube C YouTube

 

Winter 2016 - 48
exam
suggested solution
YouTube

exam48.avi
(68 MB)

Autumn 2015 - 45
exam
suggested solution
YouTube
exam45.avi
(83 MB)
Summer 2015 - 43
exam
suggested solution
A YouTube B YouTube C YouTube
exam43A.avi
(50 MB)
exam43B.avi
(59 MB)
exam43C.avi
(65 MB)
Winter 2015 - 42
exam
suggested solution
YouTube
exam42.avi
(67 MB)
Autumn 2014 - 40
exam
suggested solution
YouTube
exam40.avi
(74 MB)
Summer 2014 - 38
exam
suggested solution
A YouTube B YouTube

exam38A.avi
(58 MB)
exam38B.avi
(60 MB)

Autumn 2013 - 35
exam
suggested solution
YouTube
exam35.avi
(64 MB)
Summer 2013 - 34
exam
suggested solution
YouTube
exam34.avi
(49 MB)
autumn 2012 - 32
exam
suggested solution
YouTube
exam32.avi
(60 MB)
spring 2012 - 31
exam
suggested solution
A YouTube B YouTube
exam31A.avi
(79 MB)
exam31B.avi
(61 MB)
autumn 2011 - 30
exam
suggested solution
YouTube
exam30.avi
(38 MB)
autumn 2011 - 29
exam
suggested solution
YouTube
exam29.avi
(45 MB)
summer 2011 - 28
exam
suggested solution
YouTube
exam28.avi
(80 MB)
summer 2011 - 27
exam
suggested solution
YouTube
exam27.avi
(69 MB)
spring 2011 - 26
exam
suggested solution
A YouTube B YouTube
exam26A.avi
(38 MB)
exam26B.avi
(52 MB)
spring 2011 - 25
exam
suggested solution
A YouTube B YouTube
exam25A.avi
(40 MB)
exam25B.avi
(44 MB)
autumn 2010 - 24
exam
suggested solution
Warning: these exams are not updated any more to the current course's modifications.
You might thus find questions or requests which are not part of the course anymore.
summer 2010 - 23
exam
suggested solution

summer 2010 - 22

exam
suggested solution
autumn 2009 - 21
exam
suggested solution

autumn 2009 - 20

exam
suggested solution
summer 2009 - 19
exam
suggested solution

summer 2009 - 18

exam
suggested solution
autumn 2008 - 17
exam
suggested solution

autumn 2008 - 16

exam
suggested solution
summer 2008 - 15
exam
suggested solution

summer 2008 - 14

exam
suggested solution

autumn 2007 - 13

exam
suggested solution
summer 2007 - 12
exam
suggested solution
summer 2007 - 11
exam
suggested solution

summer 2007 - 10

exam
suggested solution
autumn 2006 - 9
exam
suggested solution
autumn 2006 - 8
exam
suggested solution
summer 2006 - 7
exam
suggested solution
summer 2006 - 6
exam
suggested solution
summer 2006 - 5
exam
suggested solution
prototype A.Y. 2005/06 - 4
exam
suggested solution

This page is maintained 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