Information Management

Code:

1GE107

Acronym:

GI

Keywords
Classification	Keyword
OFICIAL	Management Studies

Instance: 2022/2023 - 2S

Active?	Yes
Web Page:	https://moodle.up.pt/course/view.php?id=1093
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	314	Bologna Syllabus since 2012	1	-	6	42	162

Teaching language

Suitable for English-speaking students

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

Michael Alexander, Dick Kusleika; Microsoft Excel 365 Bible, Wiley, 2022. ISBN: 978-1119835103
Michael Alexander, Richard Kusleika; Access 2019 Bible, Wiley, 2018. ISBN: 978-1119514756
Norman Matloff; The Art of R Programming: A Tour of Statistical Software Design, No Starch Press, 2011. ISBN: 978-1593273842
Torgo, Luís Fernando Rainho Alves; A Linguagem R. ISBN: 978-972-592-246-0

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

It consists of four evaluation moments: Three mini-tests and a final test. If the student does not complete one of the mini-tests, the grade of the mini-test will be zero. Students with a score higher than 9.5 in each of the mini-tests are admitted to the final test.

For the grade of the mini-tests component, mini-tests 1, 2 and 3 account, respectively, with the weights 25%, 50% and 25%.

In the final grade, the test will have a weight of 100% if the grade of the mini-tests component is less than or equal to the final test. If the grade of the mini-tests component is higher than that of the test, the final non-rounded score is calculated as follows: The mini-tests component acounts 35% and the final test 65% with the limitation that the final score is, at most, equal to the non-rounded grade of final test plus 2 points.

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

The mini-tests component also applies, with a rule identical to that stated in the paragraph on continuous assessment (replacing "final test" with "exam"), in case the student undergoes an appeal exam to obtain approval.

Classification improvement

In the exam to improve the classification, the grade of the mini-tests component is not considered, and, therefore, the final grade is simply equal to the grade of the exam.