Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Introduction to Programming

Code:

LEM11104

Sigla:

IP

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

Ocorrência: 2021/2022 - 1S

Ativa?	Yes
Unidade Responsável:	Departamento de Sistemas 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
EM	93	Plano de Estudos	1	-	6	75	162

Língua de trabalho

Portuguese

Objetivos

Understanding basic concepts and principles of computer operation.

Development of logical and formal thinking skills for complex problems analysis.

Understanding of conceptual foundations related to computer programming:

- Understanding the general principles of software engineering;

- Understanding the central role of Algorithm;

- Ability to code (implement) algorithms in programming languages.

Resultados de aprendizagem e competências

In theoretical terms, it is intended to alert the students to the role and importance of the programming languages and to the concepts associated with their use.  

In practical terms and considering the growing importance of the high-level languages, it is expected that the students learn how to use the VBA programming language.

Modo de trabalho

Presencial

Programa

 

1. Background to programming
   • Definition of computer
   • Basic description of a computer - Von Neumann simplified model
   • Definition of program
   • Problem solving and programming
   • Information representation

 

2. Programming languages
   • Concepts of natural language, and programming language and machine language
   • Levels and programming languages
   • Compiler vs interpreter
   • Program development phases

 

3. Algorithms
   • Algorithm concept
   • Flowcharts and Pseudocode
   • Top-down and bottom-up approaches

 

4. Programming in a High-Level Language: Visual Basic for Applications (VBA)
   • Program structure
   • Data types
   • Expressions
   • Instructions for input and output
   • Control structures
   • Structured data types
   • Subprograms

Bibliografia Obrigatória

Loureiro, H.; Excel 2013 Macros & VBA, FCA, 2014
Niekerk, M. ; VBA Automation for Excel 2019 Cookbook: Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications, Packt Publishing Ltd., 2020

Métodos de ensino e atividades de aprendizagem

On the Theoretical-Practical classes (TP) expositive and participative methods are used with the goal to promote discovery-based learning process, through individual and group exploration. Thus being, the classes dynamic is based on the exposition of contents followed by the resolution of practical exercises and problems;
As to the Practical/laboratorial classes (PL) will be used the participative method and the resolution of works, with the goal to promote the development of ‘Knowing to do’ competences and get a higher approximation of the theoretical-practical learning to the marketplace needs. Thus, these classes dynamics is based on the realization of laboratorial works and problem solving.

Software

VBA
Excel

Tipo de avaliação

Distributed evaluation with final exam

Componentes de Avaliação

Designation	Peso (%)
Apresentação/discussão de um trabalho científico	40,00
Teste	60,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Apresentação/discussão de um trabalho científico	2,00
Elaboração de projeto	40,00
Estudo autónomo	30,00
Frequência das aulas	75,00
Trabalho laboratorial	10,00
Total:	157,00

Obtenção de frequência

Continuous Evaluation

The continuous evaluation (CE) grade is calculated as presented next:

 

CE Final Grade = 0,6 TP + 0,4 PL

 

Considering that:

 

• Theoretical-practical (TP) – The TP component is evaluated through the elaboration of 2 tests (Test1 and Test2), both with the same weighting (50%), and each one with a minimum grade of 8. The TP minimum grade is 9,5 and is calculated as follows:

 

TP = 0,5 Test1 + 0,5 Test2

 

• Practical/Laboratorial (PL) – The PL component is evaluated through:

1. 2 individual works (Trab1 e Trab2) – each one with the minimum grade of 8 (both in the individual work and in the discussion)
2. The exercises made in the classes (Exer)
3. The students participation in the classes (Part)

The PL minimum grade is 9,5 and is calculated as follows:

 

PL = 0,35 Trab1 + 0,35 Trab2 + 0,2 Exer +0,1 Part

 If any of the mentioned grades is lower than the minimum values described above, the student will have to repeat, through an exam, just the evaluation component(s) to which (s)he has failed. NOTE: the components will keep the minimum grade values and the percentual value (that is: 0,6 TP + 0,4 PL), to calculate the student final grade.

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

Final Evaluation

There are three phases of final evaluation:

 Normal Phase (1st phase):

The normal phase is based on an exam with both components: TP and PL. The TP component is worth 60% of the final grade while the PL component is worth 40% of the final grade. The minimum grade of each component is 9,5. If the exam grade is inferior to 10 the student will not be approved.

The students from continuous evaluation only need to do, through exam, the component(s) to which they have failed.

 

Resource Phase (2nd phase):

The resource phase is based on an exam with both components: TP and PL. The TP component is worth 60% of the final grade while the PL component is worth 40% of the final grade. The minimum grade of each component is 9,5. If the exam grade is inferior to 10 the student will not be approved.

The students from continuous evaluation only need to do, through exam, the component(s) to which they have failed.

 

Special Phase:

The special phase is based on an exam with both components: TP and PL. The TP component is worth 60% of the final grade while the PL component is worth 40% of the final grade. The minimum grade of each component is 9,5. If the exam grade is inferior to 10 the student will not be approved.