wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Y9 IT End of Year Assessment

Total questions: 80

Worksheet time: 50mins

Name
Class
Date
1.
What is phishing?
a)
scams through websites
b)
scams through emails
c)
scams through phone calls
d)
scams through text messages
2.

What is Malware?

a)

Bad computer equipment

b)

Pop up adverts on your computer

c)

Software designed to do harm to a computer

d)

Fake web sites

3.

What is Hacking?

a)

Looking at someone's laptop.

b)

When your screen gets stuck and glitches.

c)

Gaining unauthorized access to a computer or data.

4.

What is a virus?

a)

A type of malware that spreads through normal programs

b)

A type of malware that runs independently doing damage to your computer

c)

Software that masquerades as something it isn’t in an effort to trick the user

d)

Software that sends information about you to someone else

5.
What is a Trojan horse?
a)
It scans downloads and email attachments
b)
It replicates and makes copies of itself
c)
Is destructive software disguised as something good.
d)
An animal 
6.

What is ransomware?

a)

Malware that steals your personal information

b)

Malware that steals your money

c)

Someone steals your computer and returns it when you pay them money

d)

Locks your computer till you pay money

7.

What is Geo Tagging

a)

malware to attack a computer in some way

b)

Fraudsters openly ask for money, preying on the generosity of vulnerable people

c)

Gathering data about an individual from social networking sites

d)

Assigned when a user posts to identify their location

8.

What is Fraudulent request

a)

malware to attack a computer in some way

b)

Fraudsters openly ask for money, preying on the generosity of vulnerable people

c)

Gathering data about an individual from social networking sites

d)

Assigned when a user posts to identify their location

9.

What is a logic bomb

a)

set to activate on a particular date - malware to attack a computer in some way

b)

Fraudsters openly ask for money, preying on the generosity of vulnerable people

c)

Gathering data about an individual from social networking sites

d)

Assigned when a user posts to identify their location

10.
When someone wrongfully acquires and uses someone’s personal identification, credit or account information.
a)
Hacking
b)
Identity Theft
c)
Dumpster Diving
d)
Skimming
11.
What law makes organisations look after your personal data properly?
a)
Data Privacy Act
b)
Data Protection Act
c)
Data Protection Law
d)
Data Privacy Law
12.
If you use a mouse and keyboard for extended periods of time it could lead to what type of injury?
a)
Earache
b)
Backache
c)
RSI
d)
Eyestrain
13.

What is Copyright?

a)

Legislation passed by parliament that governs the protection of personal data in the UK.

b)

A set of rights that prevents people copying and distributing a piece of work without the copyright holder's permission.

c)

where someone else pretends to be you, copies personal details and uses them for fraud.

14.
The practice of taking someone else’s work or ideas and passing them off as one’s own.
a)
Citation
b)
Bibliography
c)
Plagiarism
d)
Newton's Law
15.

Electronic screen syndrome is:

a)

Gathering data about an individual from social networking sites. Put together it forms a complete record of a person’s identity.

b)

prolonged use of electronic devices which an adverse effect on the brain.

c)

damage to the fingers, wrists and other parts of the body due to repeated movements over a long period of time.

16.

What is e-waste?

a)

Technological waste that often contains poisonous chemicals and can be an environmental hazard.

b)

Getting rid of data on old devices, so it cannot be recovered.

c)

The process of humans having the ability and desire to purchase new technologies.

17.

Which of these images shows a Storyboard?

a)
b)
c)
d)
18.

A storyboard is used to show the _____________ and flow of scenes in a moving image product such as a video or animation.

a)

design ideas

b)

work plan

c)

sequence

d)

research

19.

Which one is a Bird's Eye View?

a)
b)
c)
d)
20.

a)

high

b)

eye-level

c)

low

21.

a)

high

b)

eye-level

c)

low

22.

a)

high

b)

eye-level

c)

low

23.

What is Framing?

