Data elaboration laboratory (2019/2020)

Course code
4S000708
Name of lecturer
Maurizio Boscaini
Coordinator
Maurizio Boscaini
Number of ECTS credits allocated
3
Other available courses
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Period
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.

Syllabus

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.]