Digital Literacy, Office Tools and Information Systems
This domain tests practical use of the tools found in an administrative office, plus the legal and security rules that go with them. Questions are concrete: a formula, a file extension, a mailing rule, a data-protection principle.
Office tools
- Word processing: styles for headings, automatic table of contents, headers and footers, mail merge (publipostage) for convocations and certificates, track changes, export to PDF.
- Spreadsheet: relative reference A1 versus absolute $A$1; functions SOMME, MOYENNE, SI, NB.SI, SOMME.SI, RECHERCHEV; sorting and filtering; charts; pivot tables.
- Files: extensions .docx, .xlsx, .pdf, .csv; a clear naming convention; backups following the 3-2-1 rule (three copies, two media, one off-site).
Information systems and security
- Database vocabulary: table, record (row), field (column), primary key, query.
- Email: Cc for visible copies, Cci for hidden recipients when mailing a list; verify the sender's address and links before opening an attachment; a .exe attachment is never opened.
- Passwords: length and uniqueness, no sharing, second factor where available.
- Legal frame: Loi 18-07 on the protection of personal data (declarations, consent, rights of access and rectification, supervised by the ANPDP); Loi 15-04 on electronic signature and certification; the CNAS electronic télé-déclaration for employers.
Worked example
In a spreadsheet, column B holds years of insurance. The formula =SI(B2>=32;80;B2*2,5) returns 80 for 32 years and 55 for 22 years. Note the semicolon separator and the decimal comma used in the French locale, where an English-language sheet would use commas and a point. If the formula is copied down, relative cells adjust automatically; to freeze a reference - a rate in $C$1 - it must be written with dollar signs.
Traps that cost marks
Forgetting $ before copying a formula and seeing the reference drift; confusing Cc and Cci; using a comma separator in a French-locale formula; treating a deleted file as destroyed without checking the recycle bin or backup; sending personal data in an open mailing list, contrary to Loi 18-07.
Key points
- A1 is relative, $A$1 is absolute: the dollar sign prevents drift when copying.
- SOMME, MOYENNE, SI, NB.SI, RECHERCHEV cover most administrative calculations.
- Cci hides recipients; Cc discloses them.
- Loi 18-07 governs personal data, under the ANPDP; Loi 15-04 governs electronic signature.
- 3-2-1 backup rule: three copies, two media, one off-site.
- Never open an unexpected executable attachment - check the sender first.