Informatics
Áreas Científicas |
Classificação |
Área Científica |
CNAEF |
Informatics - the user perspective |
Ocorrência: 2022/2023 - 1S
Ciclos de Estudo/Cursos
Sigla |
Nº de Estudantes |
Plano de Estudos |
Anos Curriculares |
Créditos UCN |
Créditos ECTS |
Horas de Contacto |
Horas Totais |
RECE |
1 |
Study Plan |
1 |
- |
4 |
45 |
108 |
Docência - Responsabilidades
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
VBA
Microsoft Word
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.