Font size
WorksheetsRevision Year 8
Total questions: 64
Worksheet time: 34mins
formulas in a spreadsheet starts with
#
$
=
fx
=AVERAGE(A1:A10)
=MEAN(A1:A10)
AVERAGE(A1:A10)
a small program to automate task
macro
average
micro
ascending is the method
order from Z to A
order from A to Z
order from 10 to 1
which of this is not a build in function in Excel
average
max
min
$
Which is not Equats operator in Excel
=
= =
<>
<
Define database term.
A storage
An organized collection of data
An application software
A computer system
Database is an organized ____ ____ ____.
(a)
A ______ database stores its data in one table.
Microsoft Access
Microsoft Excel
Flat-file
Relational
A ______ database stores its data in more than one linked table.
Microsoft Access
Microsoft Excel
Flat-file
Relational
Network is a ....
Collection of computers and mobile devices that connect together via communication devices.
Collection of computers and mobile devices that connect together via communication devices and transmission media.
Collection of computers and mobile devices that connect together via transmission media.
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
The best data type to choose for a postcode would be
Number
Text
Date/Time
Currency
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
This type of data can store two types of numbers a whole numbers and a decimal numbers?
Alphanumeric
Numeric
Currency
Logical Boolean
This data types stores data in a date or time format?
Alphanumeric
Logical Boolean
Numeric
Date/time
The sending of fraudulent emails appearing to come from legitimate companies in order to steal passwords is known as ...
Phishing
Pharming
Smishing
Vishing
Redirecting users to a bogus website that looks authentic is known as ...
Phishing
Pharming
Smishing
Vishing
Security attack where user is tricked into downloading a virus on to a cell phone from a text message is known as ...
Phishing
Pharming
Smishing
Vishing
What does a computer virus do? Choose the 3 sentences.
It infects a computer
Has the ability to replicate itself
Stoles user name and password
Encoding of data
Attaches itself to files
Using the image as a clue - how would you prevent this type of Safety issue?
Use covered cable runs
Organise wires
One plug per socket
Use wireless
Do not take drinks
Complete the sentence.
The action of sending text messages to fraudulently obtain another person's bank details is called ...
Pharming
Phishing
Spam
Vishing
Smishing
Complete the sentence.
........ is type of malware that prevents or limits users from accessing their system, either by locking the system's screen or by locking users' files unless a ransom is paid.
Ransomware
Adware
Malicious bots
Spyware
Trojan horse
What is a digital footprint
A print of a digital photograph showing a footprint
Information about yourself that you post online for anyone to obtain
Your assigned page in an online social networking site
A drawing of your own footprint using digital graphics software
A home computer network is sometimes also called a…
LAN
PAN
Identify the image shown above..
Switch
Network Cable
Network Interface Card
Hub
a type of computer network that connects a computer in a relatively small area like in an office building, school or home
Local Area Network
Wide Area Network
Wireless Local Area Network
Metropolitan Area Network
The picture attached is a
Switch Modem
Router Modem
Wireless Modem
Basic Modem
The image attached represents
Router
Nonmodem
Modem
Switch
What is Networking?
Networking is consists of two or more computers.
Networking is a business that you need if you want to be rich.
Networking is all about business.
Which of the following is a command to have a message appear on the screen?
write
msg
input
Pick the Python command used to make the user type in some data (input the data)
get
input
int
float
Which of the following Python command can be used for WHOLE numbers?
input
int
float
What would be printed by the command
print('12-5')
12-5
'12-5'
7
'7'
Which of the operators do we use if we want at least one condition to be true?
and
or
else
not
print(Hello world!)
Which of the following is used in Python to give a value to a variable
:=
==
=
What is the result of the following operation?
print(1 + 4*3)
11
12
13
15
What is the value(?) if theoutput is 12
x = 5
y = ?
print (x+y)
"7"
=7
7
/7
What is a variable?
A named block of memory, used whilst a program is running to store data.
A named block of memory, where the results of a program get stored once it has been closed down.
A block of computer memory that gets permanently named after the variable, even when the program is closed down.
A process within the cpu, that is given a specific name by the program, so it is easier to identify.
Which one is NOT a valid variable name?
my_var
myvar
_myvar
my var
What is the correct file extension for Python files?
.py
.pt
.pyt
.pyth
How do you create a variable with the numeric value 5?
Both are correct
x=5
x=int(5)
What will be the output of this code?
x = “2”
y = “4”
z = int(x) + int(y)
print(z)
6
6.0
both are correct
The input function prompts the user for input, and returns what they enter as a string
TRUE
FALSE
Below is the code for printing student's name. What is the best answer to put in (?)
name = student
print ( ? )
text
name
student
What will be the output when a user enters WILLIAM
name = input("Enter your name: ")
print("Hello, " + name)
Hello name
Hello William
Helloname
Hello WILLIAM
