2023-2024 / INFO2043-1

Mastering IT Tools

Duration

20h Pr

Number of credits

 Bachelor in business engineering2 crédits 

Lecturer

Eddy Heins

Language(s) of instruction

French language

Organisation and examination

Teaching in the first semester, review in January

Schedule

Schedule online

Units courses prerequisite and corequisite

Prerequisite or corequisite units are presented within each program

Learning unit contents

The computer :

  • basics,
  • operating system (interface, management of files and directories, configuration).
Spreadsheet :
  • general use;
  • addresses;
  • functions;
  • graphics;
  • data analysis.

Learning outcomes of the learning unit

Enabling students to use spreadsheets.
They will be able to :

  • select the appropriate tool to meet a given need,
  • conceive an optimal solution to resolve a concrete problem,
We insist on the efficient use of the software tools. Finding "one" solution is not sufficient, but the choosen solution has to be efficient, direct, and quick, and take the best advantage of the tools.
The expected learning outcomes of this course, as mentionned above, contribute to the development of several capacities of the KLO :
Strategy : The course will allow students to analyse the financial, economic, political, social and societal context of a complex situation, using his mastering of spreadsheets (calculation, data analysis, graphical vizualisation). Implementation : The course will allow students to take charge of the everyday management of a company, an organization or a project taking advantage of data digitalization, mastering query and data processing tools,
Quality and Performance Control : The course will allow students to plan and implement the performance and quality control in a company, an organization or a project, by means of spreadsheets (calculation, data analysis, ...).
Adaptability : The course will encourage students to develop an expertise in a lifelong learning perspective in their studies as well as in their professional life.
 
 

Prerequisite knowledge and skills

Be able to use Windows (an online formation is available for the students who need it)

Planned learning activities and teaching methods

The explanation of the functionalities is based on cases and practical exercises.
An exam simulation is organized.

Mode of delivery (face to face, distance learning, hybrid learning)

Face-to-face course


Additional information:

Ten lessons of two hours are organized in a computer room.

Coaching will be provided by the teacher via mail, an appointment can be made.

Software used : Windows and Excel (version 2016 minimum).

This training is organized through e-learning, over the first semester.

Recommended or required readings

Syllabi (available on LOl@). Online material (available on LOl@) : cases, exercises (with solutions), electronic files used as a basis for the exercises.

Exam(s) in session

Any session

- In-person

written exam ( open-ended questions )

Written work / report


Additional information:

Homeworks must be realized at the end of some modules. The students have to respect the deadlines. The objective is to verify that the students understand how the tools work, are able to realise an asked operation, and resolve cases. Further, it's a good preparation for the exam. The computers at school for the exam are equiped of Windows 11 and Excel 2016 (minimum). So, you have to check your homeworks in the same environment before returning them.

Homework not returned on time and via LOl@ be automatically punished with a 0. No excuses will be accepted.


Exam information :

The computer-based exam (90 marks) takes place in the N1 computer rooms. It involves :

  • the realization of an asked operation,
  • using the adequate tool;
  • the resolving of cases.
Evaluations weighting and schedule :

  • Written work (3 personal homeworks) : 10 % (4% for the first and 3% per for the last ones)
  • computer exam (mandatory in january and if failed, possibility to represent it in june or second session): 90 %

Work placement(s)

Organisational remarks and main changes to the course

Contacts

Eddy Heins : eddy.heins@uliege.be (306 - N1)

Association of one or more MOOCs

Items online

see LOl@
e-learning course