Class Software Applications

In this course unit the student will be able to develop the fundamental skills necessary to explore and master the spreadsheet in typical Biotechnology degree exercises. On the other hand, at a later stage, you will have the core competencies that are important for the high-level Matlab / Octave programming language for solving generic biotechnology problems.

1. Spreadsheet - MICROSOFT EXCEL

1.1. Introduction of spreadsheet notion and work environment.

1.2. Input and manipulation of spreadsheet data.

1.3. Use of Formulas.

1.4. Using Predefined Functions.

1.5. Absolute and Relative References: applications.

1.6. Data set manipulation: filters, custom sorting.

1.7. Data formatting: conditional formatting.

1.8. Chart Types

1.9. Macros

2. Introduction to the OCTAVE Program

2.1. Introduction to OCTAVE: OCTAVE Desktop

2.2. Basics: Variables and Arrays

2.3. Multidimensional Arrays; Sub Matrices

2.4. Special values; Output Representation

2.5. Hierarchy of operations; Intrinsic Functions

2.6. Graphics in OCTAVE

Development and deepening of theoretical teaching strategies involving practical cases at an experimental level.

• Stormy Attaway. Matlab: a Practical Introduction to Programming and Problem Solving. Elsevier, 2009.
• 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