Name: EXTENDED COMPUTING FOR BUSINESS
Code: 510109001
Type: Elective
ECTS: 4.5
Length of subject: Per term
Semester and course: 4th Year - Second term
Speciality:
Language: English
Mode of study: On-site class
Lecturer data: SÁNCHEZ GARCÍA, JUAN FRANCISCO
Knowledge area: Métodos Cuantitativos para la Economía y Empresa
Department: Métodos Cuantitativos, Ciencias Jurídicas y Lenguas Modernas
Telephone: 968325623
Email: jf.sanchez@upct.es
Office hours and location:
lunes - 09:00 / 12:00
EDIFICIO CIM - FCCE, planta 3, Despacho 321
Cita previa por correo electrónico
miércoles - 09:00 / 12:00
EDIFICIO CIM - FCCE, planta 3, Despacho 321
Cita previa por correo electrónico
Qualifications/Degrees:
Academic rank in UPCT: Profesor Contratado Doctor
Number of five-year periods: 5
Number of six-year periods: 0
Curriculum Vitae: Full Profile
Responsible for the groups: G1
[CB1 ]. Students are required to show they possess and understand knowledge in an area of study that starts from the base of general secondary education, and that they are at a level which includes aspects that imply knowledge coming from the forefront of their field of study.
[CG2 ]. To apply mathematical-statistical methods and information and communication technologies to the treatment, assessment, and forecasting of economic-business information.
La competencia específica asociada a esta asignatura optativa es: "Utilizar métodos cuantitativos informáticos en la empresa".
[CT2 ]. Team work
1. Use spreadsheets in an advanced mode
2. Identify the information needed for decision making in business
3. Create decision-making models for business
4. Prepare reports and executive summaries using computer tools
5. Present and defend reports in an oral way using computer tools
Advanced use of spreadsheet functions and tools. Creation of business analysis and planning models using computer tools.
Spreadsheets advanced tools
1. Advanced spreadsheet functions and tools
2. Advanced graphical spreadsheet tools
3. Advanced tables and pivot tables
4. Spreadsheet automation with VBA
Decision making models with spreadsheets
5. Business analysis and control models
Development of a decision-making model in the company
Company analysis and control models Planning models for different scenarios Business management models Quantitative models Decision models in cases of uncertainty Pivot tables and dashboards
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
Clase en aula convencional: teoría, problemas, casos prácticos, seminarios, etc
0
100
Class in laboratory: practical classes / internships
Clase en laboratorio: prácticas
0
100
Class in the field or open classroom (technical visits, lectures, etc.). In general, activities that require special resources or planning
Lectures by experts in the field and presentation of new IT tools.
Competences CG2 y CE and all learning outcomes are acquired by this method.
3
100
Class in a computer classroom: practical classes / internships
Practical class in the computer classroom where a problem or a practical case study is proposed, allowing time for its resolution. Resolution of questions raised by the students.
Competences CB1, CG2 and CE and all learning outcomes are acquired by this method.
39
100
Assessment activities (continuous assessment system)
Group development of a decision-making model in Excel with real data.
The acquisition of all competences and all learning outcomes is tested.
3
100
Assessment activities (final assessment system)
Resolution of a decision-making exam in Excel from the data provided.
The acquisition of competences CB1, CG2 and CE and all learning outcomes is tested.
2
100
Tutorials
Answering questions about theory and problem solving.
The acquisition of all competencies and all learning outcomes can be improved by this method.
2.5
50
Student work: study or individual or group work
Development of a group project. Autonomous study of the subject.
All competences and all learning outcomes are acquired by this method.
63
0
Presentation and defence of assignments
Presentation of the group work
Competences: CT2
Learning outcomes: 5
10 %
Participation and involvement in the teaching-learning process
Student follow-up of classes
Competences: CB1, CG2 and CE
Learning outcomes: 1 to 4
20 %
Evaluation of assignments and reports on practical sessions (final product, follow-up and contribution in the case of group work)
Development of a spreadsheet decision making model with real data developed in a group
Competences: CB1, CG2, CE and CT2
Learning outcomes: 1 to 4
70 %
Spoken or written exams
Making a decision-making model in a spreadsheet from the data provided.
Competences: CB1, CG2 and CE
Learning outcomes: 1 to 5
The exam corresponds to the activities of the continuous assessment system including the elaboration of the decision-making model (70%), the participation in the teaching-learning process (20%) and the exposition of the corresponding report (10%)
100 %
Author: MacDonald, Matthew
Title: Excel 2013: The missing manual
Editorial: O'Reilly Media
Publication Date: 2013
ISBN: 9781449357276
Author: Winston, Wayne L.
Title: Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition
Editorial: Microsoft Press
Publication Date: 2021
ISBN: 9780137613663
Author: Eckerson, Wayne W.
Title: Performance Dashboards: Measuring, Monitoring, and Managing Your Business
Editorial: Wiley
Publication Date: 2010
ISBN: 9780470589830