- Docente: Gianluca Lavezzari
- Credits: 6
- Language: English
- Teaching Mode: Traditional lectures
- Campus: Rimini
- Corso: First cycle degree programme (L) in Business Economics (cod. 8848)
-
from Feb 13, 2024 to May 07, 2024
Learning outcomes
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.
Course contents
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.
Readings/Bibliography
Teaching material (ppt slides and pdf files) distributed by the teacher and downloadable from the Unibo repository: VIRTUALE
Teaching methods
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.
Assessment methods
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).
Teaching tools
https://virtuale.unibo.it
Office hours
See the website of Gianluca Lavezzari