Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 11 PPE March 2019 PAPER 2

Total questions: 111

Worksheet time: 3620secs

Name
Class
Date
1.

What is Computational thinking?

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.

2.

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.

3.

What is Decomposition?

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.

4.

What is Algorithmic Thinking?

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.

5.
Not a definition of Decomposition
a)
They can be created independent of the other problems. 
b)
 They can be tested independently.
c)
Then combined to produce the full problem.
d)
Using symbols, variables etc. to represent a ‘real world’ problem in a computer program...
6.
What is abstraction?
a)
The process of filtering out unnecessary detail.
b)
The process of filtering out irrelevant characteristics
c)
The process of filtering out irrelevant characteristics and unnecessary detail.
7.
Why do we need to think computationally?
a)
To help us program
b)
To help us solve complex problems more easily
c)
To help us to think like a computer
8.
Which of the following is NOT a computational thinking technique?
a)
Decomposition
b)
Abstraction
c)
Coding
9.
Breaking a complex problem down into smaller problems and solving each one individually.
a)
Decomposition
b)
Abstraction
c)
Programming
d)
Algorithmic Thinking
10.
Which of the following is an example of thinking computationally?
a)
Planning out your route when going to meet a friend
b)
When going to meet a friend, wandering around until you find them
c)
When going to meet a friend, asking a parent to plan your route for you
11.

What is the difference between a function and procedure?

a)

A function always RETURNS a value

b)

A procedure always RETURNS a value

c)

No difference

12.

This is an example of ...

a)

FUNCTION

b)

PROCEDURE

13.

The parameters in this Function are ...

a)

add

b)

num1 .... num2

c)

firstNum .... secondNum

d)

total

14.

The add( ) function can be written out in PSEUDOCODE like ...

a)
b)
15.

Which description is True? ...

a)

The function takes in 2 parameters ... which are added together and stored into the variable Total. The function Returns the variable to where it was called from.

b)

The function takes in 2 parameters ... which are then multiplied together and stored into the variable Total. The function Returns the variable to where it was called

c)

The function takes in 3 parameters ... which are then added together and stored into the variable Total. The function Returns the variable to where it was called

16.

If you are storing money into a variable, the data type should be a ...

a)

STRING

b)

FLOAT (REAL)

c)

INTEGER

d)

BOOLEAN

17.

If you are storing how many cars were caught speeding, you should use the data type ...

a)

STRING

b)

FLOAT (REAL)

c)

INTEGER

d)

BOOLEAN

18.

A FLOAT (REAL) data type allows you store ...

a)

Whole numbers only

b)

Decimal numbers

c)

Letters and numbers

d)

Letters only

19.

Which line number has a SYNTAX error ?

a)

6

b)

7

c)

8

d)

9

20.

A student scores a total of 120 marks. What will be displayed ?

a)

Amazing

b)

Good

c)

Need to try harder

21.

There is a LOGIC error on Line 4. How can the LOGIC error be fixed?

a)

if Total < 120 :

b)

if Total < = 120 :

c)

if Total > = 120:

22.

Total = Paper1 + Paper2

print ( ' The total score is ' + str( Total ) )


The area highlighted in RED ^ is an example of ...

a)

Casting

b)

Converting

c)

Coupling

d)

Joining

23.

Casting means ...

a)

changing the data type of a variable to a different data type (e.g INT > STRING )

b)

Increasing the value of a variable

c)

Decreasing the value of a variable

d)

Removing the data type of a variable

24.

Which programming construct is used?

a)

SEQUENCE

b)

SELECTION

c)

ITERATION

25.

Which programming construct is used?

a)

SEQUENCE

b)

SELECTION

c)

ITERATION

26.

Which programming construct is used?

a)

SEQUENCE

b)

SELECTION

c)

ITERATION

