Information and Communication Technologies II


Information and Communication Technologies, Publication in the Diário da República - Plano 4 - 2010/2011

5.5 ECTS; 1º Ano, 2º Semestre, 30,0 PL + 30,0 TP


Knowledge of computers a user's perspective

Explore Excel as a tool to support enterprise tasks; know how to use functions; use Excel to produce graphics and data analyzes; use Excel as a BI tool; know how to automate routines using VB; use Excel to design forms

1.Introduction to Excel
4.Data analysis through decision supporting tools
5.Introduction to Business Intelligence
6.Visual Basic for Applications & Excel

Evaluation Methodology
Continuous assessment: Project I (20%) + Project II (20%) + Test (60%). Note: A minimum grade of 7 in each evaluation element is required

Final Assessment: Exam (100%)

- Bernardo, M. e Negas, M. e Isaías, P. (2013). Excel Aplicado. (Vol. I). Lisboa: FCA - Editora Informática
- Mendes, J. e Marques, C. e Silva, V. e Campos, R. (2010). Microsoft Excel 2007: Exercícios com Funções. Tomar: Instituto Politécnico de Tomar
- Campos, R. (0). Apresentação de Folha de Cálculo: Microsoft Excel 2013. Acedido em 22 de fevereiro de 2016 em
- Campos, R. (0). Apresentação de Programação em Visual Basic for Applications & Excel. Acedido em 22 de fevereiro de 2015 em

Method of interaction
Theoretical/Practical Classes: Demonstration of the syllabus to the students using the demonstrative and the lecture method

Practicals: Analysis and resolution of practical cases (adapted to the professional reality)

Software used in class
Microsoft Excel 2016

eLearning Plataform