Excel Laboratory (Verona) (2019/2020)

Learning outcomes

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, of the Verona campus, of the School of Economics and Management; in particular to second year students.

- The lessons will take place in a computer laboratory (48 seats).

- There will be three courses, two in the first semester (class E1 and class E2) and another one in the second semester.

- Requests for participation will be considered following the registration order. All CdL and CdLM students, of the Verona campus, of the School of Economics and Management can register. CdL students will have priority over CdLM students. Students are required to be present at the first lesson, or to send an email to the tutor to comunicate their absence.

- 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 class E1 of the first semester is the following:

Friday 11 October 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 18 October 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 25 October 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 8 November 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 15 November 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 22 November 2019, hours 14:00-17:00, room LAB.SMS.8;
Friday 29 November 2019, hours 14:00-17:00, room LAB.SMS.8 (final exam).

The tentative calendar of class E2 of the first semester is the following:

Monday 14 October 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 21 October 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 28 October 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 11 November 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 18 November 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 25 November 2019, hours 14:00-17:00, room LAB.SMS.4;
Monday 9 December 2019, hours 14:00-17:00, room LAB.SMS.4 (final exam).

The tentative calendar of the course of the second semester will be available as soon as possible.


Tutor (first semester, class E1): dott. Alessandro Cipolla
Tutor (first semester, class E2): dott.ssa Valeria Battistella
Tutor (second semester): to be announced

For the courses (class E1 and class E2) of the first semester, it is possible to register from the 5th of October 2019 to the 10th of October 2019.

For the course of the second semester, it is possible to register from the 5th of October 2019 to the 23rd of February 2020.

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
D. Giuliani, M. M. Dickson Analisi statistica con Excel Maggioli Editore 2015 8838789908
M. R. Middleton Analisi statistica con Excel Apogeo, Milano 2004
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
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

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 final examination will consist in a written exam, with an oral examination if necessary, on the use of the software Excel. There will be just one date for the final examination.