a)

Topography of a location

b)

The presentation of visual elements in an image

c)

Action in a single location and continuous time.

d)

Moving the camera with the subject

24.

What is Panning?

a)

Topography of a location

b)

The presentation of visual elements in an image

c)

Action in a single location and continuous time.

d)

Moving the camera with the subject

25.

What is Birds eye view

a)

Topography of a location

b)

The presentation of visual elements in an image

c)

Action in a single location and continuous time.

d)

Moving the camera with the subject

26.

What is a Scene?

a)

Topography of a location

b)

The presentation of visual elements in an image

c)

Action in a single location and continuous time.

d)

Moving the camera with the subject

27.

Which type of user interface is shown in the following image?

a)

Command Line Interface

b)

Graphical User Interface

c)

Menu Interface

d)

Speech and Sound Interface

28.

Which type of user interface is most suitable to somebody with a visual impairment

a)

Graphical User Interface

b)

Speech and Sound Interface

c)

Command Line Interface

d)

Menu Interface

29.

Which user interface is shown in the following image?

a)

Text/Command Line Interface

b)

Graphical User Interface

c)

Menu Interface

d)

Speech and Sound Interface

30.

Which type of user interface is most suitable to somebody with a visual impairment

a)

Graphical User Interface

b)

Speech and Sound Interface

c)

Command Line Interface

d)

Menu Interface

31.

What is one advantage of a Command Line Interface?

a)

It uses less processing power, so is quicker

b)

It is easy for a beginner to use

c)

It is accessible to people with visual disabilities

d)

There are a lot of accessibility functions

32.

What are TWO advantages of a Graphical User Interface?

a)

It uses less processing power, so is quicker

b)

It is easy for a beginner to use

c)

It does not take up a lot of memory on a device harddrive

d)

There are a lot of accessibility functions

33.

Amazon Alexa is an example of which type of interface?

a)

Speech and sound

b)

Command Line

c)

GUI

d)

Menu

34.

Using Siri on an iPhone is an example of a:

a)

Graphical Interface

b)

Menu Interface

c)

Sensor Interface

d)

Voice Interface

35.

A cash machine is an example of a:

a)

Text Interface

b)

Menu Interface

c)

Form Interface

d)

Sensor Interface

36.

Which user interface requires the least user input.

a)

Menu user interface

b)

Graphical user interface

c)

Sensor user interface

d)

Speech user interface

37.

Below are 2 advantages and 1 disadvantage for Speech User Interfaces.

Choose the disadvantage

a)

Suitable for disabled users

b)

Requires very little training

c)

May have difficulty understanding accents

38.

What is a user interface?

a)

It’s the computer’s brain and without it a PC cannot function.

b)

It is the name given to the computer (hardware) and operating system (software) on which applications can be run.

c)

It is software that allows users to interact with their devices

d)

It's an application or program that allows users to complete tasks or create something.

39.

What interface is this?

a)

Menu

b)

GUI

c)

Forms

d)

Speech

40.

The word accessibility means...

a)

The design of a product for users who experience disabilities

b)

The design of a product for users who don't have disabilities

c)

The design of a product to not help anyone

41.

Which of the following describes a sensor?

a)

It is central to every PC and device. It’s the computer’s brain and without it a PC cannot function.

b)

It includes buttons, tick boxes and option boxes to enable the user the enter information

c)

They detect and respond to the environment around them. They can be responsive to heat, light, sound, movement or patterns

d)

It stores the files that the device has open and stores the information from any applications in use.

42.

What is the definition of audience?

a)

the readers that the text is intended for

b)

a group of people listening at a concert

c)

anyone who is reading the text

d)

the reason the text is written

43.

what is navigation on a multimedia product

a)

People who use the system.

b)

What the client wants in a system.

c)

Features to help someone with disabilities.

d)

How the user moves around the interface

44.

What is the Audience of a multimedia product?

a)

