Reference Sheets
A guide to using computers safely
The hazards to your health
Sitting correctly at the computer
The hazards to the equipment
Organising your documents
Creating a new folder (directory)
Taking a screen shot (screen print)
Using the Internet and exploring the World
Wide Web
What is the Internet?
Using the World Wide Web
Accessing a web page using its web address
Useful web browser buttons
Finding information – using the world wide
library of information
Having difficulty in finding what you want?
Refine your search
Printing text and images
Copying text and images
Saving images
Words of caution
Email
Email addresses
Setting up a web-based email account
Test your new email address
Word processing
What is a word processor?
Creating a new document in Word
Entering text
Saving your work
Fonts
Line spacing
Find and Replace
Deleting text
Inserting text
Moving text (Cut, Copy and Paste)
Text alignment Indenting text
Numbered and bullet lists
Changing margin settings
Printing
Creating a table
Inserting rows in a table
Adding and removing borders to cells
Drop capitals
Creating columns of text
Page breaks and column breaks
Working with images
Adding an image from Clip Art
Positioning and resizing theimage in
your document
Copying images
Headers and footers
Spreadsheets
What is a spreadsheet?
Creating a new spreadsheet in Excel
Saving your work
Inserting and editing data
Formatting text
Formatting columns and rows
Displaying numbers in integer format (no
decimal places)
Displaying numbers to two decimal places
Displaying pounds and pence
Displaying percentages
Wrapping text
Merging cells in a spreadsheet
Adding borders to cells
Formulae
Adding a range of cells
Copying formulae
The Function Wizard
Headers and footers
Printing a spreadsheet
Printing out formulae
Sorting data
Creating graphs and charts
Moving a chart on a worksheet
Data points and data series
Chart types
Changing a chart type
Changing chart content
Changing a chart’s size
Changing a chart’s appearance
Chart title
Data labels
Chart scale
Chart colours
What is the best type of graph to use?
Databases
What is a database?
Parts of a database
Database structure
Database creation
Browsing records
Sorting records
Creating queries
Showing and hiding fields in a query
Inserting and deleting records
Information and Communication Technology:
Part A, Practice Tasks
Sample End Assessment
Click on picture to
close this window
