NEW
Font size
S
M
L
XL
WorksheetsGCSE ICT U1 Topics 1-6 Revision
Total questions: 36
Worksheet time: 18mins
Name
Class
Date
1.
Give one ADVANTAGE of shopping online
a)
You cannot touch / try on the goods
b)
You sometimes have to wait a long time to receive the goods
c)
Worries about giving payment details over the internet
d)
Available 24/7
2.
Give one DISADVANTAGE of shopping online
a)
Wide range of goods
b)
It is easier to compare prices
c)
Goods may get damaged in transit
d)
Can shop 24/7
3.
Which software type would be the most suitable for completing the following task:
Creating a letter to send to parents informing them of a school Fayre
Creating a letter to send to parents informing them of a school Fayre
a)
Word
b)
DTP
c)
Word Processing
d)
Spreadsheet
4.
Which software type would be the most suitable for completing the following task:
Automatically recording the number of people entering the Fayre.
Automatically recording the number of people entering the Fayre.
a)
Control Software
b)
DTP
c)
Word Processing
d)
Spreadsheet
5.
Which software type would be the most suitable for completing the following task:
Advertising the fayre with flyers and leaflets.
Advertising the fayre with flyers and leaflets.
a)
Control Software
b)
DTP
c)
Word Processing
d)
Spreadsheet
6.
Email True or False...
You can create folders to store and organise your emails.
You can create folders to store and organise your emails.
a)
True
b)
False
7.
Email True or False...
Using the cc feature will hide all other recipients from each other
Using the cc feature will hide all other recipients from each other
a)
True
b)
False
8.
Email True or False...
You can add attachments of any file size to an email.
You can add attachments of any file size to an email.
a)
True
b)
False
9.
Email True or False...
You can add signatures to your emails to give personal contact details.
You can add signatures to your emails to give personal contact details.
a)
True
b)
False
10.
Email True or False...
You can only send emails from a laptop computer.
You can only send emails from a laptop computer.
a)
True
b)
False
11.
Decide whether the following is data, information or knowledge...
The school quiz team with 45 points had the highest points of the day and were the winners
The school quiz team with 45 points had the highest points of the day and were the winners
a)
Data
b)
Information
c)
Knowledge
12.
Decide whether the following is data, information or knowledge...
45, 44, 27, 17, 7
45, 44, 27, 17, 7
a)
Data
b)
Information
c)
Knowledge
13.
Decide whether the following is data, information or knowledge...
45 points, 44 points, 27 points, 17 points, 7 points
45 points, 44 points, 27 points, 17 points, 7 points
a)
Data
b)
Information
c)
Knowledge
14.
Decide whether the following is data, information or knowledge...
Quiz Team A consisted of Katie, Jodie, Ryan, Jamie and Tomas
Quiz Team A consisted of Katie, Jodie, Ryan, Jamie and Tomas
a)
Data
b)
Information
c)
Knowledge
15.
GIS stands for
a)
Geographical Informative SatNav
b)
Geography Innit Son
c)
Geographical In System
d)
Geographical Information System
16.
How many records?
a)
6
b)
7
c)
8
d)
46
17.
How many fields?
a)
6
b)
7
c)
8
d)
46
18.
How many fields have been encoded?
a)
0
b)
1
c)
2
d)
3
19.
Which other field could have been encoded?
a)
Stallholder name
b)
Stall ID
c)
Stall Size
d)
Dat eBooked
20.
Why do we encode data?
a)
Saves time when entering data
b)
Take up less storage space
c)
Less likely to make a mistake
d)
All of these answers
21.
What type of validation is used on Date booked?
a)
Presence check
b)
Hash total
c)
Batch total
d)
Range check
22.
Which field is the keyfield?
a)
Stall ID
b)
Year
c)
Stall Size
d)
none of the above
23.
State how many fields with a Boolean data type are shown in the database.
a)
None
b)
1
c)
2
d)
3
24.
Name the field that has been sorted into ascending order.
a)
Stall ID
b)
Stallholder name
c)
Year
d)
Date booked
25.
What is encoding?
a)
shortening a word or phrase to a code
b)
Using symbols to represent something
26.
One of the biggest differences between a database and a spreadsheet is...
a)
Databases hold data in a table
b)
Spreadsheet are used to calculate whereas databases are mainly used to organise and search
c)
Spreadsheets are used to produce reports
d)
Databases are used to calculate numbers
27.
Which of the following formulas could be used to give the Total Outgoings in cell F6?
a)
=SUM(D3:D6)
b)
=D6+D11+D17
c)
=SUM(B6:D17)
d)
=D6+D11
28.
The school need to set the ticket price to break even. Give a suitable formula for calculating the Ticket Price in cell F9.
a)
=SUM(D3:D6)
b)
=D17/F3
c)
=SUM(B6:D17)
d)
=F6/F3
29.
Spreadsheets can use absolute and relative cell referencing. Explain what absolute cell referencing is.
a)
absolute references do not change when copied or filled
b)
When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
c)
Cell references that are formatted to be fixed
d)
Cells that are protected from changes
30.
Which one of the following is NOT an electronic method of registering students
a)
Smart / Swipe Card
b)
Biometric
c)
Online System
d)
Markbook
31.
Computer gaming is a popular method of home entertainment. Which one of the following is NOT an input device used in gaming...
a)
Mouse
b)
Gamepad
c)
Microphone
d)
Monitor / TV
32.
Verification or Validation...
Drop down menu to select cinema
Drop down menu to select cinema
a)
Verification
b)
Validation
33.
Verification or Validation...
Entering the email address twice
Entering the email address twice
a)
Verification
b)
Validation
34.
Verification or Validation...
Proof reading the online form before submitting
Proof reading the online form before submitting
a)
Verification
b)
Validation
35.
Verification or Validation...
Must be a real date
Must be a real date
a)
Verification
b)
Validation
36.
Name the technique used which automatically puts names and addresses into the letter below
a)
DTP
b)
Merging Mail
c)
Mail Merge
d)
Tags
Reset
