- Docente: Gianluca Lavezzari
- Crediti formativi: 6
- Lingua di insegnamento: Inglese
- Modalità didattica: Convenzionale - Lezioni in presenza
- Campus: Rimini
- Corso: Laurea in Economia dell'impresa (cod. 8848)
-
dal 13/02/2024 al 07/05/2024
Conoscenze e abilità da conseguire
At the end of this course, students are able to use MS Excel to model and solve typical business problems regarding data management. They are able to exploit advanced spreadsheet operations like summarising, reporting and analysing business data.
Contenuti
Lessons are mainly practical and are held in a computer lab: students should gain hands-on experience in manipulating data and begin to understand the important role of spreadsheets.
This course starts with an introduction to spreadsheets to learn to perform some basic level data wrangling and cleansing tasks. Students then continue to expand their knowledge of analyzing data through the use of filtering, sorting, and using pivot tables within the spreadsheet. By performing these tasks throughout the course, it will give an understanding of how spreadsheets can be used as a data analysis tool.
Testi/Bibliografia
Teaching material (ppt slides and pdf files) distributed by the teacher and downloadable from the Unibo repository: VIRTUALE
Metodi didattici
The professor will give lectures in presence at Rimini Campus in a computer lab. Students will learn the most important Excel functions and apply them to some real business cases. The lessons will be supported by power point slides.
Modalità di verifica e valutazione dell'apprendimento
Students are assessed based on a written exam made by multiple choice questions, open questions and exercises.
The exam will be held in a computer lab, in front of the pc. Students might be organized in shifts on the same day, if their number exceed a certain threshold (i.e., the number of seats in the computer lab).
Strumenti a supporto della didattica
https://virtuale.unibo.it
Orario di ricevimento
Consulta il sito web di Gianluca Lavezzari