Tecnologias de Informação

Base Knowledge

There are none.

Teaching Methodologies

The contents of the course is presented through examples with discussion. (Expositive Method)

Students solve exercises to practice solving different types of problems. (Experimental Method)

Learning Results

After attending Information Technologies course, it is expected that each student knows how to efficiently and autonomously use Office tools:

  • Solve different types of problems using computer, namely data analysis and processing;
  • Use spreadsheets to automate calculations and procedures;
  • Develop simple functions in VBA in Excel;
  • Design a database in the relational model;
  • Create a database in Access keeping integrity rules;
  • Create different types of queries in an Access database.

Program

1. Data analysis and treatment (in Excel)

a) Editing, formatting and selecting cells and/or ranges

b) Formulas and functions

c) Lists and series

d) Relative, absolute and mixed references

e) Graphics

2. Excel applied to Management

Excel financial formulas

3. VBA Programming

a) VBA architecture

– Data types

– Methods

– Arrays

– Variable declaration

– Control structures

b) Functions

4. Database Management System

a) Database Models

b) Using Access

– Design of a Database

– Construction of efficient tables and their relationships

– Creation of selection queries and action queries (deletion, insertion and update)

Curricular Unit Teachers

Internship(s)

NAO

Bibliography

Carvalho, A. (2008). Programação com excel para economia & gestão. FCA.

Carvalho, A. (2012). Exercícios resolvidos com excel para economia & gestão. FCA.

Martins, A. (2020). Excel aplicado à gestão: Exemplos resolvidos. Sílabo.

McGrath, M. (2019). Access in easy steps. In easy steps limited.

Wilson, K. (2020). Using excel 2019: The step-by-step guide. Elluminet Press.