Application Development Environments

Code:

CC4015

Acronym:

CC4015

Keywords
Classification	Keyword
OFICIAL	Computer Science

Instance: 2024/2025 - 2S

Active?	Yes
Responsible unit:	Department of Computer Science
Course/CS Responsible:	Master in Mathematical Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
M:EGEO	1	Official Study Plan	1	-	6	48	162
M:ENM	12	Official Study Plan since 2023/2024	1	-	6	48	162

Teaching language

Suitable for English-speaking students

Objectives

Provide students with experience in using, administering, and programming some of the most commonly used systems/applications in the Windows environment. The particular focus will be on the event-driven programming paradigm using the programming environment of Visual Basic for Applications coupled with data manipulation applications.

Learning outcomes and competences

Know and know how to develop programs for data manipulation and processing in tabular formats.
Know and know how to develop programs to access relational databases.
Create systems capable of integrating those tools for data manipulation, access to databases, and visual representation of data, using standard communication models.

Working method

Presencial

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

Frequency of an initial course on programming, preferably an imperative language.

Program

1) Microsoft Excel for the user and the programmer
a) Use of Excel: Data types. Format data. Document data. Cell referencing. Formulas. Operators. Functions. Automatic sum and automatic calculation. Creation and manipulation of graphics.
b) Visual Basic for Applications (VBA): Variables. Operators. Procedures. Arguments. Arrays. Decision structures. Cycles. Basic Excel functions. Objects. VBA specific to Excel.

2) Microsoft Access for the user and the programmer
a) Basic concepts about databases. Tables. Data types and properties. Relations and associations. Referential integrity. Consultations. Types of consultation. Forms and sub-forms. Graphic controls. Reports, subreports, and sections. Macros. Safety.
b) Workbook, Worksheet and Range objects. Using VBA to control Access. Form, Report, and Control objects. ActiveX Data Objects (ADO) for access to internal and external data. ADOX for run-time changes to the BD structure. Connection, Command, and Recordset objects. Error handling. Using Collections.

3) Object-based and event-based programming
Interface definitions. Interoperability and inter-application communication. Using Collection in Object data types.

4) Programming for integrating database access, data manipulation, and visualization.

Mandatory literature

Running Microsoft Excel, Microsoft Press
Running Microsoft Access, Microsoft Press

Complementary Bibliography

ADO: ActiveX Data Objects, O'Reilly

Teaching methods and learning activities

Expository method; demonstrations; resolutions of exercises and practical coursework.

Software

Moodle UP
Office 365

Evaluation Type

Distributed evaluation without final exam

Assessment Components

designation	Weight (%)
Teste	50,00
Trabalho laboratorial	50,00
Total:	100,00

Amount of time allocated to each course unit

designation	Time (hours)
Estudo autónomo	56,00
Frequência das aulas	56,00
Trabalho laboratorial	50,00
Total:	162,00

Eligibility for exams

Completing all practical work; a minimum score of 3.5 in the practical course and in the final exam; at least 35% in the final exam; attending at least 60% of the theoretical classes.

Calculation formula of final grade

Sum of all parts: coursework 1 (5 points), coursework2 (5 points), exam (10 points).

This gives a maximum of 20 points, which are converted to the correspondent scale.

And,

coursework1 >= 3.5 points
coursework2 >= 3.5 points
exam >= 35%

Examinations or Special Assignments

Coursework1 (Excel+VB). Coursework2 (Access+VBA).

Classification improvement

Improvements to the final grade can only be made by a resit for the exam.

Observations

Practical assignments will be presented during the practical classes. Students who do not attend these sessions (2 per practical assignment), do not demonstrate knowledge of the work, or do not assist their group peers, will have a deduction in the Group's grade for each assignment where this has occurred.