Cryptography
Page 1
Year 7 – Lesson 1 - HOMEWORK TASK
Make sure that you don’t cut corners – one “error” on purpose has
been added, to check that you decipher each message fully!
Plaintext A B C D E F G H I J K L M
Ciphertext B C D E F G H I J K L M N
Plaintext N O P Q R S T U V W X Y Z
Ciphertext O P Q R S T U V W X Y Z A
1. Using the cipher text above, encode the following message:
SOMETIMES IT IS IMPORTANT THAT MESSAGES ARE KEPT
S E C R E T.
TPNFUJNFT JU JT JNQPSUBOU UIBU NFTTBHFT BSF LFQU
IN TIMES OF W A R, SENDING SECRET MESSAGES CAN BE
JO UJNFT PG XBS TFOEJOH TFDSFU NFTTBHFT DBO CF
A MATTER OF LIFE OR D E A T H.
B NBUUFS PG MJGF PS EFBUI
2. Using the same cipher text table above, decode the following
message:
NFFU ZPV BU UIF CBOL BU GJUF QN
Meet you at the bank at fite pm
Says fite, I think this was the “error” and it was meant to be five
instead.
Page 2
REMEMBER – NOW WRITE HOW THIS WORK MEETS YOUR TARGET ON THE NEXT PAGE
Page 3
Year 7 – Lesson 2 - HOMEWORK TASK
Discuss how Spreadsheets can be used to help encipher and decipher messages.
Discuss specific examples (such as used in the previous homework) and how
effective these techniques are. What benefits and what drawbacks are there of
using Spreadsheets for cipher breaking?
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
Page 4
REMEMBER – NOW WRITE HOW THIS WORK MEETS YOUR TARGET ON THE NEXT PAGE
Page 5
Year 7 – Lesson 3 - HOMEWORK TASK
Suggest what each of the following spreadsheet functions does, say what it is
used for and who would use them (saying what for).
What is this
What does Who would
Formula formula used Why would
this formula use this
Name for? they use it?
do? formula?
MAX
MIN
AVERAGE
SUM
COUNT
CODE
Page 6
REMEMBER – NOW WRITE HOW THIS WORK MEETS YOUR TARGET ON THE NEXT PAGE
Page 7
Year 7 – Lesson 4 - HOMEWORK TASK
Discuss the following functions and how they could be used in a Spreadsheet
created for cipher breaking.
MAX, MIN, AVERAGE, SUM, COUNT, CODE, VLOOKUP, IF
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
Page 8
REMEMBER – NOW WRITE HOW THIS WORK MEETS YOUR TARGET ON THE NEXT PAGE
Page 9
Year 7 – Lesson 5 - HOMEWORK TASK
List five different places which could use ciphers and explain why
Someone / Place who could use Why would they use them?
codes
Page 10
REMEMBER – NOW WRITE HOW THIS WORK MEETS YOUR TARGET ON THE NEXT PAGE
Page 11
