Students have two evaluation possibilities:

1. CONTINUOUS ASSESSMENT. Through this route, students have the possibility of passing the course by presenting a loading application, solving problems, and participating in a social network and a blog. In the case of reaching more than 50 points, they will not have to do the final mixed test of the 1st opportunity.

2. FINAL MIXED TEST. This route will be applied when students do not reach a minimum of 50 points throughout the semester. In this case, the student will examine the complete syllabus, and 100% of the grade will come from this mixed test.

For students with recognition of part-time dedication and academic waiver of attendance exemption, as established by the "STARDARD THAT REGULATES OR RULES OF DEDICATION TO OR STUDY OF TWO GRADE AND MASTER UNIVERSITY STUDENTS IN UDC (Arts. 2.3; 3.b; 4.3 and 7.5) (04/05/207):

- Attendance / participation in minimum class activities: it can be compensated with remote development (on board) of the load application, conducting titories by videoconference with Teams and using the Virtual Campus and the virtual VDI desktops

- For problem solving and participation in the social network and blog, the delivery periods will be extended..

- Qualification: the same criteria will be applied..

The evaluation criteria contemplated in Table A-III / 6 of the STCW Code, and included in the Quality Assurance System, will be taken into account when designing and carrying out the evaluation.

Learning outcomes	Study programme competences
To be able to post information on a blog		B6 B8 B12 B19	C3 C7 C8 C13
To be able to share information with colleagues using cloud storage		B6 B12 B19 B22	C3
To be able to establish a network of professional contacts		B6 B12 B19	C3
To know the utilities and advanced programming possibilities of spreadsheets		B8 B14 B22	C7 C8 C13
To be able to develop an application to calculate the load, drafts, stability and structural resistance of the ship	A22 A31 A32	B2 B5 B8 B10 B12 B15 B16 B19	C3
To be able to program maritime-related plugins for a spreadsheet	A14 A22 A31 A32 A34 A36	B2 B5 B6 B8 B10 B12 B15 B16 B19	C3
To know how to correctly design the tables of a Database	A22 A36	B6 B8 B12 B14 B19 B22	C3 C13
To be able to integrate the information from a Database into a spreadsheet	A22	B2 B5 B6 B8 B10 B12 B19	C3

Topic	Sub-topic
1. FORMS, CONTROLS & DRAWING OBJECTS	1.1. INTRODUCTION 1.2. FORMS 1.3. CONTROLS 1.4. ADDING INTERACTIVITY 1.5. DRAWING OBJECTS
2. MACROS	2.1. INTRODUCTION 2.2. ADDING THE DEVELOPER TAB 2.3. ENABLE MACROS 2.4. STARTING EXCEL MACRO RECORDER 2.5. MACRO RECORDER OPTIONS 2.6. RECORDING THE MACRO 2.7. RUNNING THE MACRO 2.8. EDITING THE MACRO
3. VBA BASICS	3.1. LANGUAGE 3.2. VBA EDITOR 3.3. EXCEL VBA OBJECTS 3.4. VARIABLES 3.5. CONSTANTS 3.6. DIALOG BOXES
4. PROGRAMMING	4.1. THE CODE 4.2. CONTROLLING CODE EXCECUTION 4.3. MANIPULATING OBJECTS & COLLECTIONS 4.4. USEFUL APPLICATION PROPERTIES 4.5 RANGE OBJECTS
5. PROCEDURES	5.1. SUB PROCEDURES 5.2. FUNCTION PROCEDURES 5.3. PROCEDURE ARGUMENTS
6. USER FORMS	6.1. ALTERNATIVES 6.2. CREATING A USERFORM
7. EXCEL & ACCESS INTEGRATION	7.1. INTRODUCTION 7.2. ADO 7.3. FROM ACCESS TO EXCEL 7.4. FROM EXCEL TO ACCESS 7.5. SQL 7.6. RECORDSET OBJECT
8. CUSTOMIZE	8.1. EXCEL RIBBON 8.2. ADD-IN
9. BLOGS	9.1 INTRODUCTION 9.2. PUBLICATION 9.3. MARINA MERCANTE BLOG 9.4. WORDPRESS
10. SOCIAL NETWORKS	10.1 INTRODUCTION 10.2. LINKEDIN
The development and improvement of these contents, together with those corresponding to other subjects that include the acquisition of specific competences of the degree, guarantee the knowledge, understanding and sufficiency of the competences contained in table AII / 2, of the STCW Convention, related to the level of management of First Officer of the Merchant Marine Bridge, without limitation of gross tonnage and Captain of the Merchant Marine up to a maximum of 3000 GT.	Table A-II / 2 of the STCW Convention. Specification of the minimum standards of competence applicable to Captains and first deck officers of ships with a gross tonnage equal to or greater than 500 GT.

Methodologies / tests	Competencies	Ordinary class hours	Student’s personal work hours	Total hours
Problem solving	B2 B5 B8 B10 B12 B15 B16 B19 B22 C3	8	16	24
Mixed objective/subjective test	B2 B5 B10 B12 B14 B16 B19 B22 C3	2	10	12
Supervised projects	A22 A31 A32 B2 B5 B8 B10 B12 B15 B16 B19 C3	26	52	78
Collaborative learning	B6 B8 B12 B19 B22 C3 C7 C8 C13	4	8	12
Guest lecture / keynote speech	A14 A34 A36 B8 B12 B14 B19 B22 C3 C7 C8 C13	10	10	20

