Teaching guide for the course:

Computing for Business

Degree program: Degree in Business Administration and Management

Year 2014-2015

1. Information about the course

Name Computing for Business

Subject* Computing

Module* Quantitative Methods for Business

Code 510102008

Degree awarded Degree in Business Administration and Management

Study plan 2010

School Facultad de Ciencias de la Empresa (Faculty of Business Sciences)

Type Compulsory

Academic term First quarter Quarter 1st. Year 2nd.

Language English

ECTS 6 Hours / ECTS 25 Total workload (hours) 150

* All terms marked with an asterisk are defined in Referencias para la actividad docente en la UPCT y Glosario de términos:

http://repositorio.bib.upct.es/dspace/bitstream/10317/3330/1/isbn8469531360.pdf

2. Information about the instructor

Instructor Juan Francisco Sánchez García

Department Quantitative and Computer Methods

Area of knowledge Quantitative Methods for Business

Office location Third floor, office 321

Tel 968 325623 Fax 968 325745

E-mail jf.sanchez@upct.es

URL / WEB http://metodos.upct.es/jfsanchez

Office hours / Tutorials Published on “Aula Virtual” and on bulletin board

Location during tutorials Office 321

Teaching and research

profile Assistant Professor (Profesor Contratado Doctor)

Teaching experience Since 1996 in courses related to computing for business

Areas of research Computing, programming, simulation, game theory

Professional

experience Business assistant for 11 years

Other topics of interest

Instructor Soledad María Martínez María Dolores

Department Quantitative and Computer Methods

Area of knowledge Quantitative Methods for Business

Office location Third floor, office 327

Tel 968 325780 Fax 968 325745

E-mail soledad.martinez@upct.es

URL / WEB http://metodos.upct.es/smmd/

Office hours / Tutorials Published on “Aula Virtual” and on bulletin board

Location during tutorials Office 327

Teaching and research

profile Assistant Professor (Profesor Contratado Doctor)

Teaching experience Since 1999 in courses related to computing for business

Areas of research Computing, social media, electronic commerce and e-tourism

Professional

experience Banking, business assistant, international department

Other topics of interest

3. Description of the course

3.1. Presentation

The aim of this course is to provide the student the knowledge of information systems, and its components like hardware, software, networks, database, web commerce, and the use of tools like database managers and spreadsheets as a tool for decision support systems.

3.2. Adaptation to the professional profile

3.3. How it relates to other courses

The course Computing for Business is part of the block “Computing” which is formed by this course and Extended Computing for Business (third year, 4.5 ECTS, 2nd. quarter, elective).

3.4. Incompatibilities

None.

3.5. Recommendations for taking the course

3.6. Students with special needs

Any student who has particular circumstances and may require special resources should let the professor know at the beginning of the quarter.

4. Skills and learning outcomes

4.1. Basic skills* from the study plan associated with the course

Que los estudiantes hayan demostrado poseer y comprender conocimientos en un área de estudio que parte de la base de la educación secundaria general, y se suele encontrar a un nivel que, si bien se apoya en libros de texto avanzados, incluye también algunos aspectos que implican conocimientos procedentes de la vanguardia de su campo de estudio.

Que los estudiantes sepan aplicar sus conocimientos a su trabajo o vocación de una forma profesional y posean las competencias que suelen demostrarse por medio de la elaboración y defensa de argumentos y la resolución de problemas dentro de su área de estudio.

Que los estudiantes tengan la capacidad de reunir e interpretar datos relevantes (normalmente dentro de su área de estudio) para emitir juicios que incluyan una reflexión sobre temas relevantes de índole social, científica o ética.

Que los estudiantes puedan transmitir información, ideas, problemas y soluciones a un público tanto especializado como no especializado.

Que los estudiantes hayan desarrollado aquellas habilidades de aprendizaje necesarias para emprender estudios posteriores con un alto grado de autonomía.

4.2. General skills from the study plan associated with the course

Analizar y conocer el entorno económico-financiero relevante para la empresa y la sociedad, identificando las principales fuentes de información.

Aplicar los métodos matemático-estadísticos y las tecnologías de la información y la comunicación para el tratamiento, valoración, y previsión de la información económico-empresarial.

Emitir informes de asesoramiento sobre situaciones concretas de la empresa y los mercados.

Planificar, organizar, decidir y controlar las diferentes áreas de la gestión empresarial, aplicando sistemas de gestión estratégica avanzada.

Conocer y gestionar la operativa financiero-bancaria. Planificar y ejecutar acciones de marketing operativo y estratégico de forma

innovadora. Analizar y resolver problemas jurídicos relacionados con la empresa. Aplicar al análisis de los problemas criterios profesionales basados en el manejo de

instrumentos técnicos, desarrollando la capacidad de adaptación e innovación.

4.3. Specific skills* from the study plan associated with the course