People who use the system.

b)

What the client wants in a system.

c)

Features to help someone with disabilities.

d)

How the user moves around the interface

45.

What are user requirements of a multimedia product?

a)

People who use the system.

b)

What the client wants in a system.

c)

Features to help someone with disabilities.

d)

How the user moves around the interface

46.

To store an image on a computer, the image is broken down into tiny elements called _______________.

a)

pixels

b)

picture boxes

c)

squares

47.

What are graphics?

a)

Detect and respond to the environment around them.

b)

Visual images on a product.

c)

An image is made up of millions of pixels (dots).

48.

A multimedia structure where each page is simply linked to the one before

a)

Linear

b)

Non-Linear

c)

Hierarchical

d)

Composite

49.

A multimedia structure in which users navigate through pages which are grouped into categories underneath home page

a)

Linear

b)

Non-Linear

c)

Hierarchical

d)

Composite

50.

A multimedia structure where every page can access all the others.

a)

Linear

b)

Non-Linear

c)

Hierarchical

d)

Mesh

51.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
52.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
53.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
54.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
55.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
56.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
57.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
58.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
59.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
60.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM
61.

What does a formula do in Google Sheets?

a)

It automates a process

b)

It creates a chemical

c)

It answers a question

d)

It finds mistakes

62.

What does the =COUNTIF formula do?

a)

Counts things

b)

Counts how often something occurs

c)

Counts how many different things are there

d)

Counts how many things are in a list

63.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
64.
You can present your data graphically, using a 
a)
chart
b)
print
c)
font
d)
sort
65.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
66.
What Excel feature did we use to quickly apply this formatting feature?
a)
Data scenario formatting
b)
What-if analysis
c)
Conditional formatting
d)
PivotTables
67.
What does the term “relative” mean for a formula?
a)
The formula remains unchanged when it is moved.
b)
The formula is related to another spreadsheet.
c)
The formula is related to the cells before it.
d)
The formula changes based on its location.
68.

What does the term “absolute” mean for a formula?

a)

Locking the value of a cell using the $ symbol in order to autofill.

b)

The formula is related to another spreadsheet.

c)

The formula is related to the cells before it.

d)

When formulae are copied across multiple cells, they change based on their position

69.
What character is used to change a cell references from relative to absolute?
a)
$
b)
%
c)
*
d)
+
70.

What is the checking of data, on input, by software to make sure it is sensible or reasonable.

a)

Double entry

b)

Verification

c)

Validation

71.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
72.

What is a simulation and why are they used?

a)

A simulation is a giant model in motion for a test.

b)

A simulation uses one or more models to imitate how those models might function in a real life situation.

c)

A simulation tests a hypothesis with 100% accuracy.

73.

A ____________ is a saved sequence of

commands or keystrokes that are

stored for later use .

a)

Book

b)

Save Command

c)

Sheet

d)

Macro

74.

What function offers you the possibility to view different results depending on the entered condition?

a)

=if()

b)

=sumif()

c)

=sum()

d)

=TRUEFALSE()

75.

What key should be used to make the content of a cell absolute?

a)

F1

b)

F2

c)

F3

d)

F4

76.

A data type that can only hold a whole number

a)

Boolean

b)

Integer

c)

Real

d)

String

77.

What do we mean by formatting?

a)

The checking of data, on input, by software to make sure it is sensible or reasonable.

b)

A small program that you can use to automate a series of tasks.

c)

The appearance of a document, including the fonts, colours, size and rotation.

78.

What is Multimedia?

a)

Text

b)

animated video

c)

video

d)

combination of text, images, video, animation etc

79.

What function allows you to add up 3 or more cells?

a)

=if()

b)

=sumif()

c)

=sum()

d)

=TRUEFALSE()

80.

Which is NOT a formula?

a)

b2+b3+b4

b)

=b1+b2+b3

c)

=b4*c4

d)

=b5/b7