Checking date: 29/04/2024


Course: 2024/2025

Digital skills for data processing. Advanced level
(19826)
Bachelor in Management and Technology (Plan: 486 - Estudio: 351)


Coordinating teacher: VELASCO DE DIEGO, MANUEL

Department assigned to the subject: Transversal matters

Type: Compulsory
ECTS Credits: 3.0 ECTS

Course:
Semester:




Objectives
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.
Description of contents: programme
1. Introduction and structure of a spreadsheet. 1.1. Introduction and definitions. 1.2. Editing operations on books, sheets and cells 1.3. Data sources and import. 1.4. Insert, delete, show and hide rows and columns 1.5. Insert comments. 2. Work with cells and sheets. 2.1. Type of data. 2.2. Cell formatting and styles. 23. Automatic cell filling 3. Formulas and references 3.1. Basic operations: arithmetic, comparison and text operators. 3.2. References: types and creation of references between sheets and workbooks. 3.3. Link spreadsheets. 3.4. Trace references in formulas 3.5 Interpret formulas and functions. 4. Tables and dynamic tables. 4.1. Create a table. Definition and fields. 4.2. Operations, manipulation, filtering and ordering of data. 4.3. Format. 4.4. Creating a dynamic table. Definition and fields 4.5 Interpretation of tables 5. Data analysis and task automation 5.1. Using macros 5.2. Data analysis: solver and scenarios 5.3. Automation (distributed) 5. Data visualization 5.1. Types of graphics. 5.2 Choose the right graph 5.3. Chart data source 5.4. Axis configuration 5.5. Chart format: titles, legend and colors. 6. Accessibility and creation of documents from spreadsheets. 6.1. Accessibility aspects in spreadsheets 6.2 Document generation. 6.3. Forms 6.3. Print a spreadsheet: print area, settings and preview. 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 data representation and their interpretation. File concept. Guys. 7.3 Security objectives. Threats and vulnerabilities. Telematics security services and tools. 7.4 Practical management of passwords and keywords. 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 Document signing and validation practice. - There is a SPOC for most of this content.
Learning activities and methodology
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. In addition, students will have access to Excel 365 for Windows in the Virtual Classroom. FORMATIC ACTIVITIES Theoretical Classes: - Presentation of concepts Practical classes: - Guided resolution of exercises - General tutoring Individual work: -SPOC - Development of exercises - Contribution to team activities - Study and preparation of the final test Teamwork - Development of exercises - Carrying out a practical case in a group The group practical case will consist of the development of a complete case from data loading, analysis and generation of graphs with the objective of use and interpretation. This practical case, as well as other exercises, will address aspects of sustainability and will have as a transversal objective that students learn and reflect on the Sustainable Development Goals.
Assessment System
  • % end-of-term-examination 35
  • % of continuous assessment (assigments, laboratory, practicals...) 65
Calendar of Continuous assessment
Extraordinary call: regulations
Basic Bibliography
  • ¿ John Walkenbach. Excel 2016 Bible. Wiley. 2019
Recursos electrónicosElectronic Resources *
Additional Bibliography
  • ¿ Cole Nussbaumer Knaflic . Storytelling with Data: A Data Visualization Guide for Business Professionals. Wiley. 2015
  • ¿ Conrad Carlberg. Predictive Analytics: Microsoft Excel. Que Publishing. 2012
Recursos electrónicosElectronic Resources *
(*) Access to some electronic resources may be restricted to members of the university community and require validation through Campus Global. If you try to connect from outside of the University you will need to set up a VPN


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