1.
Lisa bought a computer that she can use for her school work, as well as for
gaming. Analyse its specifications listed below and answer the following
questions:
CPU
Intel Core i7 3.0GHz
Memory
8 GB DDR4
Storage
2 TB 5400RPM
Graphics card
GeForce RTX 2060GT
OS
Windows 10 Home
a. What is the speed of the CPU? [1]
b. What is the capacity of the RAM and the Hard Disk? [2]
c. What are the roles of memory and storage in a computer system? [2]
2. State whether the following units of storage are true or false. [5]
STATEMENT TRUE/FALSE
a. 1 bit is represented by a 0 or a 1
b. 1 kilobyte is equivalent to 1024 bits
c. 1 byte is equivalent to 8 bits
d. 1 gigabyte is equivalent to 1024 terabytes
e. 1 megabyte is equivalent to 1024 kilobytes
3. Did you know that the Internet took just four years to reach its first
50 million users?
a. Fill in the blanks using the terms given below.
Search Engine Bookmark World Wide Web
URL Home Page FTP
i. is used to find websites related to a [1]
particular interest.
ii. To download files from websites, the is used. [1]
iii. https://www.howstuffworks.com is a website that Lisa uses [1]
frequently. This can be set as a/an .
iv. Lisa wants to set the to her school’s web [1]
portal as the opening page of her browser.
v. The is a unique address specific for each [1]
website.
4. An input device is a computer hardware equipment used to help users interact with
digital devices. For each of the following tasks mention ONE appropriate input
device:
TASK INPUT DEVICE
a. To hand-draw images and animations:
b. To play computer games:
c. To verify bank cheques:
d. To update stock items at POS terminals:
e. To digitise hardcopies in document format:
5. Consider a database of a Car Rental System.
One of the tables found in the Car Rental System is the
CAR table displayed below:
CAR
Registration no. Make Model Type Price
ABC123 VW Polo Classic €25,000
QWE678 Audi A5 Saloon €35,000
ASD456 Peugeot 3008 SUV €36,500
TTT007 Audi TT Sport €48,000
a. Which is the primary key used in the CAR table? [1]
b. List ONE advantage of using a primary key in a database table. [1]
c. By which column (field) is the above table sorted? [1]
6.
1. A heater has been recently installed in an office room and is controlled
by using three main logic gates; the AND, the OR and the NOT gates. 6.
6.
a. Which logic gates are the below symbols representing? Include the [2] 6.
Boolean expression of each gate. 6.
6.
Logic Gate: AND 6.
6.
Boolean Expression: Y= A . B 6.
6.
6.
Logic Gate: OR
6.
Boolean Expression: Y=A+B 6.
6.
b. Complete the inputs and/or outputs for the logic gates below. Fill in [4] 6.
the empty boxes. 6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
6.
. Look at the spreadsheet below. Jenny is using it to calculate how much
money she spends each week on different items. W
r
B E i
C t
o e
s
t h
e
E r
a e
c
h
£ (b) w
0 h
. a
3 t
0 s
£ h
0 o
. u
8 l
0 d
£
1 t
. h
2 e
5
f
o
(a) Which cell contains the number £1.60? r
m
Select here u
l
(b) Jenny has selected a range of the spreadsheet using a mouse. This range a
is surrounded by a box like this:
b
e
?
W
r
What is the range that Jenny has selected? i
t
Select here e
(c) What are the numbers in the column labelled Quantity used for? h
Write here e
r
(d) Jenny wants to work out how much money she spends in total each week. e
(a) into which cell should the formula to calculate the total be placed?
7. Some new banks only operate on the Internet. What would be the advantages
for the customer of this type of bank ?
Write here
8. What do these acronyms stand for?
MICR Write here
EPOS Write here
PIN Write here
EFTPOS Write here
9. Ensuring security is vital when banks make use of computers. Explain why
each of the following methods are used to protect or secure our accounts.
(a) Password/PIN
Write here
(b) Encrypted
Write here
Study the pictures of ‘hole in the wall’ devices called ATM’s and then answer the
following questions …..
1. What does ATM stand for ? Write here
2. Write down 2 ways someone could carry out an illegal withdrawal of
money from one of these.
a. Write here
b. Write here
3. Suggest 2 ways these illegal withdrawals could be prevented from
happening.
Write here
Write here
4. Describe 3 ADVANTAGES for the Customer in the use of ATM’s.
a. Write here
b. Write here
c. Write here
5. What method of input is used for the user to enter their PIN number?
Write here
7. The flowchart shown below represents the program for vending
machine. According to the numbered instructions, fill in the table
below:
1: 4:
2: 5:
3: 6:
