### Overview

Have your learners ever wanted to know how to send and recieve secret messages? In this unit, students will develop their skills in encryption and decryption through stimulating practical exercises. Data encoding is the next focus - students learn about binary representation including the necessary skills required to encode and decode information and perform simple binary arithmetic. Through development of the modelling work previously studied, students then look over more advanced spreadsheet functions, and after a critical look at graphically representing sorting algorithms, students learn how to transcribe information from audio form to digital form in a single and multiple table database. Truly "advanced data"!

### Lesson by lesson key content

Lesson
number
Indicative content

Homework

1 Introducing encryption and the substitution cipher; send encrypted messages. Research into encryption methods.
2 Decoding messages encrypted with a matrix cipher; produce a quiz about substitution and matrix encryption; Multiple encryption practice.
3 Work with images and binary; create images and explore image resolution; work with images and binary; create, encode and decode images; work with numbers and binary; convert numbers to denary, and perform binary addition. Learning about ASCII.
4 Revise entering data, formulae and graphs; revise replication, autosum and If; complete models using absolute addressing. Absolute addressing.
5 Be the quickest at sorting data; in teams, use bubble and selection sort to sort numbers; use software programs to compare how good bubble and selection sorts are at sorting data; produce a brief report to explain your findings. There is no homework for this lesson.
6 Capture data in a single table (flat file) database; listen to the voice mails and record all orders in a multiple table database; use different operators to search a multiple table database. Researching SQL.
7 Challenge: Advanced Data Guide. There is no homework for this lesson.

### Computing curriculum content

• Understand several key algorithms that reflect computational thinking (for example, ones for sorting and searching);
• Use logical reasoning to compare the utility of alternative algorithms for the same problem;
• Understand how numbers can be represented in binary, and be able to carry out simple operations on binary numbers (for example, binary addition, and conversion between binary and decimal);
• Undertake creative projects that involve selecting, using, and combining multiple applications, preferably across a range of devices, to achieve challenging goals, including collecting and analysing data and meeting the needs of known users.

### Literacy curriculum content

• Learning new vocabulary;
• Writing for a wide range of purposes and audiences, including notes.

### Numeracy curriculum content

• Develop their mathematical knowledge, in part through solving problems and evaluating the outcomes, including multi-step problems;
• Begin to model situations mathematically and express the results using a range of formal mathematical representations;
• Model situations or procedures by translating them into algebraic expressions or formulae and by using graphs.