2020-2021 / 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, hybrid 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.

Organisational adjustments related to the current health context

In the event of a red code, the face-to-face sessions would be replaced by videos made available on LOl@ in accordance with the schedule for face-to-face sessions. At the beginning of the week, an announcement would be sent specifying the videos to be viewed, the documents to be used and possibly the assignment to be carried out. In case of a problem of understanding, it would be possible to send an email for an explanation or a request for an appointment via Lifesize.
In case of red code, assignments should be completed with Excel 2016 minimum and the Windows 10 requirement would no longer be met (so MacOs would be accepted).
The 4 assignments would still be evaluated on 3 points each and therefore 12 points in total.

The exam is evaluated on 88 marks.
The january session exam will be organized as a distance MCQ exam.
For the june session and second session, the exam will be a computer exam (in the computer rooms of the school), if the sanatory conditions allow it, as initialy planned.


 

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

Below you will find information on the evaluation methods planned for in-person and remote exams as well as those planned for hybrid sessions. Depending on how the health crisis evolves, the chosen method will be communicated to you no later than one month before the start of the exam session.

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. The computers at school for the exam are equiped of Windows 10 and Excel 2016. 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.
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)

Items online

see LOl@
e-learning course