WorksheetsManaging Data
Total questions: 72
Worksheet time: 36mins
Based on the explanation of physical (paper) vs digital databases, select one advantage of paper and one advantage of digital.
Paper records work without electricity or devices.
Digital databases allow quick searching and sorting.
Paper records are the fastest way to search and organize large sets of data.
Digital databases do not require any devices or internet to use.
According to the comparison of paper and digital records, what is one risk of paper records?
They can be lost or damaged by water or fire.
They require complex passwords to open.
They cannot be read without an internet connection.
They automatically back up themselves and overwrite data.
What is one security need for digital databases described in the notes?
Use passwords and make regular backups.
Keep all data only on one computer without copies.
Allow anyone to access the data to speed up sharing.
Avoid using any authentication to reduce login time.
Which option is better for a school with many students, and why?
Digital databases, because they store many records and are easy to search and share.
Paper records, because large data sets are easier to manage on paper.
Paper records, because they are faster to back up and sort than digital.
Digital databases, because they do not need devices or electricity.
When might paper records be preferred over digital?
During a school trip when no devices or internet are available.
When you need to sort thousands of records quickly and share results.
When you want multiple people to access and edit the same file online.
When you need automatic backups and easy duplication.
One advantage of digital forms is that they can check answers (validation) so entries are in the right format. Which option best states this advantage?
They can validate entries to reduce mistakes in formats
They always require internet to submit
They prevent users from seeing previous answers
They automatically translate answers into every language
One disadvantage of forms is that people may choose wrong options if choices are unclear. Which statement best describes this disadvantage?
Unclear options can lead to incorrect selections
Forms always save too slowly
Forms cannot collect multiple-choice answers
Users must always type free responses
What form element reduces typing errors for fixed answers by letting users pick an option instead of typing free text?
Drop-down lists or radio buttons
Long text boxes
File upload fields
Freehand drawing areas
How can forms protect privacy?
Ask only needed questions and store responses securely
Collect as much personal data as possible
Share responses with all users by default
Avoid using passwords or encryption
Give a good form design tip.
Use clear labels and short instructions
Use long paragraphs of directions
Hide labels to save space
Mix multiple fonts and colors in labels
Is "12/06/2015" data or information? Choose the best answer.
Data — it is a raw date value
Information — it explains a birthday
Information — it summarises attendance
Data — it calculates an average
Scores [45, 60, 75] are given. Which option is an example of information derived from this data?
Average score = 60; one student scored above 70
The numbers 45, 60, 75 listed in any order
Each student’s favorite color
A new test will be scheduled next week
Which is an example of data from a school register?
A student’s name and the dates they were present
"Most students arrived early"
"Ten students improved this term"
"Average attendance increased"
Which is an example of information from a school register?
Ten students were absent last week
Liam, Ava, Zoe
12/06/2015
Present/absent marks without totals
Why is information more useful than raw data?
It helps make decisions based on processed data
It always has more numbers than data
It is collected faster than data
It replaces the need to gather any data
Sort ages ascending: [11, 9, 12].
[9, 11, 12]
[11, 9, 12]
[12, 11, 9]
[11, 12, 9]
Sort names Z–A: [Ben, Alice, Cara].
[Cara, Ben, Alice]
[Alice, Ben, Cara]
[Ben, Cara, Alice]
[Ben, Alice, Cara]
Why sort data before answering some questions?
It organizes data for quick answers.
It increases all number values.
It hides errors in the data.
It renames fields automatically.
Sort scores descending: [56, 89, 72].
[89, 72, 56]
[56, 72, 89]
[72, 89, 56]
[56, 89, 72]
If you sort by surname, what changes?
The order uses last names instead of first names.
Only first names are shown.
Records are grouped by initials.
Only duplicate names are displayed.
Choose the appropriate data type for “Telephone number.”
Text
Number
Date
Boolean/Yes–No
Choose the appropriate data type for “Number of books borrowed.”
Number (integer)
Text
Date
Boolean/Yes–No
Choose the appropriate data type for “Enrolment date.”
Date
Text
Number
Boolean/Yes–No
Choose the appropriate data type for “Has permission slip?” (Yes/No).
Boolean/Yes–No
Text
Number
Date
Why not use Text for everything?
Text can’t be used easily in calculations or date functions and may cause errors.
Text makes all calculations faster and more accurate.
Text automatically corrects dates and numbers.
Text uses less storage than numbers for calculations.
Worked example: After filtering the Scores table for Score > 80 and counting the records, how many students were there?
5 students
6 students
7 students
8 students
In a students database, you need to answer “How many students are in Year 5?”. Which step best completes this task after selecting records where Year = 5?
Count the number of rows in the filtered result
Sort the Score column descending and read the top row
Compute the sum of all ages in the filter
Find the maximum value in the Age column
In a students spreadsheet, you must find which student has the highest score. What is the most effective sequence to do this?
Sort the Score column in descending order and read the first row
Filter Year = 5 and count rows
Average the Score column and select any name
Sort the Name column alphabetically and choose the last row
To list all students who have allergies recorded in the Allergies field, which filter should you apply before reading the Name column?
Allergies is not empty
Score is greater than 0
Year is blank
Name contains the word “Allergy”
You want the class’s overall score statistic from a Score column. Which function directly answers “Average score of the class?”
Average on the Score column
Sum on the Score column
Maximum on the Score column
Count of records in the table
You need to find all students whose last name is Smith using a Surname column. Which filter best fits this exact-match search?
Surname equals Smith
Surname contains Smi
Surname does not equal Smith
Surname starts with S
In the row [Name: Lily | Score: 85], which field does the value 85 belong to?
Score
Name
Age
Class
What is a record in a students table?
One full row of fields for a single student
A single number stored in any cell
The column header that names a field
All rows for the entire class
Which of the following is an example of data (a single value inside a field)?
12
Age column
Student table
Class list
How many fields are in the set [Name, DOB, Paid]?
2
3
4
5
If a table has 30 rows, how many records does it contain?
10
20
30
60
When you browse a website on your laptop, is your laptop acting as a client or a server?
Client
Server
Which of the following is an example of a server?
A computer that stores and sends emails for many users
A smartphone running a web browser to request pages
A keyboard connected to a PC
A monitor displaying images
Can one computer be both a server and a client?
Yes, depending on the software and tasks it runs
No, it can only be one role at a time
Only if it is connected to the internet by fiber
Only in large data centers
When many clients connect to a server at the same time, what does the server do?
It handles many requests and may need more power or resources
It shuts down to prevent overload
It becomes a client and stops serving files
It stops serving files and only stores data locally
Why do schools use servers?
To store shared files, host school websites, and manage accounts
To replace all student computers with one machine
To slow down internet traffic for security
To eliminate the need for passwords entirely
Is email part of the World Wide Web (WWW)?
No—email uses the internet but is a separate service
Yes—email is a type of web page on the WWW
Only when used on smartphones
Only if accessed through a web browser
Which statement best describes the difference between the Internet and the World Wide Web (WWW)?
The Internet is the global network of connected computers and devices; the WWW is the set of websites accessed over it
The WWW is the physical network; the Internet is the collection of web pages
They are identical terms for the same thing
The Internet exists only in browsers; the WWW is for email and file transfer
Which of the following is an internet service besides the World Wide Web?
Paper mail
Desktop wallpaper
Handwriting practice
Can the Internet be used without the World Wide Web?
Yes—for example, for email or file transfer
No—the internet only works through the WWW
Only for streaming video
Only on school networks
Which activity shows both the Web and the Internet working together?
Typing a search into a web browser to find websites
Printing a document on a local printer
Editing a photo offline
Using a calculator app without network access
Which connection is usually faster for a desktop computer: Wi‑Fi or Ethernet?
Wi‑Fi
Ethernet
Mobile data
Dial‑up
Which connection is generally better for a phone because it allows mobility without cables?
Wi‑Fi
Ethernet
Fiber‑optic cable
Coaxial cable
How can a school make its Wi‑Fi more secure?
Use strong encryption such as WPA2/WPA3 and a strong password
Leave the network open for easy access
Use a short, simple password with no encryption
Turn off encryption to increase speed
What is one downside of using Ethernet for network access?
It limits mobility because devices are tied to cables
It suffers more interference than Wi‑Fi
It drains a device’s battery faster than Wi‑Fi
It only works within a few meters of the router
When should a school choose Ethernet over Wi‑Fi?
For computers that need stable, fast connections such as exam or server machines
When students need to walk around with tablets during class
For short‑term guest access with minimal setup
When minimizing cabling in a temporary lab is the priority
What is one effect of a network failure at school?
Students can’t access online class materials
Printers work faster than usual
Internet speeds increase for everyone
Devices gain extra local storage
How could a network failure affect safety systems in a building?
Security cameras or alarms might not send alerts
Fire extinguishers stop spraying
Classroom doors automatically unlock for safety
The PA system gets louder to warn people
What is the appropriate action if the school network fails during class?
Report it to the teacher or IT staff and follow the backup plan using offline tasks
Keep refreshing webpages and ignore the issue
Open the network closet and try to fix the hardware yourself
Use a personal hotspot to share internet without permission
Which of the following is a likely cause of a network failure?
Router or server hardware failure
Low classroom temperature
Too many posters on the walls
Using pencils instead of pens
How can schools reduce the impact of failures?
Rely only on a single internet connection
Keep backups, spare hardware, and offline copies of important files
Disable all security features to increase speed
Allow students to share passwords to access files
Why do websites use HTTPS?
To encrypt data between your browser and the website so messages are private
To make pages load advertisements faster
To track users across different sites
To avoid using domain names
Where is end‑to‑end encryption commonly used?
News websites
Messaging apps like Signal or WhatsApp
Public Wi‑Fi login portals
Online maps
Give one reason to encrypt stored school records.
To make files easier to copy
To keep student personal data safe if devices are stolen
To share grades publicly
To reduce storage space
How does encryption help on public Wi‑Fi?
It speeds up video streaming
It keeps your data safe from people trying to read it on the same network by scrambling traffic
It disables the Wi‑Fi password requirement
It blocks all websites that use images
What is a simple rule to stay safe with encryption?
Use sites that show HTTPS and use strong passwords
Share your password with a friend in case you forget it
Only use HTTP so pages load quickly
Turn off device updates to prevent changes
In a Caesar cipher, each letter is shifted by a fixed number (key) through the alphabet. Encode the word CAT using key 2.
EAV
ECV
DBG
BDU
In a Caesar cipher, to decode you shift letters back by the same key. Decode KHOOR using key 3.
HELLO
JELLO
WORLD
APPLE
In a Caesar cipher where the key equals 1, encode ZOO.
APP
YPP
ZPP
AOO
In the Caesar cipher, what is the key?
The total number of letters in the message
The number of letter positions shifted
The first letter of the alphabet
A random symbol inserted between words
Why is a Caesar cipher described as not very secure?
It has few keys and a simple pattern that is easy to break
It uses random symbols that change every word
It requires complex mathematics that most people cannot use
It changes the key for every single letter automatically
Pigpen cipher explanation: A substitution cipher using simple shapes (grid and X) to represent letters. Each letter maps to a symbol. Based on this, which statement best describes how the pigpen cipher works?
Letters are replaced by symbols made from a grid and X shapes
Letters are shifted forward in the alphabet by a fixed number
Words are rearranged into different orders to hide meaning
Numbers are assigned to each letter and then added together
Worked example: With a pigpen key, the word DOG is drawn using the symbols matching D, O, and G. What must you do to encode DOG using the pigpen cipher?
Draw the specific pigpen symbols that map to D, O, and G
Shift each letter three places forward in the alphabet
Replace each letter with its position number and add them
Reverse the order of the letters and insert spaces
Practice: To encode a word with the pigpen cipher, what is required?
A pigpen key that maps each letter to a specific symbol
A Caesar shift number such as 3 or 5
A public and private encryption key pair
A keyword for a Vigenère table
Practice: Which is easier to write by hand for drawing secret notes?
Pigpen cipher
Caesar cipher
Both are equally easy by hand
Neither is practical by hand
Practice: Can the pigpen cipher be read by someone who does not have the key?
No, not without knowing the symbol mapping
Yes, it is readable without any key
Only if they know the Caesar shift number
Yes, because the shapes are self-explanatory
Practice: Historically, why might spies prefer simple ciphers like Caesar or pigpen?
They are simple and quick to use without devices
They require advanced computers to run
They are impossible for anyone to break
They depend on radio equipment to transmit keys
