IT Applications II

Approval in the Aplicações Informáticas 1 is recommended.

Classes are taught on a theoretical-practical basis, in computer rooms.

The expository methodology will be used to present the concepts of the curricular unit, supported by practical experimentation on computers, through exercises to apply the transmitted concepts.

Student-centered teaching and learning, availability of teaching materials in advance, development of activities and classes almost entirely aimed at the application of concepts, with fundamentally interactive dynamics.

This methodology allows regular monitoring, knowledge and awareness of the syllabus covered each week, promoting discussion, involvement and collaboration of everyone in the learning process.

This curricular unit, UC, follows on from Aplicações Informáticas 1.

Thus, one of the objectives of this UC is to promote the development of new skills in the practical application of the Microsoft Excel spreadsheet, raising students’ awareness of the importance of this tool in data processing, calculation, organization and information management. It is also the objective of this UC to present the valences of Microsoft Excel in the scope of: solving complex problems translated into a mathematical model; the application of financial functions and the use of automatisms such as command macros.

It is intended, therefore, that this UC allows the creation of a set of skills/aptitudes in line with its objectives, namely in the application of: database functions; the potential of dynamic tables and graphs; of financial functions and command macros, taking advantage of these valences to speed up operations in spreadsheet space.

1- Data Management and Organisation
1.1 Introduction: general concepts;
1.2 Automatic filters and advanced filters;
1.3 Database functions;

2 – Pivot Tables and Graphs

2.1 Motivation and contextualization;
2.2 Pivot tables: fields to relate and definition of relationships;
2.3 Construction of dynamic graphs: data structure and graph options.

3. Financial Functions
3.1 Introductory Concepts: summary characterization of financial operations;
3.2 Fees, interest and amortization;
3.3 Debt repayment plans;
3.4 Evaluation of investment projects

4. Macros
4.1 Fundamental Concepts;
4.2 Macro creation, execution and options;
4.3 Basic Introduction to VBA.

5. Forms
5.1 General concepts

NAO

Basic Bibliography:
[1] Luís Silva Rodrigues | UTILIZAÇÃO DO EXCEL PARA ECONOMIA & GESTÃO, ISBN: 978-972-722-775-4, FCA–Editora Informática, 2016
[2] Paulo Capela Marques | Nuno Costa, FUNDAMENTAL DO EXCEL 2013, ISBN: 978-972-722-800-3, FCA–Editora Informática, 2014

Complementary Bibliography:
[3] Adelaide Carvalho, CÁLCULOS ELEMENTARES COM EXCEL – 65 EXERCÍCIOS, ISBN: 978-972-722-873-7, FCA–Editora Informática, 2017
[4] Adelaide Carvalho, GRÁFICOS COM EXCEL, ISBN: 978-972-722-876-8, FCA –Editora Informática, 2017
[5] Tutoriais online de Microsoft Excel, disponíveis em https://digital.com/blog/excel-tutorials/