Computer Programming II

Code:

EM0125

Acronym:

PCII

Keywords
Classification	Keyword
OFICIAL	Informatics

Instance: 2017/2018 - 2S

Active?	Yes
Web Page:	https://moodle.up.pt/course/view.php?id=3191
Responsible unit:	Department of Industrial Engineering and Management
Course/CS Responsible:	Master in Mechanical Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MIEM	23	Syllabus since 2006/2007	4	-	6	45,5	162

Teaching language

Portuguese

Objectives

The aim of this course is to provide the students with a fundamental knowledge about Information and Communication Technology (ICT), and, in particular, allow them to develop their skills in computer programming and database programming tools.

Learning outcomes and competences

 The students should be able to:

- Build MS-Excel spreadsheets models using formulas and VBA programming;

- Develop integrated applications using languages such as Visual Basic for Applications (VBA); ;

- Create algorithms independently of a programming language;;

- Implement algorithms and develop applications in 'Visual Basic' language;

- Develop applications using object-oriented programming in 'Visual Basic' in a Windows environment;

- Develop Applications for handling data stored across different platforms

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Students should have knowledge corresponding to a first course in computer programming.

Program

Pprogramming:
- Programming in windows environment.
- Object-oriented programming. General concepts. Objects in Visual Basic. Classes, properties, methods and events.
- Data Structures: Primitives. Stacks (stack). Recursion. Linked lists (linked lists). Queues (queues). Ordering methods (replacement, select, insert and junction)
- Handle XML file

Use of personal productivity tools:
- Spreadsheet and Database
- Programming in VBA.

Mandatory literature

J. P. Hamilton; Object-oriented programming with Visual Basic.NET. ISBN: 0-596-00146-0

Complementary Bibliography

Henrique Loureiro; Visual Basic 2008. ISBN: 978-972-722-294-0

Teaching methods and learning activities

This course unit will be based on the following activities:
(i) Theoretical classes will be based on the presentation of the themes of the course unit on the theoretical discussion of exercises. Students will be informed about the bibliography and assignments to be carried out;
(ii) Students have to, individually or in group, give solutions to the exercises presented in theoretical classes and read the bibliography
(iii) Theoretical-practical classes will be based on the discussion of the solutions of exercises and group project, as well as on the discussion of the bibliography.

Software

Microsoft Visual Studio
Microsoft Office Professional
MySQL

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation	Weight (%)
Participação presencial	10,00
Teste	70,00
Trabalho laboratorial	20,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	72,00
Frequência das aulas	54,00
Trabalho laboratorial	36,00
Total:	162,00

Eligibility for exams

To be admitted to exams, students have to attend to 75% of the classes.

Calculation formula of final grade

0.35x (1st test) + 0.35x (2nd test) + 0.2x (Computer assignment) +0.1x (Teacher assessment)

Approval is obtained with final classification greater or equal 9,5 and 2nd test classification greater or equal 7,5.

Examinations or Special Assignments

A practical assignment on the development of an application of VBasic. NET using class of objects and data bases

Special assessment (TE, DA, ...)

Students have to do/attend to all assessment components.

Classification improvement

Students have to do/attend all assessment components.