Sergio GUADAGNO | ADVANCED COMPUTER SCIENCE LABORATORY II
Sergio GUADAGNO ADVANCED COMPUTER SCIENCE LABORATORY II
cod. 0323100054
ADVANCED COMPUTER SCIENCE LABORATORY II
| 0323100054 | |
| DEPARTMENT OF POLITICAL AND COMMUNICATION SCIENCES | |
| EQF7 | |
| CORPORATE COMMUNICATION AND MEDIA | |
| 2024/2025 |
| OBBLIGATORIO | |
| YEAR OF COURSE 2 | |
| YEAR OF DIDACTIC SYSTEM 2017 | |
| SPRING SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 2 | 40 | LAB |
| Objectives | |
|---|---|
| THE TEACHING IS AIMED AT PROVIDING STUDENTS WITH TOOLS, BOTH THEORETICAL AND PRACTICAL, FOR THE STRUCTURING AND CREATION OF A DATABASE AS WELL AS FOR THE EXTRACTION OF INFORMATION CONTAINED IN IT; THE POPULATION, PROCESSING AND EXTRACTION OF INFORMATION FROM A SPREADSHEET; THE INTEGRATION BETWEEN THE TWO ENVIRONMENTS |
| Prerequisites | |
|---|---|
| NOTHING |
| Contents | |
|---|---|
| INTRODUCTION TO OPERATING SYSTEMS - FILE SYSTEM - ORGANIZATION AND MANAGEMENT OF INFORMATION IN A DATA PROCESSING SYSTEM - USING A SPREADSHEET - FORMATTING CELL CONTENT - ABSOLUTE, RELATIVE, MIXED AND NAME CELL REFERENCES - SORTS AND FILTERS APPLIED TO SERIES OF DATA IN A SPREADSHEET - USE OF FORMULAS AND FUNCTIONS - BASIC SYNTAX AND NESTED FUNCTIONS - GRAPHS IN A SPREADSHEET STARTING FROM A SERIES OF DATA - TYPES OF GRAPHS - COMBINATION GRAPHS - ELEMENTS OF A GRAPH: TITLES, LABELS, LEGEND, TREND LINES AND FORECAST ELEMENTS - SPARKLINE GRAPHS - DEFINITION AND USE OF A DBMS – OBJECTS CONTAINED IN A DATABASE: TABLES, MASKS, QUERIES, REPORTS – DISPLAYING THE STRUCTURE AND DISPLAYING THE DATA OF AN OBJECT – OPERATIONS ON TABLES AND MASKS – BASIC USE OF MACROS IN A DATABASE – DEFINITION, SETTING AND USE OF RELATIONSHIPS BETWEEN TABLES – QUERIES AND CRITERIA FOR EXTRACTING INFORMATION FROM A DATABASE – IMPORTING AND INTEGRATION INTO A SPREADSHEET OF INFORMATION PROCESSED BY A DBMS |
| Teaching Methods | |
|---|---|
| EX CATHEDRA LESSONS / EXERCISES / LABORATORY ACTIVITIES - ORGANIZED IN 40 HOURS OF COURSES DIVIDED INTO 12 OF THEORETICAL LESSONS, 6 OF EXERCISES AND 22 OF LABORATORY |
| Verification of learning | |
|---|---|
| THE FINAL EXAM OF THE COURSE CONSISTS OF PRESENTING AND DISCUSSING THE PROJECT OF A SPREADSHEET POPULATED FROM CONTENTS EXTRACTED FROM A DATABASE, CREATED AND IMPLEMENTED ON YOUR OWN DATA PROCESSING SYSTEM. THE PROJECT MAY BE CARRIED OUT INDIVIDUALLY OR BY WORKING IN A TEAM OF MAXIMUM 2 PEOPLE. THE EVALUATION OF THE PROJECT WILL INCLUDE THE EXPRESSION OF A POSSIBLE JUDGMENT OF SUITABILITY ON: - THE LAYOUT AND OPERATION OF THE SPREADSHEET CREATED AND THE COHERENT INTEGRATION IN IT OF THE RESOURCES PROCESSED IN THE DBMS - THE DEFINITION, STRUCTURING AND EXTRACTION OF THE RESOURCES USED IN THE DBMS - THE CORRECT APPLICATION OF THE FUNCTIONAL, MANAGEMENT AND CALCULATION CONSTRUCTIONS MADE AVAILABLE BY A SPREADSHEET |
| Texts | |
|---|---|
| SLIDES PROVIDED BY THE TEACHER |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2025-07-16]
