Font size
WorksheetsY9 End of Year Assessment
Total questions: 60
Worksheet time: 31mins
Which of these is NOT a Storage Device?
USB Flash Drive
CD-R
Digital Camera
Floppy Disk
What type of device is this? (Smartphone screen)
Output Device
Input Device
Input and Output Device
Storage Device
Which one of these is an OUTPUT device?
MOUSE
GAMES CONTROLLER
PRINTER
KEYBOARD
What type of device is this?
Output Device
Input Device
Input and Output Device
Storage Device
Data gets erased from this when the computer is switched off.
ROM
Memory Card
RAM
Blu - Ray
What does CPU mean?
Center Process Unit
Central Processing Unit
Central Process Unity
Central Processor Unit
It displays an output
What is the name of the variable in this program?
colour
input
" "
What word is under the ???
SPEED
lives
Dave
speed
If the user entered 70 what would the output be?
That is above the speed limit!
That is exactly the speed limit
That is below the speed limit
What is under the ???
int(input(
input(int(
int("input"(
A (a) is someone who uses a computer system to gain unauthorised access to someone else's data on another computer/network.
What is Phishing?
Software that enables a user to obtain covert information about another's computer activities by transmitting data from their hard drive
A piece of code capable of copying itself to corrupt a system or destroy data
The practice of sending emails that claim to be from reputable sources to entice you to reveal personal information or click on unsafe links
Software designed to disrupt, damage or gain unauthorised access to a computer or system
The best definition of hacking is:
Glass frog slippers
Gaining an unfair advantage
Gaining unauthorized access
Gaining a black, grey or red hat
What makes up a digital footprint?
Photos
Texts
All of these
(a) is a technique of fraudulently obtaining private information, often using email or SMS.
What is the key indication that the email is the type of attack that you gave as your answer in question 1?
Somebody watches you create an account
Suspicious URL
It asks for you to complete a short quiz
It is an invented scenario
A mind map is used to show what a product will look like
True
False
What is a visualisation diagram?
A rough sketch of what your final design will look like
A board with different ideas on
A story board detailing the development of your project
A collection of images that insired your final design
Why would you use a mood board?
To show finished design
For visual ideas
To show your mood
to make people happy
What is a particular group of people at which your project is aimed?
Yourself
The Client
Adults
Target Audience
Which two documents would not be needed if you were planning a magazine cover?
Script
Storyboard
Mood Board
Visualisation Diagram
Which document could be used to show a client how a CD cover might look when made?
Mind Map
Mood Board
Visualisation Diagram
Storyboard
Work Plan
What is a visualisation diagram created for?
Costumes, logos, posters, cars or webpage layouts
Movies
Comic Books
Story Plots
A visualisation diagram needs to have annotations to explain
Colour
Reasons for design choices
Explain content
All of these
A storyboard includes?
Camera Angles
Timings
Detailed Dialogue
Location
Stage Directions
If you want to save a project that you will edit later, choose this option:
Export as PNG
Export as JPG
Save As PSD
Gradient tool
Magic wand tool
Polygonal lasso tool
Shape tool
What is this tool?
Zoom tool
Polygonal lasso tool
Magic wand tool
Gradient tool
What is this tool used for?
Add tools
Add text
Add transitions
Add
Filter
moves selections, layers, and guides
Menu you use to add effects
Lets you draw an area to select
Allows you to click through the changes you've made to the image. Kind of like "undo" but better.
Free Transform Tool
Lets you create a straight-edged area to select.
lets you quickly "paint" a selection using an adjustable round brush tip.
Changes the view size of the image
Allows you to change the size of an image from any corner or side.
magic wand
quick select select
magnetic lasso select
rectangle select
What is the proper name for the area that you create your graphics on in Photopea?
Canvas
Blank Page
Paper
Graphics area
Poll and quiz results appear
when everyone has finished
in real-time
an hour after the first response
every five minutes from the first response
Create surveys, quizzes, and polls, and easily see results as they come in.
Excel
Word
Microsoft Forms
Yammer
The logo for the Forms app is
List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).
/,+,-,*
*,/,+,-
^,s,r,t
Do you need an = sign to start a formula?
no
yes
never
Select all statements that apply to a cell.
[Maximum: 2]
A single block in a table/spreadsheet where we enter data.
Can be referenced in a formula by using the column and row id (e.g. A2)
Does not allow text to be entered.
Can be used to trigger macros.
Where does Excel return the result of a formula
the same cell where the formula is entered
A1
in your head
Does Excel allow the use of numbers in formulas?
yes
no
Which function will total a range of cells?
TOTAL
SUM
MIN
AVERAGE
What does the SUM function do?
Multiplies all the values in a range
Adds all the values in a range
Subtracts values in a range
Tells you what each part of the chart represents.
Legend
Vertical axis
Horizontal axis
Chart title
To insert a table into my Word document, I go to which tab?
Home
Insert
Design
Page Layout
I can change the borders of my table
True
Fasle
To remove the lines in a table, select the table and ....
On the "home" tab, click on the Borders arrow, select No Border
On the "insert" tab, click on No Border
On the "home" tab, deselect Gridlines
hunt and pecking
