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

LABORATORY SYSTEMS INTEGRATED A
cod. 1005713

Academic year 2015/16
3° year of course - Second semester
Professor
Francesco ZAMMORI
Academic discipline
Ingegneria economico-gestionale (ING-IND/35)
Field
"altre conoscenze utili per l'inserimento nel mondo del lavoro"
Type of training activity
More
21 hours
of face-to-face activities
3 credits
hub: PARMA
course unit
in - - -
lectures timetable unavailable
exam calls
Print

Learning objectives

At the end of the module, students will master all the features of Excel, and they will be able to create complex worksheets, useful for analyzing and solving typical engineering problems.

Prerequisites

The module does not have any specific prerequisite.

Course unit content

The module focuses on the use of Excel as a tool to solve classical engineering problems. Starting from basic concepts, all Excel’s potentialities will be analyzed, with specific focus on data analysis, filtering, presentation and synthesis. Specific attention will be given to the use of Logical, Research and Financial formulas, that can be used to realize complex worksheets, functional and easy to be used. Lastly, the most advanced features will be analyzed, including: (i) conditional formatting, (ii) Pivot tables, (iii) objective research, (iv) scenario analysis, (v) the solver and (vi) macro creation using VBA.

Full programme

1 The development environment
2 Data Types
3 Reference Types
4 Basic formulas
5 Advanced Formulas
6 Formatting and filtering options
7 Logical rules and conditional formatting
8 Creating charts
9 Creating Pivot Tables
10 Using Excel for discrete event simulation
11 Goal seek, scenarios and solver
12 Creating macros with VBA.

Bibliography

Microsoft Excel 2013, sfruttare con facilità la potenza dei fogli di calcolo, di S.Rubini, Edizioni Apogeo.

Excel 2013, the missing manual, di M. MacDonald, Edizioni O’Really

Teaching methods

The module will be carried on in the computer lab. All the topics discussed will be presented in an interactive way, using explanatory and / or concrete examples. All files (data and solution files) developed in the computer lab will be available in advance , together with lecture notes and power point lessons prepared by the lecturer.

Assessment methods and criteria

In order to pass the module, students must take an oral examination of about 45 minutes. During the test, students will answer questions of general theory and / or they will solve practical exercises. The oral examination includes, also, a discussion of three project-works (of which one related to the use of VBA) assigned by the teacher and developed in groups of 3 to 4 people.

Other information

- - -

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