Facultad de Ciencias de la Empresa Facultad de Ciencias de la Empresa Facultad de Ciencias de la Empresa
HUB
HUB
Calidad
Actualidad
Agenda
International [EN]
Buscador
El Centro
Estudios
Movilidad
Empleo
Investigación
Trámites
Universidad Politécnica de Cartagena Universidad Politécnica de Cartagena Universidad Politécnica de Cartagena European University of Technology European University of Technology European University of Technology
HUB
Calidad
Actualidad
Agenda
International [EN]
Buscador
El Centro
Estudios
Movilidad
Empleo
Investigación
Trámites

Inicio / Estudios / Grado en Administración y Dirección de Empresas - Plan 2024 / Plan de Estudios

Course Unit Description

COMPUTING FOR BUSINESS

Course 2025-26

  • On-site

1.Subject data

Name: COMPUTING FOR BUSINESS

Code: 510201006

Type: Compulsory

ECTS: 6

Length of subject: Per term

Semester and course: 1st Year - First term

Speciality:

Language: English

Mode of study: On-site class

2. Lecturer data

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, G3

3. Competences and learning outcomes

3.1. Basic curricular competences related to the subject

3.2. General curricular competences related to the subject

3.3. Specific curricular competences related to the subject

3.4. Transversal curricular competences related to the subject

3.5. Subject learning outcomes

1. Use information resources proficiently.
2. Identify basic computing skills.
3. Identify the different types and possibilities offered by e-commerce in business.
4. Use office software properly.
5. Identify, analyse and model problems with spreadsheets and database managers.

4. Contents

4.1 Curricular contents related to the subject

Elements of the information system in business, including hardware, software, networks, databases and their different tools. Analysis of the use of the Internet in business, especially e-commerce. Decision-making tools and models through the use of database managers and spreadsheet office applications.

4.2. Theory syllabus

Teaching modules

Units

Information systems

1. Business information systems
2. Hardware
3. Software
4. Business networks and telecommunications
5. Databases
6. Web-enabled commerce
7. Decision support and expert systems, business intelligence
8. Planning, acquisition and controls

Office productivity applications

9. Database management
10. Spreadsheets

4.3. Practice syllabus

Name

Description

Database management

Tables creation Filters Selection queries Action queries Forms Reports

Spreadsheets

Commissions (references and formats) Sales estimation Tax rate scale (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) Sales report (pivot tables, pivot charts) Investment analysis (scenario manager, random numbers) Retirement plan (tables, protection, printing) Linear regression (statistical analysis, TREND, GROWTH) Portfolio (Solver)

Risks prevention

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.

4.4. Comments

5. Teaching method

Name

Description

Hours

In-class

Name

Class in conventional classroom: theory, problems, case studies, seminars, etc

Description

Expository class using the method of the lesson and the case method. Resolution of questions raised by the students. Problem solving class.



Learning outcomes 1, 2 and 3 are acquired by this method.

Hours

23

In-class

100

Name

Class in a computer classroom: practical classes / internships

Description

Practical class in computer classroom, where a problem is proposed giving time for its resolution. Resolution of questions

raised by the students.



Learning outcomes 4 and 5 are acquired by this method.

Hours

34

In-class

100

Name

Assessment activities (continuous assessment system)

Description

Written and computer evaluation (mid-term exams).



The acquisition of all learning outcomes is tested.

Hours

3

In-class

100

Name

Assessment activities (final assessment system)

Description

Written and computer evaluation (official exam).



The acquisition of all learning outcomes is tested.

Hours

2

In-class

100

Name

Tutorials

Description

Answering questions about theory and problem solving.



The acquisition of all learning outcomes can be improved by this method.

Hours

13

In-class

50

Name

Student work: study or individual or group work

Description

Carrying out individual or group assignments. Autonomous study of the subject.

Hours

75

In-class

0

6. Assessment method

6.1. Continous assesment system

Name

Description and criteria

Percentage

Name

Spoken or written exams

Description and criteria

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 tested.



The exam may consist of short questions, essay questions or multiple-choice tests. In the case of a multiple-choice test, it may be single-choice, including a penalty for incorrect answers equal to or greater than the probability of obtaining the answer at random, or multiple-choice with no penalty.