1. Knowledge of hardware and software available for business. 2. Knowledge of the benefits of e-business and e-commerce for business. 3. Ability to manage spreadsheets and database managers for business.

4.4. Transversal skills from the study plan associated with the course

Oral and written communication in an effective way (Comunicarse oralmente y por escrito de manera eficaz).

Ability to work as a team (Trabajar en equipo). Auto-didactic skills (Aprender de forma autónoma). Use information resources successfully (Utilizar con solvencia los recursos de

información). Ability to put the knowledge into practice (Aplicar a la práctica los conocimientos

adquiridos). Apply ethical and sustainability criteria in decision-making (Aplicar criterios éticos y de

sostenibilidad en la toma de decisions). Design and undertake innovative projects (Diseñar y emprender proyectos

innovadores).

4.5. Learning outcomes** of the course

1. Knowledge of basic computer science topics 2. Knowledge of the advantages of using computer business 3. Ability to analyse and select best information system for a business 4. Ability to use database managers and spreadsheets 5. Ability to identify, analyse and model problems with spreadsheets.

** See also Guía de apoyo para la redacción, puesta en práctica y evaluación de los resultados del aprendizaje, by ANECA:

http://www.aneca.es/content/download/12765/158329/file/learningoutcomes_v02.pdf

5. Contents

5.1. Contents according to the study plan

Basic concepts of computing science: information systems, hardware, software, networks, Internet, electronic business, decision support, business intelligence and planning, acquisition and controls. Use of database managers and spreadsheets and model of problems.

5.2. Theory (modules and didactic units)

BLOCK I: INFORMATION SYSTEMS 1. Business information systems

1.1. Data, information, and information systems 1.2. Information systems in business functions

2. Hardware

2.1. Inside the computer 2.2. Input devices 2.3. Output devices 2.4. Storage media

3. Software

3.1. Instructions to the hardware 3.2. Programming languages 3.3. Compilers and interpreters 3.4. Application software

4. Business networks and telecommunications

4.1. Telecommunications 4.2. Bandwidth and media 4.3. Networks 4.4. Protocols 4.5. Internet

5. Databases

5.1. Managing digital data 5.2. Database models 5.3. Data modeling 5.4. Databases on the web 5.5. Data warehousing

6. Web-enabled commerce

6.1. Web business 6.2. Web technologies 6.3. Web-enabled business 6.4. Supply chains on the web 6.5. Options in establishing a web site 6.6. Rules for successful web-based business

7. Decision support and expert systems, business intelligence

7.1. Decision support systems 7.2. Expert systems 7.3. Business intelligence and knowledge management

8. Planning, acquisition and controls 8.1. Systems planning and development 8.2. Choices in system acquisitions 8.3. Risks security and disaster recovery

BLOCK II: COMPUTER APPLICATIONS

9. Database management

9.1. Basic topics 9.2. Data types 9.3. Tables 9.4. Queries 9.5. Forms 9.6. Reports

10. Spreadsheets

10.1. Basic topics 10.2. Data edition and formulas 10.3. Functions 10.4. Charts 10.5. Tables y lists 10.6. Pivot tables 10.7. Data analysis

5.3. Program of practical application (name and description of each practice)

Microsoft Access 1. Tables creation 2. Filters 3. Selection queries 4. Action queries 5. Forms 6. Reports

Microsoft Excel

1. Commissions (references and formats) 2. Sales prevision I 3. Taxes (Lookups and tables) 4. Commissions II (database functions, frequency, RANK, filters) 5. Subsidiaries (references, links, subtotals) 6. Break-even (goal seek, charts) 7. Loan (data validation, manual calculation, formula auditing, conditional formatting) 8. Equations system (matrix calculations, named ranges) 9. Sales (pivot tables, pivot charts) 10. Investment analysis (scenario manager, random numbers) 11. Rents (tables, protection, printing) 12. Sales prevision II (statistical analysis, TREND, GROWTH)

5.4. Program of theory in Spanish (modules and teaching units)

PARTE PRIMERA: EL SISTEMA INFORMÁTICO 1. Sistemas de información en la empresa

1.1. Datos, información y sistemas de información 1.2. Sistemas de información en las organizaciones

2. Hardware 2.1. Unidad central 2.2. Dispositivos de entrada 2.3. Dispositivos de salida 2.4. Dispositivos de almacenamiento

3. Software

3.1. Instrucciones 3.2. Lenguajes de programación 3.3. Compiladores e intérpretes 3.4. Aplicaciones informáticas

4. Redes y telecomunicaciones

4.1. Telecomunicaciones 4.2. Ancho de banda y tipos de conexión 4.3. Redes 4.4. Protocolos 4.5. Internet

5. Bases de datos

5.1. Almacenamiento digital 5.2. Modelos de base de datos 5.3. Modelado de datos 5.4. Bases de datos en web 5.5. Data warehousing

6. Comercio electrónico

