Data elaboration laboratory (2019/2020)

Course code
Name of lecturer
Maurizio Boscaini
Maurizio Boscaini
Number of ECTS credits allocated
Other available courses
Academic sector
Language of instruction
Sem 2A, Sem 2B

Lesson timetable

Go to lesson schedule

Learning outcomes

Provide the basic knowledge, theoretical and practical, for the creation of a database with Microsoft
Access and process data with Microsoft Excel.


Difference between information systems and computer systems.
Models of conceptual design:
- Database, DBMS (DataBase Management System)
- E-R diagram (Entity-Relationship)
- Cardinality (one-to-one, one-to-many, many-to-many)

Practical exercises in the laboratory with the use of Microsoft Access and Excel.

The course schedule will be available on the 'e-learning site for the course (Moodle) on January 15, 2020.

Reference books
Author Title Publisher Year ISBN Note
Lughezzani F., Princivalle D. Nuova ECDL. Syllabus 6. Base + full standard extension Hoepli 2018 9788820383152

Assessment methods and criteria

The exam is divided into two parts:
1. multiple choice test;
2. creation of a database with Access and a spreadsheet (calculations, graphs, etc.) with Excel.

Due to the Coronavirus pandemic, and in accordance with the University of Verona guidelines, during ​the 2020 summer session the assessment modality will be modified as follows: [online oral exam, online written exam, etc.]