Code: | CC3007 | Acronym: | CC3007 | Level: | 300 |
Keywords | |
---|---|
Classification | Keyword |
OFICIAL | Computer Science |
Active? | Yes |
Responsible unit: | Department of Computer Science |
Course/CS Responsible: | Bachelor in Computer Science |
Acronym | No. of Students | Study Plan | Curricular Years | Credits UCN | Credits ECTS | Contact hours | Total Time |
---|---|---|---|---|---|---|---|
L:B | 0 | Official Study Plan | 3 | - | 6 | 56 | 162 |
L:CC | 31 | Plano de estudos a partir de 2014 | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:F | 1 | Official Study Plan | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:G | 2 | study plan from 2017/18 | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:M | 4 | Official Study Plan | 2 | - | 6 | 56 | 162 |
3 | |||||||
L:Q | 1 | study plan from 2016/17 | 3 | - | 6 | 56 | 162 |
MI:ERS | 35 | Plano Oficial desde ano letivo 2014 | 2 | - | 6 | 56 | 162 |
3 |
Provide the student experience in the use, administration and programming of some of the systems / applications currently used in the Windows environment. The particular focus is on the programming environment of Visual Basic for Applications.
Know how to develop programs that use MS Excel.
Know how to develop programs that use MS Access.
Create systems capable of integrating these two above mentioned tools.
Frequency of an initial course on programming, preferably an imperative language.
Microsoft Excel: Working environment. Data types. Format data. Documenting data. Referencing cells. Formulas. Operators. Functions. Soma automatic and automatic calculation.
Microsoft Access: Fundamentals database. Work environment. Tables. Types and properties of the data. Referential integrity. Relationships and associations. Queries. Query types. Forms and sub-forms. Controls. Types of controls. Reports, sub-reports and sections. Macros. Security.
Visual Basic for Applications (VBA): Variables. Operators. Procedures. Arguments. Arrays. Decision-making structures. Cycles. Basic functions. Objects. VBA and Excel. Objects Workbook, Worksheet and Range. VBA and Access. The Form, Report, and Control objects. ActiveX Data Objects (ADO). Objects Connection, Command and Recordset. Error handling. Collections. Class modules.
Expository method; demonstrations; resolutions of exercises and practical coursework.
designation | Weight (%) |
---|---|
Teste | 60,00 |
Trabalho laboratorial | 40,00 |
Total: | 100,00 |
designation | Time (hours) |
---|---|
Estudo autónomo | 40,00 |
Frequência das aulas | 56,00 |
Trabalho laboratorial | 56,00 |
Apresentação/discussão de um trabalho científico | 10,00 |
Total: | 162,00 |
Completing all practical work; minimum score of 4 in the practical works; minimum score of 4 out of 12 on the set of the two tests; attend 75% of the practical classes.
Sum of all parts: coursework 1 (4 points), coursework2 (4 points), Exam (12 points).
This gives a maximum of 20 points, which are converted to the correspondent scale.
Coursework1 (Excel-VB). Coursework2 (Access-VBA).