WorksheetsYear 10 Benchmark
Total questions: 131
Worksheet time: 2hrs 30mins
Name
Class
Date
1.
Which Computer Scientist was involved with the creation of Logic Gates?
a)
George Boole
b)
Alan Turing
c)
Charles Babbage
d)
Tim Berners Lee
2.
Which Computer Scientist was involved with breaking the Enigma Machine in World War II?
a)
George Boole
b)
Charles Babbage
c)
Tim Berners Lee
d)
Alan Turing
3.
Which Computer Scientist is credited with designing the first computer, in order to help with ship navigation?
a)
Alan Turing
b)
Charles Babbage
c)
George Boole
d)
Tim Berners Lee
4.
What does HTML stand for?
a)
Hypertext Medium Language
b)
Hippo Tries Making Licorice
c)
Hypertext Markup Lingo
d)
Hypertext Markup Language
5.
Choose the correct tag for the largest heading:
a)
h6
b)
heading
c)
head
d)
h1
6.
http://www.google.com is an example of a what?
a)
URL
b)
IP address
c)
Browser
d)
Application
7.
Google Chrome is an example of a what?
a)
URL
b)
Web browser
c)
IP address
d)
metal
8.
Boolean commands include:
a)
social media
b)
works cited page
c)
and, or, and not
d)
authoritative authors
9.
Using the term, "Not" excludes results.
a)
True
b)
False
10.
Phrases are a combination of two or more words that must be found in the documents you are searching for in the EXACT order shown.
a)
True
b)
False
11.
What does an insertion sort do?
a)
Separates a list of data into different collections of data which are sorted and gathered back into a list
b)
Goes through a list of data a number of times and compares two items that are side by side to each other to see which is out of order
c)
Goes through a list, comparing two items that are side by side, and continues to move one value until it is in the correct place.
12.
Which of the following is an advantage of a insertion sort when compared with a bubble sort?
a)
It is quicker than a bubble sort algorithm
b)
It is simpler than a bubble sort algorithm
c)
There is no advantage.
13.
How many passes will an insertion sort go through?
a)
Only one pass
b)
Two passes
c)
Several passes - until the data is fully ordered
14.
Which type of sort algorithm is this?
a)
Bubble
b)
Merge
c)
Insertion
15.
Which type of search algorithm is this?
a)
Binary
b)
Linear
16.
Which type of search algorithm is this?
a)
Binary
b)
Linear
17.
What is Abstraction?
a)
•– the use of computers to solve problems.
b)
representing 'real world' problems in a computer using variables and symbols and removing unnecessary elements from the problem
c)
•breaking down a large problem into smaller sub-problems.
d)
•identifying the steps involved in solving a problem.
18.
'The worst case scenario is you have to check all the values' is a disadvantage for a
a)
Linear Search
b)
Binary Search
19.
What color are the "looks" blocks that allow your sprite to say something?
a)
purple
b)
green
c)
red
d)
yellow
20.
What do you need to have in order for your code to function?
a)
Event controller (green flag)
b)
Sprite that says "Good Job"
c)
Costume change
d)
Math problem
21.
The "forever" block is found in which of the following block types?
a)
sound
b)
data
c)
events
d)
control
22.
a)
0
b)
9
c)
10
d)
11
23.
What does this code accomplish?
a)
Make the character spin
b)
Make the ball bounce
c)
Start the game
d)
Add a sprite
24.
These are all part of which category of blocks?
a)
Motion
b)
Looks
c)
Events
d)
Controls
25.
These are all part of which category of blocks?
a)
Motion
b)
Looks
c)
Events
d)
Controls
26.
If I only want my sprite to travel forward and backwards, what rotation style would I use?
a)
don't rotate
b)
all around
c)
forward-backward
d)
left-right
27.
These are all part of which category of blocks?
a)
Motion
b)
Looks
c)
Events
d)
Control
28.
Which command lets the sprites walk on the screen?
a)
Walk
b)
Run
c)
Move
d)
GO!
29.
Will sprite move from his position after this code ?
a)
Yes
b)
No
30.
The y coordinate is ...
a)
Up and Down
b)
Left and Right
31.
What is a loop?
a)
Starting the program
b)
Ending the program
c)
Allows something to be repeated
d)
Programs running
32.
What would happen to a sprite if we ran this command?
a)
Go Up
b)
Go Down
c)
Go Left
d)
Go Right
33.
What part of a sprite is changed to create the illusion of animation?
a)
costume
b)
location
c)
color
d)
direction
34.
Which block is used to animate a sprite?
a)
next costume
b)
move steps
c)
switch backdrop to
d)
turn degrees
35.
What button do you press to compile (run) your program so that it runs in the shell?
a)
F3
b)
F5
c)
F7
d)
F9
36.
What function is used to let the user answer a question?
a)
Open
b)
Print
c)
Answer
d)
Input
37.
What does an IF statement do?
a)
Closes the program
b)
Makes a decision
c)
Asks a question
38.
Which Python statement will check to see if a is greater than b?
a)
if a > b:
b)
if (a > b)
c)
if a is greater than b
d)
if a >= b:
39.
What will be the output?
name = 'Dave'
print (name)
name = 'Dave'
print (name)
a)
Dave
b)
'Dave'
c)
name
d)
(name)
40.
Which of the following is not a string?
a)
new_var = "True"
b)
new_var = "3123"
c)
new_var = "3.123"
d)
new_var = False
41.
What symbol is used in python to assign values to a variable?
a)
equals =
b)
plus +
c)
forward slash /
d)
asterisk *
42.
What symbol is used in python to assign values to a variable?
a)
equals =
b)
plus +
c)
forward slash /
d)
asterisk *
43.
In python the ' BOOLEAN data type' can be defined as...?
a)
holds alphanumerical data
b)
holds whole numbers
c)
holds a number with a decimal point
d)
holds either true or false
44.
What data type would be used for storing someone's telephone numbers?
a)
Float (using a decimal point)
b)
Integer (just whole numbers)
c)
String (alphanumerical data)
45.
What best defines an IF statement in python?
a)
Is an embedded string with a variable
b)
An IF statement checks to see if a statement is true or false and then does one of two things depending on the result.
46.
Which Data Type represents text?
a)
Boolean
b)
Integer
c)
String
d)
Float
47.
Consider the loop control structure in programming. Which term describes a loop that continues repeating without a terminating (ending) condition?
a)
Conditional Loop
b)
Unlimited Loop
c)
Sequence Loop
d)
Infinite Loop
48.
Which Data Type represents a whole number?
a)
String
b)
Float
c)
Boolean
d)
Integer
49.
Syntax means:
a)
Grammar/Language of the program
b)
Meaning
c)
Income Tax
50.
What is the function of the code:amount = int(input("Enter a conversion into pounds:))currency = input ("press 1 for indian rupees, 2 for Chinese yuan or 0 to exit:")
a)
To find the total amount of currency altogether
b)
To calculate and convert the exchange rates.
c)
To calculate GBP
d)
Not a code
51.
Which symbol do we use if we want to add a comment to our code?
a)
@
b)
#
c)
*
d)
&
52.
It is like a box where we store values.
a)
Syntax
b)
Variable
c)
Code
d)
Program
53.
A computer network is?
a)
a collection of information
b)
A group of connected computers
c)
a collection of nets
d)
something that works
54.
The Internet is the largest example of a LAN
a)
True
b)
False
55.
Which of these covers the largest area?
a)
LAN
b)
PAN
c)
WAN
d)
MAN
56.
Which of these covers the smallest area?
a)
MAN
b)
LAN
c)
VPN
d)
PAN
57.
What cable is this?
a)
Ethernet Cable
b)
Coaxial Cable
c)
CATV Connection
d)
BluTooth Connection
58.
What does "LAN" stand for?
a)
Local Area Network
b)
Land Array Network
c)
Local Array Network
d)
Lets Apply Now
59.
What is this usually the sign for?
a)
Coaxial Connection
b)
Wired Connection
c)
Wi-Fi Connection
d)
BluTooth Connection
60.
What software is able to block unwanted connections to the network?
a)
Firewall
b)
Snowywall
c)
Rainwall
d)
Flamewall
61.
A local library would use a
a)
LAN
b)
WAN
62.
A network topology is
a)
the shape of the network
b)
a WAN
c)
A kind of top
d)
A link to the network
63.
This topology is a
a)
RING
b)
BUS
c)
STAR
d)
MESH
64.
This topology is a
a)
RING
b)
STAR
c)
MESH
d)
BUS
65.
Transmission signals can be disrupted by interference referred to as ____.
a)
Noise
b)
intereference
c)
disruptions
66.
This topology is a.....
a)
STAR
b)
RING
c)
BUS
d)
FULLY Connected
67.
This connects two similar networks.
a)
HUB
b)
Bridge
c)
Gateway
d)
Repeater
68.
A unique number assigned to a network interface card when it is manufactured.
a)
OP Address
b)
Mac Address
c)
IP Address
d)
IM Address
69.
A series of number used to identify a network device.
a)
IP Address
b)
IM Address
c)
MAC Address
d)
OP Address
70.
Connections are faster and more secure for this network
a)
Wired
b)
Wireless
c)
Ring
d)
Mesh
71.
A person who secretly gains access to a computer in order to gain information or cause damage.
a)
Hackers
b)
Computer Professionals
c)
Internet Trolls
72.
A part of a computer system or network that is designed to block unauthorized access while permitting outward communication.
a)
Firewall
b)
Antivirus
c)
Brickwall
d)
Firefox
73.
Network Logs allow you to do what?
a)
Maintain a log of who is logging onto your network
b)
Keep track of internet usage
c)
Network password changes
74.
What is Phishing?
a)
When you take your pole and worms and try to catch some fishies.
b)
Using email to fish for private information online.
c)
What cats do for dinner
d)
Sending a text message to fish for dates.
75.
What is your digital footprint?
a)
A scanned image of your foot
b)
A photograph of your shoe
c)
All the information online about a person, either posted by that person or others
d)
Having a blog, facebook or twitter page
76.
What information should you NOT share online?
a)
Your first and last name
b)
Your birthday
c)
The name of your school or city
d)
All of the above
77.
True or False?
Companies know what YouTube videos you watch.
Companies know what YouTube videos you watch.
a)
True
b)
False
78.
Which of the following is a good password?
a)
123456789 is a good password
b)
HsDpassword* is a good password
c)
Be@rs492 is a good password
79.
What should you have in your password?
a)
A. you should have letters, numbers, and symbols in your password
b)
Capitals, lower case, numbers, and symbols in your password
c)
You should have letters and numbers in your password
80.
You receive an email with an attachment that says 'Winner' but you don't remember entering any competition. What do you do?
a)
Reply to the message asking them to stop sending you mail.
b)
Open the attachment, you've won something!
c)
Delete the email without reading it.
d)
Forward the email to a friend, it will be funny to trick them too.
81.
It allows your program to make correct decisions and perform right actions
a)
Decision Statement
b)
Conditional Statement
c)
Agreement
d)
True or False Statement
82.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
83.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
84.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
85.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
86.
The intersection of a row and a column
a)
Cell reference
b)
Cell range
c)
Cell
d)
Active cell
87.
Text, symbols, dates, or numbers not used in a calculation
a)
Value
b)
Label
c)
Function
d)
Formula
88.
A number that is entered into a spreadsheet and used for calculations
a)
Value
b)
Label
c)
Function
d)
Formula
89.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
90.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
91.
Multiple pages in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
92.
Highlighting items within a spreadsheet is called selecting.
a)
True
b)
False
93.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
94.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
95.
Sum, average, count, maximum value, and minimum value are examples of what?
a)
a. Formulas
b)
b. Calculations
c)
c. Functions
d)
d. Spreadsheet data
96.
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
a)
a. Formulas
b)
b. Conditional formatting
c)
c. Functions
d)
d. Spreadsheet data
97.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
98.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d. Average
99.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
100.
What is the purpose of *?
a)
Selects ALL fields from the table
b)
Selects only the first field in the table
c)
Selects the last field in the table
d)
Shows only the first row in the table
101.
Return only the customers who have ER anywhere in their last name.
a)
last_name LIKE "%er%"
b)
last_name = "%er"
c)
last_name = "%er%"
d)
last_name LIKE "%er"
102.
To find the total dollar value of sales, use which?
a)
SUM
b)
COUNT
c)
MAX
d)
MIN
103.
AVG, COUNT, MAX, MIN and SUM are known as what?
a)
Aggregate functions
b)
Wildcard filters
c)
Subqueries
d)
Calculated field
104.
What is the correct order of clauses?
a)
SELECT, FROM, ORDER BY, WHERE
b)
SELECT, FROM, WHERE, ORDER BY
c)
SELECT, WHERE, FROM, ORDER BY
d)
WHERE, FROM, SELECT, ORDER BY
105.
Use what to separate multiple table names in the FROM clause?
a)
commas
b)
periods
c)
spaces
d)
semicolons
106.
SELECT MAX(price)
FROM PRODUCT
will return how many rows?
FROM PRODUCT
will return how many rows?
a)
1
b)
0
c)
2
d)
As many rows that are in the table
107.
Which word allows you to add more than one filter to a SQL query?
a)
AND
b)
BETWEEN
c)
LIKE
d)
EQUALS
108.
Write a code for the following: Return all romances that have an imdb_rating over 6.
a)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;
b)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;
c)
SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;
d)
SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;
109.
Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.
a)
SELECT * FROM movies WHERE name LIKE ‘day’;
b)
RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';
c)
SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';
d)
SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;
110.
Return all dramas made after 2004.
a)
SELECT * FROM movies WHERE genre = 'drama';
b)
SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;
c)
SELECT * FROM movies WHERE genre = "drama' AND year < 2004;
d)
SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7
111.
Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.
a)
SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;
b)
SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;
c)
SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;
d)
SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;
112.
Return 8 romances that were made before 1999.
a)
SELECT * FROM movies WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
b)
SELECT * FROM movies WHERE genre = romance AND year > 1999 LIMIT 8;
c)
SELECT * FROM games WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
d)
SELECT * FROM Movies WHERE genre = ‘romance’ AND year > 1999 LIMIT 8;
113.
Write the code for the following: Return all movies made before 2011 and order by the imdb rating from highest to lowest.
a)
RETURN * FROM movies WHERE year < 2011 AND imdb_rating ASC;
b)
SELECT * FROM movies WHERE year > 2011 ORDER BY imdb_rating DESC;
c)
SELECT * FROM movies WHERE year < 2011 ORDER BY imdb_rating DESC;
d)
SELECT * FROM movies WHERE year = 2011 ORDER BY imdb_rating ASC;
114.
a)
SELECT name, year FROM movies WHERE name LIKE '%B' ORDER BY year DESC LIMIT 6;
b)
SELECT * FROM movies WHERE name LIKE 'B%' ORDER BY year DESC LIMIT 6;
c)
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year ASC LIMIT 6;
d)
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year DESC LIMIT 6;
115.
Printer, Monitor, Speakers and Headphones are which type of devices?
a)
Input
b)
Output
c)
Software
d)
Hardware
116.
What storage loses its data every time the computer is turned off?
a)
RAM
b)
ROM
c)
CPU
d)
Motherboard
117.
Where are all the start up files located?
a)
RAM
b)
ROM
c)
CPU
d)
HARD DRIVE
118.
What is the main storage device of your computer?
a)
RAM
b)
ROM
c)
CPU
d)
HARD DRIVE
119.
Where does all of the computer's processing go through?
a)
CPU
b)
RAM
c)
ROM
d)
MOTHERBOARD
120.
Keyboard, Mouse, Scanner, Microphone are what types of devices?
a)
INPUT
b)
HARDWARE
c)
OUTPUT
d)
SOFTWARE
121.
Term for the physical parts of the computer
a)
HARDWARE
b)
HARD DRIVE
c)
SOFTWARE
d)
INPUT DEVICES
122.
What are the four tasks(classifications) that make up a computer?
a)
input, color, pixels, and application
b)
input, output, process, store
c)
printers, output, monitors, microphones
d)
keyboards, mouse, joysticks, and memory card
123.
What is considered a peripheral device
a)
printer
b)
tower
c)
cpu
d)
motherboard
124.
What is the device in the computer that holds all of the small electronic components?
a)
Big Board
b)
tower
c)
motherboard
d)
harddrive
125.
Which component enables the connections of a monitor and may provide additional graphics capabilities?
a)
video card
b)
hard drive
c)
cpu
d)
ram
126.
Which component enables a computer to connect to a network or server?
a)
cpu
b)
network card
c)
ram
d)
hard drive
127.
Flash Memory Sticks are a form of what type of storage?
a)
Optical
b)
Solid state
c)
Sequential
d)
Magnetic
128.
Blu-Ray discs are a form of what type of storage?
a)
Solid State
b)
Magnetic
c)
Sequential
d)
Optical
129.
Which device is this?
a)
Optical Disk
b)
Hard Drive
c)
Flash Memory
d)
Magnetic Tape
130.
Which word means:
How likely the device is to break
How likely the device is to break
a)
Durability
b)
Capacity
c)
Portability
131.
The data is lost when you turn the computer off
a)
Volatile
b)
Non-Volatile
100 %
