Informatics and Programming

Code:

L.EA005

Acronym:

IP

Keywords
Classification	Keyword
OFICIAL	Technological Sciences - Engineering

Instance: 2024/2025 - 1S

Active?	Yes
Web Page:	https://sigarra.up.pt/feup/pt/ucurr_adm.ficha_uc_edit?pv_ocorrencia_id=274394
Responsible unit:	Department of Chemical and Biological Engineering
Course/CS Responsible:	Bachelor in Environmental Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
L.EA	55	Syllabus	1	-	4,5	39	121,5

Teaching language

Portuguese

Objectives

This course aims to provide a foundational education in the field of computing and information technology, offering the basic concepts necessary for the formulation and development of various types of IT projects. The main tools covered are: spreadsheets (MS Excel); programming language (VBA - Visual Basic for Applications); and computer-aided design (CAD).

Learning outcomes and competences

It is intended that students gain autonomy to address moderately complex situations and acquire the skills to solve simple IT problems with readable and efficient implementations using Excel and/or VBA. The student should be able to analyze and use programming languages, as well as correctly utilize commercial software, modify, and build simple programs within the engineering domain.

Students should be able to model three-dimensional components of mechanical systems and proceed with their assembly using CAD systems, as well as produce definition drawings of components and assemblies of previously modeled mechanical systems using CAD systems.

Working method

Presencial

Program

 

1. Introduction to Programming

• Introduction to digital systems: concepts and definitions
• Data representation
• Using MS Excel in engineering problems
• Programming in Visual Basic for Applications (VBA)
  • Constants, variables, and expressions
  • Intrinsic functions
  • Data input and output
  • Conditional and loop statements
  • Indexed variables
  • External functions
  • Algorithms

2. CAD

• 3D modeling of mechanical system components and assembly using CAD systems
• Using standard components provided by CAD system libraries
• Automatically generating definition drawings of components and assemblies of previously modeled mechanical systems using CAD systems

 

Mandatory literature

M.M. Dias; Introdução à Programação com VBA, 2004
Vários; Apontamentos CAD (a disponibilizar nos conteúdos da UC)
David C. Planchard; SolidWorks 2012. ISBN: 978-1-58503-702-5

Complementary Bibliography

Chapra Steven C.; Power programming with VBA/Excel. ISBN: 0-13-047377-4
Planchard David C.; SolidWorks 2020 tutorial, 2020. ISBN: 978-1-63057-317-1

Teaching methods and learning activities

Practical classes with the presentation of key concepts and project development.

Software

VBA - Visual Basic for Applications
Microsoft Excel
SolidWorks

keywords

Physical sciences > Computer science > Informatics

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation	Weight (%)
Teste	100,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Frequência das aulas	39,00
Estudo autónomo	82,50
Total:	121,50

Eligibility for exams

 

1) Do not exceed the maximum number of absences as per the General Assessment Regulations;

2)Minimum grade of 6.5 in each assessment component.

 

Calculation formula of final grade

Continuous assessment: three tests.
The final grade (CF) is calculated using the following formula:

CF = 0,25 * Teste_Excel + 0,50 * Teste_VBA + 0,25 * Teste_CAD

The Recurso can be taken per module, following the same rules as the continuous assessment.

Examinations or Special Assignments

N/A

Internship work/project

N/A

Special assessment (TE, DA, ...)

Exam

Classification improvement

Exam