Class Programming

Development of elementar skills needed to explore and master the Excel spreadsheet at an introductory/intermediate level.
Acquire basic skills to understand and use main stuctures of MATLAB or Python programming language to solve simple and generic
problems. Insease the ability to understand and formulate a problem through an algorithm and transpose the algorithm
information into a MATLAB or Python code.

1. Introduction
1.1. Introduction to MICROSOFT EXCEL: Worksheet. Basic data manipulation; formulas; absolute
and relative references; use of filters and personalized ordering; Application examples.
1.2. Introduction to MICROSOFT EXCEL: Functions and Graphs. Application examples.
2.Introduction to programming languages.
2.1.Algorithms
2.2. Basic rules of programming
3.Introduction to programming in MATLAB
3.1 Desktop.
3.2 Basic Mathematical Operations.
3.3 Simple variables, vectors and matrices. Mathematical functions.
3.5.Programs example.
4. Comparison instructions
4.1. IF-ELSE structures
4.3. Example programs
5. Repetition structures
5.1.Clos FOR
5.2.Cycles WHILE
5.3.Programas example.
6. Read and write data. Examples
7.Graphics
7.1.Command plot, bar, pie and other related. Formatting Options.
7.2.Command subplot
7.3. Sample programs.
7.4. Surface and line graphs.

This course starts with an introductory module on Excel (5-6 weeks) where students learn how to create formulas with the most commonly used functions and manipulate data in tables and charts. In the remaining weeks students explore the most elementary programming structures using a high-level language (Matlab or Python). Although the curricular unit formally has a theoretical component and a practical component, there are no expository lessons and the classes are all developed in a theoretical-practical/practical approach. Classes are always held in computer rooms so that students can perform all the examples discussed and can solve all the proposed exercises with full autonomy. Individual student work in this subject is encouraged in all classes throughout the semester and valued in the assessment.

• Microsoft Excel - Domine a 110% - F C A-Editora Informática;
• Introdução às Técnicas de Programação - Editorial Presença;
• Essential MATLAB for Engineers and Scientists: Brian Hahn and Daniel Valentine, Fifth edition, Academic Press. 2013;
• Duane C. Hanselman and Bruce L. Littlefield, Mastering MATLAB, First edition (2011). Prentice Hall
• Notas várias disponibilizadas pela docente através do moodle