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
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
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. 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.
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. Problem solving class.
Learning outcomes 1, 2 and 3 are acquired by this method.
23
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.
Learning outcomes 4 and 5 are acquired by this method.
34
100
Assessment activities (continuous assessment system)
Written and computer evaluation (mid-term exams).
The acquisition of all learning outcomes is tested.
3
100
Assessment activities (final assessment system)
Written and computer evaluation (official exam).
The acquisition of all learning outcomes is tested.
2
100
Tutorials
Answering questions about theory and problem solving.
The acquisition of all 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
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 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.
80 %
Presentation and defence of assignments
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.
20 %
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 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.
100 %
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