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
Knowledge of computers a user's perspective

Objectives
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

Program
1.Introduction to Excel
2.Functions
3.Graphics
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%)

Bibliography
- Campos, R. e Silva, V. e Marques, C. e Mendes, J. (2010). Microsoft Excel 2007: Exercícios com Funções. Tomar: Instituto Politécnico de Tomar
- Isaías, P. e Negas, M. e Bernardo, M. (2013). Excel Aplicado. (Vol. I). Lisboa: FCA - Editora Informática
- 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
- 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

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