Class Programming

  • Presentation


    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.

  • Code


  • Syllabus


    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.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.1.Command plot, bar, pie and other related. Formatting Options.
    7.2.Command subplot
    7.3. Sample programs.
    7.4. Surface and line graphs.

  • Objectives


    The introductory chapter is a review / introduction to the Excel spreadsheet, to ensure that all students acquire the most basic skills of this useful tool. Simple applications are developed to explore and help master the spreadsheet at an introductory / intermediate level.

    The main objectives of the remaining chapters are: Acquisition of basic knowledge about the formulation of problems using numerical analysis and elaboration of algorithms.
    Transposition of the algorithms to MATLAB or Python programming language. Application of the basic structures of the MATLAB (Python) language to study simple models. Acquire basic skills to understand the MATLAB (Python) programming language for solving simple generic problems. Increase the ability to formulate a problem through an algorithm and transpose the algorithmic information to a MATLAB or Python code.

  • Teaching methodologies and assessment

    Teaching methodologies and assessment

    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.

  • References


    • 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


Lisboa 2020 Portugal 2020 Small Logo EU small Logo PRR republica 150x50 Logo UE Financed Provedor do Estudante Livro de reclamaões Elogios