6.1. Negocio web 6.2. Tecnologías web 6.3. Negocio electrónico (web-enabled business) 6.4. Cadena de suministro en web 6.5. Creación de un sitio web 6.6. Reglas para el negocio electrónico con éxito

7. DSS, sistemas expertos y business intelligence

7.1. DSS 7.2. Sistemas expertos 7.3. Business intelligence y gestión del conocimiento

8. Planificación, adquisición y control

8.1. Planificación y desarrollo de sistemas 8.2. Alternativas en la adquisición de sistemas 8.3. Riesgos, seguridad y recuperación de catástrofes

PARTE SEGUNDA: HERRAMIENTAS OFIMÁTICAS DE GESTIÓN

9. Gestión de base de datos

9.1. Conceptos básicos 9.2. Tipos de datos 9.3. Tablas 9.4. Consultas 9.5. Formularios 9.6. Informes

10. Hoja de cálculo

10.1. Conceptos básicos 10.2. Edición de datos y fórmulas

10.3. Funciones 10.4. Gráficos 10.5. Tablas y listas 10.6. Tablas dinámicas 10.7. Análisis de datos

5.5. Learning objectives detailed by modules

1. Information systems Knowledge of basic computer science topics Knowledge of the advantages of using computer business Ability to analyse and select best information system for a business

2. Computer applications Ability to use database managers and spreadsheets Ability to identify, analyse and model problems with spreadsheets.

6. Teaching methodology

6.1. Teaching methodology*

Activity* Work of the instructor Work of the student Hours

Theory class Presentation type of class taught using the lecture method. Answering questions raised by the students.

On-campus: Taking notes, asking questions

30

Off-campus: Study of the subject 30

Computer lab Learning to use the tools of general software (spreadsheets and database managers) for solving problems.

On-campus: Active participation, problem solving, asking questions

32.5

Off-campus: Practice using the software by solving practical cases

40

Tutorials Answering any questions about theory, and solving problems.

On-campus: Asking of questions during the tutorial hours

12.5 Off-campus: Asking questions by e-mail

Exams Written and computer evaluation (official exam).

On-campus: Attendance at formal review

5

Off-campus:

150

6.2. Outcomes (4.5) / teaching activities (6.1) (optional)

Learning outcomes (4.5) 7.

Teaching activities (6.1) 1 2 3 4 5 6 7 8 9 10

Theory lesson X X X

Practical lesson X X

Tutorials X X X X X

Exams X X X X X

7. Evaluation

7.1. Evaluation techniques *

Instrument

Type

Completion and criteria * Weight

(%)

Outcomes (4.5)

evaluated

Sum

mat

ive

*

Form

ativ

e*

Written tests

Theoretical questions (concepts, definitions, etc.).

Up to 50%

1, 2, 3

Practical test Practical questions in the computer classroom.

50% 4, 5

Class attendance Personalized monitoring Up to 10%

1, 2, 3, 4, 5

7.2. Mechanisms for control and tracking progress (optional)

Class attendance: The student will be evaluated on classroom attendance during the course. Attendance will account up to 10% of the final grade for the course (provided the student earns at least a 4 on the tests). Since the class size is small, each student's learning is monitored almost personally. The student's participation in the theoretical and practical classes will be evaluated. Exam: an examination will be given on the contents covered during the course, which will include theoretical and practical questions and problems to be solved. The characteristics of the exam, as well as the date, time and location will be indicated on the announcement, which is given at least 15 days before the scheduled exam. The tests (exams, classroom participation, solving practical cases, etc) enable detecting possible gaps and make it possible to consolidate the most important concepts of the course.

8. Bibliography and resources

8.1. Basic bibliography *

BERNAL GARCÍA, J.J.; SÁNCHEZ GARCÍA, J.F., MARTÍNEZ MARÍA DOLORES, S.M. (2008):“20 herramientas para la toma de decisiones”, Especial Directivos, Madrid.

MACDONALD, Matthew (2013): “Access 2013: The Missing Manual”, O’Reilly Media, USA.

MACDONALD, Matthew (2013): “Excel 2013: The Missing Manual”, O’Reilly Media, USA.

OZ, Effy (2009): “Management Information Systems, Sixth Edition”, Thomson, USA.

8.2. Additional bibliography *

ARJONILLA DOMÍNGUEZ, S.J.; MEDINA GARRIDO, J.A. (2009): “La gestión de los sistemas de información en la empresa. Teoría y casos prácticos”, Ediciones Pirámide, Madrid.

ESTRATEGIA FINANCIERA (Revista), Editorial CISS - Especial Directivos, Madrid.

8.3. Online resources and other resources

http://aulavirtual.upct.es

http://office.microsoft.com/en-us/access/

http://office.microsoft.com/en-us/excel/

http://office.microsoft.com/en-us/training/microsoft-excel-training-curriculum-guide-FX102828216.aspx

http://www.youtube.com/jfsanchezgarcia

http://www.youtube.com/soledadmmartinez