wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 8 End of Year Assessment

Total questions: 60

Worksheet time: 36mins

Name
Class
Date
1.

A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________

a)

COLUMN

b)

ROW

c)

RANGE

d)

FORMULA

2.

A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________

a)

CELL

b)

SELECTED RANGE

c)

ACTIVE CELL

d)

NONE

3.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
4.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
5.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
6.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
7.

=if(c4>30,"Win","loose")

if the value in cell c4 was 57 what message would be displayed

a)

Win

b)

Loose

c)

True

d)

False

8.

Which of the following is not a function of MS - Excel?

a)

a. AVERAGE

b)

b. ADD

c)

C.MIN

d)

d. MAX

9.

Which function can find the highest value in a cell range?

a)

a. MAXVALUE

b)

b. HIGHEST

c)

c. TOP

d)

d. MAX

10.

=if(d3>25,"Open","Close")

Which part of the function is the VALUE_IF_TRUE section?

a)

=if(

b)

d3>25

c)

"Open"

d)

"Close"

11.

=if(c4>30,"Win","loose")

What part of this function is the logical test?

a)

Win

b)

Loose

c)

c4>30

d)

=if(

12.

=if(c4>30,"Win","loose")

if the value in cell c4 was 28 what message would be displayed

a)

Win

b)

Loose

c)

True

d)

False

13.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

14.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

15.

Google Sheets is what sort of program?

a)

A document program

b)

A spreadsheet program

c)

A presentation program

d)

A television program

16.
Which of the following is a correct example using the AUTOSUM function?
a)
=Sum(A1-A10)
b)
=Sum(A1:A10)
c)
=A1+A2+A3+...+A10
d)
=Sum(A1+A2+A3+...+A10)
17.

Looking at the value of each column

what is this binary number worth ?

a)

2

b)

4

c)

6

d)

8

18.

Looking at the value of each column

what is this binary number worth ?

a)

64

b)

1

c)

65

d)

8

19.

Looking at the value of each column

what is this binary number worth ?

a)

2

b)

126

c)

128

d)

130

20.

CONVERT the binary number

00 00 11 00

a)

1100

b)

12

c)

16

d)

8

21.

Convert the binary number

00 00 01 11

a)

15

b)

13

c)

9

d)

7

22.

Convert the DECIMAL number

16

a)

00 00 00 10

b)

00 00 01 10

c)

00 01 00 00

d)

10 00 00 00

23.

Convert the DECIMAL number

20

a)

00 01 01 00

b)

00 00 01 10

c)

00 01 01 11

d)

10 01 00 00

24.

What is a Pixel?

a)

A small area of color

b)

A type of phone

c)

A picture

d)

The size of a picture

25.

What do we mean by COMPUTATIONAL THINKING?

a)

Understanding a complex problem and developing possible solutions.

b)

Breaking a task into smaller tasks.

c)

Selecting a computer to use.

d)

Focusing on what is important, ignoring what is unnecessary.

26.

Define PATTERN RECOGNITION.

a)

A sequence of instructions.

b)

Looking for similarities and trends.

c)

Breaking a task into smaller tasks.

d)

Focusing on what is important and ignoring what is unnecessary.

27.

Define ALGORITHM

a)

Breaking a task into smaller tasks.

b)

Looking for similarities and trends.

c)

A sequence of instructions.

d)

Deciding what computer to use.

28.
What is computational thinking?
a)
It allows you to break down a large / complex problem into smaller parts.
b)
It is thinking like a robot
c)
It is being able to bake a cake.
d)
It is creating a coding solution to a problem.
29.
What does decomposition mean?
a)
focuses on the important information only, ignoring irrelevant detail
b)
Step by step instructions on solving a problem.
c)
Thinking like a computer
d)
This is the breaking down of a complex problem into smaller parts
30.
What is an algorithm?
a)
A sequence of instructions on how to solve a problem.
b)
The breaking down of a problem into smaller parts.
c)
Focusing on important parts and ignoring the irrelevant details
d)
The recipe for a cake
31.
Breaking a complex problem down into smaller problems and solving each one individually.
a)
Decomposition
b)
Abstraction
c)
Programming
d)
Algorithmic Thinking
32.
Why do we need to think computationally?
a)
To help us program
b)
To help us solve complex problems more easily
c)
To help us to think like a computer
33.

What does abstraction do?

a)

The process of removing something unnecessary

b)

Breaks something up to make it easier

c)

The process of ignoring something unnecessary

d)

Looking at a solution that repeats itself

34.
What does this shape represent in a flow chart?
a)
Instruction
b)
Loop
c)
Decision
d)
Start/End
35.

What does this shape represent in a flow chart?

a)

process

b)

Loop

c)

Decision

d)

Start/End

36.
What does this shape represent in a flow chart?
a)
Instruction
b)
Loop
c)
Decision
d)
Start/End
37.
What does this flowchart symbol represent?
a)
data input / output
b)
start / end
c)
decision
d)
wait
38.
A benefit of using flowcharts is:
a)
They help you program faster
b)
They write the program for you
c)
They are easier
d)
They help you to visually plan a program
39.

