The main objective of this course is to be equipped with the proper skills to apply spreadsheet tools for providing practical solutions through the automation of tasks and data lifecycle management (load, clean, reconcile and exploit using differen techniques depending on the problem specification).

CB1: Students have demonstrated possession and understanding of knowledge in an area of study that builds on the foundation of general secondary education, and is usually at a level that, while relying on advanced textbooks, also includes some aspects that involve knowledge from the cutting edge of their field of study. CB3: Students have the ability to gather and interpret relevant data (usually within their field of study) in order to make judgements which include reflection on relevant social, scientific or ethical issues. CB5: Students will have developed the learning skills necessary to undertake further study with a high degree of autonomy. ECRT2: Ability to use communication and IT applications (office technology, databases, advanced calculus, project management, project visualization, etc.) to support development and use of telecommunication and electronics networks, services and applications. ECRT3: Ability to use IT search tools for bibliographic resources and information related to telecommunications and electronics. RA1: To acquire the knowledge and understanding of the general basic fundamentals of engineering, as well as, in particular, of multimedia communications networks and services, audio and video signal processing, room acoustic control, distributed multimedia systems and interactive multimedia applications specific to Sound and Image Engineering within the telecommunications family. RA4: To be able to carry out research and carry out innovative contributions in the field of Sound and Image Engineering, including bibliographic search and comprehension as well as the design and development of experiments that solve the challenges of knowledge in the field of audiovisual systems, in terms of the capture, processing, adaptation, diffusion and consumption of multimedia contents, as well as associated networks, services and applications, which justifies the scientific interest of this Degree. RA6: To be fluent in the performance of the generic skills that graduates require for the practice of engineering in today's society, which includes being able to develop effective oral and written communication, work in a multidisciplinary and team framework, and maintain professional competence through continuous learning throughout their lives. They also include demonstrating awareness of the responsibility of engineering practice, social and environmental impact, and commitment to professional ethics, responsibility and standards of engineering practice. They also include knowledge of business and project management practices, as well as risk management and control, and an understanding of their limitations.

Teaching Unit 1: A first contact 1.1-Structure of a spreadsheet: book, sheets and cells.and basic operations 1.2-Working with cells and sheets, data import and references. 1.3-Task automation for this unit Teaching unit TU2: Building, understanding and exploiting data. 2.1-Formula and functions Boolean operators and functions Text Database Descriptive statistics 2.2-Tables and pivot tables 2.3-Data analysis 2.4-Task automation for this unit Teaching unit TU3: Representation of data and information, task automation and applications 3.1-Visualization (pivot charts) 3.2-Spreadsheet applications: forms, mail merge, printing, document generation, etc. 3.3-Task automation for this unit

LEARNING ACTIVITIES AND METHODOLOGY THEORETICAL-PRACTICAL CLASSES. [12 hours with 100% classroom instruction, 0.48 ECTS] Knowledge and concepts students must acquire. Student receive course notes and will have basic reference texts to facilitate following the classes and carrying out follow up work. Students partake in exercises to resolve practical problems and participate in workshops and evaluation tests, all geared towards acquiring the necessary capabilities. TUTORING SESSIONS. [1 hours of tutoring with 100% on-site attendance, 0.08 ECTS] Individualized attendance (individual tutoring) or in-group (group tutoring) for students with a teacher. STUDENT INDIVIDUAL WORK OR GROUP WORK [24,5 hours with 0 % on-site, 0.98 ECTS] METHODOLOGY THEORY CLASS. Classroom presentations by the teacher with IT and audiovisual support in which the subject`s main concepts are developed, while providing material and bibliography to complement student learning. PRACTICAL CLASS. Resolution of practical cases and problems, posed by the teacher, and carried out individually or in a group. TUTORING SESSIONS. Individualized attendance (individual tutoring sessions) or in-group (group tutoring sessions) for students with a teacher as tutor. Additional note about software resources: -Excel 2013 or higher (Office 365 provided by the University would be recommended). Spanish or English language version, depending on the language of the enrollment group. -To do exercises, a personal computer can be used or you can also connect to the virtual classroom service provided by UC3M.