WorksheetsYear 7 Q3 practice quiz
Total questions: 115
Worksheet time: 1hrs 9mins
What is circled in red?
The computer's name.
Search Bar.
URL/Address.
Your teacher's address.
What does the 'Back Arrow' (circled in red) do?
Takes you back to the last page you visited.
Takes you back to the desktop.
Takes you back in time.
Takes you back to the classroom.
What is circled in red?
Tabs that allow me to keep multiple webpages open simultaneously.
A list of all the websites I have visited.
The address bar/URL.
Other programs on my computer.
What does the "Refresh Button" do?
Takes you back to the beginning.
Protects you from harmful webpages.
Reloads the page you are on if the page was not functioning correctly.
Closes the internet.
How can I improve my search?
Use fewer keywords.
Include 'and' or 'or' with my keywords and use advanced search settings.
Search again
Who needs better results?
Select all the web browsers from the list.
Microsoft
Mozilla Firefox
Yahoo
Google Chrome
Internet Explorer
What do search engines use to keep a record of resources located on the World Wide Web?
indexes
links
joins
records
Please select 2:
The process of creating an index involves using a piece of software called...
Spider
Web Crawler
Indexer
Search Bot
What information does a web crawler NOT record about a web page?
URL
Content
Last Updated
Quality (Credibility)
Usefulness
In PageRank, how is the importance of a web page determined?
By the number of outbound links to other pages
By the number of inbound links from other pages
What is a search engine?
System to use internet
System designed to search for information on the World Wide Web
System to send and receive emails
System for internet connectivity
What is Google?
A secondary source
A search engine
An operating system
A word processing software
Give an example of a search engine.
Gmail
What should I search for if I am trying to find the definition of the word 'computer'?
dictionary computer
meaning computer
computer word meaning
define computer
Internet browsers and search engines are the same.
False
True
How do search engines find the websites that they index?
You have to submit your website.
They search the web.
They get a list from the government.
They use spiders to move from link to link, finding pages.
Which operator is used to ensure a word is not included?
+
-
" "
OR
What are the individual rectangles on a worksheet called?
Rows
Columns
Cells
Formula
A vertical line of cells in a spreadsheet is a what?
Row
Column
A horizontal line of cells in a spreadsheet is a what?
Row
Column
How are columns labelled on a worksheet?
Letters
Numbers
Symbols
How are rows labelled on a worksheet?
Letters
Numbers
If you wanted to change the colour of the text inside a cell, which tool would you use?
Text colour
Fill colour
Borders
Bold
If you wanted one cell or a number of cells to stand out from the rest which tool could you use?
Bold
Fill Colour
Currency
Borders
If you wanted to change the size of the text inside a cell which tool would you use?
Cell width
Cell height
Text colour
Font size
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What do all formulae start with in a spreadsheet?
+
/
*
=
Which symbol would you use if you are adding the values in cells together?
/
-
+
=
Which symbol would you use to divide the values in two cells?
/
-
*
=
Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?
/
-
*
=
Which symbol would you use to multiply the values in two cells together?
/
-
*
=
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MIN
MAX
AVERAGE
What is the cell reference of the cell with value Coca-Cola inside?
A3
3A
C5
D7
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?
Item
Price
Number Sold
Total
Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta
£1.25 times 12
C5*D5
=C5*D5
Which of the following formulas will work when typed into a cell in Excel?
£0.65 times 23
C10*D10
=C10*D10
=C10xD10
To create an absolute cell reference ___________ sign is used before the parts of formula.
#
$
*
=
A type to cell reference that does not change when copied or filled is called
Cell reference
Absolute cell reference
Relative cell reference
A cell reference that changes when copied is called
Cell reference
Absolute cell reference
Relative cell reference
Which of these formulas uses absolute cell references?
=A25*B12
What is the most popular form of transportation?
walk
cycle
car
bus
taxi
What proportion of people get to work by car?
half
a quarter
a third
three-quarters
an eighth
Do people who taxi or bus combined make more than half of the responses?
yes
no
These are responses to a school trip survey. Which is the most popular choice?
activity centre
wildlife park
museum of natural history
These are responses to a school trip survey. What fraction of students wanted to visit the museum?
a quarter
a half
a third
all of them
Do the students who want to visit the museum and wildlife park combined make up more than half of results?
no
yes
Two schools surveyed students about what they wanted to recycle. Which school decided on plastic bottles?
School A
School B
Sarah asked people what day was best for a party. Which choice did most of her friends choose?
Sunday
Friday
Thursday
Saturday
A tally of cars driving to a school had these results. How many cars contained more than one person?
3
5
8
9
A tally of cars driving to a school had these results. Which was the lowest result?
1
2
3
4
A tally of cars driving to a school had these results. How many people arrived alone?
6
3
5
1
What is the lowest calorie combo meal?
Chocolate muffin and cucumber sandwich
Cheese & ham sandwich and Victoria sponge
Cucumber sandwich and Bakewell tart
Coronation chicken sandwich and Bakewell tart
What is the highest calorie combo meal?
Chocolate muffin and cucumber sandwich
Cheese & ham sandwich and Victoria sponge
Cucumber sandwich and Bakewell tart
Coronation chicken sandwich and chocolate muffin
A balanced lunch should be under 400 calories. If you had a cucumber sandwich, which cake should you not have to stay under this number?
Victoria sponge
Bakewell tart
Chocolate muffin
A survey of class pets showed these results. Which two types of pet are most popular?
cat and fish
dog and hamster
cat and dog
rabbit and dog
What part of a chart is "Types of pets"?
X axis label
Y axis label
title
data labels
What essential component is this chart missing?
X axis label
Y axis label
title
categories
What essential component is this chart missing?
X axis label
Y axis label
title
data labels
What is the most popular flavour of ice cream?
toffee
strawberry
mint
vanilla
chocolate
What is the least popular flavour of ice cream?
toffee
strawberry
mint
vanilla
chocolate
Which two flavours were picked by 8 children in total?
toffee and strawberry
vanilla and strawberry
chocolate and toffee
mint and toffee
vanilla and chocolate
Is the Y axis vertical or horizontal?
horizontal
vertical
On which day was the temperature 26 degrees?
Tuesday
Monday
Wednesday
Saturday
Liam has gathered data about the noise levels in his garden overnight. What kind of chart or graph would work best for this?
pie chart
line graph
bar chart
At what time is Emily's house at its coldest?
9am
3pm
12pm
5pm
Fake news is...
Always sensational, spread on the Internet only, not real stories
Often sensational, not real, spread as a joke, for money or political reasons
Stories, jokes, information told online for financial purposes
News which is not true, told by journalists and copied by million other users
The phrase FAKE NEWS became the phrase of the year in...
2017
2007
2014
2004
Real news...
makes strong emotions
presents facts
is all about manipulation
informs
When people spread false information because they simply don't know, but they don't want to hurt anybody, they spread...
uninformation
iminformation
disinformation
misinformation
Is this fake news?
yes
no
is this fake news?
yes
no
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.
What are the benefits of talking with people you've only met online?
They may give you helpful advice
They may not be who they say they are
You can learn from someone who lives in a different place and has different experiences
They may say things that are inappropriate or mean
Which ones are examples of private information. Choose 2 answers.
First Name.
Email address.
Phone Number.
Country you live in.
Is this website safe or unsafe?
safe
unsafe
True or False?
You can have both a positive and negative digital footprint.
True.
False.
How can you avoid plagiarism?
Make sure you don't get caught
Make sure you remove any highlighting so that you don't get found out
Make sure that you change the title
Make sure that you always rewrite in your own words and cite your sources
What is 'phishing'?
Trying to catch a fish
Sending messages to steal personal details
Software that causes computer failure
A website where you can input information
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.
How does being SMART on the internet help us?
It means we can be better researchers and find reliable answers on the internet.
It means we can protect our identity and stop ourselves from being cyberbullied.
It means that we won't get into trouble and our parents will completely trust us to do what is right online.
You receive an email about your Minecraft account. It says you need to update your password. What do you do?
Click on the link in the email to update your password.
Don't reply because it is probably a hacker trying to get your private information.
Reply and tell them you are blocking the address because this is a scam.
Ignore the email because you aren't having any problems with your account.
What is a virus?
A program that makes the user feel unwell
A program which replicates itself and spreads to other computers via attachments
A program that stops a computer from working
You are playing minecraft when a person who says they go to your school joins the game and starts chatting with you. What do you do?
Keep playing and ignore the chat box and the message.
Hop off Minecraft straight away and go tell your parents about the message.
Say hi and start chatting.
Say hi and keep playing but ignore any other messages that come through.
Which of the following helps to safeguard against phishing?
A firewall
Not following links from an email
Anti-virus software
What is a troll?
A person who leaves distasteful messages on someone's social media account
Someone who sends a virus
Someone who spies on a computer
Who can you share your password with?
Your friends.
Nobody - you should keep them to yourself.
Your family.
Your teacher.
Which ones are examples of personal information. Choose 2 answers.
Hobbies.
Full Name.
Favourite Food.
School.
Which of the following is a way to help keep a computer free of malware?
A firewall
A filter
Not opening emails from unknown or unfamiliar sources
What is a privacy policy?
It is a long, boring document that explains the privacy laws for that country.
It is a document on a website or app that tells you what kind of info they are collecting and how they will use it.
It is an app on your phone that explains how to keep your personal information private.
What is a digital footprint?
Everything you do and everywhere you go on your computer?
The trail of websites you visit on the internet.
Everything you do and everywhere you go on the internet.
1101 to decimal
15
11
12
13
1111 to decimal
15
11
12
13
16 to binary
10000
1111
1000
111
8 to binary
10000
1111
1000
111
28 to binary
11100
11001
10011
00111
64 to binary
1000 0000
0100 0000
0010 0000
0001 0000
16 to binary
1000 0000
0100 0000
0010 0000
0001 0000
Computers store all data using...
Binary
Hexadecimal
Denary
Octal
A byte is made up of how many binary digits?
8
4
6
12
How many bits make a byte?
2
4
8
16
