Name: COMPUTING FOR BUSINESS
Code: 510102008
Type: Compulsory
ECTS: 6
Length of subject: Per term
Semester and course: 2nd 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
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
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:
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
[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.
[CG2 ]. To apply mathematical-statistical methods and information and communication technologies to the treatment, assessment, and forecasting of economic-business information.
[CE17 ]. Use the spreadsheet tools and database managers in the company
[CT4 ]. Using information resources responsibly
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.
Elements of the information system in business, including hardware, software, networks, databases and their different tools. Tools and models for decision making, using database managers and spreadsheets.
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
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)
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
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
Class in laboratory: practical classes / internships
No classes in laboratory.
0
100
Class in the field or open classroom (technical visits, lectures, etc.). In general, activities that require special resources or planning
No classes in the field or open classroom.
0
100
Class in a computer classroom: practical classes / internships
Practical class in computer classroom, where a problem is proposed giving time for its resolution. Resolution of questions
raised by the students.
All competencies CB3, CG2, CE17 and CT4 and learning outcomes 4 and 5 are acquired by this method.
34
100
Assessment activities (continuous assessment system)
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
Answering questions about theory and problem solving.
The acquisition of all competencies and learning outcomes can be improved by this method.
13
50
Student work: study or individual or group work
Carrying out individual or group assignments.
Autonomous study of the subject.
75
0
Presentation and defence of assignments
0 %
Spoken or written exams
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.
The multiple-choice tests 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.
80 %
Participation and involvement in the teaching-learning process
Attendance and active participation in the practical lessons. Individualized follow-up allows to determine the progression in the acquisition of competencies and learning results.
10 %
Evaluation of assignments and reports on practical sessions (final product, follow-up and contribution in the case of group work)
Individual practical exercises or projects.
All competencies and learning outcomes 4 and 5 are checked.
10 %
Spoken or written exams
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 50% of the final grade and corresponds to the mid-term exam 2, plus participation and involvement in the teaching-learning process.
The multiple-choice tests 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.
90 %
Evaluation of assignments and reports on practical sessions (final product, follow-up and contribution in the case of group work)
Individual practical exercises or projects.
All competencies and learning outcomes 4 and 5 are checked.
10 %
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
Author: Stair, Ralph M.
Title: Principles of Business Information Systems
Editorial: Cengage learning
Publication Date: 2015
ISBN: 9781473703889