Experience in the use of computers will be valuable.

The objective of this course is to obtain general skills and numeric literacy when handling structured data, so that the student is able to understand the structure of the data, perform operations with them to obtain new processed information, analyze the results to obtain conclusions about them and represent them visually. Moreover, students must know how to use spreadsheets as a simple office tool to perform the mentioned operations. At the end of this course, the student will be able to: -Be able to create books and spreadsheets organizing data and the management of data cells. -Acquire the skills to create series and insert comments including the spreadsheet styling and formatting. -Be able to manage spreadsheets: copy and paste operations, insert, remove cells, rows and columns. -Use different types of formula, absolute and relative references and management of operations and operators. -Be able to link different spreadsheets. -Understand the structure of a formula, sorting and filtering data. -Understand the use of tables: formatting, management and sorting and filtering of data. -Understand the creation and management of charts: titles, captions, edges, images, etc. ¿ Create books and sheets, organizing data and the management of data cells. ¿ Create series and insert comments including the spreadsheet styling and formatting.. ¿ Edit spreadsheets, copy and paste operations, insert, remove cells, rows and columns. ¿ Use different types of formula, absolute and relative references and management of operations and operators. ¿ Create links between different spreadsheets. ¿ Understand the structure of a function and use different functions: logic, text, search, etc. ¿ Create tables with different formats, and management, sorting and filtering data. ¿ Handle datasets and use tables and pivot tables using filtering, sorting and summaries of the information. ¿ Create and personalize different types of charts. ¿ Create dashboards integrating different elements. ¿ Adapt spreadsheets so as to consider accessibility aspects. ¿ Reflect and discuss topics related to democratic principles and values and sustainable development goals. ¿ Understand the concept of digital signature, its foundations and scope. ¿ Digitally sign documents. ¿ Understand the main security threads and the available tools to protect digital actives.

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.

Requirements: Students must bring their laptops to the face-to-face sessions. The reference version will be Excel 365 for Windows, Spanish or English language version, depending on the language of the enrolment group. Moreover, students will have access to Excel 365 for Windows in the Virtual Classroom. LEARNING ACTIVITIES Theoretical Lectures: - Show foundations and main concepts Practical Lectures: - Exercise resolution - General tutoring Individual Work: - SPOC - Exercises - Contribution to team activities - Study and preparation of final test Team Work: - Exercises - Development of a study case in group The group study case will consist of the development of a complete case from data loading, analysis, and graph generation with objective of use and interpretation. This practical case, and some other exercises, will address sustainability issues and this sustainability part will be related to a traversal objective so that students learn and reflect about the Sustainable Development Goals.