What errors are shown on this flowchart?

a)

Incorrect exit from 'Is employee exempt' decision

b)

No end (terminator)

c)

No direction arrows

d)

Cannot have multiple entry points to an 'End' terminator

e)

Incorrect decision shape

40.

What error is is shown on this flowchart?

a)

Incorrect exit from 'Is employee exempt' decision

b)

No end terminator

c)

No direction arrows

d)

Cannot have multiple entry points to an 'End' terminator

e)

Incorrect decision shape

41.

An Algorithm can be represented by what? Check all that apply

a)

Decomposition

b)

Flow Chart

c)

Psuedocode

d)

Pizza

42.

What is the first stage in computational thinkging?

a)

Decomposition

b)

Abstraction

c)

Pattern Recognition

d)

Algorithm

43.

In this flow chart, if a=2, b=1, c=3 what till the ouput be?

a)

print a

b)

print b

c)

print c

d)

Stop

44.

if a = 3, b=2, c=1 what will be the output?

a)

print a

b)

print b

c)

print c

d)

stop

45.
a)
heart, heart, heart
b)
octagon, octagon, octagon
c)
octagon, octagon, heart
d)
octagon, heart, octagon
46.

What is pattern recognition?

a)

Breaking down a complex problem into smaller problems

b)

Looking for similarities among and within problems

c)

Building models from patterns

47.

Which of the following is not a social engineering technique?

a)

Blagging

b)

Hacking

c)

Phishing

d)

Pharming

48.

Which of the following describe 'Social engineering'?

a)

Confusing people so they give-up information

b)

Manipulating people to give-up information

c)

Assaulting people so they give up information

d)

Paying people so they give-up goods and services

49.

This email is what type of attack?

a)

Shouldering

b)

Blagging

c)

Phishing

d)

Hacking

50.

A set of methods used by cyber criminals to deceive individuals into handing over information that they can use for fraudulent purposes’ is a definition of what?

a)

Blagging

b)

Shouldering

c)

Phishing

d)

Social Engineering

51.

Which would be the best password?

a)

ilovemypiano

b)

!LoveMyPiano

c)

!Lov3MyPiano

d)

lovepiano3

52.
What type of key can be freely shared with anyone so that they can encrypt a message?
a)
Personal key
b)
Private key
c)
Free key
d)
Public key
53.
What type of key is not shared and computers cannot decrypt a message without it?
a)
Free key
b)
Private key
c)
Public key
d)
Personal key
54.
Personal information that should never be shared online is:
a)
 address and phone number
b)
Your school name and town where you live 
c)
Names of your friends
d)
All of the above
55.
 If anyone online is making you uncomfortable or scared, the best thing for you to do is:
a)
 Tell a trusted adult about it. 
b)
Write them back and tell them to leave you alone. 
c)
 Turn off your computer 
d)
 Meet them and tell them to leave you alone. 
56.

What are examples of a biometric security system?

a)

Touch ID

b)

Voice recognition software

c)

A typed password

d)

CCTV (security cameras) in our school

57.

A bitmap image is made up of

a)

Pixels

b)

Colours

c)

Sounds

d)

Samples

58.
Increasing the colour depth means…
a)
A bigger range of colours can be used for each pixel
b)
More pixels are in the image.
c)
More colours are in the image.
d)
Darker colours
59.
How many colours can be used for each pixel if the colour depth is 4 bit?
a)
4 colours
b)
5 colours
c)
15 colours
d)
16 colours
60.
Reducing the amount of colours in the image will
a)
Reduce the quality of the image.
b)
Reduce the amount of binary needed for each pixel.
c)
Make the file size larger
d)
Remove pixels from the image.

Similar Resources on Wayground

Cyber Foundations II Semester Study Guide

57 questions

Cyber Foundations II Semester Study Guide

quiz

Worksheet

•

7th Grade

Direct Data Entry

55 questions

Direct Data Entry

quiz

Worksheet

•

7th Grade

Unit 2 Test Review - The Internet

61 questions

Unit 2 Test Review - The Internet

quiz

Worksheet

•

9th - 12th Grade

HTML Assessment

60 questions

HTML Assessment

quiz

Worksheet

•

9th Grade

CIS Microsoft Excel (Review)

62 questions

CIS Microsoft Excel (Review)

quiz

Worksheet

•

9th Grade - Professio...

Safety and Security - Easy

57 questions

Safety and Security - Easy

quiz

Worksheet

•

7th Grade - University

YR 9 Cultural, Ethical & legal issues in ICT

58 questions

YR 9 Cultural, Ethical & legal issues in ICT

quiz

Worksheet

•

9th Grade

Digital Media Semester REVIEW 2021

55 questions

Digital Media Semester REVIEW 2021

quiz

Worksheet

•

8th - 9th Grade