-
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 Biochemistry degree exercises. On the other hand, at a later stage of the course, you will have the important core competencies for the MATLAB / OCTAVE high level programming language for generic biochemistry problem solving.
-
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
ULHT2532-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