Levels and Descriptors for Exercises


Level Descriptor text in red indicates coverage of the level in the exercise
In very broad terms: Level 4 exercises will map to Year 7 students
Level 5 exercises will map to Year 8 students
Level 6 and 7 exercises will map to Year 9 students
Readability scores are also available to help colleagues to map exercises to their teaching sets
  Exercise (Topic) Lev Cat CT Level Descriptor
1
What is an Algorithm?
(Algorithm and Programs)
4
Algo
AL
AB
Understand a key algorithm that reflects computational thinking: They understand and can describe what an algorithm is and give several examples.
2
Pseudocode
(Algorithm and Programs)
5
Algo
AL
AB
Understand a key algorithm that reflects computational thinking: They understand that an algorithm can be defined using pseudocode or flow charts, and that algorithms consist of combinations of simple constructs.
3
Flow Charts
(Algorithm and Programs)
5
Algo
AL
AB
Understand a key algorithm that reflects computational thinking: They understand that an algortihm can be defined using pseudocode or flow charts, and that algorithms consist of combinations of simple constructs.
4
Designing Algorithms
(Algorithm and Programs)
5
Algo
AL
AB
EV
Understand a key algorithm that reflects computational thinking: They understand how to design and test simple algorithms.
5
Data Structures
(insertion sort prep.)

(Algorithm and Programs)
5
Algo
AL
AB
EV
Understand a key algorithm that reflects computational thinking: They understand the flow of data in an insertion sort algorithm.
6
Tracing an Algorithm
(insertion sort)

