The course "Advanced Excel Laboratory" is an optional "type f" activity, which allows the students to obtain 3 CFU, once a final examination is passed. The course is open to all students in Economics and Business Administration. In particular:
- The course is intended preferably, but not only, for third year students.
- The frequency is compulsory. The student is required to attend at least 2/3 of the exercise lessons/tutorial activity in order to be admitted to the final evaluation.
- The course will start once at least 10 registrations will be collected.
The course consists of 18 hours of exercise lessons and tutorial activity (plus 2 hours of final examination) in computer laboratory (40 seats) delivered as in the following calendar (tentative):
Friday 15 April 2016 - 9.00-12.30
Friday 22 April 2016 - 9.00-12.30
Friday 29 April 2016 - 9.00-12.30
Friday 6 May 2016 - 9.00-12.30
Friday 13 May 2016 - 9.00-12.30
Friday 20 May 2016 - 9.00-12.30
Tutor: dott. Andrea Veronese
Requests for participation will be considered following the registration order. The registration is possible from the 1st of April 2016 to the 14th of April 2016. 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.
|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|
|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.