PRACTICAL SKILLS
Practical skills are crucial to success in this examination. Students studying any of the syllabi titled Information Technology or Information & Communication Technology will be tested over a wide range of skills within several application packages.

The materials available here are grouped according to application area and not specific application software. However, at present all the materials refer to Microsoft Office. As this site develops the intention is to move towards worksheets that can be used across a number of application software packages.

All materials here are in pdf format. You will need Acrobat Reader to view them.

Acrobat Reader is FREE. To download click here...   

Application Topic Worksheets
Databases Tutorials 
Creating tables, primary keys...Lesson #1
Sorting and using filtersLesson #2
Using queries, difference between filters & queriesLesson #3
Creating reports, attaching queriesLesson #4
Editing reports, changing layoutLesson #5
Importing data from other sources - .csv filesLesson #6
Students.csv
Creating forms Lesson #7
Using Check Boxes and Combo Boxes Lesson #8
Creating relationships between tables Lesson #9
Using wildcards in queries Lesson #10
More with relationships and transaction tables Lesson #11
Practising skills  
Oxford's Cholera Outbreak of 1854:
Worksheet 1 		Cholera 1,
Patients.csv
Worksheet 2 Cholera 2,
Patients2.csv
Student database: Student 2,
Student 3
   
   
Website authoring Tutorials
  Getting started, terminologyLesson #1
Example HTML pageExample.html
Example2.html
Example.txt
Using imagesLesson #2
Images.html
camelbleach.jpg
The structure of a web page, some tagsLesson #3
Using tables, spanning columns and rowsLesson #4
Lists: ordered and unorderedLesson #5
TeaMug.gif,
City.gif
TeaMug.html
Fonts, styles and coloursLesson #6
Fonts.html
Style and CSS
                                                                 NEW
                                                                 NEW
                                                                 NEW		Lesson #7
Styles info sheet 1
Styles info sheet 2
Styles info sheet 3
Using frames? Lesson #8
Home Page templatesLesson #9
Linking to other pagesLesson #10
Getting a web presenceLesson #11
Building a home page of your owncoming soon
Practising skills  
Tigers Tropical Fish Worksheet
Tin Tin's Holiday Worksheet
Big Pond Hotel Worksheet
  
  
©2008 ICTGCSE.NET Last update July 2008