NEW
Font size
WorksheetsYear 7 End of Year Revision
Total questions: 39
Worksheet time: 20mins
Finding and fixing errors in your code
Debugging
Iteration
Algorithm
Selection
The physical parts of a computer system
Hardware
Software
Input
Output
Translating a set of instructions into a language the computer can understand
Algorithm
Programming
Iteration
Debugging
A set of instructions to solve a problem or complete a task written for humans to follow
Hardware
Software
Input
Algorithm
Hardware that sends data to a computer system
Input
Output
Software
Algorithm
Follows instructions to process input and turn it into output
Hardware
Computer System
Selection
Iteration
Repeating steps in an algorithm or program, also called repetition and loops
Selection
Iteration
Algorithm
Debugging
A decision or a question that tells a program to look at the answer, then follow a particular sequence
Selection
Iteration
Algorithm
Debugging
The programs that run on a computer
Hardware
Software
Algorithm
Iteration
Hardware used to communicate data that has been processed
Input
Output
Software
Algorithm
Every cell in a spreadsheet or worksheet has a unique cell reference, which consists of
a letter followed by a number
two letters
two numbers
a number followed by a letter
In Excel...
Both rows and columns are referred to by numbers
Both rows and columns are referred to by letters
Letters refer to columns and the numbers refer to rows
Letters refer to rows and the numbers refer to columns
In excel, formulas always start with
=
+
formula
(
In Excel, what symbol is used for multiplication?
x
*
:
/
In Excel, what symbol is used for division?
x
*
:
/
What formula CANNOT calculate the total stock level in the bakery for all of its products combined.
=SUM(C2:C7)
=SUM(C2,C3,C4,C5,C6,C7)
=C2+C3+C4+C5+C6+C7
=SUMC2+C3+C4+C5+C6+C7
Which of the formula's would output the price of the CHEAPEST item in the bakery?
=MIN(B2:B7)
=LOW(B2:B7)
=SML(B2:B7)
=BOTTOM(B2:B7)
Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?
=MAX(B2:B7)
=HIGH(B2:B7)
=LRG(B2:B7)
=TOP(B2:B7)
What would be a correct formula to add together all the prices in the bakery?
=SUM(B2:B7)
=SUM(B2+B7)
=SUM(B2,B7)
=ADD(B2:B7)
What is the cell reference for the the label Price?
1B
B1
1
B
Which of the following is NOT a helpful question to ask yourself when determining whether to trust information online?
Who is the author?
Can I find another source?
What is the motivation?
How cool does it look?
Which of the following is NOT a helpful option if you're uncomfortable with the way someone is communicating with you online?
Reporting to CEOP
Telling a trusted adult
Continuing to talk to them
Blocking the person
Which face design will you see if the code is run?
Sleepy
Happy
_______ can be used to represent characters in your game.
Code
Sprites
People
Which block of lets you create your sprite?
Which of these blocks of codes tells the sprite what to do when it overlaps with another sprite?
What is the name of the variable in this code?
score
button A
Level 2
What will happen when you press the A button?
score will go up by 1
score will go down by 1
Nothing will happen
What will happen when you press the B button?
score will go up by 1
score will go down by 1
Nothing will happen
What score would you need to reach Level 2?
1
5
5 or above
What is the name of the variable in this code?
randomNumber
pick random
"Dare"
"Truth"
What will be displayed first if the random number is a 1?
Truth
Dare
Next Person
What will be displayed first if the random number is a 0?
Truth
Dare
Next Person
Nothing
The _______ variable is set to True
Happy
Sleepy
if
on start
What are variables used for in programming?
Storing data for later use
Displaying something on the screen
Which of these blocks will continuously repeat your code?
On Start
Forever
On Button A
On Shake
Which of these blocks will only be executed when the user performs an action?
On Start and Forever
On Button A and On Shake
Which of these is an output
Which of these is an input?
