Information Management

Code:

1GE107

Acronym:

GI

Keywords
Classification	Keyword
OFICIAL	Management Studies

Instance: 2015/2016 - 2S

Active?	Yes
Responsible unit:	Management
Course/CS Responsible:	Bachelor in Business Administration

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
LGES	167	Bologna Syllabus since 2012	1	-	6	42	162

Teaching language

Portuguese

Objectives

Provide learning of basic concepts in informatics including:

- Basic forms of data representation,

- Computation of new values from others values, charting,

- Methods of selecting a subset of data and / or grouping of these items and computation of measures that characterize each group, for example, averages, totals etc..

- Methods for comparing subgroups of data,

- Representations of decision-making structures and its relation to programming.

Furthermore, it is intended to provide students with the skills on some tools (eg Excel spreadsheets, Access database) and R language, suitable for general objectives mentioned above.

Learning outcomes and competences

Students should be able to use the software tools to calculate , select and group sets of records according to certain criteria.

The student should be able to use the software tools to solve problems involving an information processing at a basic and advanced level.

The type of problems addressed in this course should give them adequate training so that they can represent the initial data of the problem and to compute the resulting information. The domain of data graphical representation allow the student to demonstrate clearly the information contained in the data.

The knowledge on databases systems prepare students for accessing databases and know what is possible to extract directly through queries.

Students should also obtain basic skills of decision models and their relationship with programming.

Working method

Presencial

Program

Spreadsheets:

Formulas and functions; management of small amounts of data, graphs, searching and data exploration; exploration of datasets through Pivot tables.

Operational objectives: Using Excel. Development of the first student assignement (task) that involves data available in FEP (eg OECD international trade etc..).

 

Relational databases:

Tables, relationships, queries (QBE), interfaces (forms); designing databases (entities and relationships).

Operational goals: using Access. Development of the student assignment in the area.

 

Introduction to Programming:

Data structures (simple objects, vectors, data frames); instructions; programming functions, handling data sets (eg data frames);

Operational objectives: Programming in R.

 

Data analysis and modeling of decision:

Classification; decision trees and rules, regression, exploratory data analysis.

Operational objectives: Data Analysis in R and import of data and exploratory analysis (eg histograms); generation models classification / regression. Importing data from the Internet; Development of the third student assignment in the area.

Mandatory literature

Torgo, Luís Fernando Rainho Alves; A Linguagem R. ISBN: 978-972-592-246-0
Viescas, John; Microsoft Office Access 2007. ISBN: 0-7356-2325-2
Carvalho, Maria Adelaide Pinto; Excel 97. ISBN: 972-97488-0-2

Teaching methods and learning activities

Theoretical-practical classes with concept exposition and simple exercises, resolution of practical exercises and support the student into their assignments.

Software

Access
R
Excel

keywords

Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Teste	65,00
Trabalho escrito	35,00
Total:	100,00

Amount of time allocated to each course unit

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

Calculation formula of final grade

Continuous Assessment
consists of four stages of evaluation: Three practical assignments and a final test. If the student does not complete one of the assignments, the grade will be zero. The students who have achieved a grade greater than 9.5 in each of the first two assignments are admitted to the final test.

The grade of the practical assignment is calculated by attributing the weights of 25%, 50% and 25% to the assignments 1, 2 and 3.

If the grade of the practical assignment is lower than, or equal to, the grade of the final test, the final test has a weight of 100% when calculating the final grade.

 

If the grade of the practical assignment is higher than the grade of the final test, the final grade before rounding is calculated as follows:

The practical assignment weighs 35% and the final test 65%, subject to a limitation that the final grade must not exceed the grade of the test by more than two values.

Final Exam
For students undertaking the exam In the ordinary examination period, the grade of the assignments is not considered, and therefore, the final grade is simply equal to the grade obtained in the exam.

 

2^nd examination period

 

A similar rule as stated above (while replacing "final test" with "exam in the 2^nd examination period"), applies to students that undergo the exam in the 2^nd examination period.