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 , Cód. 925016.
Lecturer
- Ricardo Nuno Taborda Campos (2)
(1) Docente Responsável
(2) Docente que lecciona
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
7.Forms
Evaluation Methodology
Continuous assessment: Individual Project (25%) + frequency (75%). Note: A minimum grade of 7 in each evaluation element is required
Final Assessment: Exam (100%)
Bibliography
- Bernardo, M. e Negas, M. e Isaías, P. (2013). Excel Aplicado. (Vol. I). Lisboa: FCA - Editora Informática
- Campos, R. (0). Apresentação de Folha de Cálculo: Microsoft Excel 2010. Acedido em 22 de fevereiro de 2015 em http://www.ccc.ipt.pt/~ricardo/ficheiros/Excel2010.pdf
- Campos, R. (0). Apresentação de Programação em Visual Basic for Applications & Excel. Acedido em 22 de fevereiro de 2015 em http://www.ccc.ipt.pt/~ricardo/ficheiros/Excel_VBA.pdf
- 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
Teaching Method
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 2010
eLearning Plataform
