WorksheetsY7 Assessment
Total questions: 54
Worksheet time: 31mins
When a user enters data into a computer, what is this called?
Input
Process
Output
Program
When you press a key on your keyboard what is the result shows on the screen called?
Input
Process
Output
Storage
How does a computer produce the answer when you enter a calculation as an input?
it stores the data
It uses its brain
It processes the input data
It takes a guess
How does a computer know how to process data that is input into it?
It follows program instructions
It's clever, it just knows
It checks stored outputs
It generates a random output
What type of device is this? (Printer)
Input
Output
What type of device is this? (Remote Control)
Input
Output
What type of device is this? (Projector)
Input
Output
What type of device is this? (Headphones)
Input
Output
What type of device is this? (Speakers)
Input
Output
What type of device is this? (Scanner)
Input
Output
What type of device is this? (Microphone)
Input
Output
What type of device is this? (Monitor)
Input
Output
What type of device is this? (Smartphone screen)
Input
Output
Input and Output
What symbol must be at the beginning of every formula you write in a spreadsheet?
(a)
=SUM(A1,A3,A4)
What is the purpose of this formula?
To add up the values referenced inside the brackets.
To multiply the values referenced inside the brackets
To compare the values referenced inside the brackets.
To find a value in the cells referenced inside the brackets.
Which formulas below will count the number of items with a cost above £1.50?
=COUNT(IF(B2>1.5))
COUNTIF(B2-B7, >1.5)
=COUNTIF(B2:B7, ">1.5")
COUNTIF(B2:B7, ">1.5")
Write a formula to find calculate the total stock level in the bakery for all of its products combined.
Your formula MUST include cell references.
(a)
Which mathematical function does the symbol below represent?
*
To the Power of
Multiplication
Division
Which mathematical function does the symbol below represent?
/
To the Power of
Multiplication
Division
Which of the formula's would correctly output Yes/No in column D.
=IF(D2 < 10) "Yes", "No"
=IF(D2 < 10, "Yes", "No")
=IF(D2 > 10, "Yes", "No")
IF(D2 > 10, "Yes", "No")
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)
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
Which function would be used to find the lowest number in a range of cells?
AVERAGE
SUM
MIN
MAX
When sending an email you must always give the email context by filling in the
(a)
What personal information might a phisher try to trick you into revealing?
credit card numbers
login and password information
all of these
Social Security number
What should you do if you receive an email that says it is from someone or a business you know asking for personal information?
Reply and ask them if they would like more personal information for their records.
Go ahead and reply and give them the information they want. They must know who you are if they sent you an email.
Open a new window and type in the official address of the company or person you know to be sure you're providing information to the correct business or person.
What should you look for in the URL to make sure that a site is safe before adding personal information?
https: and a padlock
www. and a globe symbol
that it ends with .com
What does this code do?
Moves forward 1 time
Moves forward forever
Moves forward 5 times
Moves left
An error in a program that prevents the program from running as expected.
bug
debugging
for loop
binary
Finding and fixing errors in a program.
debugging
bug
nested loop
event
Look at the puzzle and the code below. What can you fix in the code to help the bird get to the pig?
Remove a move forward block
Add a move forward block
Change the first turn block to left
Change the second turn block to left
What shape does this code make?
Rectangle
Triangle
Square
Circle
A list of steps to finish a task.
Algorithm
Program
Bug
Is there more than one way to code a puzzle?
No
No, but you can make up your own design
Yes
Yes, but it will be counted wrong
If you weren't able to complete a challenge the first time you should
pout
give up
try again
bang on the keyboard
What does this code do?
Moves forward, turns, moves forward
Moves forward 2 times, turns left, moves forward 2 more times
Moves forward 4 times and turns left
Moves and turns
An algorithm that has been coded into something that can be run by a machine.
Program
Variable
Function
Input
