Vai al contenuto principale
Coronavirus: aggiornamenti per la comunità universitaria / Coronavirus: updates for UniTo Community
Oggetto:
Oggetto:

Business Analytics Lab - Stream A

Oggetto:

Business Analytics Lab A

Oggetto:

Academic year 2022/2023

Course ID
MAN0518
Teachers
Lisa Sella (Lecturer)
Thu Nga Le (Tutor)
Year
3rd year
Teaching period
Second term
Type
Other activities
Credits/Recognition
3
Course disciplinary sector (SSD)
SECS-P/06 - applied economics
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:

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)

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.

Suggested readings and bibliography

Oggetto:

Slides



Enroll
  • Open
    Enrollment opening date
    01/08/2022 at 00:00
    Enrollment closing date
    31/12/2022 at 23:55
    Oggetto:
    Last update: 19/08/2022 17:33
    Non cliccare qui!