(Algorithm and Programs)
6
Algo
AL
AB
EV
Understand a key algorithm that reflects computational thinking: They are able to understand the pseudocode for an insertion sort. They are able to use a trace table to show the changing values of variables for an insertion sort.
7
Coding an Algorithm
((insertion in Python)

(Algorithm and Programs)
7
Algo
AL
AB
EV
Use a textual programming language to solve a computational problem; make appropriate use of a list data structure; develop a program that uses a procedure or function: They are able to use, explore and modify the given code for an insertion sort to make it more efficient.
8
Bubble Sort
(Algorithm and Programs)
6
Algo
AL
AB
EV
Understand a key algorithm that reflects computational thinking: They are able to understand the flow of data for a bubble sort algorithm. They are able to use a graphical representation to show the changing values of variables for a bubble sort.
9
Quick Sort
(Algorithm and Programs)
6
Algo
AL
AB
EV
Understand a key algorithm that reflects computational thinking: They are able to understand the flow of data for a quick sort algorithm. They are able to use a graphical representation to show the changing values of variables for a quick sort.
10
Comparing Sorting Algorithms
(Algorithm and Programs)
7
Algo
AL
AB
DE
EV
Understand several key algorithms that reflect computational thinking; use logical reasoning to compare the utility of alternative algorithms for the same problem.
Use a textual programming language to solve a computational problem; make appropriate use of a list data structure; develop a program that uses a procedure or function: They are able to use, explore and modify the given code for a program that compares the efficiency of bubble sort, insertion sort and quick sort with both small and large data sets.
11
Micro:bit and The Moon Dust Aliens 1-3
(BBC Microbit)
12
Microbit 1 - SOS Beeps
(BBC Microbit)
4
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They explore the use of a simple repeat loop to produce an audio SOS distress signal. This is implemented using the Microsoft Block Editor.
13
Microbit 2 - SOS Lights
(BBC Microbit)
4
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They explore the use of a series of repeat loops to produce a visual SOS distress signal. This is implemented using the Microsoft Block Editor.
14
Microbit 3 - Compass 1
(BBC Microbit)
4
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They create a simulation of a buggy ride across the Moon on a straight line bearing. This is implemented using the Microsoft Block Editor.
15
Microbit 4 - Compass 2
(BBC Microbit)
4
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They create a simulation of a buggy ride across the Moon using three compass bearings. This is implemented using the Microsoft Block Editor.
16
Microbit 5 - Buggy Race 1
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to control a sprite in preparation for a simulated buggy race. This is implemented using the Microsoft Block Editor.
17
Microbit 6 - Buggy Race 2
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to debug a program to control a sprite in preparation for a simulated buggy race. This is implemented using the Microsoft Block Editor.
18
Microbit 7 - Buggy Race 3
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to initialise a program for a simulated buggy race. This is implemented using the Microsoft Block Editor.
19
Microbit 8 - Buggy Race 4
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to develop a program for a simulated buggy race between two buggies. This is implemented using the Microsoft Block Editor.
20
Microbit 9 - Buggy Race 5
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to develop a program for a simulated buggy race between two buggies. This is implemented using the Microsoft Block Editor.
21
Microbit 10 - Thermostat 1
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to use image blocks on the BBC micro:bit in preparation for developing a program for a simulation of a thermostatically controlled heating system. This is implemented using the JavaScript Blocks Editor.
22
Microbit 11 - Thermostat 2
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to develop a program for a thermostatically controlled heating system. This is implemented using the JavaScript Blocks Editor.
23
Microbit 12 - Thermostat 3
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to use image blocks on the BBC micro:bit to develop a simulation for a thermostatically controlled heating and air conditioning system. This is implemented using the JavaScript Blocks Editor.
24
Microbit 13 - Radio 1
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to use the radio functions of the BBC micro:bit. They develop a program to transmit radio signals between two micro:bits. This is implemented using the JavaScript Blocks Editor.
25
Microbit 14 - Radio 2
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to use nested for loops. They develop a program to plot all the LEDs on a micro:bit. This is implemented using the JavaScript Blocks Editor.
26
Microbit 15 - Radio 3
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They learn how to use nested for loops in conjunction with an array of co-ordinates. They develop a program to conditionally plot some of the LEDs on a micro:bit. This is implemented using the JavaScript Blocks Editor.
27
Microbit 16 - Radio 4
(BBC Microbit)
5
Prog
AL
AB
EV
Use a graphical programming language to solve a computational problem: They build a program that uses an array of co-ordinates to transmit these data between two micro:bits. This is implemented using the JavaScript Blocks Editor. They go on to encode the transmission data using a hexadecimal cipher.
28
Number Bytes
(Bits and Bytes)
4
DataRep
AB
GE
Understand how numbers can be represented in binary, and be able to carry out simple operations on binary numbers: They compare denary numbers with binary numbers. They convert whole binary numbers to denary numbers.
29
Binary Addition 1
(Bits and Bytes)
5
DataRep
AB
GE
AL
Understand how numbers can be represented in binary, and be able to carry out addition on binary numbers:They add two simple binary numbers together.
30
Binary Addition 2
(Bits and Bytes)
5
DataRep
AB
GE
AL
Understand how adding binary numbers may result in overflow. Understand how the bit-size of a computer is related to the range of numbers that it can represent. They add several binary together and identify overflow situations. They determine the range of values for 8-bit and 16-bit computers.
31
Text Bytes
(Bits and Bytes)
5
DataRep
AB
GE
Understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits: They look at text representation using byte codes, and deduce related file sizes for the storage of textual data.
32
Picture Bytes
(Bits and Bytes)
5
DataRep
AB
GE
Understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits: They look at how images can be represented as pixels using multiple bytes per pixel, and deduce related file sizes for the storage of images.
33
Picture Bytes and
Compression

(Bits and Bytes)
5
DataRep
AB
GE
Understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits: They look at how and why images are often compressed. They look at the pros and cons of using lossy and lossless compression codecs.
34
Sound Bytes - 1
(Bits and Bytes)
5
DataRep
AB
GE
Understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits: They look at analogue and digital sound signals. They look at the need for for A-D and D-A convertors when working with sound using computers.
35
Sound Bytes - 2
(Bits and Bytes)
6
DataRep
AB
GE
AL
Understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits: They look at sound sampling rates and sound resolution. They use a model to determine the size of sound files by varying sampling rate, sound resolution and sound channels.
36
Data Capture for Surveys
(Charting Data)
4
Apps
DE
EV
Undertake creative projects ... including collecting and analysing data and meeting the needs of known users: They understand the need for care in framing questions when collecting information.
37
Analysing Survey Data
with Charts

(Charting Data)
4
Apps
DE
EV
Undertake creative projects including ... analysing data and meeting the needs of known users: They interpret their findings.
38
Showing Data Values on Charts
(Charting Data)
4
Apps
DE
EV
Create, re-use, revise and re-purpose digital artefacts design and usability: They use applications to present information in different forms. They show that they are aware of the intended audience.
39
Annotating Charts
(Charting Data)
4
Apps
DE
EV
Create, re-use, revise and re-purpose digital artefacts design and usability: They use applications to present information in different forms. They show that they are aware of the intended audience.
40
Introduction
(Computer Files)
4
CompSys
AB
Understand the ... software components that make up computer systems: They understand some basic differences between ASCII and non ASCII files.
41
ASCII
(Computer Files)
5
CompSys
AB
Understand the ... software components that make up computer systems: They develop an understanding of the ASCII character set, and can use it to decode binary ASCII characters.
42
Common File Types
(Computer Files)
6
CompSys
AB
EV
Understand the ... software components that make up computer systems: They develop an awareness of a wide range of ASCII and non ASCII file types. They are able to work with CSV data.
43
Organising Files
(Computer Files)
5
CompSys
AB
GE
DE
Understand the ... software components that make up computer systems: They develop an awareness of the importance of organising files, especially with reference to web sites.
44
Network Basics
(Computer Networks)
4
CompSys
AB
EV
Understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems: They understand how computers are linked together to form a network. They gain an insight into the benefits of networked environments.
45
Peer-to-Peer Networks
(Computer Networks)
5
CompSys
AB
EV
Understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems: They understand how computers are linked together to form peer-to-peer networks. They begin to develop an understanding of the pros and cons of peer-to-peer networking.
46
Client-Server Networks
(Computer Networks)
5
CompSys
AB
EV
Understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems: They begin to understand the kinds of network services that are provided in networked environments.
47
Introduction
(Control)
4
CompSys
AB
GE
Understand the hardware and software components that make up computer systems: They develop an awareness of the role of sensors in Control Technology.
48
Beginning Flowcharts
(Control)
4
Algo
AL
AB
GE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They use a flowchart to model the logic of a coffee making machine.
49
Controlling Lights
(Control)
4
Algo
AL
AB
GE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They use a flowchart to model the logic for controlling security lighting.
50
Level Crossing 1
(Control)
4
Algo
AL
AB
GE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They explore the problem of automated level crossings.
51
Level Crossing 2
(Control)
5
Algo
AL
AB
GE
Design and develop modular programs that use procedures or functions: They explore the development of subroutines for an automated level crossing system.
52
Level Crossing 3
(Control)
6
Algo
AL
AB
GE
Design and develop modular programs that use procedures or functions: They convert pseudocode, which uses subroutines, into a flowchart which models an automated level crossing system.
53
Primary Keys
(Database Construction)
4
Apps
DE
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of data records in a doctor's surgery.
54
Data Types
(Database Construction)
5
Apps
DE
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of of various data types and their respective storage requirements.
55
Databases
(Database Construction)
4
Apps
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of database views and the importance of well structured and ordered data.
56
Data Encoding
(Database Construction)
5
Apps
DE
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of the importance of encoding data in order to store and retrieve data efficiently.
57
Data Validation
(Database Construction)
5
Apps
AL
DE
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of the role of validation rules when setting up databases.
58
Data Verification
(Database Construction)
5
Apps
AL
DE
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of the need to verify data in order to ensure its accuracy.
59
Simple and Complex Searches
(Database Searching)
4
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They interrogate a simple database using AND and OR operators to extract appropriate data.
60
Searching for Properties
(Database Searching)
5
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They interrogate a property database using AND and OR operators to extract appropriate data.
61
Relational Operators (1)
(Database Searching)
4
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They use simple relational operators to interrogate a small database to extract appropriate data.
62
Relational Operators (2)
(Database Searching)
5
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They use compound relational operators to interrogate a small database to extract appropriate data.
63
Wild Card Searching
(Database Searching)
5
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They use wild card operators to interrogate a small database to extract appropriate data.
64
Database Reports
(Database Searching)
5
Apps
DE
GE
EV
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of well formatted data to produce compelling reports for an estate agents.
65
Database Sorting
(Database Searching)
6
Apps
AL
AB
GE
Undertake creative project including collecting and analysing data and meeting the needs of known users: They develop an understanding of the importance of sorting data into order - in order to make the data accessible to end users.
66
Must-Have Requirements
(Developing Evaluation Skills)
5
Eval
DE
EV
Undertake creative projects ... using ... applications... to achieve challenging goals... and meeting the needs of known users: They learn how to develop a requirements specification for a hat company's web site.
67
Success Criteria
(Developing Evaluation Skills)
5
Eval
DE
EV
Undertake creative projects ... using ... applications... to achieve challenging goals... and meeting the needs of known users: They learn how to develop success criteria based on a requirements specification for a hat company's web site.
68
Evaluate Diary
(Developing Evaluation Skills)
5
Eval
DE
EV
Undertake creative projects ... using ... applications... to achieve challenging goals... and meeting the needs of known users: They evaluate a diary based on a requirements specification and defined success criteria.
69
Evaluate Shopping Model
(Developing Evaluation Skills)
5
Eval
DE
EV
Undertake creative projects ... using ... applications... to achieve challenging goals... and meeting the needs of known users: They evaluate a shopping model based on a requirements specification and defined success criteria.
70
Evaluate Newsletter
(Developing Evaluation Skills)
5
Eval
DE
EV
Undertake creative projects ... using ... applications... to achieve challenging goals... and meeting the needs of known users: They evaluate a newsletter based on a requirements specification and defined success criteria.
71
Comparing Web Pages
with Printed Pages

(Developing Websites)
4
Apps
DE
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience: They modify a web page for use by a particular audience.
72
Basic HTML
(Developing Websites)
4
Apps
AL
AB
Create, re-use, revise and re-purpose digital artefacts for a given audience: They are introduced to HTML and make use of some basic HTML tags to mark up a poem.
73
Web Page Design-Consistency
(Developing Websites)
4
Apps
DE
GE
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to design and usability: They identify inconsistancies of design between two web pages from the same web site.
74
Responsible Web Publishing:
Copyright

(Developing Websites)
5
LegIss
EV
Use technology safely, respectfully, responsibly: They explore issues of copyright, especially with respect to copying from the Internet.
75
Responsible Web Publishing:
Plagiarism

(Developing Websites)
5
LegIss
EV
Use technology safely, respectfully, responsibly: They explore issues of plagiarism, especially with respect to using material from the Internet.
76
CSS 1
(Developing Websites)
5
AL
AB
EV
Understand the...software components that make up computer systems...: They develop an understanding of the structure of an HTML document. They begin to develop an understanding of how to style heading and paragraph tags.
77
CSS 2
(Developing Websites)
5
AL
AB
EV
Understand the...software components that make up computer systems...: They begin to develop an understanding of CSS inline styles. They apply a number of inline styles to paragraph tags.
78
CSS 3
(Developing Websites)
5
AL
AB
EV
Understand the...software components that make up computer systems...: They begin to develop an understanding of CSS internal styles. They are able to apply internal styles to paragraph tags.
79
CSS 4
(Developing Websites)
5
AL
AB
EV
Understand the...software components that make up computer systems...: They begin to develop an understanding of CSS external styles and how they may be used. They are able to understand and apply a number of external styles to format an HTML document.
80
Features
(DTP)
4
Apps
DE
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals, including ... meeting the needs of known users: They explore some of the features that are to be found in DTP programs.
81
Typefaces
(DTP)
5
Apps
DE
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They develop an understanding of type faces and fonts.
82
Fetch Execute Cycle 1
(Fetch Execute Cycle)
5
Prog
AL
GE
AB
Understand how instructions are stored and executed withing a computer system: They begin to develop a basic understanding of how computer programs are made up of lists of simple instructions.
83
Fetch Execute Cycle 2
(Fetch Execute Cycle)
5
Prog
AL
GE
AB
Understand how instructions are stored and executed withing a computer system: They begin to develop a basic understanding of the structure of a CPU. They begin to develop a basic understanding of the Fetch, Decode, Execute cycle.
84
Fetch Execute Cycle 3
(Fetch Execute Cycle)
5
Prog
AL
GE
AB
Understand how instructions are stored and executed withing a computer system: They begin to develop a deeper understanding of the Fetch, Decode, Execute cycle.
85
Introduction to Bitmap and
Vector Images

(Graphics)
4
DigiArt
DE
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They explore bit map and vector images and develop an awareness of pixels.
86
Working with Bitmap Tools
(Graphics)
5
DigiArt
DE
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They explore bit map selection tools and layers.
87
Modifying Bitmap Images
(Graphics)
6
DigiArt
DE
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They develop an awareness of what happens to bitmap images when they are resized.
88
Working with Vector Tools
(Graphics)
5
DigiArt
DE
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They explore the concepts of vector paths and points using the pen selection tool.
89
Modifying Vector Images
(Graphics)
6
DigiArt
DE
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They develop an awareness of what happens to vector shapes when they are combined using operations such as union and intersect.
90
Word Processing:
Formatting Text

(Handling Text)
4
Apps
AB
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They develop an understanding of the importance of well considered formatting to support good communication.
91
Writing Formal Letters
(Handling Text)
5
Apps
AL
AB
EV
Undertake creative projects that involve selecting, using ... applications to achieve challenging goals: They develop an understanding of some of the rules behind formal communication in a business environment.
92
Mail Merge
(Handling Text)
5
Apps
AL
AB
DE
EV
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals: They develop an understanding of the process of merging data from a database with a document to support business to customer communications.
93
Personalised Stories 1
(Handling Text)
5
Apps
AL
AB
DE
EV
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals: They develop an understanding of the process of merging data with a document to support a business process.
94
Personalised Stories 2
(Handling Text)
6
Apps
AL
AB
DE
EV
Undertake creative projects that involve selecting, using and combining multiple applications to achieve challenging goals: They develop an understanding of the process of merging data conditionally with a document to support a business process.
95
Keyboard Shortcuts
(Hardware)
6
CompSys
AL
AB
Understand the hardware and software components that make up computer systems, and how they communicate with one another: They develop an understanding of the efficient use of a keyboard to control applications.
96
Input/Output Devices
(Hardware)
5
CompSys
AB
Understand the hardware and software components that make up computer systems, and how they communicate with one another: They develop an understanding of the wide range of input/output devices that may be linked to computers.
97
Storage
(Hardware)
5
CompSys
AB
Understand the hardware and software components that make up computer systems: They develop an understanding of a wide range of storage devices and their capacities.
98
Ports
(Hardware)
5
CompSys
AB
Understand the hardware and software components that make up computer systems: They develop an understanding of the most common ports that are available to link external devices to computers.
99
People as Input Devices
(Hardware)
6
CompSys
AB
Understand the hardware and software components that make up computer systems, and how they communicate with one another: They develop an understanding of some of the ways that people can link to computers by using physical movement and gestures.
100
Repetitive Strain Injury
(Health and Safety)
5
HelSaf
EV
Understand a range of ways to use technology safely: They develop an understanding of how repetitive strain injuries may develop if they use computing devices without taking regular breaks.
101
Desks, Chairs and Cables
(Health and Safety)
5
HelSaf
EV
understand a range of ways to use technology safely: They develop an understanding of how desks, chairs and cables may be the source of accidents and or RSI when working with computers.
102
Using Monitors
(Health and Safety)
5
HelSaf
EV
understand a range of ways to use technology safely: They develop a basic understanding of how monitors work, and how best to use monitors without the risk of developing eye strain.
103
E-Safety
(Impact of Computing on Society)
5
HelSaf
DE
EV
Understand a range of ways to use technology safely ... and securely, including protecting their online identity and privacy: They develop an understanding of a range of potential threats when using the Internet, and how to deal with such threats.
104
Bullying
(Impact of Computing on Society)
4
HelSaf
EV
Understand a range of ways to use technology safely ... and know how to report concerns: They develop an understanding of how to deal with threats of bullying and intimidation within a school context.
105
Tools of our Times
(Impact of Computing on Society)
6
Apps
AB
EV
Undertake creative projects that involve selecting, using, and combining multiple applications ... to achieve challenging goals, including collecting and analysing data and meeting the needs of known users: They develop an understanding of a wide range of software tools and their uses.
106
Changing Working Patterns
(Impact of Computing on Society)
6
CompSys
AB
EV
Understand a range of ways to use technology safely: They develop an understanding of telecommuting and can discuss the pros and cons of telecommuting for individuals and for society.
107
Shops and Supermarkets
(Impact of Computing on Society)
6
CompSys
AB
EV
Understand a range of ways to use technology safely ... securely, including protecting their ... Privacy: They develop an understanding of the way that technology is used in supermarkets and how their private shopping habits are used by retailers.
108
The Data Protection Act
(Impact of Computing on Society)
6
LegIss
EV
Understand a range of ways to use technology safely ... including protecting their online identity and privacy ... and know how to report concerns: They develop an understanding of the Data Protection Act and how it protects the rights of living individuals.
109
Introduction
(Modelling)
4
Modl
AB
DE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems: They use a computer model to explore patterns and relationships.
110
Key Spreadsheet Features
(Modelling)
4
Modl
AB
Use and evaluate computational abstractions that model the state and behaviour of real-world problems: They use a computer model to explore patterns and relationships.
111
Building a Model: Holiday
(Modelling)
5
Modl
AB
DE
EV
Use and evaluate computational abstractions that model the state and behaviour of real-world problems: They explore the effects of changing the variables in a computer model.
112
The SUM Function
(Modelling)
5
Modl
AB
DE
EV
Use and evaluate computational abstractions that model the state and behaviour of real-world problems: They explore the effects of changing the variables in a computer model.
113
Building a Model: Birthday Party
(Modelling)
5
Modl
AB
DE
EV
Use and evaluate computational abstractions that model the state and behaviour of real-world problems: They explore the effects of changing the variables in a computer model.
114
Changing the Rules in a Model:
Medical Diagnosis

(Modelling)
6
Modl
AB
DE
EV
Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems: They use a computer model to make predictions and vary the rules within the model.
115
Common Spreadsheet Functions
(Modelling)
6
Modl
AB
Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems: They use a computer model to make predictions and vary the rules within the model.
116
The IF Function
(Modelling)
6
Modl
AB
DE
EV
Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems: They use a computer model to make predictions and vary the rules within the model.
117
Personal Data
(Privacy and Security)
4
legIss
EV
Understand a range of ways to use technology safely including protecting their online identity and privacy: They understand the need to protect their personal data and are aware of the legal protection given to an individual's personal data.
118
Controlling a Turtle Cursor 1
(Programming: Logo)
4
Prog
AL
AB
Use two or more programming languages, at least one of which is textual, to solve a variety of computational problems: They develop a sequence of commands to direct a turtle cursor to a specific point.
119
Controlling a Turtle Cursor 2
(Programming: Logo)
4
Prog
AL
AB
Use two or more programming languages, at least one of which is textual, to solve a variety of computational problems: They distinguish between two sequences of commands to direct a turtle cursor to a specific point.
120
The Repeat Command
(Programming: Logo)
4
Prog
AL
AB
DE
Use two or more programming languages, at least one of which is textual, to solve a variety of computational problems: They use repetition commands to produce regular shapes efficiently.
121
Nested Repeats Commands
(Programming: Logo)
4
Prog
AL
AB
DE
Use two or more programming languages, at least one of which is textual, to solve a variety of computational problems: They use nested repetition to produce more complex regular shapes.
122
Logo Procedures
(Programming: Logo)
5
Prog
AL
AB
DE
Use two or more programming languages, at least one of which is textual, to solve a variety of computational problems: They use procedures to produce regular shapes.
123
Introduction to Python
(Programming: Python)
4
Prog
AB
Use a textual programming language: They are introduced to a Python program's structural elements.
124
Printing: Enclosing Text
(Programming: Python)
4
Prog
AL
EV
Use a textual programming language: They are able to explore Python's print function to send output to the screen; they become familiar with Python's error messages.
125
Printing: Separating Text
(Programming: Python)
4
Prog
AL
EV
Use a textual programming language: They explore Python's print function's separator parameter to format text.
126
Printing: Line Endings
(Programming: Python)
5
Prog
AL
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They explore Python's print function's line ending parameter. They use a function to create short stories in which they modify line endings.
127
Introduction to Lists
(Programming: Python)
5
Prog
AL
AB
EV
Use a textual programming language; make appropriate use of a data structure: They explore Python's list operations.
128
Getting Random List Elements
(Programming: Python)
6
Prog
AL
AB
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They explore Python's randint function to extract random elements from a list. They create a function with a list parameter to enable them to extract random elements from any list.
129
Random Stories using Lists
(Programming: Python)
7
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; make appropriate use of data structures; develop a program that uses a procedure or function: They modify and adapt a program for generating random stories from various lists of parts of speech.
130
Conditional Statements
(Programming: Python)
4
Prog
AL
EV
Use a textual programming language: They explore Python's conditional statement: if elif and else.
131
Quiz 1 - Asking a Question
(Programming: Python)
5
Prog
AL
AB
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop a simple quiz using functions.
132
Quiz 2 - Checking Input
(Programming: Python)
6
Prog
AL
AB
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop a simple quiz using a function which incorporates a check on user input.
133
Quiz 3 - Adding a
Scoring Mechanism

(Programming: Python)
6
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop a simple quiz using functions and which incorporates a check on user input and adds a scoring mechanism.
134
Quiz 4 - Three Question Quiz
(Programming: Python)
7
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop a fuller quiz using functions and which incorporates a check on user input and adds a scoring mechanism.
135
Repetition 1 - for loop
with numbers

(Programming: Python)
5
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop a function using a for loop to print a range of values using ranges and steps with break and continue statements.
136
Repetition 2 - for loop with lists
(Programming: Python)
5
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop functions using Python's iteration functions with for loops and lists and also explore Python's string format method.
137
Repetition 3 - for loop with Logo
(Programming: Python)
5
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop functions with parameters using Python's logo module. They use for loops to draw regular shapes.
138
Repetition 4 - while loop
with numbers

(Programming: Python)
5
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem; develop a program that uses a procedure or function: They develop functions using while loops and parmeters, together with the format method to print out ranges of numerical values.
139
Repetition 5 - number
guessing game

(Programming: Python)
5
Prog
AL
AB
DE
EV
Use a textual programming language to solve a computational problem: They develop a number guessing game using while loops and format specifiers.
140
Communication and Control
(Programming: Scratch)
4
Prog
AB
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They explore the idea of stored programs for controlling devices and appliances.
141
Stored Programs
(Programming: Scratch)
4
Prog
AL
AB
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They explore stored program instructions to control a washing machine and a robot.
142
Constants and Variables
(Programming: Scratch)
5
Prog
AL
AB
Use a textual programming language, to solve a computational problem: They explore the idea of constants and variables within the context of a simple shooter game.
143
Conditional Statements 1
(Programming: Scratch)
4
Prog
AL
AB
Use a graphical programming language to solve a computational problem: They explore the use of conditional statements within the context of a simple quiz. This is implemented in the Scratch programming language.
144
Conditional Statements 2
(Programming: Scratch)
5
Prog
AL
AB
Use a graphical programming language to solve a computational problem: They explore the use of nested conditional statements within the context of a number guessing game. This is implemented in the Scratch programming language.
145
Repetition 1
(Programming: Scratch)
4
Prog
AL
AB
Use a graphical programming language to solve a computational problem: They explore the use of simple for loops to produce regular shapes efficiently. These are implemented in the Scratch programming language.
146
Repetition 2
(Programming: Scratch)
5
Prog
AL
AB
Use a graphical programming language to solve a computational problem: They explore the use of a repeat until loop, together with conditonal statements, to build a number guessing game. This is implemented in the Scratch programming language.
147
X,Y Coordinates
(Programming: Scratch)
5
Prog
AL
AB
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They explore the X,Y co-ordinate system within the context of a simple shooter game.
148
Collision Detection
(Programming: Scratch)
6
Prog
AL
AB
DE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems: They explore the concept of collision detection within the context of computer games and simulations. They are able to modify a shooter game which is implemented in the Scratch programming language.
149
Message Passing
(Programming: Scratch)
6
Prog
AL
AB
DE
Use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems; Use a graphical programming language to solve a computational problem: They explore the concept of message passing between entities within the context of computer games and simulations. They are able to modify a message passing program which is implemented in the Scratch programming language.
150
Using Lists
(Programming: Scratch)
6
Prog
AL
AB
DE
Use a graphical programming language to solve a computational problem; make apprpriate use of a data structure: They explore a computer game that simulates a maze. The program incorporates a list and collision detection. They are able to modify this program which is implemented in the Scratch programming language.
151
Displaying Information
(Public Information Systems)
4
Apps
AB
EV
Undertake creative projects that involve selecting, using, and combining multiple applications ... including collecting and analysing data and meeting the needs of known users: They understand that dispalying the same data in two different ways can make it easier for users to understand a data set.
152
Public Information System
(Public Information Systems)
4
Apps
AB
EV
Undertake creative projects that involve selecting, using, and combining multiple applications ... including collecting and analysing data and meeting the needs of known users: They understand that Public Information Systems may need to provide data from the past as well as from the present, and may also need to provide predictive data.
153
Reliability
(Reliability, Validity and Bias)
4
Apps
AB
EV
Undertake creative projects that involve using ... applications ... to achieve challenging goals, including collecting and analysing data and meeting the needs of known users: They understand the importance of collecting reliable information.
154
Valid Information
(Reliability, Validity and Bias)
4
Apps
AB
EV
Undertake creative projects that involve using ... applications ... to achieve challenging goals, including collecting and analysing data and meeting the needs of known users: They understand that valid information needs to be timely, in the right format, within a valid range and be of the right type.
155
Information Bias
(Reliability, Validity and Bias)
4
Apps
AB
EV
Undertake creative projects that involve using ... applications ... to achieve challenging goals, including collecting and analysing data and meeting the needs of known users: They understand the importance of detecting and mitigating bias in the information that they collect.
156
Sensors
(Sensors)
4
CompSys
AB
Undertake creative projects that involve using ... applications ... to achieve challenging goals, including collecting and analysing data: They understand the advantages of collecting data using sensors: They become aware of the wide range of sensors that are available to support computer applications.
157
Framing Camera Shots
(Video)
5
Apps
AB
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to ... design and usability: They develop an understanding of framing a scene in preparation for video capture.
158
Storyboarding
(Video)
5
Apps
AB
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to ... design and usability: They begin to develop an understanding of the importance of storyboarding in preparation for filming a video sequence.
159
Video and Audio Clips
(Video)
5
Apps
AB
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to ... design and usability: They develop an understanding of using overlays and adding sound channels to their work. They understand the importance of editing their work.
160
Titles, Effects and Transitions
(Video)
5
Apps
AB
EV
Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to ... design and usability: They understand the importance of selecting appropriate titles, and adding effects and transitions when developing a story through film.