Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Informatics and Programming

Code:

BIOT014

Sigla:

IP

Áreas Científicas
Classificação	Área Científica
OFICIAL	Matemática e Informática

Ocorrência: 2020/2021 - 1S

Ativa?	Yes
Unidade Responsável:	Matemática e Informática
Curso/CE Responsável:	Undergraduate in Biotechnology

Ciclos de Estudo/Cursos

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

Língua de trabalho

Portuguese

Objetivos

The student should be able to: form a solid base in abstract programming concepts, which allows students to adapt to new programming languages; Make an introduction to Visual Basic programming, applying abstract concepts to a specific programming language; Be able to understand the concepts of using a spreadsheet; Determine VBA - Visual Basic for Applications programming concepts.

Resultados de aprendizagem e competências

Not applicable.

Modo de trabalho

Presencial

Programa

Chap. 1 - 4 sem. Formatting cells, references, graphics, pre-defined functions. VBA: construction of functions and macros.
Chap. 2 - 4 sem. Programming techniques: Top-Down approach, constants, variables, expressions and functions.
Chap. 3 - 1.5 sem. Pseudocode: Structure of an algorithm, declaration of variables, assignment of values, comments, input and output commands, basic structures (sequential, conditional and repetition).
Chap. 4 - 1.5 sem. Flowchart vs pseudocode: Symbology, structure, declaration of variables, assignment of values, inputs and outputs, basic structures. Composite variables, modules.
Chap. 5 - 3 sem. Visual Basic - analogy with pseudocode and flowchart. Object-oriented programming and event-driven programming, VB code and fundamentals - variables, matrices, constants, assignment, flow control, repetition instructions. Work objects. Correction of code errors: syntax and semantic errors.
Chap. 6 - 1 sem. Revisions

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, supported by computer tools. Theoretical concepts will always be linked with practical explanations and students will be invited to carry out practical exercises on each subject.

Regular exercises will be carried out during the classes to be counted in the continuous assessment, which will allow the consolidation of the learning.

The continuous assessment will be complemented with a written test.

The final assessment comprises an exam and a practical exercise resolution component.

Software

Microsoft Excel
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 + 40% test, where ER corresponds to regular exercises performed during classes (6 ER weight 10% each)

Final assessment

• 40% T + 60% Exam, where T corresponds to assignments. These works can be replaced by the grades obtained in the corresponding ER.

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 and the construction of small programming routines.