ICT Tools

Sustainable Development Goals (SDG)

• 12. Responsible consumption and production

Objectives

• Know appropriate calculation tools for decision making.
• Learn about free software alternatives in the field of information management tools.
• Analyze, manage and visualize information about an organization.
• Know how to apply the information technologies most appropriate to your needs.
• Be able to operate in different computer environments.

Learning outcomes

1. Learn the basic nomenclature of ICT.
2. Works in different operating environments.
3. Use a spreadsheet as a decision-making aid.
4. Model mathematically using a spreadsheet.
5. Analyze, manipulate and visualize data to aid decision making.

Competencies

General skills

• Show ability to adapt to contexts and changing business and social realities within a global environment.

Specific skills

• Interpret mathematical and statistical data related to the company, to aid in business decision making, using digital technology tools as needed.

Basic skills

• Students can communicate information, ideas, problems and solutions to both specialists and non-specialists.
• Students have the ability to gather and interpret relevant data (usually within their field of study) in order to make judgments that include reflection on relevant social, scientific and ethical issues.

Core skills

• Display professional skills in complex multidisciplinary contexts, working in networked teams, whether face-to-face or online, through use of information and communication technology.

Content

1. Introduction to ICT
2. Productivity Tools: Spreadsheet:
   1. Data and formulas
   2. Graphics
   3. Optimization tools
   4. Dynamic data analysis
3. Business intelligence : Power BI
   1. Introduction to the PowerBI ecosystem
   2. Obtaining and transforming data
   3. Data Model Management
   4. Creating interactive panels

Evaluation

Evaluation system

• Follow-up of face-to-face sessions: 10%
• Completion of required tasks: 10%
• Exams: 80%

Description of evaluation actions

• Monitoring of face-to-face sessions: this involves individually completing a set of exercises during the face-to-face sessions. Any support material can be used. The teacher evaluates the student's overall progress in achieving the learning outcomes. It is not mandatory to pass this section to pass the course.
• Completion of required tasks: this involves individually completing a set of tasks. Any support material can be used. Each set of exercises is corrected in the face-to-face session after completion. The teacher globally grades the student's progress in achieving the learning outcomes. It is not mandatory to pass this section to pass the course.
• Exam: consists of three individual exercises (control 1, 2 and 3 in the work plan) in which a minimum of 4 must be obtained to be able to make an average. If a single control does not exceed 4, it can be recovered in the retake period.

The final exam grade is a weighted average of the three blocks.

Methodology

• Guided sessions with small groups
• Individual practices with tutoring

Bibliography

Key references

• Microsoft (2023). Documentación de introducción a Power BI. Retrieved from https://learn.microsoft.com/es-es/power-bi/fundamentals/
• Valdés- Miranda C. (2016). Excel 2016 (Manuales Imprescindibles). ANAYA MULTIMEDIA.

Further reading

Teachers will provide complementary bibliography and compulsory reading throughout the course via the Virtual Campus.