Provide the knowledge and tools to collect, organize, analyze, and visualize data from multiple sources.
The course allows you to learn the basics of two types of tools: spreadsheets and relational database management systems (RDBMS).
The student will acquire the basic knowledge for the management of spreadsheets with Microsoft Excel 365, the design and implementation of a database through the use of Microsoft Access and the use of the SQL language.

Lectures in which the topics will be introduced.

Demonstrations in which the teacher will show the practical use of software applications. 

Exercises to be carried out with the assistance of the teacher to verify learning.

Module A: Fundamentals of Data Management

• Data and Information
• Importance of Data Management
• Digital Data Preservation
• Types of data
• Data management tools

Module B: Microsoft Excel

• Introduction to Spreadsheets
• Folder and Worksheets
• Cells and data type
• Perform calculations on data
• Absolute and Relative Addressing
• Working with Formulas
• Sorting the data
• Graphs
• Pivot Tables
• Page Layout
• Macros

Module C: Elements of Statistics and Probability

• Introduction to Statistics
• Position Indices
• Average
• Weighted Average
• Dispersion indices
• Range
• Variance
• Standard deviation
• Covariance of two statistical variables
• Introduction to Probability
• Probability of an event
• Certain events
• Adverse events
• Compound events (dependent and independent)
• Intersection of events
• Merging Events
• Introduction to Bayes' theorem

Module D: Database

• Introduction to databases
• Relational Database Management System (RDBMS)
• Design a database
• Relationship Entity Schema
• Tables and Reports
• Microsoft Access (RDBMS)
• Create a database
• Tables and Records
• Primary Keys and Foreign Keys
• Views
• Forms
• QBE
• Structured Query Language (SQL)
• Data Manipulation Language (DML)
• Insert, Update, Delete
• Data Definition Language (DDL)
• Create, Drop, Alter
• Data Query Language (DQL)
• Select
• Databases using SQL (with reference to Microsoft SQL Server)
• Searching for Data (Queries)
• Inserting, Editing, and Deleting Records
• Sorting the Result of a Query
• Joined queries
• Grouping data

- Microsoft Access 2002 Step by Step, Microsoft Press.
- Microsoft  SQL Server 2012 Step by Step, Patrick Leblanc, Microsoft Press.