|
Derived from
|
119033 LABORATORIO DI COMPETENZE DIGITALI: OFFICE AUTOMATION AVANZATO in Marketing and Quality Management LM-77 BRACCINI Alessio maria
(syllabus)
The laboratory tackles the advanced use of electronic spreadsheets and database management systems software as follows.
Advanced use of electronic spreadsheets:
• Import data from external sources (csv, textual data, database, web)
• Manual and conditional cells formats
• Filter and sort data sources
• Charts
• Pivot tables and pivot charts
• Data analysis for problem solving tools: matrix formulas, problem solving with 1, 2 or n variables
Advanced use of database management systems:
• Conceptual modelling of a database with E/R
• Create a database in a database management system
• Create relationships between tables
• Create queries for extracting data from relations
• Create views for data input and visualisation
(reference books)
Materials available on the Moodle learnig platform
|
