IMAGES

Année académique : 2020-2021
Département : Sciences économiques et de gestion
Domaine d'étude : Sciences économiques et de gestion
Cursus : Assistant de direction - option langues et gestion
Volume horaire : 60 périodes
Nombre de crédits : 4
Implantation(s) : Hazinelle
Quadrimestre(s) : Q1
Niveau du cadre francophone de certification : 6

Intitulé U.E. : Data treatment and software skills Code U.E. : L202A
Pondération : 80 pts Cycle : 1 Obligatoire : oui Bloc : Bloc 2 Langue d'enseignement : English

Activités d'apprentissage composant l'UE :

Titre : Titulaire(s) de l'AA : Nombre d'heures :
Data treatmentToussirot Muriel, 30
Software skillsROSU Stephanie, 30

Coordonnées du responsable de l'UE :

Toussirot Muriel (Muriel.TOUSSIROT@hel.be) 

Coordonnées des intervenants de l'UE :

Toussirot Muriel (Muriel.TOUSSIROT@hel.be), ROSU Stephanie (Stephanie.ROSU@hel.be),

Prérequis :

Corequis :

Compétences visées
Description du contenu des activités d'apprentissage (AA) :

1 : Data treatment

IT offers many possibilities in terms of information processing:
Diversity of treatments: obtaining information (text recognition, voice recognition, accounting and statistics, etc.)
Transforming information (classification, spelling, image processing, etc.)
Storage of information (including the possibility of using it in the near future).
Data treatment of information


At the end of this learning activity, the student will be able to :
• master the computer in order to take full advantage of existing tools (to use a computer and internet correctly and intelligently)
• master the processing of data treatment in management
• master the processing of information



2 : Software skills

At the end of the learning sessions, the student will be able on Excel®:

  • to optimize data encoding;
  • to produce advanced spreadsheets and graphics (Management Dashboard), and pivot tables.
  • to process large amounts of data;
  • to create and manage links between Excel files;
  • to customize the program interface;
  • to set up the printing of a complex document (several sheets and graphics);
  • to use advanced formulas;
  • to use the acquired skills in a real world situation.


Description des méthodes d'enseignement :

1 : Data treatment

The teaching will be of the hybrid type (mix of face-to-face and distance learning) or full distance education depending on health needs. Hybrid teaching will tend towards "crew" type learning that promotes interpersonal interactions in order to bring the learner out of his isolation.

The objective of this course covers theoretical and practical aspects but it is also there to support the development of independent learning online.

Students will be encouraged to share with each other in order to promote peer learning.

The course will use tools such as Padlet, Noodle, Youtube, Wooclap, PPT presentations, Word documents etc… but also book references. In some courses, a Portfolio produced by the teacher is available at the school library.

The mode of communication will be TEAMS, Skype for Business and email.

A summary table of class sessions, appointments, tasks ... will be fed regularly on TEAMS with the description of the tasks to be carried out and the outputs expected from the students with the description of the materials, deadlines and methods of sending.

This course is based on an active and inductive method even if few sessions are "ex-cathedra".

Theory is illustrated by cases, headline examples.

Pratice is enhanced by exercices, discussion questions...



2 : Software skills

At each lesson, application exercises of increasing difficulty are proposed and then corrected. The inductive method is preferred: the student takes note of each new acquired know-how. These exercises are completed by theoretical syntheses incorporating learning outcomes.

The exercises are representative of real-world situations.

A remediation is ensured continuously by the teacher at the request of the student.

The course is organized in person. If, however, the health situation made face-to-face teaching impossible, the sessions would be organized remotely in a synchronous manner.



Modalités et critères d'évaluation :

1 : Data treatment

This course emphasizes active / inductive methods, content construction is also done from learning activities carried out in classes. Participation in courses (even online) therefore determines success.

The assessment will focus on a production / work integrating the course material: theory, exercises, various documents distributed or viewed ...

The evaluation methods remain the same in all health situations, only the "means" used change if necessary (face-to-face or remotely)

2 : Software skills

An exam is organized during the session. This evaluation aims to place students in a real-world situation, for this reason students may dispose of their notes. It consists in a single great summation of the matter.

In the event of failure, a similar examination is organized in second session.

The evaluation is organized in person. If, however, the health situation made a face-to-face evaluation impossible, the evaluation would take place remotely, according to the procedures communicated by e-mail to the students by the professor.

Pondération A.A. :

1 : Data treatment

Written output 100% of the evaluation

Identical for each session

Work = 100% of the grade

2 : Software skills

Examination Excel®: 40 points

Dispositions spéciales COVID-19 :

1 : Data treatment

2 : Software skills

Dispositions spéciales COVID-19 (session août/septembre 2020) :

1 : Data treatment

2 : Software skills

Sources, références et supports éventuels :

1 : Data treatment

Documents on TEAMS.

Lambin J.J. de Moerloose C. (2016). Marketing stratégique et opérationnel. La démarche marketing dans l'économie numérique. Dunod.



2 : Software skills

Access 2016, Eni édition, France, 2016

Excel 2016, Eni édition, France, 2015



Pondération U.E. :

80

Pour les unités optionnelles de langues de du département économique, veuillez vous référer à la fiche de langue correspondante (en cours obligatoire).
Toute modification éventuelle de cette fiche en cours d’année ne peut se faire qu’exceptionnellement et avec l’accord de la direction départementale conformément à l’article 77 du décret du 7/11/2013 (force majeure touchant les enseignants responsables).