Computing Applied to Spatial Planning

There are none.

The contents of the course is presented through examples. (expositive method)

Students solve exercises to practice solving different types of problems. (experimental method)

After attending the course, each student is expected to be able to efficiently use the computer to solve different types of problems:

• Use spreadsheets to automate calculations and procedures;
• Design a database in the relational model and create a database in Access keeping the integrity rules;
• Create different types of queries in an Access database;
• Use a vector CAD system for graphical representation.

1. Introduction to Microsoft Excel

a) Cell editing

b) Cell formatting

c) Selection of cells and/or ranges

d) Formulas and functions

e) Lists and series

f) Relative, absolute, and mixed references

g) Charts

2. Graphical representation systems

a) Raster models; Vector Models;

b) Autocad

i) Program overview

ii) Drawing commands

iii) Editing commands

iv) View

v) Text

vi) Printing

vii) Plots

viii) References, Inserting Images and Reference Files (2002)

3. Database Systems

a) Access application development

i) Creation of a Database

ii) Construction of efficient tables

iii) Creation of Selection Queries and Action Queries (deletion, insertion, and update)

• - Exam exam on Excel - 25.0%
• - Hands-on work using AutoCAD - 50.0%
• - Access assessment test - 25.0%

• - Exam - 100.0%

NAO

Garcia, J. (2012). AutoCAD 2012 & AutoCAD LT 2012 – Curso completo. FCA.

Martins, A. (2020). Excel aplicado à gestão: Exemplos resolvidos. Sílabo.

McGrath, M. (2019). Access in easy steps. In easy steps limited.

Santos, J. (2011). AutoCAD 2012 & 2011 – Guia de consulta rápida. FCA.

Silva, J., Feitas, V., Ribeiro, J. & Martins, P. Mechanical desktop 4 – Curso completo. FCA.

Wilson, K. (2020). Using excel 2019: The step-by-step guide. Elluminet Press.