|
Teaching GuideTerm Higher Technical University College of Nautical Science and Naval Engines |
| Grao en Náutica e Transporte Marítimo |
 Subjects |
| Applied Informatics |
| Contents |
|
|
| Identifying Data | 2021/22 | |||||||||||||
| Subject | Applied Informatics | Code | 631G01501 | |||||||||||
| Study programme |
|
|||||||||||||
| Descriptors | Cycle | Period | Year | Type | Credits | |||||||||
| Graduate | 2nd four-month period |
Third | Optional | 6 | ||||||||||
|
||||||||||||||
| 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. |
|
