Studying at the University of Verona
Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.
Type D and Type F activities
| years | Modules | TAF | Teacher |
|---|---|---|---|
| 1° | Future matters | D |
Alessandro Bucciol
(Coordinator)
|
| 1° | Future matters | D |
Alessandro Bucciol
(Coordinator)
|
| years | Modules | TAF | Teacher |
|---|---|---|---|
| 1° | Design and Evaluation of Economic and Social Policies | D |
Federico Perali
(Coordinator)
|
| 1° | Public debate and scientific writing - 2020/2021 | D |
Martina Menon
(Coordinator)
|
| 1° | Soft skills coaching days Vicenza (terza edizione) - 2020/2021 | D |
Paola Signori
(Coordinator)
|
| 1° | Wake up Italia - 2020/2021 | D |
Sergio Noto
(Coordinator)
|
Advanced Excel Laboratory (Vicenza) (2020/2021)
Teaching code
4S009617
Teacher
Coordinator
Credits
3
Also offered in courses:
- Advanced Excel Laboratory (Vicenza) of the course Bachelor's degree in Economics and Business (Vicenza)
- Advanced Excel Laboratory (Vicenza) of the course Bachelor's degree in Business Administration (Vicenza)
- Advanced Excel Laboratory (Vicenza) of the course Master's degree in International Economics and Business Management
- Advanced Excel Laboratory (Vicenza) of the course Master’s degree in International Economics and Business
- Advanced Excel Laboratory (Vicenza) of the course Master’s degree in Management and business strategy
- Advanced Excel Laboratory (Vicenza) of the course Bachelor's degree in Business Innovation and Economics
Language
Italian
Scientific Disciplinary Sector (SSD)
NN - -
Period
Not yet assigned
Learning outcomes
The course "Advanced Excel Laboratory" is an optional "type f" activity, which allows to students to obtain 3 CFU, once a final examination is passed. In particular:
- The course is open to all CdL and CdLM students of the Vicenza campus of the School of Economics and Management.
- Due to the COVID-19 emergency, this year lessons will be delivered online through Zoom meetings. Each course has, approximately, 50 places.
- There will be two courses, one in the first semester and another one in the second semester.
- Requests for participation will be considered following the registration order. All CdL and CdLM students of the Vicenza campus of the School of Economics and Management can register. As regard to admission to the course, there will be no distinction between CdL and CdLM students. Students are required to participate to the first lesson, or to send an email to the tutor to communicate their absence.
- To participate to the course it is not required a previous participation to the course “Excel Laboratory”.
- The frequency to the classes is compulsory. Students are required to attend at least 2/3 of the exercise lessons/tutorial activity in order to be admitted to the final evaluation.
- The course consists of 18 hours of exercise lessons and tutorial activity (plus 2 hours of final examination).
The calendar of the course of the first semester will be available as soon as possible.
The calendar of the course of the second semester will be available as soon as possible.
Tutor (first semester): dott. Alessandro Cipolla
Tutor (second semester): dott. Alessandro Cipolla
For the course of the first semester, it is possible to register from the 13th of October 2020 to the 18th of October 2020.
For the course of the second semester, it is possible to register from the 13th of October 2020 to the 28th of February 2021.
Please, register through the elearning platform (Moodle). Students without a university IT account can ask to be registered by writing an email to the coordinator of the course. All other students must use the procedure on Moodle.
Program
The program of the course comprises an introduction to Excel and its main functions. Then, some of the topics encountered in Mathematics and Statistics courses will be considered, as for example, matrix algebra, optimization and interpolation. A considerable portion of the course will focus on the use of Visual Basic for Application (VBA). The course aims at improving the computational skills of the students and at providing instruments useful for the subsequent thesis work. The activity will allow to improve the knowledge of Excel, a software which is highly requested in the job market.
| Author | Title | Publishing house | Year | ISBN | Notes |
|---|---|---|---|---|---|
| Guojun Gan | An Introduction to Excel VBA Programming with Applications in Finance and Insurance (Edizione 1) | CRC Press | 2017 | 9781138197152 | |
| Mike Davis | Costruire applicazioni con Excel 2016: Dal foglio di calcolo alle tabelle pivot, le macro e il linguaggio VBA (Edizione 1) | APOGEO | 2017 | 9788850334223 | |
| John W. Foreman | Data Smart: Using Data Science to Transform Information Into Insight (Edizione 1) | Wiley | 2014 | 9781118661468 | |
| Curtis Frye | Microsoft Excel 2016: La guida ufficiale (Edizione 1) | Hoepli | 2016 | 9788820374785 | |
| Anna Maria D'Arcangelis, Silvia Patacchini, Felice Bruno | VBA per la finanza: tassi di interesse, gestione di portafoglio, derivati (Edizione 1) | Apogeo Education, Maggioli Editore | 2018 | 8891627766 |
Examination Methods
Students are required to attend at least 2/3 of the exercise lessons/tutorial activity in order to be admitted to the final evaluation. The final examination, which will take place online through a Zoom meeting, will consist in a written exam, followed by an oral examination, if necessary, on the use of the software Excel. There will be just one date for the final examination.
