INFO1001-1 : Computer skills

Study Programmes 2016-2017

INFO1001-1

Computer skills

Duration :

10h Th, 10h Pr

Number of credits :

Master in public health (120 ECTS)		2

Lecturer :

Nathalie Cavan, Eddy Husson, Sylvie Streel

Coordinator :

Sylvie Streel

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 2010
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 2010
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 2010 as well as Microsoft Office Excel 2010 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.

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.