Information Technologies

Recommended Prerequisites

Não aplicável.

Teaching Methods

The course unit is given using both expositive and participative methods, in interactive classes given in a computer lab. The students will also be given hand-outs and exercise sheets to be solved either on class in supervised group work or as home assignments.

The mixed evaluation is carried out through 2 practical tests (corresponding to 65% of final grade) during the semester and a written examination (equivalent to 35% of the final grade). Alternatively the practical components can be evaluated within the framework of the final exam.

Learning Outcomes

Overall objectives

Present an overview of the information technology field and its application, as well as the development of skills for their usage in practice.

 Specific objectives

The student should gain knowledge regarding the working of computers and of computer networks and be able to use the IT terminology. The student should also develop skills in applying and developing processes to problem solving; increase their problem solving capabilities using Microsoft Excel and Visual Basic for Applications.

 Specific competencies

The student should develop technological instrumental skills related to the ability to use spreadsheets and programming in analysis and information processing tasks.

Work Placement(s)

No

Syllabus

• Computer architecture and behavior

• Information System components: Hardware and Software

• Information Technology evolution

• Computer and Telecommunication Networks

• Enterprise Information Technology usage

• Microsoft Excel spreadsheet: advanced usage

• Data analysis formulas and functions

• Information selection, handling and presentation

• Introduction to algorithms and programming

• Visual Basic programming inside Excel

Head Lecturer(s)

Óscar Manuel Domingos Lourenço

Assessment Methods

final exam
Exam: 100.0%

Mixed evaluation
a written examination : 35.0%
2 practical tests : 65.0%

Bibliography

ALMEIDA, Luís Miguel Alçada Tomás de — Computadores e tecnologias da informação: uma introdução ao mundo digital. Coimbra: IDTec, 2003. [BP 519.6 ALM]

AZUL, Artur Augusto — Introdução às tecnologias da informação: de acordo com as mais recentes linhas orientadoras de lecionação (2000/2001). Porto: Porto Editora, 2003-2005. 2 vols. [BP 519.6 AZU]

CARVALHO, Adelaide — Programação com Excel para economia e gestão. 2ª ed. act. e aument.. Lisboa: FCAEditora de Informática, 2008. [BP 519.6 CAR]

LOUREIRO, Henrique — Excel 2007 Macros e VBA: curso completo. Lisboa FCA-Editora de Informática, 2008. [BP 519. 6 LOU]

MARQUES, Paulo Capela — Exercícios de Excel 2010. Lisboa: FCA-Editora de Informática, 2011

SOUSA, Maria José — Fundamental do Excel 2010. Lisboa: FCA-Editora de Informática, 2011