- Oggetto:
- Oggetto:
Business Analytics Lab - Stream A
- Oggetto:
Business Analytics Lab A
- Oggetto:
Academic year 2021/2022
- Course ID
- MAN0518
- Teacher
- Lisa Sella (Lecturer)
- Year
- 3rd year
- Teaching period
- Second term
- Type
- Other activities
- Credits/Recognition
- 3
- Course disciplinary sector (SSD)
- SECS-P/06 - economia applicata
- Delivery
- Formal authority
- Language
- English
- Attendance
- Obligatory
- Type of examination
- Written
- Oggetto:
Sommario del corso
- Oggetto:
Course objectives
The course is intended to familiarize students with the use of MS Excel in data analysis for economic and financial applications.
- Oggetto:
Results of learning outcomes
The purpose of the course is to provide the ability of analyze simple and complex databases in MS Excel, by means of formula manipulation, statistical and graphical tools, data analysis tools.
- Oggetto:
Course delivery
This academic year the course is in presence. Please get equipped with a personal laptop and your Excel software: during the classes practical exercises are carried out.
A Webex synchronous connection is guaranteed for students unable to be in presence. Please get equipped with a good internet connection. Connect to my personal webroom following the scheduled class timetable using the link:
https://unito.webex.com/meet/lisa.sella | 847806249
- Oggetto:
Learning assessment methods
The exam consists of a laboratory test (lasting about 1 hour) aimed at ascertaining the students' ability to use the analysis tools developed during the course to solve practical exercises
- Oggetto:
Support activities
During the course, there will be weekly complementary practical exercises.
The tutor is Thu Nga Le (thunga.le@unito.it)
- Oggetto:
Program
Tools for an efficient use of MS Excel (autofill, formulas, functions, addressing, text manipulation, charts, descriptive statistics, frequency distributions)
Financial functions in MS Excel (net present value, internal rate of return, annuity functions, amortization tables)
Simple and advanced data analysis tools (sorting, filters, data forms, grouping, subtotals, pivot tables, multi-page systems, lookups, what-if analysis, sensitivity analysis)
Power Query (search the web, modify queries, merge tables)
Suggested readings and bibliography
- Oggetto:
Slides
- Oggetto:
Note
“Le modalità di svolgimento dell'attività didattica potranno subire variazioni in base alle limitazioni imposte dalla crisi sanitaria in corso. In ogni caso è assicurata la modalità a distanza per tutto l'anno accademico”- Oggetto:
