It is advisable to have experience in the use of computers.

The course aims to train students in the comprehensive handling of structured data, understanding its structure, performing operations to obtain processed information, automating tasks, analyzing results, and visualizing data, all using spreadsheets as the main tool. Additionally, it will cover the fundamentals of cybersecurity, including basic concepts, threats, and security measures, as well as a practical focus on authentication, confidentiality, and integrity of information. It will also study the critical and ethical use of information, from identifying sources to creating bibliographic references and preventing plagiarism. Finally, it will introduce the basic concepts of Artificial Intelligence (AI), exploring its application in everyday life and business, as well as the ethical and legal aspects of generative AI. Upon completion of this course, the student will be able to: - Create sheets and workbooks, 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, perform 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. - Understand the general structure of a function and use different functions: logical, text, informational. - Create tables with different formats, manipulation and sorting of data, and use of filters. - Handle data lists, tables, and pivot tables through filtering, sorting, and summarizing them. - Create and customize different types of charts. - Create dashboards integrating different types of elements. - Adapt spreadsheets to consider accessibility aspects. - Reflect on and debate topics related to democratic principles and sustainable development values. - Automate tasks: use of macros, solver, forms, etc. - Understand the concept of digital signature, its foundation, and scope. - Identification and understanding of threats and vulnerabilities in digital systems. - Practical implementation of security measures, including authentication, confidentiality, and data integrity. - Ability to analyze current trends and evolution of attacks. - Develop critical skills in the use of digital information and in source evaluation. - Train in the ethical retrieval of information and in the precise creation of bibliographic references. - Introduce the basic concepts of Artificial Intelligence and its practical application in various contexts. - Explore Generative AI and its ethical, legal, and regulatory implications.

1. Data Analysis 1.1. Introduction, structure, basic operations, and working with cells in spreadsheets 1.1.1. Introduction a) Definitions. b) Editing operations on workbooks, sheets, and cells. c) Data sources and importation. d) Insert, delete, show, and hide rows and columns. e) Insert comments. 1.1.2. Working with cells and sheets. a) Data types. b) Cell formatting and styles. c) Auto-fill cells. 1.2. Formulas, references, and functions. a) Basic operations: arithmetic, comparison, and text operators. b) References: types and creation of references between sheets and workbooks. c) Linking spreadsheets. d) Tracing references in formulas. e) Interpreting formulas and functions. 1.3. Tables and pivot tables. a) Creating a table. Definition and fields. b) Operations, manipulation, filtering, and sorting of data. c) Format. d) Creating a pivot table. Definition and fields. e) Interpreting tables. 1.4. Data analysis and task automation. a) Using macros. b) Data analysis: solver and scenarios. c) Automation (distributed). 1.5. Data visualization. a) Types of charts. b) Choosing the appropriate chart. c) Data source for the chart. d) Configuring axes. e) Chart formatting: titles, legend, and colors. 1.6. Accessibility. a) Accessibility aspects in spreadsheets. b) Document generation. c) Forms. d) Printing a spreadsheet: print area, configuration, and preview. e) Spreadsheets as a starting point. 2. Cybersecurity. 2.1. Cybersecurity: Basic concepts & current situation. a) Introduction to cybersecurity. b) Threats, vulnerabilities, and attacks. c) Security measures: mechanisms and services. d) Current trends and evolution of attacks. 2.2. Cybersecurity: A practical approach. a) Authentication. b) Confidentiality. c) Integrity. 3. Information Usage. 3.1. Introduction and Sources. a) Information, its excess, and misinformation. b) Critical, reflective, and proactive use of digital information. c) Information sources: identification, selection, and evaluation. d) New spaces of interaction with knowledge: social media as a source of scientific information. 3.2. Information Retrieval. Ethical Use and Plagiarism. a) Principles and strategies for efficient information retrieval. b) Major platforms for accessing general and specialized resources. c) Tools for information organization and bibliographic management. d) Ethical use of information: ethics and intellectual property. e) Academic work without plagiarism. 3.3. Creation of Bibliographic References. a) Creating and managing bibliographic references in academic work. b) Presentation formats and ordering of bibliographic references. c) Originality analysis tools for plagiarism prevention. 3.4. Practical Session. 4. Artificial Intelligence. 4.1. Basic Concepts & Applications. a) Introduction to Artificial Intelligence (AI). b) Machine learning and Deep Learning. c) AI in everyday life and in the business sector. 4.2. AI: A practical approach. Generative AI (biases, legality, and ethics). a) Introduction to Generative AI: definition and operation. b) Biases and Ethics in Generative AI. c) Legality and Regulatory Challenges of Generative AI. -There is a SPOC for most of these contents.

Requirements: Students must bring their laptops to class. The reference version will be Excel 365 for Windows, Spanish or English language version, depending on the language of the enrollment group. Additionally, students will have access to Excel 365 for Windows in the Virtual Classroom. Training Activities Theoretical/Practical Classes: -Presentation of concepts -Guided resolution of exercises Tutoring -Individual - Group Individual or Group Work: -SPOC -Development of exercises and practical cases -Contribution to team activities In exercises and practical cases, in addition to the different training sessions of the four subjects that make up the course, aspects of sustainability will be addressed, and the transversal objective will be for students to learn and reflect on the Sustainable Development Goals.