Computer Programming II
Keywords |
Classification |
Keyword |
OFICIAL |
Informatics |
Instance: 2015/2016 - 2S
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
MIEM |
27 |
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.