Computer Applications

There are none.

The course has no teaching component.

After attending this course, it is expected that each student knows how to

• Search, process and communicate information through new information and communication technologies;
• Efficiently use (create, edit, save and print files from) different IT tools autonomously;
• Solve different types of problems, namely data analysis and processing, on the computer;
• Use spreadsheets to automate calculations and procedures;
• Know programming concepts;
• Develop simple VBA functions in Excel;
• Design a database in the relational model;
• Create and use a relational database in Access;
• Create an Access database keeping the integrity rules;
• Perform queries of different types in an Access database.

1. Text Processing (Word)
a. Editing, correction and formatting of texts
b. Page setup
c. Creating tables
d. Insertion of objects: images, graphics,…
e. Advanced functions: document printing, document template creation, task automation (automatic text correction, automatic title configuration and numbering, indexes)

2. Multimedia Presentation Utility (Powerpoint)
a. Inserting and editing the template document
b. Inserting and formatting text
c. Text, Drawing and Graphics Tools
d. Effects (transitions and animations)

3. Spreadsheet (Excel)
a. Cell editing
b. Cell formatting
c. Formulas and functions (mathematics, date and time, query and reference, text and information)
d. Lists and series
e. Charts
f. User Defined Macros and Functions

4. Database Management System (Access)
a. Database Models
b. Access Applications
– Database creation
– Construction of efficient tables and their relationships
– Creation of selection queries and action queries (deletion, insertion and update)
– Creating Forms and Reports
c. Linking Access to other tools: linking to Word and Excel, importing / exporting data

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.

Sousa, S. & Sousa, M. (2014). Microsoft office 2010 para todos nós. FCA.

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

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