The objective of this course is to obtain general skills and solvency in the management of structured data, so that the student is able to understand its structure, perform operations with them that allow obtaining new processed information, automate tasks, analyze the results. to obtain conclusions about them and represent them visually. Likewise, for this data management, the objective is for students to know how to use spreadsheets as a simple office tool to carry out the aforementioned operations.
Upon completion of this subject, the student will be able to:
¿ Create sheets and books, with the consequent organization and introduction of data and cell management.
¿ Create series and insert comments, working with different formats and styles of cells and sheets.
¿ Edit spreadsheets, make special pastes, and insert or delete cells, rows, or columns.
¿ Use different formulas, absolute and relative references and handle arithmetic, comparison and text operators.
¿ Establish links between spreadsheets and textbooks.
¿ Know the general structure of a function and use different functions: logical, text, information.
¿ Create tables with different formats, manipulation and ordering of data and use of filters.
¿ Manage data lists, tables and dynamic tables by filtering, sorting and summarizing them
¿ Create and customize different types of graphics.
¿ Create dashboards integrating different types of elements.
¿ Adapt spreadsheets to take into account accessibility aspects
¿ Reflect and debate on issues related to democratic principles and values ¿¿and sustainable development.
¿ Automate tasks: use of macros, solvers, forms, etc.
¿ Understand the concept of digital signature, its foundation and scope
¿ Digitally sign a document
¿ Know the main security threats and the tools available to protect digital assets.