Name: QUANTITATIVE AND COMPUTING TOOLS FOR BUSINESS DECISION MAKING
Code: 212101005
Type: Compulsory
ECTS: 4
Length of subject: Per term
Semester and course: 1st Year - First term
Speciality:
Language: English
Mode of study: On-site class
Lecturer data: PICHER VERA, DÉBORA
Knowledge area: Métodos Cuantitativos para la Economía y Empresa
Department: Métodos Cuantitativos, Ciencias Jurídicas y Lenguas Modernas
Telephone: 968327004
Email: debora.picher@upct.es
Office hours and location:
lunes - 08:00 / 10:00
EDIFICIO CIM - FCCE, planta 3, Despacho 330
Pedir cita previa antes de acudir al despacho.
miércoles - 08:00 / 10:00
EDIFICIO CIM - FCCE, planta 3, Despacho 330
Pedir cita previa antes de acudir al despacho.
Qualifications/Degrees:
Academic rank in UPCT: Profesora Asociada
Number of five-year periods: Not applicable due to the type of teaching figure
Number of six-year periods: No procede por el tipo de figura docente
Curriculum Vitae: Full Profile
Responsible for the groups: G1, G2
Lecturer data:
1. Ser capaces de aplicar herramientas cuantitativas e informáticas para el análisis de datos económico-empresariales y la toma de decisiones.
2. Elaborar modelos de análisis, planificación y simulación empresarial con software especializado.
3. Ser capaces de Identificar patrones de comportamiento empresarial utilizando técnicas estadísticas.
4. Ser capaces de aplicar técnicas de optimización en la empresa.
5. Ser capaces de elaborar y presentar informes a partir de las herramientas cuantitativoinformáticas citadas.
Herramientas informáticas, estadísticas y matemáticas para elaborar modelos basados en datos cuantitativos, fundamentales para la toma de decisiones empresariales. Mediante el software estadístico R se aprenderá a realizar: 1. Análisis exploratorio avanzado y su visualización mediante gráficos. 2. Modelos de regresión múltiple. Validación de hipótesis estructurales. 3. Análisis de componentes principales para la reducción de la dimensionalidad en la modelización. 4. Regresión logística binaria para modelización de variables binarias. 5. Análisis clúster jerárquico y no jerárquico para realizar tanto agrupaciones de casos como de variables. Con estas técnicas se abordará el análisis de datos económico-empresariales con el objetivo de apoyar la toma de decisiones en diversos contextos, como la economía, la industria y la empresa.
1. Advanced exploratory analysis and its visualization using graphs.
2. Multiple regression models. Validation of structural hypotheses.
3. Principal component analysis for dimensionality reduction in modeling.
4. Binary logistic regression for modeling binary variables.
5. Hierarchical and non-hierarchical cluster analysis for grouping cases and variables.
Excel
SPSS
R
Jamovi
Promoting the continuous improvement of working and study conditions of the entire university community is one the basic principles and goals of the Universidad Politécnica de Cartagena. Such commitment to prevention and the responsibilities arising from it concern all realms of the university: governing bodies, management team, teaching and research staff, administrative and service staff and students. The UPCT Service of Occupational Hazards (Servicio de Prevención de Riesgos Laborales de la UPCT) has published a "Risk Prevention Manual for new students" (Manual de acogida al estudiante en materia de prevención de riesgos), which may be downloaded from the e-learning platform ("Aula Virtual"), with instructions and recommendations on how to act properly, from the point of view of prevention (safety, ergonomics, etc.), when developing any type of activity at the University. You will also find recommendations on how to proceed in an emergency or if an incident occurs. Particularly when carrying out training practices in laboratories, workshops or field work, you must follow all your teacher's instructions, because he/she is the person responsible for your safety and health during practice performance. Feel free to ask any questions you may have and do not put your safety or that of your classmates at risk.
Class in conventional classroom: theory, problems, case studies, seminars, etc
Lectures will be delivered combining theoretical and practical lessons. Practical examples will be solved. Classes will be distributed according to the teaching units that comprise the course. Questions posed by students will be answered. This activity contributes to competencies 4, 25, and CB10, and to learning outcomes 1, 4, and 5.
9
100
Class in a computer classroom: practical classes / internships
Practical classes in the computer lab. Solving practical examples using software.
28
100
Assessment activities (continuous assessment system)
Assessment activities that allow determining the acquisition of competencies and learning outcomes associated with the subject
3
100
Assessment activities (final assessment system)
Assessment activities that allow determining the acquisition of competencies and learning outcomes associated with the subject.
3
100
Tutorials
Posing questions on both theoretical and practical aspects. This activity contributes to competency CB10 and all learning outcomes.
3
50
Student work: study or individual or group work
Independent study of the subject, solving exercises, and completing tasks proposed by the teacher.
This activity contributes to the CB10 and CT3 competencies and all learning outcomes.
54
0
Exam
Students will complete practical questions individually.
The exam may be divided into parts corresponding to the teaching units that comprise the subject.
This activity contributes to assessing all learning outcomes.
Learning Outcomes involved: RA18, RA24
50 %
Evaluation of written work, internships, cases, visits and seminars.
This activity involves assessing students' performance through various practical and academic tasks, including written assignments, internship experiences, case studies, educational visits, and participation in seminars. It aims to evaluate their understanding, application of knowledge, and professional development in real-world or simulated contexts.
Learning Outcomes involved: RA18, RA24
15 %
Participation and involvement in the teaching/learning process.
This activity refers to the active engagement of students in the educational process, including their attendance, contribution to class discussions, collaboration in group work, completion of tasks, and overall attitude towards learning. It reflects their commitment, motivation, and responsibility in achieving the learning objectives. Learning Outcomes involved: RA18, RA24
10 %
Performance, presentation and defense of individual and/or group work.
This activity involves the preparation, delivery, and justification of assignments or projects, either individually or in groups. It assesses students' ability to organize information, communicate ideas effectively, and respond to questions or feedback, demonstrating their understanding and critical thinking skills.
Learning Outcomes involved: RA18, RA24
25 %
Exam
Students will complete practical questions individually.
The exam may be divided into parts corresponding to the teaching units that comprise the subject.
This activity contributes to assessing all learning outcomes.
Learning Outcomes involved: RA18, RA24
50 %
Evaluation of written work, internships, cases, visits and seminars.
Preparation of practical exercises or reports, which may be divided into the parts that make up the subject.
Learning Outcomes involved: RA18, RA24
15 %
Participation and involvement in the teaching/learning process.
This activity will be evaluated in the exam through 1 question. Learning Outcomes involved: RA18, RA24
10 %
Performance, presentation and defense of individual and/or group work.
This activity involves the preparation, delivery, and justification of assignments or projects, either individually or in groups. It assesses students' ability to organize information, communicate ideas effectively, and respond to questions or feedback, demonstrating their understanding and critical thinking skills.
Learning Outcomes involved: RA18, RA24
25 %
Author: Pérez López, César
Title: Técnicas estadísticas multivariantes con SPSS
Editorial: Garceta,
Publication Date: 2009
ISBN: 9788492812004
Author: Webster, Allen L.
Title: Estadistica aplicada a los negocios y la economia
Editorial: McGraw- Hill
Publication Date: 2000
ISBN: 9584100726
Author: Pérez López, César
Title: Técnicas Estadísticas Predictivas con IBM SPSS Modelos
Editorial: Garceta Ediciones
Publication Date: 2014
ISBN: 9788415452874
Author: Bernal García, Juan Jesús
Title: 20 herramientas para la toma de decisiones método del caso
Editorial: Wolkers Kluwer
Publication Date: 2009
ISBN: 9788493602819
Author: Winston, Wayne L
Title: Operations Research. Applications and Algorithms
Editorial: McGraw-Hill
Publication Date: 2004
ISBN: 0-534-52020-0
Author: Lebelle, Bernard
Title: Construire un tableau de bord pertinent sous excel théorie, méthodologie et mise en oeuvre
Editorial: Groupe Eyrolles
Publication Date: 2010
ISBN: 9782212539813
Author: García Pérez de Lema, Domingo
Title: El emprendedor innovador y la creacion de emprededor
Editorial: UPCT
Publication Date: 2010
ISBN: 9788496997578
Author: Winston, Wayne L.
Title: Microsoft Excel 2013 Data Analysis and Business Modeling
Editorial: Microsoft
Publication Date: 2015
ISBN: 9780735669130
Author: Walkenbach, John
Title: Excel 2010 programación con VBA
Editorial: Anaya
Publication Date: 2010
ISBN: 9788441528284
Author: Propergol, Sergio
Title: Excel 2019 manual avanzado
Editorial: Anaya Multimedia
Publication Date: 2019
ISBN: 9788441541153