Applied Informatics

There are none.

The contents of the course is presented through examples with discussion. (Expositive Method)

Students solve exercises to practice solving different types of problems. (Experimental Method)

After attending Applied Informatics course, it is expected that each student knows how to efficiently and autonomously use Office tools:

• Solve different types of problems using computer, namely data analysis and processing;
• Use spreadsheets to automate calculations and procedures;
• Develop simple functions in VBA in Excel;
• Design a database in the relational model;
• Create a database in Access keeping integrity rules;
• Create different types of queries in an Access database.

1. Data analysis and treatment (in Excel)

a) Editing, formatting and selecting cells and/or ranges

b) Formulas and functions

c) Lists and series

d) Relative, absolute and mixed references

e) Graphics

2. Excel applied to Management

Excel financial formulas

3. VBA Programming

a) VBA architecture

– Data types

– Methods

– Arrays

– Variable declaration

– Control structures

b) Functions (text, math, formatting, conversion)

4. Database Management System

a) Database Models

b) Using Access

– Design of a Database

– Construction of efficient tables and their relationships

– Creation of selection queries and action queries (deletion, insertion and update)

• - Exam - 100.0%

• - two group assignments (each weights 25% of the final grade) and two tests (each weights 25% of the final grade) with a minimum grade of 8 values (out of 20) each. - 100.0%

NAO

Carvalho, A. (2008). Programação com excel para economia & gestão. FCA.

Carvalho, A. (2012). Exercícios resolvidos com excel para economia & gestão. FCA.

Martins, A. (2020). Excel aplicado à gestão: Exemplos resolvidos. Sílabo.

McGrath, M. (2019). Access in easy steps. In easy steps limited.

Wilson, K. (2020). Using excel 2019: The step-by-step guide. Elluminet Press.