Information Management

Code:

1GE107

Acronym:

GI

Keywords
Classification	Keyword
OFICIAL	Management Studies

Instance: 2025/2026 - 2S

Active?	Yes
Web Page:	https://moodle2324.up.pt/course/view.php?id=1067
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	8	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 other 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 (e.g., 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 (e.g., 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 (e.g., 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 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	42,00
Trabalho laboratorial	60,00
Total:	162,00

Eligibility for exams

Students are approved by distributed assessment if they have a weighted average of tests equal to or greater than 9.5 points, and have not received a grade lower than 6.0 points in any of the 3 tests.

Students who obtain a grade lower than 6.0 points in any of the tests are considered excluded from distributed assessment without a final exam, regardless of the weighted average of the partial grades obtained. Students who obtain a grade lower than 6.0 points in either of the first two tests will not be able to continue with distributed assessment, and a final grade will not be assigned. A student who obtains a grade lower than 6.0 points on the third test does not achieve approval.

Any student may take the final exam, regardless of the grades obtained on the first two tests.

Calculation formula of final grade

Continuous Assessment

Distributed assessment consists of three in-person assessment tests during the semester. If a student does not take one of the tests, they will receive a zero on that test and will be excluded from distributed assessment. The third test coincides with the date of the regular exam period.

Any student in distributed assessment may, up until the date of the third test, withdraw from it and choose to be assessed by a final exam. If they submit the third test, then they will no longer be able to be assessed by a final exam in the regular exam period.

For the final grade, the grades of tests 1, 2, and 3 count with weightings of 30%, 40%, and 30%, respectively. The test grades are rounded to the nearest tenth.

Students are approved by distributed assessment if they have a weighted average of the tests equal to or greater than 9.5 points, and have not received a grade lower than 6.0 points on any of the 3 tests.

Final Exam

In the regular exam period's final exam, the final grade is simply equal to the exam grade.

2^nd Examination Period

In the 2nd examination period, the final grade is simply equal to the exam grade.