MANAGEMENT ENGINEERING | University of Parma

Professor: Francesco ZAMMORI
Academic discipline: Sistemi di elaborazione delle informazioni (ING-INF/05)
Field: Attività formative affini o integrative
Type of training activity: Related/supplementary

24 hours
of face-to-face activities

3 credits

hub: -

course unit
in ITALIAN

lectures timetable unavailable

exam calls

Integrated course unit module: INFORMATION SYSTEMS FOR MANAGEMENT

Learning objectives

By the end of the course, students will master Excel 365, for data analysis and numerical calculation.
In particular, they will be able to analyze data and to create control dashboards.

Prerequisites

The course requires a good knowledge of the main functionality of Excel.
However, to foster the comprehensions, basic topics will be recalled if needed.

Course unit content

The course introduces advanced tools and functionality of Excel 365 for data analysis and dashboarding.

Full programme

- Recaps on logical functions and conditional formatting.
- Lookup functions.
- Lambda and Let functions: how to create personalized functions.
- Creating array with MAP and MAKEARRAY functions.
- Recaps on data sorting, filtering and Pivot Table.
- Advanced sorting and filtering techniques.

Bibliography

1) Analisi Dati con Excel 2013, di Francesco Borazzo, edito da Apogeo
2) Excel 2013 The missing manual, by Matthew MacDonald, edited by O’Reilly
3) Excel Workbook, by Ballerini et al., Edited by Egea Editori

Lecturer's teaching handouts will be also provided.

Teaching methods

All the topics (whether purely theoretical or practical) will be carried out in the computer room.
A practical reference problem will always be developed in the classroom, starting from scratch.
All material produced in the laboratory will be made available and, as the course progresses, handouts and exercises (written by the lecturer) will
be provided.

Assessment methods and criteria

The test is written and it has a duration of about 1 hour. Please note that the test will be taken together with he written Python test.
This test consists of 2-3 exercises and accounts for approximately 1/3 of the total score.

Other information

The entire course will take place in the computer labs.
However, students are allowed to use their laptop in place of the PCs in the labs. For this purpose, it is necessary to be equipped with Excel 365, with the both the data analysis module and the solver module installed and functioning.

2030 agenda goals for sustainable development

- - -

Contacts

Toll-free number

800 904 084

Student registry office

E. segreteria.ingarc@unipr.it
T. +39 0521 905111

Quality assurance office

Education manager:
Lucia Orlandini
T.+39 0521 90 6542
Office E. dia.didattica@unipr.it
Manager E. lucia.orlandini@unipr.it

Erasmus delegates

Roberto Montanari
E. roberto.montanari@unipr.it
Fabrizio Moroni
E. fabrizio.moroni@unipr.it
Adrian Hugh Alexander Lutey
E. adrianhughalexander.lutey@unipr.it

Quality assurance manager

Fabrizio Moroni
E. fabrizio.moroni@unipr.it

Erasmus delegates

Quality assurance manager

Prof.ssa Alessandra Mori

Internships

Paolo Lunghi

Tutor students

Nicolò Bellin
Stefano Nicolosi

INFORMATION SYSTEMS FOR MANAGEMENT 2° cod. 1008757

Learning objectives

Prerequisites

Course unit content

Full programme

Bibliography

Teaching methods

Assessment methods and criteria

Other information

2030 agenda goals for sustainable development

Contacts

Toll-free number

Student registry office

Quality assurance office

President of the degree course

Faculty advisor

Career guidance delegate

Tutor professor

Erasmus delegates

Quality assurance manager

Tutor students

Erasmus delegates

Quality assurance manager

Internships

Tutor students

INFORMATION SYSTEMS FOR MANAGEMENT 2°
cod. 1008757