Information Management

Code:

1EC107

Acronym:

GINF

Keywords
Classification	Keyword
OFICIAL	Computer Science

Instance: 2022/2023 - 2S

Active?	Yes
Responsible unit:	Agrupamento Científico de Matemática e Sistemas de Informação
Course/CS Responsible:	Bachelor in Economics

Cycles of Study/Courses

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

Teaching language

Portuguese

Objectives

Explain the role Information systems and their support role in the process of reaching a decision in business issues, indispensible in companies. Form users that are capable to take a critical stand regards the methods of information management, providing the possibility to learn about the instruments appropriate in decision making. Efficient management of available information requires integration of different types of information from different sources, aggregation of data and its treatment and analysis. In this currciculum unit the aim is to provide learning of instruments in the area of information systems that permit, among other aspects:

- provide knowledge of basic forms of data representation,

- use tools that permit to describe and analyze data,

- organize data in databases,

- select subsets of structured data and use methods that permit to compare different subsets,

- Elaborate representations of decision structures and relate these to programming concepts,

 

Learning outcomes and competences

The course aims to develop learning skills on management information system tools that allow the students to:

- Know the basic forms of data representation,

- use tools that permit to describe and analyze data,

- organize data in databases,

- select subsets of structured data and use methods that permit to compare different subsets,

- Elaborate representations of decision structures and relate these to programming concepts,

Working method

Presencial

Program

Spreadsheets: Formulas and functions; calculation of new values on the basis of others; elaboration of elaboration of graphs and charts; search of particular data items and their use in further calculations; compact views of data using Pivot tables and charts. Operational objectives: Usage of Excel.

Relational databases: Tables; relationships; queries (QBE); interfaces (forms); design of a database (entities and relationships). Operational objectives: Usage of DB system Access.

Introduction to programming: Data structures (simple objects; vectors; data frames); instruction; elaboration of functions; processing more complex structures (e.g. data frames); Operational objectives: programming in language R.

Data analysis and elaboration of decision models: Exploratory data analysis; Rules and decision trees; classification and (linear) regression; Operational objectives: Data analysis in R; Import of data and exploratory analysis (ex. elaboration of histograms); generation of decision models for classification / regression;

Mandatory literature

L.Torgo; LINGUAGEM R - PROGRAMAÇÃO PARA ANÁLISE DE DADOS, Livraria Escolar Edi

Complementary Bibliography

John Viescas, Jeff Conrad; Microsoft Office Access 2007, 2007. ISBN: 0-7356-2325-2
Maria Adelaide Pinto Carvalho; Excel 97. ISBN: 972-97488-0-2

Teaching methods and learning activities

Theoretical-practical classes which include presentation of the teaching material, practical exercises and practical work (assignments).

Software

R
Access
Excel
RStudio

keywords

Technological sciences > Technology > Information technology

Evaluation Type

Distributed evaluation without 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	39,00
Trabalho laboratorial	63,00
Total:	162,00

Eligibility for exams

Students who have a weighted average of tests greater than or equal to 9.5 values are approved by distributed assessment, and have not received on any test a grade below 6.0.

Students who scored less than 6 in any test are considered excluded from the distributed assessment without a final exam. Who obtains a classification below 6 values in any of the first two tests, will not be able to continue with the distributed assessment and will not be assigned a final classification. A student who obtained a rating lower than 6 in the third test, did not obtain a final result.

A student who gives up the third test, can choose to be evaluated by the final exam, and therefore a final classification will not be assigned in the distributed assessment.

All enrolled students can take the exam.

Calculation formula of final grade

Continuous Assessment

The distributed assessment consists of three written assessment tests during the semester. If the student does not take one of the tests, he will have zero in that test, and will be excluded from the continuous assessment.

Any student undergoing distributed assessment may, until the date of the third test, withdraw from it and choose to be assessed by final exam. If you deliver the third test, then you can no longer be assessed by final exam in the final exam in the normal season.

For the final grade, the grades of tests 1, 2 and 3 count, respectively, with the weights 30%, 40% and 30%. Test scores are rounded to one decimal.

Students who have a weighted average of tests greater than or equal to 9.5 values are approved by distributed assessment, and have not received on any test a grade below 6.0.

Final Exam

In this final exam the final grade is simply the same as the exam grade.

Retake Exam

In this final exam the final grade is simply the same as the exam grade.