Computer skills I

Recommended Prerequisites

Theoretical and practical knowledge of basic computer usage, covered by the syllabus of information technologies disciplines of high school courses.

Teaching Methods

The course unit is given using both expositive and participative methods, in interactive classes given in a computer lab. Whenever possible, the resolution of practical cases will be used.

Learning Outcomes

This curricular unit develops skills for using information technology in practice. By completing this unit the student should be capable of:
- Using the Excel software at an advanced level
- Organizing data in the spreadsheet aiming at problem resolution
- Understanding the role of macros in Excel
These learning outcomes contribute to develop several generic skills, namely use of computer tools, problem solving, information interpretation and information management.

Work Placement(s)

No

Syllabus

1. Introduction to computers and spreadsheets

2. Use of the Excel spreadsheet

- Operators and functions for arithmetic calculations, logical operations, text manipulation, basic descriptive statistics, value lookup, and conditional functions.

- Organization, formatting and data validation.

- Charts.

- Dynamic tables and charts.

- Macros.

Head Lecturer(s)

Manuel Paulo Albuquerque Melo

Assessment Methods

Continuous Assessment
Two practical tests on the computer, held during the lecturing period – 100%: 100.0%

Final Assessment
Exam: 100.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]

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. [BP 519. 6 MAR]

SOUSA, Maria José — Fundamental do Excel 2010. Lisboa : FCA-Editora de Informática, 2011. [BP 519. 6 SOU]