Information Management

Code:

1GE107

Acronym:

GI

Keywords
Classification	Keyword
OFICIAL	Management Studies

Instance: 2018/2019 - 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	179	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.

Relational databases:

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

Operational goals: using Access.

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.

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, and resolution of practical exercises.

Software

R
Excel
Access

keywords

Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Teste	100,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

Eligibility for exams

Not applicable. All students enrolled can take the exam.

Calculation formula of final grade

Continuous Assessment

Consists of four stages of evaluation: Three mini-tests and a final test. If the student does not complete one of the mini-tests, the grade will be zero.

The grade of the mini-tests component is calculated by attributing the weights of 25%, 50% and 25% to the mini-tests 1, 2 and 3, respectively.

The final grade is the weighted average of the mini-tests component (35% weight) and the final test (65% weight). That is, the final grade (NF) is calculated according to the formula:

NF = 0.35 * NMT + 0.65 * NE,

where NMT represents the grade of the mini-tests component before rounding and NE represents the grade of the exam before rounding.

Final Exam

For students undertaking the exam in the ordinary examination period, the grade of the mini-tests component is not considered, and therefore, the final grade is simply equal to the grade obtained in the exam.

2^nd examination period

For students undertaking the exam in the second examination period, the grade of the mini-tests component is not considered, and therefore, the final grade is simply equal to the grade obtained in the exam.

Classification improvement

Students who have already passed the course (GINF)  in the 1st period of exams can obtain an improvement in classification using the 2nd period of exams.

For the purpose of calculating the final grade, the mini-tests component is not considered, with the final grade being equal to the grade of the exam.