Font size
WorksheetsYear 7 Assessment: Online Safety and Spreadsheets
Total questions: 68
Worksheet time: 41mins
What can change how someone understands a post online?
When it was posted
How the person reading it feels
How many likes it has
All of the above
How can liking, sharing, or forwarding posts online affect someone’s reputation?
It doesn’t affect them
It can only make their reputation better
It can make their reputation better or worse
It always makes their reputation worse
What’s a good way to make search results more useful?
Use only one word in the search
Use tools like filters for size, type, or usage rights
Avoid using quotation marks
Search without checking spelling
What makes a strong password?
Short and easy to remember
Long, with a mix of letters, numbers, and symbols
The same as your username
A common word or phrase
What is two-factor authentication?
Using two different passwords for one account
A way to add extra security by needing a password and another step, like a code or fingerprint
Changing your password every two weeks
Using the same password for two accounts
Why should you back up your data?
To share it with others easily
To keep it safe in case your device is hacked
To free up space on your device
To make it available to everyone online
What is a benefit of online shopping for buyers?
Fewer choices
Risk of scams
Shopping from home with lots of choices
Higher delivery costs
What is a problem for businesses using online shopping?
Reaching customers around the world
Security risks like hacking
Lower running costs
Getting more customers
Which of these is an example of illegal online activity?
Buying a movie on a legal platform
Downloading movies from an illegal website (e.g. a 'pirate' website)
Watching free content on YouTube
Streaming a film on a paid service
What could happen if you use illegal streaming sites?
Better video quality
Free movies
Risk of hacking, viruses, and losing your personal data
No problems at all
What does the term ‘Internet of Things’ (IoT) mean?
A type of internet company
Devices like smart speakers and watches that connect to the internet
Only phones and computers
Websites with online shopping
What can help keep smart devices safe at home?
Leaving them on all the time
Using default passwords
Updating the software and using secure networks
Sharing device access with friends
What is plagiarism?
Making new ideas from research
Using someone else’s work or ideas without giving them credit
Sharing your work with others
Quoting a source correctly
Which of these is NOT plagiarism?
Copying text without saying where it’s from
Paraphrasing someone’s work and not giving them credit
Quoting a source correctly and giving credit to the owner of the work
Taking ideas from many places and saying they’re yours
Why is it important to use secure websites for online payments?
To save money
To protect personal and financial information
To make payments faster
To avoid typing your details
What should you do if you receive a suspicious email asking for personal information?
Reply with your details
Delete it immediately
Report it as spam and avoid clicking on any links
Share it with friends
Why is it risky to use the same password for multiple accounts?
It makes it easier to remember
If one account gets hacked, all your accounts could be at risk
It takes longer to log in
It’s harder to forget
What is a benefit of using password managers?
They make passwords easier to guess
They help you use unique passwords for each account
They share passwords with your friends
They create shorter passwords
How can you identify if a website is secure?
It loads very quickly
It has a padlock symbol and starts with "https://"
It has lots of pictures
It has a long website name (URL)
What should you check before downloading an app?
If it has a fun name
The reviews, permissions, and if it’s from a trusted source
If your friends use it
If it’s free
Which of these passwords is the MOST secure?
FishDogBicycle10*
QWERTY
Password
123456
Which of these passwords is the LEAST secure?
123456
P@ssw0rd
S£cure4321
FishDogBicycle10
Choose an action from the list that you are allowed to do in the computing lab.
Log in using a secure password
Swap a keyboard for another one
Drink water
Eat lunch
What kind of software is Excel?
Spreadsheet Software
Database Software
Word processing Software
In Excel, rows are labeled by
Letters
Numbers
Letters and numbers
In Excel, columns are labeled by
Letters
Numbers
Letters and numbers
What word matches this definition?"A line of cells going across the screen from side to side" (a)
sheet
formula
blank
cell
Which letter points to a cell?
A
B
C
D
E
Which letter points to two columns?
B
C
D
E
F
Which of the labels points to the fill colour?
B
C
D
E
F
What word does the cell B2 contain?
Hello
School
Excel
Lesson
What is the name of this part of a Spreadsheet?
Row
Column
Letters
Cell
Spreadsheet
What is a spreadsheet?
A sheet of paper.
A Computer Game.
An electronic document where data is organized in rows and columns.
A PowerPoint.
When you key a formula in a spreadsheet what do you key in first?
+
*
=
%
When would you use this option?
When changing font style
When formatting a table
When formatting numbers as currency
When changing font size
Which mathematical symbol is used to divide on a spreadsheet?
*
+
\
/
What data type is shown here: £34.50
Currency
Number
Text
Date
What is the name of this part of a Spreadsheet?
Row
Column
Letters
Cell
Spreadsheet
What is the Icon for MS Excel?
What is =B2 + C2 ?
2
10
1
11
What is =A2 - C1 ?
2
10
1
11
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
Which function would be used to calculate a total?
=MAX(B5:B10)
=SUM(B5:B10)
=AVGERAGE(B5:B10)
=MIN(B5:B10)
Organize these options into the right categories to explain the difference between primary and secondary data sources:
Collected by researcher
Collected by someone else, used by the researcher
Interview
Questionnaire
Takes more time and effort
Data is exactly what researcher requires
Internet Research
Book Research
Quick and easy to collect
Data may not be exactly what the researcher wanted
Formatting means changing the way something
smells
sounds
works
What does the SUM function in a spreadsheet do?
Adds a range of cells together.
Subtracts one cell from another.
Finds the highest value in a range.
Multiplies two cells together.
What does the COUNTA function tell you?
The average
The largest value
The number of non-blank cells
The number of As
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Because bar charts are taught early and so everyone understands them.
Because they don't require you to enter any formula.
Because the data is presented in a more visual way.
What symbol is used to make a cell reference absolute?
Dollar $
Exclamation mark !
Ampersand &
Colon :
What does "Conditional Formatting" mean?
Changing the background and borders
Changing the font and text colour
Changing how some cells look based on a rule e.g. a condition.
Hiding some data in the spreadsheet
Choose the correct way of sorting numbers in a spreadsheet?
Sorting by text
Sorting by ascending and
descending order
Sorting by symbols
Sorting by alphabet
You are creating a spreadsheet to calculate the cost of a party. You want to know how much you will spend on food. Why is it better to use a formula rather than working out the total yourself?
It will make it easier if you want to rearrange your spreadsheet
A formula will instantly calculate the change in cost if you update the price of the food
The spreadsheet will look tidier if your use a formula
It is always faster to calculate the answer in your head, you should not use a formula.
It is possible to automatically change how a cell looks based on the contents of the cell
TRUE
FALSE
Match the descriptions of data and information
Data DOESN'T
make sense
Information DOES
make sense
Data is
raw facts and figures
Information is
processed data with context
Conditional formatting changes a cell based on a condition being met. It has been applied to this spreadsheet.
What might have been the condition to fill the cell green?
If the maths score was >80
If the physics score was >80
If the maths score was >85
The correct formula to add up two(2) cells are?
=sum(C12 + C17)
=C12 + C17
C12 + C17
=sum(C12:C17)
The correct formula to add up more than two(2) cells are?
B12 +C12 + F12
=B12 + C12 + F12
=sum(B12+C12+F12)
=sum(B12:F12)
Formatting refers to?
The size of the cell only
The appearance of a document including font, colours, size and rotation and how data is displayed in cells
The way that formulae appear in cells
What word is used to describe re-organising the order of data in spreadsheets? e.g. ascending order, 1, 2, 3, and so on.
Search
Sort
Fill
Filter
Choose the correct word for the following: _______ are used to find all records matching a certain criteria at one place.
Sorting
Filters
AutoSum