27.
What arithmetic operator should I use to find 2 to the power of 3
a)
2 ** 3
b)
2 // 3
c)
2 % 3
d)
2 * 3
28.
What arithmetic operator should I use to find the answer of a division as a whole number?
a)
10 / 3
b)
10 // 3
c)
10 % 3
d)
10 - 3
29.
What arithmetic operator should I use to find the remainder of a division (modulus) ?
a)
10 / 3
b)
10 // 3
c)
10 % 3
d)
10 - 3
30.
10 % 8 (modulus) ... what is the answer?
a)
1
b)
2
c)
3
d)
4
31.
10 % 6 (modulus) ... what is the answer?
a)
1
b)
2
c)
3
d)
4
32.
What will be the result of this comparison?
9 == 9
a)
TRUE
b)
FALSE
33.
What will be the result of this comparison?
9 == 10
a)
TRUE
b)
FALSE
34.
What will be the result of this comparison?
9 != 10
a)
TRUE
b)
FALSE
35.
What will be the result of this comparison?
9 != 9
a)
TRUE
b)
FALSE
36.
What will be the result of this comparison?
'JEFF' == 'JEFF'
a)
TRUE
b)
FALSE
37.
What will be the result of this comparison?
'JEFF' == 'jeff'
a)
TRUE
b)
FALSE
38.
What will be the result of this comparison?
2 > 5
a)
TRUE
b)
FALSE
39.
What will be the result of this comparison?
2 >= 5
a)
TRUE
b)
FALSE
40.
What will be the result of this comparison?
2 >= 2
a)
TRUE
b)
FALSE
41.
What will be the result of this comparison?
10 == 5 + 5
a)
TRUE
b)
FALSE
42.
What will be the result of this comparison?
10 != 5 * 10 / 5
a)
TRUE
b)
FALSE
43.
Joining elements together to make a string is called what?
a)
Combining
b)
Connecting
c)
Concatenation
d)
Stringing
44.

What arithmetic operator should I use to find the answer of a division as a whole number (DIV) ?

a)

10 / 3

b)

10 // 3

c)

10 % 3

d)

10 - 3

45.

Modulus means ... ( e.g. 5 % 2 = 1 )

a)

finds the remainder (after division)

b)

division giving an integer (whole number as the answer)

46.

DIV means ... ( e.g. 5 // 2 = 2 )

a)

finds the remainder (after division)

b)

division giving an integer (whole number as the answer)

47.

What is the name given for the area highlighted in RED ?

a)

RECORD

b)

FIELD

c)

TABLE

d)

PRIMARY KEY

48.

What is the name given for the area highlighted in BLUE?

a)

RECORD

b)

FIELD

c)

TABLE

d)

PRIMARY KEY

49.

What is the name given for the area highlighted in YELLOW?

a)

RECORD

b)

FIELD

c)

TABLE

d)

PRIMARY KEY

50.

What will be displayed using following SQL


SELECT * FROM Gymnasts WHERE HighScore = 9.1

a)

0004 Tom 7.9 Vault

b)

0005 Xavier 8.4 Floor

c)

0006 Victoria 9.1 Rings

51.

What will be displayed using following SQL


SELECT * FROM Gymnasts WHERE Competition = "Floor"

a)

0004 Tom 7.9 Vault

b)

0005 Xavier 8.4 Floor

c)

0006 Victoria 9.1 Rings

52.

What will be displayed using following SQL


SELECT ID FROM Gymnasts WHERE HighScore < 7

a)

0004

b)

0005

c)

0003

d)

0002

53.

What will be displayed using following SQL


SELECT ID FROM Gymnasts WHERE HighScore >= 9 AND Competition = "Rings"

a)

0004

b)

0005

c)

0003

d)

0006

54.

What is the correct definition of a Primary Key?

a)

Uniquely identifies any record in a table

b)

It is always a number

c)

It is always the first number

d)

Uniquely identifies any field in a table

55.

What is the correct definition of a Field?

a)

Uniquely identifies any record in a table

b)

It is always a number

c)

Used to store all of the data about each specific item

d)

Used to store a category (e.g. Names / Gender / Mobile Num)

56.

What is the correct definition of a Record?

a)

Uniquely identifies any record in a table

b)

It is always a number

c)

Used to store all of the data about each specific item

d)

Used to store a category (e.g. Names / Gender / Mobile Num)

57.

What type of data is stored as Boolean?

a)

Whole numbers

b)

Decimal numbers

c)

Strings

d)

Yes / No ... True / False

58.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
59.
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
60.

What does "SQL" stand for?

a)

Structured Question Language

b)

