Checking date: 07/06/2023


Course: 2023/2024

Advanced knowledge of Spreadsheets
(17881)
Bachelor in Energy Engineering (Plan: 452 - Estudio: 280)


Coordinating teacher: VELASCO DE DIEGO, MANUEL

Department assigned to the subject: Transversal matters

Type: Compulsory
ECTS Credits: 1.5 ECTS

Course:
Semester:




Objectives
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).
Skills and learning outcomes
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. CB2. Students are able to apply their knowledge to their work or vocation in a professional manner and possess the competences usually demonstrated through the development and defence of arguments and problem solving within 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. CB4. Students should be able to communicate information, ideas, problems and solutions to both specialist and non-specialist audiences. CB5. Students will have developed the learning skills necessary to undertake further study with a high degree of autonomy. CG9. Acquire the ability to organize and plan within a company as well as in other institutions and organizations and knowing human resources management and project planning, programming and control in such sphere. CG10. Being able to work in a multi-lingual and multidisciplinary environment CE3 Módulo FB. Basic knowledge of the use and programming of computers, operating systems, databases, and computer software with engineering applications. CT1. Ability to communicate knowledge orally as well as in writing to a specialized and non-specialized public. CT2. Ability to establish good interpersonal communication and to work in multidisciplinary and international teams. CT3. Ability to organize and plan work, making appropriate decisions based on available information, gathering and interpreting relevant data to make sound judgement within the study area. CT4. Motivation and ability to commit to lifelong autonomous learning to enable graduates to adapt to any new situation. By the end of this content area, students will be able to have: RA2.1 the ability to apply their knowledge and understanding in spreadsheets to identify, formulate and solve engineering problems using established methods; RA3.2 an understanding of design methodologies, and an ability to use them. RA4.1 the ability to conduct searches of literature, and to use data bases and other sources of information; RA5.1 the ability to select and use appropriate equipment, tools and methods; RA6.1 function effectively as an individual and as a member of a team.
Description of contents: programme
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
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.
Assessment System
  • % end-of-term-examination 0
  • % of continuous assessment (assigments, laboratory, practicals...) 100
Calendar of Continuous assessment
Basic Bibliography
  • Conrad Carlberg. Predictive Analytics: Microsoft Excel. Que Publishing. 2012
  • John Walkenbach. Excel 2016 Bible. Willey. 2016
  • Matthew MacDonald.. Excel 2010: The Missing Manual. . O'Reilly.. 2010
Recursos electrónicosElectronic Resources *
Additional Bibliography
  • Cole Nussbaumer Knaflic. Storytelling with Data: A Data Visualization Guide for Business Professionals. Willey. 2015
  • Jordan Goldmeier. Advanced Excel Essentials. APress. 2014
  • Jordan Goldmeier. Dashboards for Excel. APress. 2015
(*) 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.