Information Technologies
1
2015-2016
01620219
Information Systems
Portuguese
Face-to-face
SEMESTRIAL
4.0
Compulsory
1st Cycle Studies
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)
NoSyllabus
• 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)
Víctor Manuel dos Reis Raposo
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