Name: COMPUTING FOR BUSINESS
Code: 520101004
Type: Basic
ECTS: 6
Length of subject: Per term
Semester and course: 1st Year - First 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 - 4060 - 968325319
Email: jf.sanchez@upct.es
Office hours and location:
lunes - 16:00 / 19:00
EDIFICIO DE LA FACULTAD CC EMPRESA, planta 3, Despacho 321
Cita previa por correo electrónico
miércoles - 16:00 / 19:00
EDIFICIO DE LA FACULTAD CC EMPRESA, planta 3, Despacho 321
Cita previa por correo electrónico
Qualifications/Degrees:
PhD in . from Technical University of Cartagena (SPAIN) - 2004
Licensed in . from University of Murcia (SPAIN) - 1993
Academic rank in UPCT: Profesor Contratado Doctor
Number of five-year periods: 5
Number of six-year periods: 0
Curriculum Vitae: Full Profile
[CB3 ]. Students are required to have the ability to gather and interpret relevant data (usually within their area of study) to make judgments that include a reflection on relevant issues of a social, scientific or ethical nature.
[CG4 ]. To analyze, evaluate and summarize information in different areas of the tourism sector, applying ICTs and statistical methods.
[CE9 ]. To use and analyze information and communication technologies (ICT) in the different areas of the tourism sector.
[CT4 ]. Using information resources responsibly
1. Use information resources properly
2. Identify basic knowledge related to computing
3. Identify the different types and possibilities of e-commerce in business
4. Use office software properly
5. Identify problems, analyse and solve them properly by using spreadsheets and database managers
Introduction to information systems in business, including hardware, software, networks, telecommunications, databases and their different tools. Analysis of Internet tools in tourism, especially e-commerce. Tools and models for decision making, using database managers and spreadsheets.
Sistemas de información
1. Sistemas de información en la empresa
2. Hardware
3. Software
4. Redes y telecomunicaciones
5. Bases de datos
6. Comercio electrónico
7. Planificación, adquisición y control
Herramientas ofimáticas de gestión
8. Gestión de base de datos
9. Hoja de cálculo
Database management
Tables creation Filters Selection queries Action queries Forms Reports
Spreadsheets
Commissions (references and formats) Sales prevision I Taxes (Lookups and tables) Commissions II (database functions, frequency, RANK, filters) Break-even point (goal seek, charts) Loan calculator (data validation, manual calculation, formula auditing, conditional formatting) System of linear equations (matrix calculations, named ranges) Hotel (pivot tables, pivot charts) Hotel 2 (scenario manager) Linear regression (statistical analysis, TREND, GROWTH)
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.
Theory class: Activities consisting of training sessions to develop theoretical knowledge based on concepts and theories
Expository class using the method of the lesson and the case method. Resolution of questions raised by the students.
Learning outcomes 1, 2 and 3 are acquired by this method.
Problem solving class
23
100
Problem solving class: Activities consisting of training sessions to develop practical or applied knowledge based on problem solving exercises, or practical cases
Laboratory or field practice class
0
100
Laboratory or field practice class: Activities aimed at developing practical or applied skills by the student supervised by a remote teacher
Laboratory or field practice class
Seminars, tutorials led by teaching staff, conferences, visits, round tables, etc
0
100
Practical class in the computer room: Activities for the acquisition of certain skills through the use of specific software
Practical class in computer classroom, where a problem is proposed giving time for its resolution. Resolution of questions raised by the students.
All competencies and learning outcomes 4 and 5 are acquired by this method.
34
100
Seminars, tutorials led by teaching staff, conferences, visits, round tables, etc .: Activities to develop theoretical, practical or applied knowledge based on specific topics or views of the profession
Written and computer evaluation (partial exams) and task submissions.
The acquisition of all competencies and learning outcomes is checked.
3
100
Assessment activities (final assessment system)
Written and computer evaluation (official exam).
The acquisition of all competencies and learning outcomes is checked.
2
100
Tutorials: Individual or in groups, will serve to advise, resolve any doubts, guide, monitor work or the knowledge acquired
Answering questions about theory and problem solving.
The acquisition of all competencies and learning outcomes can be improved by this method.
13
50
Carrying out individual or group assignments: Autonomous and / or collaborative learning to develop theoretical, practical or applied knowledge by carrying out projects, practice reports and / or assignments
Carrying out individual or group assignments
Autonomous study of the subject.
The acquisition of all competencies and learning outcomes can be improved by this method.
75
0
Evaluation of practical activities
Individual practical exercises or projects.
All competencies and learning outcomes 4 and 5 are checked.
20 %
Individual final test
Two individual mid-term exams to evaluate theoretical topics and practical questions in the computer classroom.
Mid-term exam 1 (40%): Theoretical exam, where learning outcomes 1, 2 and 3 are checked.
Mid-term exam 2 (40%): Practical exam, where all competencies and learning outcomes 4 and 5 are checked.
80 %
Evaluation of practical activities
Individual practical exercises or projects.
All competencies and learning outcomes 4 and 5 are checked.
20 %
Individual final test
Individual written exam to evaluate theoretical topics and practical questions in the computer classroom.
Learning outcomes 1, 2 and 3 are checked by the written theoretical exam. This part is worth 40% of the final grade and corresponds to the mid-term exam 1.
All competencies and learning outcomes 4 and 5 are checked by the practical questions in the computer classroom. This part is worth 40% of the final grade and corresponds to the mid-term exam 2.
80 %
Author: Oz, Effy
Title: Management information systems
Editorial: Cenage learning
Publication Date: 2015
ISBN: 1285186133
Author: LibreOffice Documentation Team
Title: Getting started with LibreOffice 6.0
Editorial: 12th Media Services
Publication Date: 2019
ISBN: 9781680922653
Author: Stair, Ralph M.
Title: Principles of Business Information Systems
Editorial: Cengage learning
Publication Date: 2015
ISBN: 9781473703889
Author: Benckendorff, Pierre
Title: Tourism information technology
Editorial: CABI
Publication Date: 2019
ISBN: 9781786393432
Author: Matthew MacDonald
Title: Access 2013: The missing manual
Editorial: O'Reilly Media
Publication Date: 2013
ISBN: 9781449357412
Author: Matthew MacDonald
Title: Excel 2013: The missing manual
Editorial: O'Reilly Media
Publication Date: 2013
ISBN: 9781449357276
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
http://office.microsoft.com/en-us/access/
http://office.microsoft.com/en-us/excel/
http://www.youtube.com/jfsanchezgarcia
http://www.youtube.com/soledadmmartinez