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