Programming and Computer Science

Year
1
Academic year
2019-2020
Code
01006180
Subject Area
Informatics
Language of Instruction
Portuguese
Mode of Delivery
Face-to-face
Duration
SEMESTRIAL
ECTS Credits
4.5
Type
Compulsory
Level
1st Cycle Studies

Recommended Prerequisites

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

Teaching Methods

Theoretical Lectures

Detailed presentation of the subjects, principles and fundamental concepts, with application problems solved punctually. Complementarily, some exercises are presented to the students with the purpose of stimulate the learning process and promote the auto-evaluation of knowledge.

Practical and Laboratorial Lectures

The exercises presented in the Practical Issues are solved with tutorial support. Development of the capabilities to use computer software. In these classes, students may work in groups of maximum two persons, and each group has one desktop personal computer.

Learning Outcomes

To present some of the basis of computers functioning.

To provide the students on the use of a software tool for computer-aided engineering design.

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 present some basic concepts of structured programming and algorithms, with the purpose of development of logical thinking and programming intelligence.

To provide the students on the use of a programming language for solving problems. Some basis of programming in VBA (Visual Basic for Applications) code language is provided.

Work Placement(s)

No

Syllabus

1. Drawing with AutoCAD

Presentation of AutoCAD software; Main capabilities; Basic drawing tools; Drawing annotation; Handling of layers.

2. Advanced Knowledge of Excel

Presentation of Excel software; Use of worksheets, creation of 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”.

3. Fundamentals of Programming and VBA

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; Basis of VBA programming; Interface design; Programming and design of forms; Record of Macros; Development of VBA codes to solve practical exercises.

Head Lecturer(s)

António Manuel Gonçalves Pedro

Assessment Methods

Final assessment
Exam: 100.0%

Continuous assessment
Mini Tests: 37.5%
Exam: 62.5%

Bibliography

Grazina, J.C. (2011). “Apontamentos das aulas teóricas de Informática”.

Ribeiro, B.; Paquete, L. e Pereira, V. “Breve introdução ao AutoCAD – Apontamentos”.

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

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

Santos, J. “Autocad 2010: Depressa & Bem”, FCA Editora.

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

Green, J.; Bullen, S., Bovey, R. and Alexander, M. “Excel 2007 VBA – Programmer´s Reference”, Wiley Publishing, Inc.