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
|