Font size
WorksheetsY7 Q4: Digital literacy
Total questions: 80
Worksheet time: 40mins
Generally, when you receive an email, it will appear in your _________.
Calendar
Message pane
Compose pane
Inbox
Identify the correctly written email address below:
jane at gmail dot com
jane@gmail.com
jane.gmail@com
jane@gmail
The ________ is a brief description of what the email is about.
Subject
forward
attachment
recipient
If you want to share an email you've received, you can ________ it.
forward
archive
reply
________ is another term for junk email.
Attachment
Malware
Bcc
Spam
The person sending the email is called the...
Sender
Recipient
Identify the poor netiquette in this message
Miss
Please could you check if I left my jumper in your classroom?
Thank you
Katherine Jameson, 7H
Missing capital letters
Rudely written
No polite greeting
Not enough detail at the end
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
