IPT Logotipo do IPT

Tecnologias de Informação e Comunicação

Information and Communication Technologies II

<< back to Curriculum Plan

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

(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

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
- 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 2013. Acedido em 22 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 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 2016

eLearning Plataform

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado