Checking date: 27/08/2025 09:53:35


Course: 2025/2026

Digital skills for data processing. Intermediate level
(19887)
Dual Bachelor in Political Science and Sociology (Plan: 579 - Estudio: 247)


Coordinating teacher:

Department assigned to the subject: Computer Science and Engineering Department

Type: Compulsory
ECTS Credits: 3.0 ECTS

Course:
Semester:




Learning Outcomes
K1: To know the principles and values of democracy and sustainable development, in particular, respect for human rights and fundamental rights, gender equality and non-discrimination, the principles of universal accessibility and climate change. S1: To know of basic humanistic contents, oral and written expression, following ethical principles and completing a multidisciplinary training profile. S2: Use information interpreting relevant data avoiding plagiarism, and in accordance with the academic and professional conventions of the area of study, being able to assess the reliability and quality of such information.
Description of contents: programme
1. Introduction and structure of a s spreadsheet. 1.1. Foundations and concepts. 1.2. Editing operations over books, sheets and cells 1.3. Data sources and importation. 1.4.. Add, remove, show and hide rows and columns. 1.5. Add and manage comments. 2. Working with cells and sheets. 2.1. Datatypes. 2.2. Formatting cells (styles). 2.3. Autofill options. Design and use of macros. Series. 3. Formula and references. 3.1. Basic operations: arithmetic, string and comparison operators. 3.2. Building references: types and creation between books and sheets. 3.3. Linking spreadsheets. 3.4. Tracing references in formulas 3.5. Interpreting formulas and functions. 4. Tables and Pivot tables. 4.1. Creating a table. Definition and fields. 4.2. Operations and management: filtering and sorting data. 4.3. Formatting tables. 4.4. Creating a pivot table. Definition and fields.. 4.5. Interpreting tables. 5. Data visualization. 5.1. Chart types. 5.2 Selecting the proper chart. 5.3. Data sources. 5.4. Edge customization 5.5. Formatting the chart area: title, caption and colors. 6. Accessibility and creation of documents using spreadsheets 6.1. Accessibility aspects of spreadsheets 6.2. Generation of documents 6.3. Printing spreadsheets: printing area, settings and preliminary view 6.4. Spreadsheets as a starting point. 7. Cybersecurity basics 7.1. Basic architecture of a computer: Hardware, Operating System and Applications. 7.2. Digital information. Examples of binary representation of data and its interpretation. Concept of file. Types. 7.3. Security objectives. Threads and vulnerabilities. Services and tools of telematics security. 7.4. Practical management of passwords and keys. 8. Digital signature 8.1. Concept of Cryptographic Hash. 8.2. Symmetric and asymmetric cryptography. 8.3. Public Key Infrastructure. Certificates and Certification Authorities. 8.4. Digital signature. Concept and scope. 8.5. Practice about signing and validating documents. - There is a SPOC related with all these concepts.
Assessment System

The course syllabus may change due academic events or other reasons.