Base Knowledge
There are none.
Teaching Methodologies
The contents of the course is presented through examples. (expositive method)
Students solve exercises to practice solving different types of problems. (experimental method)
Learning Results
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.
Program
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 & Rhino + Grasshopper
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)
Curricular Unit Teachers
Grading Methods
- - Hands-on work using AutoCAD - 50.0%
- - Access assessment test - 25.0%
- - Exam exam on Excel - 25.0%
- - Exam - 100.0%
Internship(s)
NAO
Bibliography
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.