Personalized attention		4	0	4

(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies	Description
Problem solving	Master classes will be combined with problem solving by the students. This will be the most potentiated methodology during the course, and it will be used during the personal work of the students. The proposed problems will be related to the previous master class. The exercises that the students solve must be delivered to the Virtual Campus before the deadline for delivery. For those exercises of greater difficulty for the students, a much longer period can be provided, which will end near the end of the semester.
Mixed objective/subjective test	Students who do not achieve a minimum grade of 5 with the problems and assignments proposed throughout the semester will have the right to be evaluated by means of a mixed test, in which they will have to solve problems similar to those proposed throughout the course. The test will be developed using the Virtual Campus and Teams
Supervised projects	Students will be proposed to create a loading application for a ship that they can develop throughout the semester, incorporating the knowledge acquired during the master classes.
Collaborative learning	Students will use cloud storage to share class materials, and will have to create a profile on a social network that can facilitate job search and professional contacts. They will also have to contribute to a blog with a contribution of their own
Guest lecture / keynote speech	The sessions will take place in the classroom or through Teams and will be complemented with videos on Sharepoint. The week prior to the presentation of a topic, the teacher will post the contents on the Virtual Campus, providing the students with either materials or instructions on how to consult additional sources to deepen their study of the topic. After the presentation of the topic, the basic concepts will be worked individually on the computer by the students with the assistance of the teacher, being able to make use of the VDI virtual desktops.

Methodologies	Competencies	Description	Qualification
Problem solving	B2 B5 B8 B10 B12 B15 B16 B19 B22 C3	The resolution of computer problems related to the contents of the lectures will be valued up to a maximum of 30 points. Exercises delivered after the deadline will be valued at 50%	30
Supervised projects	A22 A31 A32 B2 B5 B8 B10 B12 B15 B16 B19 C3	The development of a loading application will be valued up to a maximum of 50 points.	50
Collaborative learning	B6 B8 B12 B19 B22 C3 C7 C8 C13	Active participation in a professional social network will be valued up to a maximum of 10 points. Participation in a blog on the subject will be valued up to a maximum of 10 points	20

Assessment comments
Students have two evaluation possibilities: 1. CONTINUOUS ASSESSMENT. Through this route, students have the possibility of passing the course by presenting a loading application, solving problems, and participating in a social network and a blog. In the case of reaching more than 50 points, they will not have to do the final mixed test of the 1st opportunity. 2. FINAL MIXED TEST. This route will be applied when students do not reach a minimum of 50 points throughout the semester. In this case, the student will examine the complete syllabus, and 100% of the grade will come from this mixed test. For students with recognition of part-time dedication and academic waiver of attendance exemption, as established by the "STARDARD THAT REGULATES OR RULES OF DEDICATION TO OR STUDY OF TWO GRADE AND MASTER UNIVERSITY STUDENTS IN UDC (Arts. 2.3; 3.b; 4.3 and 7.5) (04/05/207): - Attendance / participation in minimum class activities: it can be compensated with remote development (on board) of the load application, conducting titories by videoconference with Teams and using the Virtual Campus and the virtual VDI desktops - For problem solving and participation in the social network and blog, the delivery periods will be extended.. - Qualification: the same criteria will be applied.. The evaluation criteria contemplated in Table A-III / 6 of the STCW Code, and included in the Quality Assurance System, will be taken into account when designing and carrying out the evaluation.

Basic	Teaching Soft Group (2011). Access 2010: curso práctico. Paracuellos de Jarama, Madrid: Ra-Ma Walkengach, John (2007). Excel 2007 power programming with VBA. Hoboken, N.J.: Wiley McFedries, Paul (2010). Excel 2010: fórmulas y funciones. Madrid: Anaya Multimedia Carbonell, Lorenzo (1997). Introducción práctica a las bases de datos. Alicante: Universidad de Alicante Martin iglesias, Joaquín P. (2011). Manual imprescindible de servicios Google como herramienta educativa. Madrid: Anaya Multimedia Jeschke, Egbert (2011). Microsoft Excel 2010, Formulas & Functions Inside Out. Hoboken, N.J,: Microsoft Press Derrett, D.R. (2006). Ship Stability for Masters and Mates. Oxford: Butterworth-Heinemann Sanchez, Yoani (2011). Wordpress: un blog para hablar al mundo. Madrid: Anaya Multimedia
	Manuais en de carga e estabilidade en formato PDF específicos para o buque de traballo. Apuntes e transparencias elaboradas polo profesor.
Complementary	Alexander, Michael (2007). Microsoft Excel & Access integration with Office 2007. Indianapolis: Wiley Monk, Ellen F (2012). Problem solving cases in Microsoft Access & Excel. Boston, MA: Course Technology Bovey, Rob (2009). Professional Excel development: the definitive guide to developing applications using Microsoft Excel, VBA and .NET. Upper Saddle River (New Jersey): Addison-Wesley Bottfried, Byron S. (1998). Spreadsheet tools for engineers. Boston: McGraw-Hill

Other comments