Internet
Textbook
CD-ROM
Telephone

2. Which of these programs processes data?

Word Processor
Spreadsheet
Database
They all do.

3. Which is the best way for a person to use a computer connected to the Internet to communicate with somebody else?

E-mail
Website
FTP
Telegram

4. Which 2 types of information should be combined to make the front page of a newspaper?

Text and Graphics
Numbers and Text
Data and Graphics
Numbers and Data

5. Which of these commands should be used to keep your work safe?

Open
Edit
Format
Save

6. You need to find out some information about King Charles the First.  Which of these are appropriate words to use when searching for         information on the Internet?

"King"
"Duck"
"King Charles" and "First"
"First"

7. A crane is controlled by four commands. For example: N3 moves three squares north, W2 two squares west, S4 four squares south and E9 nine squares east. Commands can be separated by a space e.g. N3 W2.

 

Which set of commands will move the crane along the red line from B to A?

S2 W4 N4
S2 E4 N2
S4 E4 N2
S2 N4 W4

8. Which of these is a disadvantage of having an internet connection at home?

You could download a virus
You can look at other people's websites
You can communicate by e-mail
You could search for information using a search engine

9. Which picture would you choose to add to this book to make it more attractive to adults?

 

A

B

C

D

A, The Bear
B, The Alsatians
C, The puppy
D, The Dog and the Toilet

10. A school uses a spreadsheet to record weekly drink sales at its vending machines. They sell 5 types of drink, which sell at 50p each. The spreadsheet shows the price at which they buy the cans in column H. The school uses the spreadsheet to record sales and calculate profits. 

 

	A	B	C	D	E	F	G	H	I	J	K
1		Mon	Tue	Wed	Thu	Fri	Total	Cost	Sell	Profit	Total
2							sales	price	price	per can	profit
3	Cola	23	12	19	24	19	97	£0.17	£0.50	£0.33	£32.01
4	Diet Cola	12	16	16	18	19	81	£0.16	£0.50	£0.34	£27.54
5	Orangeade	21	17	18	11	18	85	£0.18	£0.50	£0.32	£27.20
6	Lemonade	17	19	19	13	24	92	£0.18	£0.50	£0.32	£29.44
7	Cherry Cola	16	21	20	16	13	86	£0.15	£0.50	£0.35	£30.10
8
9										Weekly
10										profit	£146.29

What is the formula in cell J3? 

G3*I3
G3+I3
I3-H3
H3-I3

11.Which of the following statements is used to calculate the total profit made from each type of drink during the week?

Cost Price * Total Sales
Sell Price - Cost Price
Total Profit - Total Sales
Total Sales * Profit Per Can

12. The school uses the spreadsheet to fix prices and project profits over the school year. This is known as modelling. Which features of spreadsheet software make this possible?

You can vary the data and look at different outcomes
You can import graphics
You can format the borders to make squares
You can format numbers

13. This spreadsheet shows the cost of a range of computer equipment:

	A	B	C	D
1	Item	Quantity	Cost per unit (£)	Total cost (£)
2	Printer	3	280	840
3	Modem	2	72	144
4	Mouse	4	15	60
5	Monitor	2	130	260
6	Computer	3	750	2250
7	Scanner	1	90	90
8
9			Total
10			bill	3644

If the price of a printer changes which other cells change as a result?

C2 and D10
B2 and D2 and D10
D2 and D10 
A2 and C9

14. Which type of sensor could be used to detect if a pinball machine has tilted?

Sound
Humidity
Light
Position

15. Which of these is a suitable method for quickly finding information about a volcano?

The Internet
A Geography textbook
A Maths CD-ROM
A Biology CD-ROM

Stop taking the test now.

Do not press anything else.  

If you do, your test score may be cancelled!

Put your hand up, and wait for your teacher to take your score