Programming and Computer Science

Year
1
Academic year
2021-2022
Code
01018194
Subject Area
Informatics
Language of Instruction
Portuguese
Mode of Delivery
Face-to-face
Duration
SEMESTRIAL
ECTS Credits
6.0
Type
Compulsory
Level
1st Cycle Studies

Recommended Prerequisites

Mathematics (Arithmetic, Logic, Trigonometry and Geometry) / English Language.

Teaching Methods

Theoretical-Practical Lectures

Hands-on type: presentation of the subjects and fundamental concepts, complemented with application problems solved. Engineering problems are presented to the students with the purpose of stimulate the learning process and promote the auto-evaluation of knowledge. In the lectures audio-visual equipment is used.

Practical and Laboratorial Lectures

The exercises presented in the Practical Issues are solved with tutorial support. Development of the capabilities to use computer software (1 personal computer per student). In the lectures audio-visual equipment is used.

Learning Outcomes

To present some of the basis of computers functioning.

To encourage the use of software tools for analysis and treatment of numerical data, with the goal of the improvement of decision and arguing capacities.

To explore the use of spreadsheets as a useful engineering tool.

To present some basic concepts of structured programming and algorithms, with the purpose of development of logical thinking and programming intelligence.

To provide the students with knowledge of a programming language and enable them to use it to create code for solving practical cases.

Work Placement(s)

No

Syllabus

1. Advanced Knowledge of Excel

Presentation of Excel software; Use of worksheets, creation of tables, dynamic tables, creation and analysis of charts; Main intrinsic functions used in arithmetic and trigonometry, matrix calculus, statistical, date and time, logical and lookup and reference; Achievement of approximated solutions by the use of “Goal Seek” and solution of multivariable problems by the use of “Solver”.

2. Fundamentals of Programming for engineering problems

Basis of design of algorithms, representation of algorithms and flowcharts; Structured programming, principal programs and subroutines; Decision and looping statements; Types of data and declaration of variables; Operating with array data; Interface design; Data read and data export; Chart design; Development of codes applied to solve practical engineering problems.

Head Lecturer(s)

António Alberto Santos Correia

Assessment Methods

Assessment
Frequency: 25.0%
Mini Tests: 25.0%
Exam: 50.0%

Bibliography

Correia, A. & Grazina, C. "Informática - Parte I: Fundamentos de Excel", DEC-UC (2017).

Correia, A. "Informática - Parte II: Introdução à programação em Matlab", DEC-UC (2017).

Sousa, M.J. “Fundamental do Excel 2010”, FCA Editora (2011)

Peres, P. “Macros e Aplicações Excel 2007”, Edições Sílabo (2009)

Walkenbach, J. “Excel 2007 Bible”, Wiley Publishing, Inc. (2011).

Morais, V. & Vieira, C. MATLAB - Curso Completo, FCA editor (2013).

William Palm III, “Introduction to MATLAB for Engineers” 3rd Edition (2010).