INTEGRATED MANAGEMENT WORKSHOP
cod. 1006931

Academic year 2017/18
3° year of course - Second semester
Professor
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:
course unit
in ITALIAN

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 with basic concepts all Excel’s potentialities will be analyzed, with specific focus on data analysis, filtering, presentation and synthesis.Particular 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 and (v) the solver

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.

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 two project-works assigned by the teacher and developed in groups of 3 to 4 people.

Other information

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 teacher.