This is the header! It has been centred
Eastbourne Technology College - ICT Faculty
Revision Notes – GCSE (Paper 1) & Key Skills
The multiple choice papers are not difficult but you DO need to know the official names of various techniques which you and I just take for granted – otherwise you might get an easy question wrong!
The Basics!
| Bold | Italic | Underline | Plain Text |
Leading to
| Bold italic | Bold underline | Italic underline |
Font size 12, font size 16, Font size 20
Times New Roman, Arial, Comic Sans MS etc
Typical questions will ask “The date of the letter is” or “The main test of the report is”
| 13/5/03 | 13/5/03 | 13/5/03 |
| Aligned left (or left justified) | Centred | Aligned Right (or right justified) |
-----------------------------------
The GCSE Paper 1 and Key Skills examination is considered by staff at Eastbourne Technology College to be relatively straight forward although it still catches students out. This is normally due to inadequate or poor revision, not listening properly in lessons, not reading the questions carefully and not checking the answers before the end of the examination!
The text above is
fully justified because the text is straight on both left and right margins.
|
Single |
1½lines |
Double |
The GCSE examination in ICT (Paper 1) is a multiple choice paper of 40 questions |
The GCSE examination in ICT (Paper 1) is a multiple choice paper of 40 questions |
The GCSE examination in ICT (Paper 1) is a multiple choice paper of 40 questions |
|
Bullets |
Numbers |
Indented |
|
1) 40 questions 2) 1 hour for the paper 3) Always check your answers when you have finished
|
40 questions 1 hour for the paper Always check your answers when you have finished
|
Tabs
Sometimes confusing. Remember tabs are often used instead of tables to display information in columns – like this.
| Name | Job Title | Salary |
| Joe Brown | Machinist | £12,000 |
| Maggie Smith | Checker | £10,000 |
| Diana Matthews | Supervisor | £18,000 |
There are three columns above, each are aligned left
| Borders are normally lines of varying width that can be put around text, images, graphics or a whole page to make them standout. |
Margins are the space left around the edge of a page. The margins in this picture are 2cm all round. To change the margins go to File, Page SetUp, Margins and take a look!
Images and Graphics are the names given to pictures, logos or diagrams that might appear in a document.
You can always expect to see questions about images or graphics that are in, or could be put into, a document.
Here are a few tips:
1) A suitable source for an IT image would be a clipart CD-Rom, a picture taken with a digital camera or a picture scanned from a magazine or other paper source. BUT BE CAREFUL! If the questions was:
a.
A suitable IT source for an image would be
1. Painting
The answer could ONLY be 4. Because
the other answers DO NOT say a scanner has been used!
2)
Images and Graphics can have changes made to
them. Here are the changes you might be asked to identify:
Mail Merge is
when data from a data source such as a table in a Word Processing document, a
database or spreadsheet is merged into a document. Good examples of mail merge
are the same letter being sent to hundreds of customers of a mail order company
or payslips being created for employees.
Spreadsheet
questions always look harder than they really are. When asked to identify the
correct formula look at the spreadsheet you have been given and try to work out
the answer yourself BEFORE looking at the possible answers and risking a guess!
If you are still stuck look at the column heading for the formula. If the
formula is to calculate ‘Total Price’ or ‘Total Units’ the chances are it will
be an addition or multiplication. Only then look at the possible answers and
start to cross out the ones that can’t be correct. THE BASICS Formula Description Answer =A1+B1 Add the
contents of cell A1 and B1 15 =A1-B1 Subtracts
the contents of cells B1 from A1 5 =A1*B1 Multiplies
the contents of cell A1 with B1 50 =A1/B1 Divides the
contents of cell B1 with cell A1 2 =Sum(A1:A9) Add together
the contents of cells A1 to A9 50
=Average(A1:A9) Calculates
the average of all the cells in A1 to A9 5.5555 =Max(A1:A9) Finds the
highest number in the cells A1 to A9 10 =Min(A1:A9) Finds the
lowest number in the cell A1 to A9 2
Typical
questions;
1)
The format of the description Blue Biros
is
2)
The format of the contents of cell B7
is
3)
The format of the cell F6 is
4)
Which row contains the spreadsheet column
heading? Questions
about graphs will be about the data, you may be asked to identify a rising or
falling trend or a particular piece of data. The other type
of question is on the format of the chart. Remember the X axis is along the
bottom, the Y up the side!. A legend is a label somewhere on the chart. This
chart does not need one but I have left it on anyway (Series 1) Like
spreadsheets database questions look harder than they really are. As long as you
understand the basics common sense and a clear head will ensure you answer the
questions correctly. Ascending means
going up a list I.E. 1, 2,3,4,5,6,7,8 Descending means
going down a list I.E. 8,7,6,5,4,3,2,1 Sounds nasty but
it’s not really. If you are asked to identify the correct search criterion all
you need to do is think logically and understand the criteria below; Refer to
the database above when looking at the examples. Symbol Description Example
Question Answer < Less than Students
with scores of less than 45 in Test 1 Test 1 <50 > Greater than Students
with scores of more than 46 in Test 2 Test 2 >46 <= Less than or
equal to Students
with scores less than or equal to 34 in Test 3 Test 3 <=34 AND Finds
records with stated values in more than one field Students
with the score of 78 in Test 1 and 67 in Test 2 Test 1 = 78
AND Test 2 =67 OR Finds
records which can have more than one value in the same field Students
with a score of 38 or 34 in Test 3 Test 3 = 38
OR 34 Other Tips In no particular
order the following is worth remembering;
1)
To connect to the Internet and/or send an
e-mail you need a modem and telephone line
2)
To search the Internet use a search engine
3)
To find details of website used more than once
use a bookmark or favourite
4)
To restrict access to a computer or a
particular file use a password
5)
All personal information held by organisations
should be kept confidential
6)
To reduce the risk of eye strain take
regular breaks
7)
To check the accuracy of data always
proof read
8)
To change a word that has occurred many times
in a document, for example tennis to TENNIS use find and replace
Best of luck! (This is
written in the footer, it has been aligned left)
2. Magazine
3. Prospectus
4. Clip art CD-ROM
Reduced or Enlarged
Cropped
Rotated
Copied
Mail Merge
SPREADSHEETS
FORMATTING
Text
Number
Currency
5
FORMULAS
Graphs
Databases
The
Basics
Search Criterion!