Structured Query Language

c)

Simple Query Language

d)

Simple Question Language

61.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

62.

What will the following SQL statement return?

SELECT Name, Competition FROM Gymnasts;

a)
b)
63.

What will the following SQL statement return?

SELECT Name, Competition

FROM Gymnasts

WHERE HighScore < 7;

a)
b)
64.

What's wrong with this SQL statement?

SELECT *

FROM Gymnasts

WHERE Competition = Floor;

a)

should be: WHERE Competition = "Floor";

b)

should be: SELECT all

65.

An image that has a 2 bit colour depth means ...

a)

there are 2 possible colours

b)

there are 3 possible colours

c)

there are 4 possible colours

d)

there are 5 possible colours

66.

An image that has a bit depth of 8 means ...

a)

there are 256 possible colours

b)

there are 512 possible colours

c)

there are 8 possible colours

d)

there are 1024 possible colours

67.
The higher the colour depth, the _________the image file size.
a)
Smaller
b)
Larger
68.
The higher the resolution, the ____ the file size.
a)
Smaller
b)
Larger
69.
Define what is meant by the term 'metadata'.
a)
Metadata is the smallest element of an image.
b)
Metadata is the number of bits used to store the colour of a pixel.
c)
Metadata refers to information stored about an image.
d)
Metadata is a lossy compression file format that allows for very compact file sizes.
70.
Which of the following is NOT metadata that could be stored about an image?
a)
Pixel width and height.
b)
Picture resolution measured in DPI
c)
Camera name and model.
d)
Printer description
71.
When we have a 'one-bit' colour, which are the only two binary numbers that are possibilities?
a)
00 and 11
b)
000 and 111
c)
0 and 1
d)
0000 and 1111
72.
How many combinations are there for a '2 bit' colour?
a)
8
b)
4
c)
16
d)
32
73.
Which 'bit' image would give the best picture quality?
a)
24
b)
4
c)
8
d)
2
74.

Which best describes the relationship between bits per pixels and colours?

a)

The number of bits of per pixel is not relevant to the colours

b)

The number of bits per pixel links directly to how many colours the pixel can represent

c)

The number of pixels per bit is always 16 (including 0)

75.

How many bits are needed to represent 8 colours?

a)

1

b)

2

c)

3

d)

4

e)

16

76.

An 8 bit sequence can represent 256 colours

a)

True

b)

False

77.

The greater the bit depth, the smaller the file size and the poorer the quality.

a)

True

b)

False

78.

A 24 bit colour bitmap image will be better quality and have a greater file size than an 8 bit colour image

a)

True

b)

False

79.

What is

1010 1111

in HEX ?

a)

A F

b)

B G

c)

A G

d)

C 8

80.

What is

0011 1111

in HEX ?

a)

3 F

b)

3 G

c)

2 G

d)

2 F

81.

Computers uses binary because

a)

The transistors inside the computer only have 2 states ( 1 = ON .... 0 = OFF )

b)

The transistors inside the computer only have one state ( 1 = ON )

c)

The transistors inside the computer only have one state ( 0 = OFF )

d)

It is the programming language that a computer understands

82.

Hex is easier to work with rather than binary

a)

Easier to convert to / from and read

b)

Harder to convert to / from and read

c)

Because it is smaller

83.

4 bits represent 1 HEX number

a)

TRUE

b)

FALSE

