Advanced Excel Laboratory (Verona) (2018/2019)

Learning outcomes

The course "Advanced 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 to all CdL and CdLM students in economics and business administration.

- The lessons will take place in a computer laboratory (48 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 considering that: the working language of the course of the first semester is English and to this course priority will be given to CdLM students; the working language of the course of the second semester is Italian and, as regard to admission to the course, there will be no distinction between CdL and CdLM students.

- To participate to the course it is not required a previous participation to the course “Excel Laboratory”.

- 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:

Friday 12 October 2018, hours 14:00-17:30, room LAB.SMS.4;
Friday 19 October 2018, hours 14:00-17:30, room LAB.SMS.4;
Friday 26 October 2018, hours 14:00-17:30, room LAB.SMS.4;
Friday 9 November 2018, hours 14:00-17:30, room LAB.SMS.4;
Friday 16 November 2018, hours 14:00-17:30, room LAB.SMS.4;
Friday 23 November 2018, hours 14:00-17:30, room LAB.SMS.4.

The tentative calendar of the course of the second semester is the following:

Friday 8 March 2019, hours 14:00-17:30, room LAB.SMS.4;
Friday 15 March 2019, hours 14:00-17:30, room LAB.SMS.4;
Friday 22 March 2019, hours 14:00-17:30, room LAB.SMS.4;
Friday 29 March 2019, hours 14:00-17:30, room LAB.SMS.4;
Friday 5 April 2019, hours 14:00-17:30, room LAB.SMS.4;
Friday 12 April 2019, hours 14:00-17:30, room LAB.SMS.4.

Tutor (first semester): dott. Antonio Pozzo
Tutor (second semester): dott. Antonio Pozzo

For the course of the first semester, it is possible to register from the 3rd of October 2018 to the 11th of October 2018.

For the course of the second semester, it is possible to register from the 3rd of October 2018 to the 28th of February 2019.

Please, register through the elearning platform.

Syllabus

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.

Reference books
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

Assessment methods and criteria

The final examination will consist in a written exam, with an oral examination if necessary.

STUDENT MODULE EVALUATION - 2017/2018