Duration
10h Th, 10h Pr
Number of credits
| Master in public health (120 ECTS) | 2 crédits |
Lecturer
Coordinator
Language(s) of instruction
French language
Organisation and examination
Teaching in the first semester, review in January
Units courses prerequisite and corequisite
Prerequisite or corequisite units are presented within each program
Learning unit contents
Microsoft Office Word
Introduction to the software and its basic functions: environment and interface, input and typing, page layout, formatting, tabs, tables, etc.
Advanced software features: headers and footers management, styles and table of contents, numbering, bullets, etc.
Microsoft Office Excel
Introduction to the software and its basic functions: environment and interface, managing folders, files and spreadsheet, page layout, formatting, basic functions, graphs, etc.
Advanced functions: analyzing data using formulas or more complex features (Convert, Concatenate, IF, AND, OR, COUNTIF, SUMIF, AVERAGEIF, VLOOKUP, etc.), freeze rows and columns, filter and sort data in a table, subtotals, pivot tables, etc.
Learning outcomes of the learning unit
At the end of the training, the student will master the basic functions of Microsoft Office Word as well as Microsoft Office Excel softwares. He/She will also have to use more advanced functionality to better manage long documents and analyze large amounts of data.
Prerequisite knowledge and skills
Knowing how to use basic functions of a computer and Windows.
Planned learning activities and teaching methods
Courses, tutorial session with PC.
Mode of delivery (face-to-face ; distance-learning)
Face-to-face lessons.
Teaching during the first semester. The theoretical course schedule is communicated to the students by the Department of Public Health Sciences.
Recommended or required readings
Course materials and exercises will be available to students via the website https://www.ecampus.ulg.ac.be
For further information :
www.goulet.ca
www.editions-eni.fr
Assessment methods and criteria
For newcomers (=students who have never been registered in INFO1001-1) :
Students who have obtained a mark of 16/20 or more in the dispensatory test organized on 22/09/2017 and 29/09/2017 will be exempt from the final examination and the course.
The subject of this dispensatory test is the use of basic and advanced functions of Excel and Word. To sign up for one of these two sessions, click on the link associated with the date and the time that suits you.
Please, only register ONCE! The number of students per session is limited to 30.
Registration - Friday 22/09/2017
- 08h30 - 10h30 : https://www.inscription-facile.com/form/0vaq8veT7pWTKklWv4W0
- 11h00 - 13h00 : https://www.inscription-facile.com/form/lcEMnRsuGLobpylSXLlp
- 13h30 - 15h30 : https://www.inscription-facile.com/form/GuzsbFL1nDPu3GWLxgQA
- 16h00 - 18h00 : https://www.inscription-facile.com/form/axXTdo1xehrw1bIlfJkg
Registration - Friday 29/09/2017
- 08h30 - 10h30 : https://www.inscription-facile.com/form/7dNUfvsmKJCwEsky4dt2
- 11h00 - 13h00 : https://www.inscription-facile.com/form/0fyCSn5TqAaXjx06HBtz
- 13h30 - 15h30 : https://www.inscription-facile.com/form/isUzB2l9HFlZznGZr13G
- 16h00 - 18h00 : https://www.inscription-facile.com/form/boi1HApuwO1m0uR3Sxv9
For further information : Sylvie.Streel@ulg.ac.be
Final evaluation for non-dispensed students and those repeating the course : practical examination on computer.
Work placement(s)
Organizational remarks
///
Contacts
Nathalie CAVAN
Bât. B26 SEGI : Opérations : Formations
Quartier Polytech 1
Allée de la Découverte, 8
4000 LIEGE 1
Belgique
ncavan@ulg.ac.be