The course "Excel Laboratory" is an optional "type f" activity, which allows to students to obtain 3 CFU, once a final examination is passed. In particular:
- The course is open, but not exclusively, to all CdL students in economics and business administration; in particular to second year students.
- The lessons will take place in a computer laboratory (40 seats).
- There will be two courses, one in the first semester and another one in the second semester.
- Requests for participation will be considered following the registration order; CdL students will have priority over CdLM students.
- The frequency to the classes is compulsory. Students are required to attend at least 2/3 of the exercise lessons/tutorial activity in order to be admitted to the final evaluation.
- The course consists of 18 hours of exercise lessons and tutorial activity (plus 2 hours of final examination).
The tentative calendar of the course of the first semester is the following:
Thursday 18 October 2018, hours 14:00-17:30, computer laboratory;
Thursday 25 October 2018, hours 14:00-17:30, computer laboratory;
Thursday 15 November 2018, hours 14:00-17:30, computer laboratory;
Thursday 22 November 2018, hours 14:00-17:30, computer laboratory;
Thursday 29 November 2018, hours 14:00-17:30, computer laboratory;
Thursday 6 December 2018, hours 14:00-17:30, computer laboratory.
The tentative calendar of the course of the second semester is the following:
Monday 4 March 2019, hours 14:00-17:30, computer laboratory;
Monday 11 March 2019, hours 14:00-17:30, computer laboratory;
Monday 18 March 2019, hours 14:00-17:30, computer laboratory;
Monday 25 March 2019, hours 14:00-17:30, computer laboratory;
Monday 1 April 2019, hours 14:00-17:30, computer laboratory;
Monday 8 April 2019, hours 14:00-17:30, computer laboratory.
Tutor (first semester): dott.ssa Valeria Battistella
Tutor (second semester): dott.ssa Valeria Battistella
For the course of the first semester, it is possible to register from the 5th of October 2018 to the 17th of October 2018.
For the course of the second semester, it is possible to register from the 5th of October 2018 to the 28th of February 2019.
Please, register through the elearning platform.
The program of the course will start with an introduction to Excel and its main functions. Then, some of the topics encountered in Mathematics and Statistics courses will be considered, as for example, matrix algebra, optimization and interpolation. The course aims at improving the computational skills of the students and at providing instruments useful for the subsequent thesis work. The activity will allow to improve the knowledge of Excel, a software which is highly requested in the job market.
| Author | Title | Publisher | Year | ISBN | Note |
| M. R. Middleton | Analisi statistica con Excel | Apogeo, Milano | 2004 | ||
| D. Giuliani, M. M. Dickson | Analisi statistica con Excel | Maggioli Editore | 2015 | 8838789908 | |
| F. P. Borazzo, P. Perchinunno | Analisi statistiche con Excel | Pearson, Education | 2007 | ||
| Francesco Borazzo, Angelo Roffo | Business Intelligence con Excel: Tabelle pivot, macro, formule e funzioni al servizio dei processi aziendali (Edizione 1) | APOGEO | 2017 | 9788850334230 | |
| Mike Davis | Costruire applicazioni con Excel 2016: Dal foglio di calcolo alle tabelle pivot, le macro e il linguaggio VBA (Edizione 1) | APOGEO | 2017 | 9788850334223 | |
| Curtis Frye | Microsoft Excel 2016: La guida ufficiale (Edizione 1) | Hoepli | 2016 | 9788820374785 | |
| E. Battistini | Probabilità e statistica: un approccio interattivo con Excel | McGraw-Hill, Milano | 2004 | ||
| P. Klibanoff, A. Sandroni, B. Moselle, B. Saraniti | Statistica per manager (Edizione 1) | Egea | 2010 | 9788823821347 | |
| D. M. Levine, D. F. Stephan, K. A. Szabat | Statistics for Managers Using Microsoft Excel, Global Edition (Edizione 7) | Pearson | 2014 | 0133061817 |
The final examination will consist in a written exam, with an oral examination if necessary.
