Font size
WorksheetsYear 8 - End of year test
Total questions: 96
Worksheet time: 48mins
What type of coding is Scratch?
Textual
Non-Textual
What colour blocks allow the code to start running?
Blue
Green
Yellow
Red
What colour blocks allow movement/motion in Scratch?
Blue
Green
Yellow
Red
True or False: The blocks don't need to be joined, as long as they are on the script area, they will run
True
False
Which of these blocks can be identified as Iteration.
When Space key pressed
Forever
Move 10 Steps
If on edge, bounce
Data can be stored in a Scratch program, what is data saved in?
Stage
Variable
Variant
Code drawer
What is the definition of an Algorithm?
A set of instructions to perform a process.
The answer to a question.
A question to be answered
A list of instructions.
What is the key word used for when code is repeated or looped?
Iteration
Isolation
ISO File
Instantaneous
What shape will this code draw?
Circle
Square
Triangle
Rectangle
Which code block allows scratch to draw on the stage?
Pen Down
Pen Up
Pen In
Pen Out
What colour is the default cat in Scratch?
Brown
Black
Orange
White
It is possible to add maths into scratch, what colour blocks are these?
Blue
Green
Orange
Yellow
It is possible to add maths into Scratch, what is the Scratch Key Word used for it?
Operators
Calculators
Calculations
Operations
Why do we learn Python?
It's a really big snake
It's the name of a very funny comedy show
It's simple and easy to learn
It's so rare that no one else knows it
print("Hello world!")
print(3+4)
What would this print?
print("3+4")
Print("Hello world!")
print("Hello" + "world" + "today")
print(Hello world!)
print("Hello world!\nHello world!")
Hello world!
print("Hello world!" * 2)
print(9/3)
What is a program?
A series of step-by-step instructions that tell a computer how to solve a task/problem
A video that is watched on the computer
A flow chart written on a computer
A series of steps in the incorrect order that tell a computer how to solve a task/problem
What is the name of the editor you have used to code your Microbit?
Scratch
Python
Block editor
Excel
How many LEDs does the microbit have?
15
25
23
21
How many buttons does the Microbit have?
0
1
2
3
How many pins does the Micro:Bit have?
1
2
3
4
What is a variable?
A named memory location used to store data values in a computer program
A type of code used in a computer program
A function/command which stores data
Texts or words within in your computer program
What is selection?
Repeating a number of steps
Repeating a number of steps until the condition is true
A decision point in your program
The order in which instructions are carried out
In programming how is selection implemented?
IF - OTHERWISE
IF - ELSE IF - ELSE
DO - ELSE
IF - ELSE - DO
Which function would you use on the Block editor to implement selection statement?
Variables
Maths
Input
Logic
Select an output?
Select an input?
What is a 'string'?
Whole numbers
Decimal numbers
Text
True or false
Jacob = 10
This is an example of what data type?
String
Boolean
Float
Integer
How many variables have been used in this program?
1
2
What will the code output?
Access Granted
Access Denied
Error
Try again
What does iteration mean?
Code is repeated until the user presses enter
Code which has errors within it
When a set of instructions in a code are repeated a certain number of times or until a condition is met
It is a decision point in a computer program
What formula should be used in cell D4?
=B4+C4
=B4*C4
=B4/C4
=B4-C4
Type the formula that should appear in cell D4.
(a)
What is happening in this spreadsheet?
A formula is being replicated
A formula is being duplicated
A formula is being copied
A formula is being moved
What formula should be used in cell D8?
=SUM(D4+D7)
=SUM(D4:D7)
=SUM(D4+D5+D6+D7)
=SUM(D4:D8)
What is missing from the formula for cell D8?
= (a) (D4:D7)
Cell D8 should contain a function. What kind?
=SUM
=AVERAGE
=MIN
=MAX
Which month is the wettest?
January
February
March
April
May
Which month is the least windy?
January
February
March
April
May
Which month is the least windy?
January
February
March
April
May
What function should be used in the cells in row 17?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in the cells in row 16?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in the cells in row 15?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in cell B15?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=AVERAGE(C3:C14)
=SUM(D3:D14)
What function should be used in cell D16?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=AVERAGE(D3:D14)
=SUM(D3:D14)
What function should be used in cell C17?
=SUM(C3:C14)
=AVERAGE(C3:C14)
=MAX(C3:C14)
=MIN(C3:C14)
What function should be used in cell B15?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=MAX(B3:B14)
=MIN(B3:B14)
What function should be used in cell B16?
=SUM(B3:B14)
=SUM(B3:B17)
=SUM(B1:B17)
=SUM(B3:B15)
A cell reference that changes when copied is called
Cell reference
Absolute cell reference
Relative cell reference
Which of the following formulas will work when typed into a cell in Excel?
£0.65 times 23
C10*D10
=C10*D10
=C10xD10
What do all formulae start with in a spreadsheet?
+
/
*
=
