Course information

Unit

Learning Unit

Key Topics

1

Apply Computer Fundamentals

Computer types & components, input/output devices, file & folder management (FAT/NTFS), user accounts, security threats, antivirus & utility software, data backup & restore, system updates, hardware protection.

2

Apply Advanced Word Processing

Document views & formatting, styles, tables, graphics, watermarks, page layout, table of contents, references, mail merge, embedding & automation, document printing.

3

Apply Advanced Spreadsheet

Workbook & worksheet management, data entry & editing, formulas and functions, relative/absolute/mixed references, macros, sorting & filtering, charts & graphics, page layout, printing.

4

Apply Advanced PowerPoint Presentation

Slide creation & views, themes, text & lists, multimedia (audio/video), graphics, tables, charts, transitions & animations, slide master, speaker notes, printing & packaging.

5

Use Internet

Internet vs. intranet, network types, web browsers, search engines, email, instant messaging, social networking, video conferencing, online office applications.

Element of Competence

Performance Criteria

1. Apply Computer Fundamentals

Introduce a computer system; manage files and folders; protect the computer system based on the OS installed.

2. Apply Advanced Word Processing

Format documents; use insert options; create references; apply mail merge, embedding & automation; print documents.

3. Apply Advanced Spreadsheet

Apply advanced formatting; use formulas & functions; use insert options; manage data; print spreadsheets.

4. Apply Advanced PowerPoint

Create slides; apply design, transitions & animations; manage slide master; print presentations.

5. Use Internet

Introduce the internet; use web browsers & search engines; use web application software.