Mid-term exam 2 (40%): Practical exam, where learning outcomes 4 and 5 are tested.



Percentage

80 %

Name

Presentation and defence of assignments

Description and criteria

Delivery of practical exercises at the end of the class and exercises, individually or in groups, carried out in class. Learning outcomes 4 and 5 are tested.

Percentage

20 %

6.2. Final assesment system

Name

Description and criteria

Percentage

Name

Spoken or written exams

Description and criteria

Individual written exam to evaluate theoretical topics and practical questions in the computer classroom



Learning outcomes 1, 2 and 3 are tested by the written theoretical exam. This part is worth 40% of the final grade and corresponds to the mid-term exam 1.



The theoretical exam may consist of short questions, essay questions or multiple-choice tests. In the case of a multiple-choice test, it may be single-choice, including a penalty for incorrect answers equal to or greater than the probability of obtaining the answer at random, or multiple-choice with no penalty.



Learning outcomes 4 and 5 are tested by the practical questions in the computer classroom. This part is worth 60% of the final grade and corresponds to the mid-term exam 2 (40%), plus the participation and practical activities of the continuous assessment system (20%).



The student may repeat any part of the continuous assessment system in the final assessment, but in this case only the new mark will be valid and the previous mark will not be taken into account. In those parts that are not repeated, the mark obtained in continuous assessment will be maintained.



The marks obtained in the final assessment system will not be retained for the extraordinary exam.

Percentage

100 %

Information

7. Bibliography and resources

7.1. Basic bibliography

Author: Oz, Effy
Title: Management information systems
Editorial: Cenage learning
Publication Date: 2015
ISBN: 1285186133

Author: MacDonald, Matthew
Title: Access 2013: The missing manual
Editorial: O'Reilly Media
Publication Date: 2013
ISBN: 9781449357412

Author: MacDonald, Matthew
Title: Excel 2013: The missing manual
Editorial: O'Reilly Media
Publication Date: 2013
ISBN: 9781449357276

7.2. Supplementary bibliography

Author: Stair, Ralph M.
Title: Principles of Business Information Systems
Editorial: Cengage learning
Publication Date: 2015
ISBN: 9781473703889

7.3. On-line resources and others

http://office.microsoft.com/en-us/access/
http://office.microsoft.com/en-us/excel/
http://www.youtube.com/jfsanchezgarcia
http://www.youtube.com/soledadmmartinez

CRAI
Campus Virtual
Sede
UPCT-TV

(+34) 968 32 55 69

decanato@fce.upct.es

  • EL CENTRO
    • Equipo de Dirección
    • Junta Directiva
    • Secretaría Académica
    • Delegación de Estudiantes
    • Calendario del Centro
    • Profesorado
    • Departamentos
    • Normativa
  • HUB
  • ESTUDIOS DE GRADO
    • Doble Grado en Administración y Dirección de Empresas y Turismo
    • Grado en Administración y Dirección de Empresas - Plan 2009
    • Grado en Administración y Dirección de Empresas - Plan 2024
    • Grado en Turismo - Plan 2018
    • Grado en Turismo - Plan 2024
  • ESTUDIOS DE MÁSTER
    • Máster Universitario en Administración y Dirección de Empresas (MBA)
    • Máster Universitario en Dirección de Entidades de la Economía Social
    • Máster Universitario en Gestión y Dirección de Empresas e Instituciones Turísticas - Plan 2024
    • Máster Interuniversitario en Contabilidad y Finanzas Corporativas (COFIC)
    • Máster Interuniversitario en Orientación e Intermediación Laboral
    • Máster Interuniversitario en Prevención de Riesgos Laborales
  • MOVILIDAD
    • Erasmus+
  • INVESTIGACIÓN
    • Grupos de Investigación
    • Cátedras
  • ACTUALIDAD
    • Noticias
    • Agenda
  • TRÁMITES
  • CALIDAD
  • EMPLEO
  • CONTACTO
    • Ubicación

    • Calle Real, 3
      30201 - Cartagena

Conserjería
(+34) 968 32 55 69
Dirección

(+34) 968 32 55 69
decanato@fce.upct.es

Conserjería
Dirección
Logo FCE
Universidad Politécnica de Cartagena EUt+ 25 Aniversario de Universidad Politécnica de Cartagena