2019-2020 / 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 tu use Windows 10 (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)

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 10 and Excel 2016.
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.

Assessment methods and criteria

Assessment tools :
A continuous assessment is based on homeworks proposed 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.
Homework not returned on time and via LOl@ be automatically punished with a 0. No excuses will be accepted.
The computer-based exam 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 :






  • continuous evaluation (4 personal homeworks) : 12 % (3% per homework)
  • computer exam (mandatory in january and if failed, possibility to represent it in june or second session): 88 %

Work placement(s)

Organizational remarks

Contacts

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

Adaptation of teaching commitments following the COVID-19 pandemic for the May-June 2020 session

Teaching methods implemented : distance-learning

Assessment subjects

Assessment methods

Assessment tools :
A continuous assessment is based on homeworks proposed 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.
Homework not returned on time and via LOl@ be automatically punished with a 0. No excuses will be accepted.
The exam will be a QCM.


  • choice of the right tool, even data analysis tools, and its parameters, to resolve a given problem,
  • choice of the right function ans its parameters to realize a formula, to resolve a given problem,
  • choice of the right type of address to realize a formula, to resolve a given problem,
  • choice of the type of graphic and its format to realise a graphic to resolve a given problem.
Evaluations weighting and schedule :


  • continuous evaluation (4 personal homeworks) : 12 % (3% per homework)
  • QCM : 88 %

Contacts

Adaptation of teaching commitments following the COVID-19 pandemic for the Aug-Sept 2020 session

Assessment subjects

Assessment methods

Assessment tools :
A continuous assessment is based on homeworks proposed 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.
Homework not returned on time and via LOl@ be automatically punished with a 0. No excuses will be accepted.
The exam will be a QCM on LOl@ Examens (https://examens.hec.uliege.be/) :


  • choice of the right tool, even data analysis tools, and its parameters, to resolve a given problem,
  • choice of the right function ans its parameters to realize a formula, to resolve a given problem,
  • choice of the right type of address to realize a formula, to resolve a given problem,
  • choice of the type of graphic and its format to realise a graphic to resolve a given problem.
Evaluations weighting and schedule :


  • continuous evaluation (4 personal homeworks) : 12 % (3% per homework)
  • QCM : 88 %

Contacts

Items online

see LOl@
e-learning course