ACARA Digital Technologies Years 9–10 Crossword: Cyber Security Threats and Vulnerabilities (Modules 860–875)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 3. Counting how often each letter appears in ciphertext and matching the most common ones to common English letters like E, to work out a substitution cipher's key. Word 2 of: _________ ________ (8)
- 4. Returns True if the character ch is a letter, so a Caesar loop can shift letters and leave spaces and punctuation unchanged. ch.isupper() checks for capitals. Word 2 of: ch._______() (7)
- 6. Shifts the capital letter in A2 forward by the key in locked cell $B$1, wrapping Z back to A, and returns the encrypted letter. Copy it across so each cell encrypts one letter. Word 1 of: =____(MOD(CODE(A2)-65+$B$1,26)+65) (4)
- 7. ______("A") returns the number code of a character (65). ______(65) turns a number code back into its character ("A"). Ciphers use them to change letters to numbers and back. Word 1 of: ___() and ___() (3)
- 9. Word 1 of the term in 3 Across: _________ ________ (9)
Down
- 1. Decrypts by calling the same ______ function with the negative of the original shift. Shifting back by the same amount undoes the encryption, and % keeps the letters wrapping. Word 1 of: ______(______, -_____) (6)
- 2. A ______ that keeps the same letters but changes their order, like writing a message in a zigzag across rails and then reading each rail in turn. Word 2 of: transposition ______ (6)
- 5. Shifts an upper-case letter ch along the alphabet by ______, wrapping past Z back to A. A for loop applies it to each letter and builds the ciphertext with +=, skipping spaces. Word 5 of: ___((___(ch) - 65 + _____) % 26 + 65) (5)
- 8. Returns the remainder after division, so numbers wrap around. =MOD(27,26) gives 1, which is how a Caesar shift loops from Z back to A. Word 2 of: =MOD(______, divisor) (6)
- 10. Word 3 of the term in 7 Across: ___() and ___() (3)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 860–875
1C
2C
3A
N
A
L
Y
S
I
S
E
P
4I
S
A
L
P
H
A
5S
A
E
6C
H
A
R
7O
R
D
I
8N
9F
R
E
Q
U
E
N
10C
Y
T
M
H
B
R
E
R
Across
3ANALYSIS — Counting how often each letter appears in ciphertext and matching the most common ones to common English letters like E, to work out a substitution cipher's key. Word 2 of: _________ ________
4ISALPHA — Returns True if the character ch is a letter, so a Caesar loop can shift letters and leave spaces and punctuation unchanged. ch.isupper() checks for capitals. Word 2 of: ch._______()
6CHAR — Shifts the capital letter in A2 forward by the key in locked cell $B$1, wrapping Z back to A, and returns the encrypted letter. Copy it across so each cell encrypts one letter. Word 1 of: =____(MOD(CODE(A2)-65+$B$1,26)+65)
7ORD — ______("A") returns the number code of a character (65). ______(65) turns a number code back into its character ("A"). Ciphers use them to change letters to numbers and back. Word 1 of: ___() and ___()
9FREQUENCY — Word 1 of the term in 3 Across: _________ ________
Down
1CAESAR — Decrypts by calling the same ______ function with the negative of the original shift. Shifting back by the same amount undoes the encryption, and % keeps the letters wrapping. Word 1 of: ______(______, -_____)
2CIPHER — A ______ that keeps the same letters but changes their order, like writing a message in a zigzag across rails and then reading each rail in turn. Word 2 of: transposition ______
5SHIFT — Shifts an upper-case letter ch along the alphabet by ______, wrapping past Z back to A. A for loop applies it to each letter and builds the ciphertext with +=, skipping spaces. Word 5 of: ___((___(ch) - 65 + _____) % 26 + 65)
8NUMBER — Returns the remainder after division, so numbers wrap around. =MOD(27,26) gives 1, which is how a Caesar shift loops from Z back to A. Word 2 of: =MOD(______, divisor)
10CHR — Word 3 of the term in 7 Across: ___() and ___()