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
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
