Tecnologias de Informação

The teaching of this subject will be divided in three parts:
– a theoretical part with the exposition and illustration of the theoretical foundations,
– a practical part with problem solving,
– a laboratory part with the usage of equipment and software to enhance learning outcomes.

After attending to Information Technologies course, each student should
Be able to efficiently use the computer to solve several kind of problems, namely using a spreadsheet;
Have fundamental knowledge on computer programming, in particular VBA used in Excel;
Know how to use and create a database in Access.

1. Data analysis and processing (in Microsoft Excel)
a) Editing, formatting, and selection of cells and/or ranges
b) Formulas and Functions
c) Lists and Series
d) Relative, absolute, and mixed references
e) Graphics
f) Task automation (Macros)
g) Access to databases (Microsoft Access, SQL Server, OLAP, Text Files)
2. Programming in VBA
a) VBA Architecture
– Types of data
– Methods
– Arrays
– Variable declaration
– Control structures
b) Functions (text, mathematics, formatting, conversion)
c) Objects
3. Database Management System
a) Database models
b) Applications in Microdoft Access
– Design of a Database
– Construction of efficient tables and their relationships
– Creation of selection queries and action queries (insertion, update, and delection)
– Forms and reports creation
c) Connecting Microsoft Access to other programs: link to Word and Excel, import/export data

• - Nota Final = ProvaEscrita x 0,25 + TrabalhoLaboratorial1 x 0,25 + TrabalhoLaboratorial2 x 0,25 + TrabalhoLaboratorial3 x 0,25 - 100.0%

NAO