Year 9 Computing
Binary gets a shorthand and text turns out to be numbers all along. Networks come apart into shapes and boxes that each do one job, a spreadsheet learns functions and formulas that can be copied without breaking, and programs grow structure: indented blocks, loops inside loops, and blocks of lines given a name so they can be used again.
Print the whole term as one worksheet pack →Numbers and Codes
Networks in More Detail
- The boxes that make a network workLesson
Work out what a hub, a switch, a router, a modem and an access point each do, and choose the one a job needs.
- The shapes a network is built inLesson
Work out how much cable a bus, star, ring or mesh needs, and what a single break costs each of them.
- Addresses and names on a networkLesson
Read a machine's address, work out which machines share a network, and say what turns a name into an address.
Spreadsheets that Calculate
- Spreadsheet functionsLesson
Work out what SUM, AVERAGE, MAX, MIN, COUNT and IF show for a sheet you are given.
- Copying formulas, and references that stay putLesson
Work out what a formula points at once it has been copied, and use a dollar sign to stop a reference moving.
- Charts from a spreadsheetLesson
Choose the kind of chart a set of numbers needs, and read amounts and shares off the chart that results.
Programs with Structure
- Loops that countLesson
Work out what values a counting loop's variable takes, and how many times its body runs.
- Blocks and indentationLesson
Read a program's indentation to say which lines belong to which block, and how often each line runs.
- Loops inside loopsLesson
Work out how many times the body of a loop inside another loop runs, and in what order the two counters change.
- Procedures, and calling themLesson
Read a program that gives a block of lines a name, and say what runs, when, and how many times.
- Procedures that take values and give one backLesson
Read a procedure that is handed values to work on, and work out what a call to it gives.