Computer Science lesson packs

Why computers use binary: binary and denary

1.1

PlanWorksheetQuizLab

Hexadecimal and where it is used

1.1

PlanWorksheetQuizLab

Binary addition and overflow

1.1

PlanWorksheetQuizLab

Logical binary shifts

1.1

PlanWorksheetQuizLab

Two's complement for negative numbers

1.1

PlanWorksheetQuizLab

Representing text: ASCII and Unicode

1.2

PlanWorksheetQuizLab

Representing sound: sample rate and resolution

1.2

PlanWorksheetQuizLab

Representing images: resolution and colour depth

1.2

PlanWorksheetQuizLab

Measuring data storage and calculating file sizes

1.3

PlanWorksheetQuizLab

Lossy and lossless compression

1.3

PlanWorksheetQuizLab

Packets and packet switching

2.1

PlanWorksheetQuizLab

Serial and parallel, simplex, half-duplex and full-duplex

2.1

PlanWorksheetQuizLab

The universal serial bus (USB)

2.1

PlanWorksheetQuizLab

Parity checks, checksums and echo checks

2.2

PlanWorksheetQuizLab

Check digits and automatic repeat query (ARQ)

2.2

PlanWorksheetQuizLab

Symmetric and asymmetric encryption

2.3

PlanWorksheetQuizLab

The CPU and Von Neumann architecture

3.1

PlanWorksheetQuizLab

The fetch-decode-execute cycle

3.1

PlanWorksheetQuizLab

Cores, cache and clock speed

3.1

PlanWorksheetQuizLab

Instruction sets and embedded systems

3.1

PlanWorksheetQuizLab

Input and output devices

3.2

PlanWorksheetQuizLab

Sensors and how they are used

3.2

PlanWorksheetQuizLab

Primary storage: RAM and ROM

3.3

PlanWorksheetQuizLab

Magnetic, optical and solid-state storage

3.3

PlanWorksheetQuizLab

Virtual memory and cloud storage

3.3

PlanWorksheetQuizLab

NICs, MAC addresses, IP addresses and routers

3.4

PlanWorksheetQuizLab

System software and application software

4.1

PlanWorksheetQuizLab

The operating system, firmware and the hardware

4.1

PlanWorksheetQuizLab

Interrupts

4.1

PlanWorksheetQuizLab

High-level and low-level languages

4.2

PlanWorksheetQuizLab

Assemblers, compilers and interpreters

4.2

PlanWorksheetQuizLab

Integrated development environments (IDEs)

4.2

PlanWorksheetQuizLab

The internet, the world wide web and URLs

5.1

PlanWorksheetQuizLab

HTTP, HTTPS and web browsers

5.1

PlanWorksheetQuizLab

How a web page is located and retrieved: DNS

5.1

PlanWorksheetQuizLab

Session and persistent cookies

5.1

PlanWorksheetQuizLab

Digital currency and blockchain

5.2

PlanWorksheetQuizLab

Cyber security threats

5.3

PlanWorksheetQuizLab

Keeping data safe from security threats

5.3

PlanWorksheetQuizLab

Automated systems: sensors, microprocessors and actuators

6.1

PlanWorksheetQuizLab

Robotics

6.2

PlanWorksheetQuizLab

Artificial intelligence: expert systems and machine learning

6.3

PlanWorksheetQuizLab

The program development life cycle

7 (1-2)

PlanWorksheetQuizLab

Decomposition, structure diagrams, flowcharts and pseudocode

7 (1-2)

PlanWorksheetQuizLab

Standard methods: linear search and bubble sort

7 (3-4)

PlanWorksheetQuizLab

Standard methods: totalling, counting, maximum, minimum and average

7 (3-4)

PlanWorksheetQuizLab

Validation and verification checks

7 (5-6)

PlanWorksheetQuizLab

Normal, abnormal, extreme and boundary test data

7 (5-6)

PlanWorksheetQuizLab

Dry-running algorithms with trace tables

7 (7-9)

PlanWorksheetQuizLab

Finding and correcting errors in algorithms

7 (7-9)

PlanWorksheetQuizLab

Writing and amending algorithms

7 (7-9)

PlanWorksheetQuizLab

Variables, constants and data types

8.1

PlanWorksheetQuizLab

Sequence and selection: IF and CASE

8.1

PlanWorksheetQuizLab

Iteration: count-controlled, pre-condition and post-condition loops

8.1

PlanWorksheetQuizLab

String handling

8.1

PlanWorksheetQuizLab

Arithmetic, relational and logical operators

8.1

PlanWorksheetQuizLab

Procedures, functions, parameters and scope

8.1

PlanWorksheetQuizLab

Library routines: MOD, DIV, ROUND and RANDOM

8.1

PlanWorksheetQuizLab

Writing maintainable programs

8.1

PlanWorksheetQuizLab

One-dimensional arrays

8.2

PlanWorksheetQuizLab

Two-dimensional arrays and nested loops

8.2

PlanWorksheetQuizLab

Reading from and writing to files

8.3

PlanWorksheetQuizLab

Single-table databases: fields, records and data types

9 (1-3)

PlanWorksheetQuizLab

Primary keys

9 (1-3)

PlanWorksheetQuizLab

SQL: SELECT, FROM, WHERE and ORDER BY

9 (4)

PlanWorksheetQuizLab

SQL: SUM, COUNT, AND and OR

9 (4)

PlanWorksheetQuizLab

The six logic gates

10 (1-2)

PlanWorksheetQuizLab

Drawing logic circuits

10 (3)

PlanWorksheetQuizLab

Completing truth tables

10 (3)

PlanWorksheetQuizLab

Writing logic expressions

10 (3)

PlanWorksheetQuizLab