COMPUTER LAB

Academic Year 2022/2023 - Teacher: GIOVANNI GIUFFRIDA

Expected Learning Outcomes

COMPUTER SKILLS: Development of theoretical and practical skills on Microsoft Office applications (especially Word, Excel, PowerPoint, Access) in order to fully develop a Degree Thesis or paper of medium complexity - fundamental knowledge of Computer and network, web security.

TELEMATIC SKILLS: Development of legal and practical skills on the application of the Digital Administration Code (CAD 3.0) and European Regulations on digitization and personal data protection (EIDAS, GDPR) and digital citizenship (digital identity, digital signature, CNS, PEC, SPID).

Course Structure

INFORMATIC SKILLS: Frontal lectures and exercises on Microsoft Office applications and training objectives.

TELEMATIC SKILLS: Frontal lectures and practical simulations on the use of a PEC, digital signature, use of SPID

Required Prerequisites

No particular background knowledge required.

Attendance of Lessons

Recommended

Detailed Course Content

COMPUTER SKILLS:
    - Operating system basics
    - Computer hardware and software
    - Functionality of popular applications
    - Activities of: Word processor (Word), Spreadsheet (Excel), Presentations (PowerPoint), Interactions in a database (Access)
    - Browser; Networking (network) concepts; Digital communication; Safe computer use; Searching for information on the web

TELEMATICS SKILLS:
    - CAD tools
    - Document flow in PA.
    - The document; the electronic, advanced, digital signature
    - Digital citizenship (PEC, digital signature, SPID, CNS)
    - PA websites - transparency and Open Data
    - Protection of personal data

Textbook Information

Slides provided by the teacher.

Learning Assessment

Learning Assessment Procedures

COMPUTER SKILLS: Practice test on Microsoft Office applications.
TELEMATIC SKILLS: Multiple-choice test.

Examples of frequently asked questions and / or exercises

COMPUTER SKILLS:
    - Processing and formatting of short text: page setup, insertion of: images, page numbers header and footer; footnotes; table of contents and table of contents.
    - Data and graph processing: table formatting, data entry, filters and relative/absolute links, three-dimensional formulas and functions, explanatory graphs.
    - Presentation: insertion of text, graphs, images, audio and video files for presentation of a paper.
    - Building a database: inserting Access objects, tables, masks, queries, reports, links between tables.

TELEMATICS SKILLS:
    - What are the European Digital Agenda and the Italian Digital Agenda?
    - What is in info ematic document?
    - What are the differences between digital and analog documents?
    - what is a PEC?
    - what does digital citizenship mean?
    - what is a digital identity?
    - What does the CAD provide for public administrations?
    - What does dematerialization mean?
    - What is computerized protocol?
    - What is the Agency for Digital Italy?

VERSIONE IN ITALIANO

Corso di laurea in

Sociologia e servizio sociale