Please check out the information for each course that I teach by following the appropriate links.

You will find information about assignments, tests and dates.

Thanks for visiting our site!

Here is the link to my tutorials on Youtube.

Grade 10B Test for Excel and Web Design Friday May 18 day 2.
Grade 10A Test for Excel and Web Design Tuesday May 22 Day 3

Here are some to things to be prepared for :

Tests Grade 10 Excel:

1.       VLOOKUP – using Criteria, Extract, Advanced Filters,
     Conditional formatting using ICON sets.
     Formulas :SumIF statements.
  Advanced formulas – using VLOOKUP and Multiplication for example.
  Creating coloured table formats.
  Using Drop Down listboxes with VLOOKUP.

Web Design:

1.       Creating a Timeling animation – ALT + F9.
 Inserting a .swf animation.
 Using hotspots to reveal and hide an image.
 Creating a roll over image. 

Last Updated: Mon, 14 May 2012