Software Tools and Applications

Code:

CC3007

Acronym:

CC3007

Level:

300

Keywords
Classification	Keyword
OFICIAL	Computer Science

Instance: 2018/2019 - 2S

Active?	Yes
Web Page:	https://moodle.up.pt/course/view.php?id=2513
Responsible unit:	Department of Computer Science
Course/CS Responsible:	Bachelor in Computer Science

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
L:B	0	Official Study Plan	3	-	6	56	162
L:CC	16	Plano de estudos a partir de 2014	2	-	6	56	162
			3
L:F	0	Official Study Plan	2	-	6	56	162
			3
L:G	0	study plan from 2017/18	3	-	6	56	162
L:M	1	Official Study Plan	2	-	6	56	162
			3
L:Q	3	study plan from 2016/17	3	-	6	56	162
MI:ERS	27	Plano Oficial desde ano letivo 2014	2	-	6	56	162
			3

Teaching language

Suitable for English-speaking students

Objectives

Provide the student experience in the use, administration and programming of some of the systems / applications currently used in the Windows environment. The particular focus is on the programming environment of Visual Basic for Applications.

Learning outcomes and competences

Know how to develop programs that use MS Excel.
Know how to develop programs that use MS Access.
Create systems capable of integrating these two above mentioned tools.

Working method

Presencial

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

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

Program

Microsoft Excel: Working environment. Data types. Format data. Documenting data. Referencing cells. Formulas. Operators. Functions. Soma automatic and automatic calculation.
Microsoft Access: Fundamentals database. Work environment. Tables. Types and properties of the data. Referential integrity. Relationships and associations. Queries. Query types. Forms and sub-forms. Controls. Types of controls. Reports, sub-reports and sections. Macros. Security.
Visual Basic for Applications (VBA): Variables. Operators. Procedures. Arguments. Arrays. Decision-making structures. Cycles. Basic functions. Objects. VBA and Excel. Objects Workbook, Worksheet and Range. VBA and Access. DoCmd object, Form, Report, and Control. ActiveX Data Objects (ADO). Objects Connection, Command and Recordset. Error handling. Collections. Class modules.

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
MS Office 2016

Evaluation Type

Distributed evaluation without final exam

Assessment Components

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

Amount of time allocated to each course unit

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

Eligibility for exams

Completing all practical work; minimum score of 4 in the practical works; minimum score of 4 out of 12 on the set of the two tests; attend 75% of the practical classes.

Calculation formula of final grade

Sum of all parts: coursework 1 (4 points), coursework2 (4 points), test1 (6 points), test2 (6 points).

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

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.