WorksheetsYear 9 After Easter big retrieval - power 5
Total questions: 129
Worksheet time: 1hrs 7mins
A loop that does an instruction for a certain number of times is known as:
a (a) controlled loop, or a 'for loop'.
playerName = (a) ("Enter your name")
print("Welcome to the game " + playerName)
The below above allows a player to enter their name and then greets them. What is the missing word?
for counter in range(10):
print(counter)
What will be the final line output by this program?
(Type your answer as a number)
(a)
laurions = ["Altius", "Citius", "Fortius"]
laurions. (a) ("Magnus")
fill in the blanks to make it so that the code ADDS Magnus to the list of laurions.
code:
___ counter in range(2):
print(counter)
What word is missing from the code above. The program outputs the numbers 0 and 1.
and
for
while
if
nor
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
playerName = input("Enter your name")
chosenLaurion = input("Who would you like to choose as your starter Laurion")
How many variables are there in the above code?
0
1
2
3
4
What does the flowchart to the left represent?
Selection
Count Controlled Iteration
Condition Controlled Iteration
Hacking
Decomposition
spice_girls = ["Emma", "Geri", "Mel B", "Mel C", "Victoria"]
which line of code would output the word Geri if added to the program above.
print(spice_girls[1])
print(spicegirls[0])
print(Spice_girls[1])
pint(spice_girls[1])
Count-controlled iteration in python uses:
for loops
while loops
if statements
print statements
condition controlled iteration in python uses:
for loops
while loops
if statements
print statements
which can hold multiple pieces of data?
a variable
a list
dinner_options = ["pizza", "pasta", "stir-fry", "curry", "fish and chips", "fajitas"]
import random
randomNumber = random.randint(0,3)
print(dinner_options[randonNumber]
Kieran is indecisive and has created a python program to help him choose what to have for dinner. There is an error with his program. Which options will the program never choose?
pizza
stir-fry
curry
fish and chips
fajitas
A loop that keeps repeating steps until something happens is called a (a) controlled loop.
import random
letters = ["a","b","c","d","e","f"]
chosenLetter = letters(random.randint(0,5))
What is the name of the variable in the code above
chosenLetter
letters
random
randint
what peice of syntax always comes at the end of a line declaring a loop in python?
?
*
:
!
>
count-controlled iteration can also be referred to as
(a) loops
(a) counter in range(5):
print(counter)
fill in the blank to make the above code print the numbers 0-4
what is python?
a game
a coding language
a program
a browser
machine code
newName = input("Enter a name")
characterNames = ["Ada", "Alan", "Charles", "Katherine"]
characterNames.append(newName)
What is the name of the list in this code?
newName
characterNames
input()
append()
=
characterNames = ["Ada", "Alan", "Charles", "Katherine"]
characterNames. (a) ("Ada")
What word would I add in the blanks to take Ada out of the list called characterNames
Create a program that it outputs "Hello World":
(a) (b) (c) (d)
userAge = (a) ("How old are you?")
What is printed by the following lines of code?
eggs
bread
2
sugar
How many items can a list contain? Tick all that apply.
0
1
2
3
10
What is the maximum amount of items you can store in a variable?
0
1
2
3
What would be the output of this code?
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
print(laurions)
["Altius", "Citius", "Fortius", "Magnus"]
Altius , Citius, Fortius , Magnus
laurions
"Altius", "Citius", "Fortius", "Magnus"
Error
What would be the output of this code?
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
print(laurions[2])
(a)
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
chosenLaurion = laurions[1]
What is the variable in this code?
(a)
What is the name for the data structure in python which can hold more than one item?
(a)
What is the output of the code below?
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
laurions.clear()
laurions.append("magnus")
laurions.append("citius")
print(laurions[1])
(a)
firstNames = ["Ada", "Alan", "Charles"]
surnames = ["Lovelace", "Turing", "Babbage"]
subject = "Computer Science"
What is the name of the variable in the code above?
(a)
import random
randomNumber = random.randint(0,4)
letters = ["a","b","c","d","e"]
print(letters[randomNumber])
What is the name of the variable in the code above?
(a)
In an array, what is the first numbered position in which data can be stored?
Position 0
Position 1
Which of these in an advantage of a database?
Select all that apply
It’s easy to add to or amend existing records.
They're written in python.
Multiple people can access a database at the same time.
Security can be better than paper files by using a password.
They can be hacked.
I have created a database of students. 'name' is likely to be what?
A table
A field
A record
A DBMS
I have created a database of pets who are up for adoption. Snowy is a white labrador, all of his data can be grouped together. This would be classed as a ... ?
A table
A field
A record
A DBMS
the name of a category in a database, such as 'name', 'age', 'gender' is a (a)
DBMS stands for what?
Database Management System
Double Base Mega Slam
Database Money System
Database Media Storage
Which of these is a DISADVANTAGE of a database?
It can store more than one piece of data.
It can be hacked.
It relies on paper.
It cannot be moved from place to place.
Tables are ususally named starting with which three letter abbreviation?
(a)
Which of these is true of a primary key?
It must be unique
It must start with the letter a.
It must start with the number 0.
It must be only 1 character long.
A database can hold more than 1 Million pieces of data?
True
False
Databases make it easier to find and use data from big data sets.
False
True
In a database, each record will usually have data in multiple fields?
False
True
There will always be more records than fields in a database.
True
False
subjects = ["Computing", "Drama", "English", "Maths", "Science", "Spanish"]
What is subjects [2]
Computing
English
Science
Drama
Index Error
What would be the output of the code below:
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
print(laurions[3] + " beat " + laurions[2])
Error
Fortius beat Citius
Magnus beat Fortius
Magnus beat Citius
Fortius beat Magnus
Which of these is an appropriate name for a list containing:
Apples, Oranges, Pears, Bananas
Fruit
fruit
x
list1
What is python
Programming Language
Browser
Coding Method
Computer Game
name = input("What is your name?"
print("Hello" + name")
If I inputted Elsa into the program above, what would the output be?
Hello Elsa
Elsa
HelloElsa
Error
Let it go!
A loop that does an instruction for a certain number of times is known as:
a (a) controlled loop, or a 'for loop'.
playerName = (a) ("Enter your name")
print("Welcome to the game " + playerName)
The below above allows a player to enter their name and then greets them. What is the missing word?
for counter in range(10):
print(counter)
What will be the final line output by this program?
(Type your answer as a number)
(a)
laurions = ["Altius", "Citius", "Fortius"]
laurions. (a) ("Magnus")
fill in the blanks to make it so that the code ADDS Magnus to the list of laurions.
code:
___ counter in range(2):
print(counter)
What word is missing from the code above. The program outputs the numbers 0 and 1.
and
for
while
if
nor
laurions = ["Altius", "Citius", "Fortius", "Magnus"]
playerName = input("Enter your name")
chosenLaurion = input("Who would you like to choose as your starter Laurion")
How many variables are there in the above code?
0
1
2
3
4
What does the flowchart to the left represent?
Selection
Count Controlled Iteration
Condition Controlled Iteration
Hacking
Decomposition
spice_girls = ["Emma", "Geri", "Mel B", "Mel C", "Victoria"]
which line of code would output the word Geri if added to the program above.
print(spice_girls[1])
print(spicegirls[0])
print(Spice_girls[1])
pint(spice_girls[1])
Count-controlled iteration in python uses:
for loops
while loops
if statements
print statements
condition controlled iteration in python uses:
for loops
while loops
if statements
print statements
which can hold multiple pieces of data?
a variable
a list
dinner_options = ["pizza", "pasta", "stir-fry", "curry", "fish and chips", "fajitas"]
import random
randomNumber = random.randint(0,3)
print(dinner_options[randonNumber]
Kieran is indecisive and has created a python program to help him choose what to have for dinner. There is an error with his program. Which options will the program never choose?
pizza
stir-fry
curry
fish and chips
fajitas
Create a statement which adds "Citius" to a list called laurions:
(a) (b) (c) (d) "Citius" (e)
Who is that
Santa
Elf
A Snowflake
Rudolph the Red-Nosed Reindeer
A normal Reindeer
2. In the song The 12 days of Christmas, what gift was given on the fourth day?
French Hens
Golden Rings
Calling Birds
4. How do you say "Merry Christmas" in Spanish?
Sheng Dan Kuai Le
Feliz Navidad
Maligayang Pasko
On which continent is the Sahara desert?
Africa
Asia
North Africa
South Africa
Which planet is the smallest?
Mars
Saturn
Mercury
Venus
How many zeroes in ten million?
5
6
7
8
John, Paul, George and Ringo were part of which band?
The Rolling Stones
Bee Gees
The Monkees
The Beatles
Select the animal that can't jump:
Kangaroo
Elephant
Dog
Cat
What is the sweet food made by bees?
Wax
Pollen
Nectar
Honey
What’s the name of the toy cowboy in Toy Story?
Woody
Buzz
Andy
Sid
What is the name of the fairy in Peter Pan?
Wendy
Tinkerbell
Lily
Jane
What is the largest ocean on Earth?
The Atlantic.
The Artic.
The Pacific.
The Indian.
Who is the premier league footballer with the most goals?
Alan Shearer
Teddy Sheringham
Sergio Aguero
Thierry Henry
What Is The Hottest Colour Of A Fire?
Light Blue
Red
Green
Orange
Which Country Has Cities Such As Sydney, Canberra, Perth And Melbourne?
New Zealand
Australia
Lebanon
Oman
What Is The Gestation Period Of A Rhinoceros On Average?
16 months
8 months
21 months
3.5 years
What Is 12 x 12?
144
156
189
211
Which Country Has The Capital Lima?
Peru
Venezuela
Morocco
Australia
What sport is this?
mountain biking
skiing
surfing
sky diving
Who is this?
Blue Girl
Elsa
Frozen
Anna
What is lava?
hot rock
liquid fire
cold fire
hot metal
(a) are involved with everything we do online. From social networking to the BBC website, (b) are crucial tools used to store large amounts of (c) in an (d) way.
Humans using methods trick or manipulate other humans into handing over information is known as (a) .
(a) is an attack that involves an attacker watching the victim while they provide sensitive information such as their pin number.
Select the attack that requires a lot of processing power in order to flood a device, service or network with requests.
Select the attacks that exploit humans in order to gain access to a system (and require little to no coding knowledge).
a (a) of (b) attack (DoS) is is done by (c) the targeted machine or website with lots of (d) in an attempt to overload the (e) .
Attempting to use a large volume of password attempts to access a system is known as a (a) .
(a) are rarely motivated by theft, but are more interested in creating disruption to cause public embarrassment or to promote a cause.
Hacking is gaining (a) access to or control of a (b) system.
(a) is raw facts and figures. (b) is created when that (c) has been processed and becomes meaningful.
What do companies convert data into?
Awards
Data
Points
Information
What is the definition of a computer virus?
Malicious software that self-replicates
Malicious software that disguises itself as something else
Malicious software that uses network bandwidth to deliberately disrupt the speed of the network
Malicious software that monitors every keystroke the user makes
Which of the following statements best describes a "worm"?
Self replicates and encrypts files to make them inaccessible
Self replicates, does not attach to files, but is designed to take up system resources to slow down the network or computer
Attaches to files and is designed to take up system resources to slow down the network or computer. Does not self replicate.
Malicious software that monitors every keystroke the user makes
Which of the following is defined as: 'A program designed to breach the security of a computer system while ostensibly performing some innocuous function'
Ransomware
Virus
Trojan Horse
Worm
Spyware
Which of the following may result in a malware infection?
Opening an email attachment
Downloading a file from a website
Clicking on an infected link
Installing a firewall
Increasing user authentication protocols
Which of the following are the signs of a virus attack?
The computer runs slower than normal.
There is a change in file size.
The computer restarts on its own.
You receive a suspicious email.
The (a) type of malware collects personal information and sends it to a third party.
Organising Data Retrieval Question:
What type of data can a Binary Search be performed on?
Ordered
Unordered
Both
Neither
Organising Data Retrieval:
What is the 3 letter acronym used for the language that searches and amends databases?
(clue: S-- )
(a)
Python Retrieval:
A loop that repeats steps a certain number of times is called a (a) controlled loop.
Python Retrieval:
Create a program that it outputs "Hello World":
(a) (b) (c) (d)
A (a) is an attack in which the victim is asked in an app or social media post to combine a few pieces of information or complete a short quiz to produce a name.
If you receive an email with a suspicious link, it is likely what type of attack?
What type of attack involves inputting code into a database in order to illegally read private data from that database?
Clue: Think back to the language used for reading and writing from databases
Python Retrieval:
In programming, what is iteration?
The repetition of steps within a program
The order in which instructions are carried out
A decision point in a program
Testing a program to make sure it works
Python Retrieval:
Which of the following symbols is used in Python for variable assignment
=
!=
==
>=
A (a) checks incoming and outgoing network traffic.
It scans the data to make sure it doesn’t contain anything malicious and that it follows the rules set by the network.
(a) is software that (b) any file that is able to execute (c) . The anti-malware will have a list of (d) of sequences of (e) that they are aware are malicious.
(a) refers to software that automatically checks for available (b) for the (c) you have on your (d) .
Cyber Security In 2022:
2% of breaches featured (a) , 28% involved malware, and 32–33% included (b) .
Network security provision is based on (a) . Often, companies will compare the (b) of an attack against the (c) of it happening.
This helps organisations plan how best to spend their (d) s.
Select all the types of malware
Worms
Trojans
Ransomware
Virus
Blagging
Match the cyber attacks with the best defense against them.
Brute Force Attacks
Two factor authentication
Viruses
Anti-Malware software
Phishing
Educating employees
Denial of Service attack
Firewall
