Vai al contenuto principale Vai al footer
Università degli Studi di Parma Università degli Studi di Parma
Degree course in
Management engineering
Università degli Studi di Parma
Department of Engineering for Industrial Systems and Technologies

INFORMATION SYSTEMS FOR MANAGEMENT 2°
cod. 1008757

Academic year 2022/23
3° year of course -
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

Print

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 data and create control dashboards.

Prerequisites

The course requires a good knowledge of the main functionality of Excel. However, to foster the comprehensions, all topics will be introduced and explained starting from scratch.

Course unit content

The course introduces Excel 365 for data analysis and dashboarding.

Full programme

- Recap on the excel worksheets.
- Recap on baisc formula and references.
- Recap on graphs, plot, and data analysis.
- Some advanced functions, logical functions, lookup functions.
- Logical condition and Conditional formatting.
- Lambda and Let functions, the best way to create your own personalized functions.
- Tables, Data Sorting, Data Filtering, Pivot Table.
- Goal Seeking and the Excel's Solver.

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 (covering both Excel and Python topics) will also be available.

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 to cover all the elements covered.

Assessment methods and criteria

The test is written; it has a duration of about 0.5 hours ad it will will be taken at the same time as the written Python test.
This test consists of 1-2 exercises and accounts for approximately one third of the total score.
The oral test is optional; it is compulsory only for students who obtained a mark of less than 20 in the written test.

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 data analysis module and solver already installed.

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 906542
Office E. dia.didattica@unipr.it
Manager E. lucia.orlandini@unipr.it
 

President of the degree course

Barbara Bigliardi
E. barbara.bigliardi@unipr.it

Faculty advisor

Fabrizio Moroni
E. fabrizio.moroni@unipr.it

Career guidance delegate

Fabrizio Moroni
E. fabrizio.moroni@unipr.it

Tutor professor

Fabrizio Moroni
E. fabrizio.moroni@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

Tutor students

Laura MONFERDINI
Stefano ARDIZZONI
Ulderico TARASCONI
Natalya LYSOVA
Alberto CORVI
Marco GHIRINI
Marco PANNO
Michele GULINO
Elisa CONTI
Elena MOSCATELLI
Alessia DEPIETRI
Francesco BENELLI
Marco VICINI
Claudio SUPPINI
Gianluca RUPEALTA
Giuliana DE DONNO
Benedetta PINI
Andrea NOTARO
Arianna PAINI
Martina MUNDULA