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.