Laboratory Excel (2015/2016)

Course code
4S003565
Name of lecturer
Marco Minozzo
Coordinator
Marco Minozzo
Number of ECTS credits allocated
3
Other available courses
Academic sector
NN - -
Language of instruction
Italian
Period
not yet allocated

Learning outcomes

The course "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 for students in Economics and Business Administration. In particular:

- The course is intended preferably, but not only, for second and third year students.

- The frequency is compulsory. The student is required to attend at least the 70% 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 20 hours of exercise lessons and tutorial activity in computer lab (50 seats) delivered as in the following calendar (tentative):

Friday 16 October 2015 - 14.00-17.30
Friday 23 October 2015 - 14.00-17.30
Friday 13 November 2015 - 14.00-17.30
Friday 20 November 2015 - 14.00-17.30
Friday 27 November 2015 - 14.00-17.30
Friday 4 December 2015 - 14.00-17.30
Friday 8 January 2016 - 14.00-17.30

Tutor: to be announced

Requests for participation will be considered following the registration order. The registration is possible from the 5th of October 2015 to the 15th of October 2015. 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
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 opinions - 2015/2016