Skip to content

Home

Courses

GCSE Computer Science

Unit 1 Programming

1.1 Variables, constants, data types and casting
1.2 Input, output, assignment and string operations
1.3 Arithmetic, comparison and Boolean operators
1.4 Sequence & Basic selection constructs
1.5 Complex and nested selection
1.6 Count- and condition-controlled iteration
1.7 One-dimensional arrays
1.8 Procedures and functions
1.9 Nested iteration, status flags and loop control
1.10 Two-dimensional arrays
1.11 File handling
1.12 Records
1.13 SQL
1.14 Defensive design
1.15 Errors and testing
1.16 Translators and programming languages
1.17 Integrated Development Environments

Unit 2 Hardware

2.1 CPU components and registers
2.2 Fetch-decode-execute cycle
2.3 CPU performance
2.4 Embedded systems
2.5 RAM and ROM
2.6 Virtual memory
2.7 Secondary storage
2.8 Logic gates and truth tables

Unit 3 Software

3.1 Operating systems
3.2 Utility software

Unit 4 Data representation

4.1 Data units
4.2 Binary number representation
4.3 Binary arithmetic
4.4 Hexadecimal
4.5 Characters
4.6 Images
4.7 Sound
4.8 Data compression and file formats
4.9 Encryption

Unit 5 Networks

5.1 LAN
5.2 Network hardware
5.3 Wireless networking
5.4 LAN topologies
5.5 Internet and WANs
5.6 Client-server and peer-to-peer network architecture
5.7 Standards and protocols
5.8 Network layers

Unit 6 Cyber security

6.1 Network threats
6.2 Preventing vulnerabilities

Unit 7 Algorithms

7.1 Computational thinking
7.2 Linear search
7.3 Binary search
7.4 Bubble sort
7.5 Insertion sort
7.6 Merge sort
7.7 Flowcharts
7.8 Pseudocode
7.9 Interpreting algorithms

Unit 8 Societal implications of digital technology

8.1 Ethical and cultural issues
8.2 Environmental issues
8.3 Privacy and data protection
8.4 Computer misuse and copyright
8.5 Software licensing

Tutorials

Programming Problems

Concepts

Memory Management

Virtual Memory

Process Scheduling

Round Robin Scheduling

Algorithms

Linear Search

Courses / GCSE Computer Science / Unit 1 Programming

1.13 SQL

Unit 1 Programming

GCSE Computer Science

1.13 Lesson