Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Informatics

Code:

TLQBVF02

Sigla:

Inf

Áreas Científicas
Classificação	Área Científica
CNAEF	Informatics - the user perspective

Ocorrência: 2022/2023 - 1S

Ativa?	Yes
Unidade Responsável:	Departamento de Matemática e Informática
Curso/CE Responsável:

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
TLQBVF	13	Study Plan	1	-	4	45	108

Língua de trabalho

Portuguese

Objetivos

It is intended in this course that the student acquires the skills of manipulating a word processor and a spreadsheet. It is also intended to acquire bases on the abstract concepts of programming and introduction to programming techniques, which allows it to adapt to new programming languages.

Resultados de aprendizagem e competências

Not applicable.

Modo de trabalho

Presencial

Programa

1. Advanced text editing functions
2. Spreadsheet (data manipulation, formulas and functions, pivot tables, graphs) 3. Introduction to programming (basic notions of algorithm, introduction to structured programming, programming techniques, practical program building)

Bibliografia Obrigatória

Buyens, Jim; Aprender + Programação, McGraw-Hill
Curtis, F; Microsoft Office Excel 2016 Step by Step, Microsoft Press

Métodos de ensino e atividades de aprendizagem

Theoretical-practical classes where teaching methods will be adopted using expository methods, presentation of basic concepts and tools, and activities in a computer lab to solve small tasks.

Software

Microsoft Excel
Microsoft Word
VBA

Tipo de avaliação

Distributed evaluation with final exam

Componentes de Avaliação

Designation	Peso (%)
Participação presencial	60,00
Teste	40,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Estudo autónomo	63,00
Frequência das aulas	45,00
Total:	108,00

Obtenção de frequência

Not applicable.

Fórmula de cálculo da classificação final

Continuous assessment

• 60% ER + 20% test1 + 20% test2, where ER corresponds to regular exercises performed during classes, namely, 1 word processor (10%), 2 spreadsheet (10% + 15%) and 2 programming (10% + 15%)

Final assessment

• 10% T1 + 25% T2 + 25% T3 + 40% Exam, where T corresponds to assignments (T1 word processor, T2 spreadsheet and T3 programming).

The 100% assessment regime per exam is not applicable (that is, an exception regime is applied) since, according to the learning objectives and the skills to be acquired, the student must have a strong practical component in the use computer tools, more specifically the use of the spreadsheet, mastering the construction of small programming routines and customized spreadsheets.