WorksheetsY7 Summer 2 Assessment
Total questions: 80
Worksheet time: 29mins
If you receive a message that your computer has a virus, you should . . .
download the fix immediately!
be suspicious because they can't tell if your computer has a virus.
send them your credit card information right away to get help!
Your password should contain the following:
letters, numbers, symbols
letters only
numbers only
symbols only
Email stands for
Electronic Mail
Electronic Messaging
E-Messages
Which of the following would make the best password?
14921218
H3110!
moby_b!
9FarmAppleRoom24
What are the keyboard shortcuts for Copying and Pasting something?
Alt + C, Alt + V
Alt + C, Alt + P
Ctrl + C, Ctrl + V
Ctrl + C, Ctrl + P
The strongest password would be
gRe@tj0b2
greatjob
gre@tj0b
great_job
Who are examples of trusted adults we can go to if something doesn't feel right online? Choose 2 answers.
Parents.
All family members.
Teachers.
Random strangers.
Someone in your class has sent around an embarrassing photo of another classmate. What should you do?
Forward the photo onto other people.
Show your teacher and say what has happened.
Save it on your phone so you can embarrass them again later.
Laught at the photo with your friend.
If I delete a file from the desktop, is it permanently deleted?
Yes, it is gone forever
No, it goes to the recycle bin which empties it
No, it goes to the recycle bin and you have to empty the recycle bin
Which software has the following icon?
Microsoft Word
Microsoft Excel
Google Docs
What is a folder?
an object that contains data or information
a container that can store food
a container that can store hardware components
a container that can store files or folders
Backing up your files is important because....
Computer drives could fail
A virus could corrupt your work
You could accidentally delete a file
All of the above
Microsoft Publisher is a
Web Browser
Operating System
Desktop Publisihing Program
Word Processor
If you want to remove a portion of the picture, you can use the ____________tool.
Cut
Copy
Crop
Delete
What do you do if a text is in front of a picture and you want it behind?
Move it behind text
Delete it
Send backward
Move it away from the picture
How can you zoom in and out in Microsoft Publisher?
Clicking the Zoom button in the View tab
Holding down the CTRL key & Scrolling
Pressing the F5 key & Scrolling
Using the zoom slider
How can you import pictures into your publication?
Through the Page Design tab
From the File menu
Using the Pictures option in the Insert tab
By dragging and dropping into the workspace
Which of the following should Publisher NOT be used for?
Designing a flyer
Designing a poster
Designing a menu
Calculating money
This is one thing you can't create with MS Publisher
Brochure
Posters
spreadsheet
Flyer
What do we mean by COMPUTATIONAL THINKING?
Understanding a complex problem and developing possible solutions.
Breaking a task into smaller tasks.
Selecting a computer to use.
Focusing on what is important, ignoring what is unnecessary.
When drawing a dog, which of the following characteristics is non-essential?
Dogs have 4 paws
Dogs have fur
Dogs have brown fur
Abstraction and Decomposition are examples of...
Computational Thinking
Algorithmic Thinking
Computer Science
Logical Reasoning
If you were to create a step-by-step sequence of instructions to solve a problem, which Computational Thinking skill would you be using?
Decomposition
Algorithm Design
Pattern Recognition
Abstraction
‘Focusing on what’s important, ignoring what is unnecessary’ is a definition of which part of Computational Thinking?
Decomposition
Algorithm Design
Pattern Recognition
Abstraction
You are creating a computer game. Which of the following activities below requires decomposition?
Creating all the sprites the same style.
Considering what parts make up the game: graphics, levels, programming, intro, etc.
Creating a demo version of the game.
Testing the game after the demo version is finished.
Abstraction, Decomposition, Algorithms and Pattern Recognition form the four key skills of WHAT?
(a)
Define ABSTRACTION
Breaking a task into smaller tasks.
Drawing a map to show how to reach a destination.
Creating step by step instructions.
Focusing on what is important and ignoring what is unnecessary.
Define DECOMPOSITION
Breaking a task into smaller tasks.
Looking for similarities and trends.
A sequence of instructions.
Focusing on what is important and ignoring what is unnecessary.
Why do we decompose a complex problem?
To make it more difficult to solve
To change the problem we have
To make it easier to solve
Which of these is an example of decomposition?
Watching a mechanic repair a bicycle
Looking at different bicycles for similarities between them
Finding out how a bicycle works by looking in detail at the different parts that make up the bicycle
Which of these is an example of decomposition?
Guessing who has solved a crime from looking at patterns that have happened before
Solving the complex problem of a crime by breaking it down into when the crime was committed and were there any witnesses
Looking at what different crimes could be committed
What is the shortest distance, in meters, that the worm has to crawl to eat all of the apples?
4
9
13
15
How many parking spaces were empty both on Monday and Tuesday?
3
4
5
6
How many different routes can Jane take to school?
1
2
3
4
5
What is the best way to solve a difficult problem in computer science?
Break the problem down and solve it in small chunks.
Try and solve the problem in one go.
If you can do it straight away you should give up.
Which of the follwing is a CORRECT solution to the following logic problem:
A horse is a mammal/
Horses have legs/
Frogs have legs/
A frog can lay eggs/
Amphibians can lay eggs/
Mammals do not lay eggs/
A frog is an amphibian
All creatures with legs are mammals
All creatures with legs are amphibians
All creatures who lay eggs are amphibians
3
5
8
15
2
4
8
10
2
3
12
35
9
10
13
15
Which logic gate is this?
AND
OR
NOT
NAND
Which logic gate is this?
OR
AND
NOT
NOR
Which logic gate represented by this symbol?
OR
NOR
XOR
NOT
Which logic gate represented by this symbol?
OR
XNOR
XOR
NAND
Every formula needs to begin with...
=
()
;
FORMULA
A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________
COLUMN
ROW
RANGE
FORMULA
What symbol is used to multiply?
/
-
+
*
What symbol is used to divide?
*
+
/
-
What is written in cell D4?
4376
Doz
PDA
What is written in cell B3?
Ea
Quantity
Flash Drive
What is written in row 1?
The title
The descriptions
The unit prices
Select all correct cell references for the yellow cells
D3:F4
D3, E3, F3, D4, E4, F4
3D:4F
3D, 3E, 3F, 4D, 4E, 4F
A good password should...
Just have letters.
Be something others can guess.
Have a mixture of numbers and characters.
Contain 4 letters.
What will this function will do =SUM(A1:A10)
Add up something
Add up cells in the range A1 to A10
Sum up something
Sum up everything
You are at the yellow arrow, pointing in the direction indicated. How would you move to fill in the 2 black squares?
Straight, Turn right, Straight x 1, Fill Square, Straight x 2, Turn left, Straight x 1, Fill Square
Straight x 2, Turn right, Straight x 1, Fill Square, Straight x 2, Turn left, Straight x 1, Fill Square
Straight x 2, Turn right, Straight x 1, Fill Square, Straight x 2, Turn right, Straight x 1, Fill Square
Straight x 2, Turn right, Straight x 1, Fill Square, Straight x 2, Turn left, Straight x 2, Fill Square
Which of these algorithms will complete this maze?
Turn Left, Forward 1 space, Turn Right, Forward 6 spaces, Turn Right, Forward 3 Spaces, Turn Left, Forward 1 space
Turn Left, Forward 3 Spaces, Turn Right, Forward 1 Space, Turn Left, Forward 1 space, Turn Right, Forward 3 Spaces
Turn Right, Forward 2 Spaces, Turn Left, Forward 7 Spaces
How many cubes are in the 4th arrangement?
8 cubes
10 cubes
12 cubes
