Contact Dewald P. Montgomery

These topics will be assessed in tests and examinations:

• Introduction to Windows (desktop, start menu, task bar etc.)
• Click, double click, right click, drag and scroll
• Creating and opening folders
• Introduction to Office programs (look & feel)
• Creating new documents and spreadsheets
• Saving, organising and opening documents and spreadsheets
• Font, font size, font colour, bold, italic and underline
• Indenting and aligning text (Word & Excel)
• Line and character spacing (Word)
• Page size and layout (Word & Excel)
• The golden rules in Excel (= and ENTER)
• Operators (+, -, / and *) and basic calculations (Excel)
• Selecting all rows and columns (Excel)
• Selecting cells, rows and columns (Excel)
• Increasing and decreasing decimals (Excel)
• Borders (Excel)
• Cell background (fill) colour (Excel)
• Autusum (Excel)
• Formulas, the formula bar and fixing mistakes (Excel)
• Sheets (adding, renaming, deleting, colouring the tab) and workbooks (Excel)
• Resizing rows and columns (Excel)
• Copying formulas (Excel)
• Bullets and numbered lists (Word)
• Aligning and indenting bullets and numbered lists (Word)
• Page numbers (Word)
• Formatting page numbers (Word)
• Inserting a new page (Word)
• Special language characters (Word)
• Shapes (resize, background (fill) colour, rotate etc.) and text boxes (Word)
• About gridlines (Word)
• Inserting new rows and columns and deleting rows and columns (Excel)
• Colouring figures (Excel)
• Comparing figures and calculating the difference in Rand and % (Excel)
• Budgets and income statements (Excel)
• Watermarks (Word)
• Headers and footers (Word)
• Columns (Word) (page or selected text)
• Page background colour (Word)
• Page borders (Word)
• Link to cells on a different sheet/in a different workbook (Excel)
• Bar charts and pie charts (Excel)
• Creating tables in Excel and copying them to Word
• Stock sheets (Excel)
• Invoicing (Excel)
• Writing letters, creating letterheads, writing reports (Word)
• SmartArt (Word) (process, cycle and hierarchy)
• Citations and bibliographies (Word)
• Find and replace (Word)
• Spell and grammar check (Word)
• VAT (Excel)
• Discount and service fees/tips (Excel)
• Net profit, gross profit, % (Excel)
• Averages (Excel)
• PowerPoint: General rules
• Layout of a slideshow (Powerpoint)
• Creating a slideshow (PowerPoint)
• Slide design (colour scheme/fonts etc.) (PowerPoint)
• Transitions and animation (PowerPoint)
• Introduction to the WWW (Internet Explorer/Firefox)
• How to find your way around the WWW (Internet Explorer/Firefox)
• Using Gmail (Internet Explorer/Firefox)
• How to use Outlook (Outlook) (new e-mail, organise e-mail, attachments, CC, BCC, etc.)
• Using Google Maps (Internet Explorer/Firefox)
• Using Google to find information and images (Internet Explorer/Firefox)