84.
What is the point of binary?
a)
It represents how computers interpret electrical signals
b)
Because we like to make you do extra maths ;-D
c)
For the lulz
d)
Because it describes star systems
85.
What is 12 in binary?
HINT: It has an 8 and a 4 in it!
a)
12
b)
11
c)
1100
d)
1011
86.
What is 1011 in denary?
a)
11
b)
14
c)
26
d)
1011
87.
What is the denary number system?
a)
It counts the number of dens
b)
Our usual base 10 number system
c)
A special number system for computers
d)
Den Ary's number system
88.
Convert 128 to binary
a)
10000000
b)
01111110
c)
10000001
d)
11001100
89.
If you have a large amount of data to search through the best algorithm would be a 
a)
Binary Search
b)
Linear Search
90.
Which of these is NOT a Sort algorithm
a)
Binary
b)
Merge
c)
Bubble
d)
Insertion
91.
Which search algorithm is the easiest to understand?
a)
Binary
b)
Linear
92.
Which search algorithm is more likely to complete the search in fewer steps?
a)
Binary
b)
Linear
93.
Which type of sort algorithm is this?
a)
Bubble
b)
Merge
c)
Insertion
94.
Which type of sort algorithm is this?
a)
Bubble
b)
Merge
c)
Insertion
95.
Which type of search algorithm is this?
a)
Binary
b)
Linear
96.
Which type of search algorithm is this?
a)
Binary
b)
Linear
97.
If the data is in order the best search to use would be a
a)
Binary Search
b)
Linear Search
98.
A merge sort requires both lists of data to be in the correct order
a)
True
b)
False
99.
An algorithm is...
a)
A set of steps to follow in order
b)
When you sort data into the correct order
c)
When you search data for a specific entity
100.
Which of these is NOT a search algorithm
a)
Binary
b)
Linear
c)
Bubble
101.
When is terminal testing carried out?
a)
Before you start
b)
At the end
c)
During the project
d)
After the design section
102.

Which line contains a syntax error?

a)

print("Hello")

b)

sprint("Hello")

c)

print("hello")

d)

print("HELLO")

103.
What is iterative testing?
a)
Testing completed after an error is found
b)
Random tests on a computer program
c)
Test completed as the program is being coded
d)
Test which are planned
104.
Testing while coding a program is called?
a)
Development Testing
b)
Coder Testing
c)
Terminal Testing
d)
Iterative Testing
105.
What is the purpose of testing?
a)
To identify errors
b)
To identify issues that may occur when a customer uses the program
c)
To test the security of the program
d)
All of the above
106.

What is a null value test on data entry?

a)

Data that does not have a value such as a name or phone number

b)

Data that is not entered in order to test how the program responds

c)

Data that has a value of zero

d)

Data that is incorrect

107.
Which of these is appropriate data for a range test for a youth club?
a)
10 – 20 years
b)
16 – 19 years
c)
13 – 19 years
d)
13 – 23 years
108.

Which data below is a valid test for an age field?

a)

18.6

b)

99

c)

Twenty-five

d)

17 years 5 months

109.

What problems can occur when coding a program?

a)

Bugs in code

b)

Wrong user name / password details

c)

Poorly designed GUI

d)

Changes in program syntax

110.
 When a program runs it asks the user to enter their age. Which data would be most suitable to test for an incorrect piece of data being entered? 
a)
44
b)
1
c)
97
d)
Forty five
111.
When a program runs it asks the user to enter their first name. Which is an example of Valid data?
a)
Mr Jones
b)
Sarah
c)
Sarah Jones
d)
Mrs Jones

Similar Resources on Wayground

2026-1-29_110 Α ΕΠΑΛ ΕΦΑΡ ΕΚεφ7, 9.3, 10, 11, 13, 14.2,

110 questions

2026-1-29_110 Α ΕΠΑΛ ΕΦΑΡ ΕΚεφ7, 9.3, 10, 11, 13, 14.2,

quiz

Worksheet

•

12th Grade

PC Hardware practice quiz

107 questions

PC Hardware practice quiz

quiz

Worksheet

•

9th - 12th Grade

UF0319 Sistema Operativo, Búsqueda de La Información. parte 1

106 questions

UF0319 Sistema Operativo, Búsqueda de La Información. parte 1

quiz

Worksheet

•

12th Grade

Network Technology

115 questions

Network Technology

quiz

Worksheet

•

9th - 12th Grade

Bài 1 Thông tin và quyết định

106 questions

Bài 1 Thông tin và quyết định

quiz

Worksheet

•

3rd Grade - University

Cisco 2, Modules 1-7 MidTerm Exam

106 questions

Cisco 2, Modules 1-7 MidTerm Exam

quiz

Worksheet

•

12th Grade

APCSP All Questions

112 questions

APCSP All Questions

quiz

Worksheet

•

9th - 12th Grade

डिजिटल वित्तीय सेवाएँ chapter 7

108 questions

डिजिटल वित्तीय सेवाएँ chapter 7

quiz

Worksheet

•

12th Grade