-
Presentation
Presentation
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.
-
Class from course
Class from course
-
Degree | Semesters | ECTS
Degree | Semesters | ECTS
Bachelor | Semestral | 5
-
Year | Nature | Language
Year | Nature | Language
1 | Mandatory | Português
-
Code
Code
ULHT2710-64
-
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
This course aims to create the ability to use and exploit the potential of a personal computer with the application of automatic calculation in Microsoft Excel environment to solve generic problems in Biotechnology. The work environment and mathematical calculation as well as the introductory programming concepts in MATLAB / OCTAVE will be introduced in an introductory manner.
-
Teaching methodologies and assessment
Teaching methodologies and assessment
Development and deepening of theoretical teaching strategies involving practical cases at an experimental level.
-
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.
-
Office Hours
Office Hours
-
Mobility
Mobility
No