Information and Communication Technologies

N/A

Contents of the course are presented using examples.

Many exercises are proposed to the students so they can try to solve different kinds of problems.

1. Develop the ability to research, compute, and communicate information using new information, and communication technologies;

2. Efficiently use (create, use, save, and print files of) different informatic tools files autonomously;

3. Have a few ideas on computer programming, in particular VBA used in Excel.

1. Text Processing (Word)

a. Text editing, proofreading, and formatting

b. Page setup

c. Table creation

d. Objects insertion: images, graphics,…

e. Advanced features: document printing, document template creation, task automation (automatic text correction, automatic numbering, indexing)

2. Tool for multimedia presentations (Powerpoint)

a.Template document Insertion and edition

b. Text insertion and formatting

c. Text, drawing, and graphics tools

d. Effects (transitions and animations)

3. Spreadsheets (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 functions in VBA

• - Practical test - 100.0%

• - Practical test - 50.0%
• - Work - 50.0%

NAO

SOUSA, SÉRGIO; SOUSA, MARIA JOSÉ (2014) – Microsoft Office 2010 para todos nós. FCA.

CARVALHO, ADELAIDE (2007) – Exercícios Resolvidos com Excel para Economia & Gestão. 2ª Edição Actualizada e Aumentada. FCA.

RODRIGUES, LUÍS SILVA (2010) – Utilização do Excel 2007 para Economia & Gestão. 2ª Edição Revista. FCA.