Information and Communication Technologies II

Information and Communication Technologies
5.5 ECTS; 1º Ano, 2º Semestre, 30,0 PL + 30,0 TP

Lecturer
- Ricardo Nuno Taborda Campos

Prerequisites
Computer skills at the user level

Objectives
Students should be able to exploit Excel as a support tool in the context of an organization; use functions; master the graphical analysis of data; use Excel as BI tool; know how to automate routines resorting to the use of VB; use Excel to design forms

Program
1. Spreadsheet
2. Functions
3. Graphical analysis of data
4. Data analysis through decision support tools
5. Introduction to business intelligence
6. Programming in Visual Basic for Applications & Excel

Evaluation Methodology
Periodical assessment: Frequency (60%) + Project I(20%) + Project II(20%)
Final Assessment: Exam (100%)

Note: It is mandatory to have all the elements of evaluation to exempt from examination. Minimum grade of each evaluation element is 7 (seven).

Bibliography
- 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 em22 de fevereiro de 2016 em http://www.ccc.ipt.pt/~ricardo/ficheiros/Excel2013.pdf
- Campos, R. (0). Apresentação de Programação em Visual Basic for Applications & Excel.Acedido em22 de fevereiro de 2015 em http://www.ccc.ipt.pt/~ricardo/ficheiros/Excel_VBA.pdf

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 Office 2013 + Power BI add-ons