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 | |
| 2023/2024 |
| 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 DESIGN, STRUCTURING AND CREATION OF TEXT DOCUMENTS, THE POPULATION, PROCESSING AND EXTRACTION OF INFORMATION FROM A SPREADSHEET, AND THE INTEGRATION BETWEEN THE TWO ENVIRONMENTS |
| Prerequisites | |
|---|---|
| NOTHING |
| Contents | |
|---|---|
| INTRODUCTION TO OPERATING SYSTEMS - FILE SYSTEMS - ORGANIZATION AND MANAGEMENT OF INFORMATION IN A DATA PROCESSING SYSTEM - USING A WORD PROCESSOR – FORMATTING AND LAYOUT OF TEXTUAL CONTENTS – SUPPLEMENTARY REFERENCES TO TEXTUAL CONTENTS: SUMMARIES, INDEXES, NOTES – LAYOUT CONTROL: PAGE SETUP, BREAKS, HEADERS AND FOOTERS – INSERTING NON-TEXTUAL OBJECTS: LISTS, TABLES, IMAGES AND SHAPES, LINKS – TEXT AND PRINT MERGE PROCEDURE FROM A DATA SOURCE AVAILABLE THROUGH A SPREADSHEET – USING A SPREADSHEET – FORMATTING CELL CONTENTS – ABSOLUTE, RELATIVE, MIXED AND BY NAME CELL REFERENCES – SORT AND FILTERS APPLIED TO SERIES OF DATA IN A SPREADSHEET - USE OF FORMULAS AND FUNCTIONS - BASIC SYNTAX AND NESTED FUNCTIONS - USING MACROS AND BASIC PROGRAMMING IN VBA (VISUAL BASIC FOR APPLICATIONS) - CHARTS IN A SPREADSHEET FROM A SERIES OF DATA - TYPES OF CHARTS - COMBINED CHARTS - ELEMENTS OF A CHART: HEADLINES, LABELS, LEGEND, TREND LINES AND FORECAST ELEMENTS – SPARKLINE CHARTS - INTEGRATION OF GRAPHS PROCESSED IN A SPREADSHEET INTO A TEXT DOCUMENT, DATA CONNECTION AND ORIGINAL FORMATTING |
| 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 IN PRESENTING AND DISCUSSING THE PROJECT OF A TEXT DOCUMENT INTEGRATED BY CONTENTS PROCESSED IN A SPREADSHEET, CREATED AND IMPLEMENTED ON YOUR OWN DATA PROCESSING SYSTEM. THE PROJECT CAN BE CARRIED OUT INDIVIDUALLY OR BY WORKING IN A TEAM OF UP TO 2 PEOPLE. THE EVALUATION OF THE PROJECT WILL INCLUDE THE EXPRESSION OF A POSSIBLE ELIGIBILITY JUDGMENT ABOUT: - THE LAYOUT OF THE DOCUMENT CREATED AND THE FUNCTIONAL INTEGRATION INTO IT OF THE RESOURCES PROCESSED IN THE SPREADSHEET - THE STRUCTURING, FORMATTING AND EXTRAPOLATION OF THE RESOURCES USED IN THE SPREADSHEET - THE CORRECT APPLICATION OF THE FUNCTIONAL, MANAGEMENT AND CALCULATION CONSTRUCTS AVAILABLE IN A SPREADSHEET ENVIRONMENT |
| Texts | |
|---|---|
| SLIDES PROVIDED BY THE TEACHER |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2024-12-17]
