Data Management Tools

Universidade Católica Portuguesa

Course Description

  • Course Name

    Data Management Tools

  • Host University

    Universidade Católica Portuguesa

  • Location

    Lisbon, Portugal

  • Area of Study

    Computer Science

  • Language Level

    Taught In English

  • Course Level Recommendations


    ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.

    Hours & Credits

  • ECTS Credits

  • Recommended U.S. Semester Credits
    2.5 - 3
  • Recommended U.S. Quarter Units
  • Overview

    Course overview and objectives
    To become a more effective business and financial manager there are certain spreadsheet modeling skills and database knowledge that must be mastered.
    This course will focus on advanced spreadsheet features and modeling with Excel, database development and data analysis with MS Access.
    The course will use a “learn by doing” modular approach with real life business examples.
    At the end of the course, students should be able to:
    • Use advanced conditional formatting and data validation
    • Use advanced functions and formula including array formulas
    • Master Goal Seek, Solver, Tables, Scenarios and Pivot Tables
    • Create and Edit Macros
    • Create Models that are easy to navigate and use them to assist your decision-making process
    • Understand the database relational model
    • Use MS Access to create databases, queries and forms

    Course Content
    MS Excel
    Advanced functions and formula, Advanced Conditional Formatting and Validation, Goal Seek, Solver, Scenarios, Tables (a Monte Carlo simulation example), Pivot Tables, Macros
    MS Access
    Data Modeling, The Entity Relationship Model, Entities, Attributes and Keys, Relationships, Entity Relationship Diagrams (ERD), Database organization, The Relational Model, Components of the Relational Model, Normalization, Implementation in MS Access, Creation of databases, tables, Queries and forms, The SQL language.

    The final grade will be calculated using the following weights:
    • Computer Excel exam: 60%
    • Group database assignment: 40%
    Both components are mandatory, if you miss one of them, you will fail the course.

    Online Excel files with tutorials and exercises at:
    Carlos Rondão – online database topics
    Carlos Rondão - It´s Some Kind of Magic
    David M. Kroenke – Database Processing Fundamentals, Design & Implementation. Prentice Hall International Editions
    Dave Ensor, Ian Stevenson 1997 – ORACLE Design. O’Reilly

Course Disclaimer

Courses and course hours of instruction are subject to change.

Eligibility for courses may be subject to a placement exam and/or pre-requisites.

Some courses may require additional fees.

Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.

ECTS (European Credit Transfer and Accumulation System) credits are converted to semester credits/quarter units differently among U.S. universities. Students should confirm the conversion scale used at their home university when determining credit transfer.


This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies.

Read our Privacy Policy to learn more.