Computing

Code:

LGE105

Acronym:

INF

Keywords
Classification	Keyword
OFICIAL	Mathematics and Informatics

Instance: 2005/2006 - 1S

Active?	Yes
Responsible unit:	Matematics and Informatics Group
Course/CS Responsible:	Business Administration

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
GES	174	Official Curricular Structure since 2004	1	3		-

Objectives

To convey fundamental concepts in informatics.
To provide students with the ability to master data processing tools and programming languages.

Program

Spreadsheet:
Formulae and functions; dealing with small volumes of data; data lookup and data exploration; data views with pivot tables:
Operational aims: Use of Excel.

Relational Data Bases:
Tables; relationships; queries (QBE and SQL); data base design (normalisation; entities and relationships).
Operational aims: use of Access and development of a project.

Introduction to programming:
Data structures; instructions; function programming; data set manipulation; use of data on the web;
Operational aims: programming in R.

Data Analysis and Decision Models:
Classification; decision trees and rules; linear regression; data exploratory analysis and data mining; eletronic commerce.
Operational aims: Data analysis with R; Data exploratory analysis in economics: histograms / linear regression models, data transfer between applications.

Main Bibliography

Booklets edited by the lecturing team.

Teaching methods and learning activities

Tutorial lectures, with exercises and course works.

Software

MS Excel, MS Access, R (www.r-project.org)

Evaluation Type

Distributed evaluation with final exam

Eligibility for exams

All the enrolled students can submit the exam.

Calculation formula of final grade

It is not mandatory to obtain a positive classification in courseworks. If the Courseworks grade (NT) is lower than the written exam grade (NE), the latter has a weighting of 100%.

The final grade (NF) is calculated as follows:
if NE>=7 and NT>=NE
then NF=minimum of (NE * 0.65 + NT * 0.35) and 20
otherwise NF = NE
NF cannot excede NE + 2

The students with final grade (NF) >= 9,5 will pass.

When mandatory according to Faculty rules, the students that do not pass may be admitted to a complementary exam if :
final grade >=7.5 AND exam grade >= 6.0
OR exam grade >= 7.5

Observations

Tutoring

Each lecturer must publish a schedule for tutoring her/his students. However, students should arrange with their lecturer for any individual meeting.