ACARA 9-10 Digital Technologies: Coding ciphers in spreadsheets and Python
Students build Caesar, Vigenere and XOR ciphers using spreadsheet formulas and Python code.
One content description (AC9TDI10K01) from the full ACARA Digital Technologies Years 9–10 — Cyber Security Threats and Vulnerabilities journey. All 13 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (13)
1
CODE and CHAR functions in a spreadsheet
2
The MOD function in a spreadsheet
3
Encrypting a letter with a Caesar formula in a spreadsheet
4
Decrypting a Caesar cipher in a spreadsheet
5
For Loops
6
ord() and chr() in Python
7
More Arithmetic
8
Testing letters with isalpha() and isupper()
9
Encrypting a message with a Caesar loop in Python
10
Decrypting a Caesar cipher in Python
11
Brute-forcing a Caesar cipher in Python
12
Vigenere cipher in Python
13
The XOR cipher
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →