-
Presentation
Presentation
In this course unit the student can develop the essential skills necessary to explore and master a spreadsheet in typical Biology undergraduate exercises. On the other hand, at a later stage you will have as your core competencies important to the high level MATLAB / OCTAVE programming language for solving generic biology problems.
-
Class from course
Class from course
-
Degree | Semesters | ECTS
Degree | Semesters | ECTS
Bachelor | Semestral | 3.5
-
Year | Nature | Language
Year | Nature | Language
1 | Mandatory | Português
-
Code
Code
ULHT101-25
-
Prerequisites and corequisites
Prerequisites and corequisites
Not applicable
-
Professional Internship
Professional Internship
Não
-
Syllabus
Syllabus
1. Introduction to the MICROSOFT WORD 1.1-Writing and formatting text. 1.2- Indexes, references, Review the text; 1.3-Insertion of tables, graphs. 1.4-Conversion into PDF format. 2. Spreadsheet - MICROSOFT EXCEL 2.1. Introduction of spreadsheet notion and work environment. 2.2. Input and manipulation of spreadsheet data. 2.3. Use of Formulas. 2.4. Using Predefined Functions. 2.5. Absolute and Relative References: applications. 2.6. Data set manipulation: filters, custom sorting. 2.7. Data formatting: conditional formatting. 2.8. Chart Types 2.9. Macros 3. Introduction to the OCTAVE Program 3.1. Introduction to Octave 3.2. Basics: Variables and Arrays 3.3. Multidimensional Arrays; Sub-Matrices 3.4. Special values; Output Representation 3.5. Hierarchy of operations; Intrinsic Functions 3.6. Introduction to graphical representation in Octave
-
Objectives
Objectives
Computer exploitation as an important tool for scientific development. Explore the possibilities of Excel as a graphing tool but also as a programming platform. Introduce MATLAB/OCTAVE as a scientific programming language. Introduction to numerical computing techniques with applications to the natural sciences.
-
Teaching methodologies and assessment
Teaching methodologies and assessment
Develop teaching strategies using practical examples arising from real data for treatment and use of specific programs.
-
References
References
Isabel Vaz (2012) Word 2010; FCA Editora. Joan Lambert (2023) Microsoft Word Step By Step (Office 2021 And Microsoft 365); Editor: PEARSON EDUCATION (US); ISBN: 9780137522729. Stormy Attaway. (2009) Matlab: a Practical Introduction to Programming and Problem Solving. Elsevier. Morais, W e Vieira, C. (2013) MATLAB ¿ Curso completo; FCA-Editora Informática Microsoft Excel ¿ Domine a 110% - FCA-Editora Informática. Exercícios de Excel - FCA-Editora Informática. Material de apoio fornecido pelo Docente da cadeira
-
Office Hours
Office Hours
-
Mobility
Mobility
No