B5478 - EXCEL FOR BUSINESS

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 some 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).

Mark range:

• 18-19: knowledge of a very limited number of topics covered in the course and analytical skills that emerge only with the help of the teacher, expressed in an overall correct language;
• 20-24: knowledge of a limited number of topics covered in the course and ability to autonomous analysis only on purely executive matters, expression in correct language;
• 25-29: good knowledge of a large number of topics covered in the course, ability to make independent choices of critical analysis, mastery of specific terminology;
• 30-30 cum laude: excellent knowledge of the topics covered in the course, ability to make autonomous choices of critical analysis and connection, full mastery of specific terminology and ability to argue and self-reflection.

Strumenti a supporto della didattica

https://virtuale.unibo.it

Orario di ricevimento

Consulta il sito web di Gianluca Lavezzari