{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Theory Content Overview","Component 01","Component 02","General revision"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Theory Content Overview","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[3,1,3,4],[3,5,3,11],[31,1,31,11],[32,1,32,11],[33,1,33,11]]}
[]
[]
[]
[null,"Component 01: Computer systems",{"$nulls":3},"Component 02: Computational thinking, algorithms and programming"]
[]
[null,"1.1 Systems Architecture",{"$nulls":3},"2.1 Algorithms"]
[null,null,"1.1.1 Architecture of the CPU",{"$nulls":3},"2.1.1 Computational thinking"]
[null,null,"1.1.2 CPU Performance",{"$nulls":3},"2.1.2 Designing, creating and refining algorithms"]
[null,null,"1.1.3 Embedded systems",{"$nulls":3},"2.1.3 Searching and sorting algorithms"]
[null,"1.2 Memory and storage",{"$nulls":3},"2.2 Programming fundamentals"]
[null,null,"1.2.1 Primary storage (Memory)",{"$nulls":3},"2.2.1 Programming fundamentals"]
[null,null,"1.2.2 Secondary storage",{"$nulls":3},"2.2.2 Data types"]
[null,null,"1.2.3 Units",{"$nulls":3},"2.2.3 Additional programming techniques"]
[null,null,"1.2.4 Data storage",null,null,"2.3 Producing robust programs"]
[null,null,"1.2.5 Compression",{"$nulls":3},"2.3.1 Defensive design"]
[null,"1.3 Computers networks, connections and protocols",{"$nulls":4},"2.3.2 Testing"]
[null,null,"1.3.1 Networks and topologies",null,null,"2.4 Boolean logic"]
[null,null,"1.3.2 Wired and wireless networks, protocols and layers",{"$nulls":3},"2.4.1 Boolean logic"]
[null,"1.4 Network security",{"$nulls":3},"2.5 Programming languages and Integrated Development Environments"]
[null,null,"1.4.1 Threats to computer systems and networks",{"$nulls":3},"2.5.1 Languages"]
[null,null,"1.4.2 Identifying and preventing vulnerabilities",{"$nulls":3},"2.5.2 The Integrated Development Environment (IDE)"]
[null,"1.5 Systems software"]
[null,null,"1.5.1 Operating systems"]
[null,null,"1.5.2 Utility software"]
[null,"1.6 Ethical, legal, cultural and environmental impacts of digital technology"]
[null,null,"1.6.1 Ethical, legal, cultural and environmental impact"]
[]
[]
[]
[]
[]
[null,"Re"]

{"sheet":"Component 01","index":1,"n_rows":157,"n_cols":9,"rows_kept":157,"merged":[[2,1,2,3],[3,1,3,3],[4,1,8,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[10,1,21,1],[10,2,21,2],[22,1,25,1],[22,2,25,2],[26,1,27,1],[26,2,27,2],[28,1,32,1],[28,2,32,2],[33,1,45,1],[33,2,45,2],[46,1,56,1],[46,2,56,2],[57,1,79,1],[57,2,79,2],[80,1,83,1],[80,2,83,2],[84,1,100,1],[84,2,100,2],[101,1,118,1],[101,2,118,2],[119,1,125,1],[119,2,125,2],[126,1,133,1],[126,2,133,2],[134,1,139,1],[134,2,139,2],[140,1,144,1],[140,2,144,2],[145,1,155,1],[145,2,155,2]]}
[]
[]
[null,"J277 - Specification Component 01: Computer systems"]
[null,"Student Guidance"]
[null,"Use this Study Record to help track and review your GCSE Computer Science learning over the teaching of the course.\n\nYou can use this information to review your progress and help to plan your revision. It will help you to focus on:\n- What have you been taught? Have you reviewed or revised it? How confidently do you think you know the topic?\n\nPractical Programming forms an essential part of learning.\nYou are encouraged to balance your academic studies with practical programming tasks using Python."]
[]
[]
[]
[{"$nulls":4},"Taught","Revised","Not confident","Confident"]
[null,"Date introduced:","Specification Topic","Sub topic",{"$nulls":4},"Notes and Comments"]
[null,null,"1.1.1 Architecture of the CPU"," the purpose of the CPU",{"$nulls":4},"The architecture of the Central Processing Unit (CPU) - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize   https://cdn.savemyexams.com/pdfs/X9EOc9JChwK2j0h.pdf"]
[{"$nulls":3},"    o  the fetch-execute cycle",{"$nulls":4},"The fetch-decode-execute cycle - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," common CPU components and their function:",{"$nulls":4},"Common CPU components and their functions - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o  ALU (Arithmetic Logic Unit)"]
[{"$nulls":3},"    o  CU (Control Unit)"]
[{"$nulls":3},"    o  Cache",{"$nulls":4},"Cache memory - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o  Registers"]
[{"$nulls":3}," Von Neumann architecture:",{"$nulls":4},"Von Neumann architecture - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o  MAR (Memory Address Register)"]
[{"$nulls":3},"    o  MDR (Memory Data Register)"]
[{"$nulls":3},"    o  Program Counter"]
[{"$nulls":3},"    o  Accumulator"]
[null,null,"1.1.2 CPU Performance"," how common characteristics of CPUs affect their performance:",{"$nulls":4},"CPU performance - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o  Clock speed"]
[{"$nulls":3},"    o  Cache size"]
[{"$nulls":3},"    o  Number of Cores"]
[null,null,"1.1.3 Embedded systems"," The purpose and characteristics of embedded systems",{"$nulls":4},"Embedded systems - Systems architecture - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Examples of embedded systems"]
[null,null,"1.2.1 Primary storage (Memory)"," The need for primary storage",{"$nulls":4},"Primary storage - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The difference between RAM and ROM",{"$nulls":4},"Random access memory - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The purpose of ROM in a computer system",{"$nulls":4},"Read-only memory - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The purpose of RAM in a computer system",{"$nulls":4},"Random access memory - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Virtual memory",{"$nulls":4},"Virtual memory - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"1.2.2 Secondary storage"," The need for secondary storage",{"$nulls":4},"Secondary storage - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Common types of storage:",{"$nulls":4},"Common types of secondary storage - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    Optical"]
[{"$nulls":3},"    o    Magnetic"]
[{"$nulls":3},"    o    Solid state"]
[{"$nulls":3}," Suitable storage devices and storage media for a given application",{"$nulls":4},"Suitable storage devices and storage media - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The advantages and disadvantages of different storage devices and storage media relating to these characteristics:",{"$nulls":4},"Suitable storage devices and storage media - Memory and storage - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    Capacity"]
[{"$nulls":3},"    o    Speed"]
[{"$nulls":3},"    o    Portability"]
[{"$nulls":3},"    o    Durability"]
[{"$nulls":3},"    o    Reliability"]
[{"$nulls":3},"    o    Cost"]
[null,null,"1.2.3 Units"," The units of data storage:",{"$nulls":4},"Units of data - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize       https://craigndave.org/videos/ocr-gcse-j277-slr-1-2-the-units-of-data-storage/"]
[{"$nulls":3},"    o   Bit"]
[{"$nulls":3},"    o   Nibble (4 bits)"]
[{"$nulls":3},"    o   Byte (8 bits)"]
[{"$nulls":3},"    o   Kilobyte (1000 bytes or 1 KB)"]
[{"$nulls":3},"    o   Megabyte (1,000 KB)"]
[{"$nulls":3},"    o   Gigabyte (1,000 MB)"]
[{"$nulls":3},"    o   Terabyte (1,000 GB) "]
[{"$nulls":3},"    o   Petabyte (1,000 TB)"]
[{"$nulls":3}," How data needs to be converted into a binary format to be processed by a computer.",{"$nulls":4},"Units of data - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize      https://www.bbc.co.uk/bitesize/guides/zfspfcw/revision/3"]
[{"$nulls":3}," Data capacity and calculation of data capacity requirements",{"$nulls":4},"Data capacity - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"1.2.4 Data storage","Numbers"]
[{"$nulls":3}," How to convert positive denary whole numbers to binary numbers (up to and including 8 bits) and vice versa",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zfspfcw/revision/3"]
[{"$nulls":3}," How to add two binary integers together (up to and including 8 bits) and explain overflow errors which may occur",{"$nulls":4},"Binary addition - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," How to convert positive denary whole numbers into 2-digit hexadecimal numbers and vice versa",{"$nulls":4},"Hexadecimal - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," How to convert from binary to hexadecimal equivalents and vice versa",{"$nulls":4},"Hexadecimal - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Binary shifts",{"$nulls":4},"Binary shifts - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"Characters",{"$nulls":4},"Characters - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The use of binary codes to represent characters"]
[{"$nulls":3}," The term ‘character-set’"]
[{"$nulls":3}," The relationship between the number of bits per character in a character set, and the number of characters which can be represented, e.g.: "]
[{"$nulls":3},"    o    ASCII"]
[{"$nulls":3},"    o    Unicode"]
[{"$nulls":3},"Images",{"$nulls":4},"Images - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," How an image is represented as a series of pixels, represented in binary"]
[{"$nulls":3}," Metadata"]
[{"$nulls":3}," The effect of colour depth and resolution on:"]
[{"$nulls":3},"    o    The quality of the image"]
[{"$nulls":3},"    o    The size of an image file"]
[{"$nulls":3},"Sound",{"$nulls":4},"Sound - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," How sound can be sampled and stored in digital form"]
[{"$nulls":3}," The effect of sample rate, duration and bit depth on:"]
[{"$nulls":3},"    o    The playback quality"]
[{"$nulls":3},"    o    The size of a sound file"]
[null,null,"1.2.5 Compression"," The need for compression",{"$nulls":4},"Compression - Units and data representation - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Types of compression:"]
[{"$nulls":3},"    o    Lossy"]
[{"$nulls":3},"    o    Lossless"]
[null,null,"1.3.1 Networks and topologies"," Types of networks:",{"$nulls":4},"Networks - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize    https://www.bbc.co.uk/bitesize/guides/zvspfcw/revision/2"]
[{"$nulls":3},"    o    LAN (Local Area Network)"]
[{"$nulls":3},"    o    WAN (Wide Area Network)"]
[{"$nulls":3}," Factors that affect the performance of networks",{"$nulls":4},"Factors that affect the performance of networks - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The different roles of computers in a client-server and a peer-to-peer network",{"$nulls":4},"Client-servers and peer-to-peer networks - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The hardware needed to connect stand-alone computers into a Local Area Network:",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zvspfcw/revision/5"]
[{"$nulls":3},"    o    Wireless access points"]
[{"$nulls":3},"    o    Routers"]
[{"$nulls":3},"    o    Switches"]
[{"$nulls":3},"    o    NIC (Network Interface Controller/Card)"]
[{"$nulls":3},"    o    Transmission media"]
[{"$nulls":3}," The Internet as a worldwide collection of computer networks:",{"$nulls":4},"What is the internet? - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    DNS (Domain Name Server)",{"$nulls":4},"Domain name servers (DNS) - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    Hosting",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zvspfcw/revision/7"]
[{"$nulls":3},"    o    The Cloud",{"$nulls":4},"The cloud - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    Webservers and Clients"]
[{"$nulls":3}," Star and Mesh network topologies",{"$nulls":4},"Star and mesh networks - Computer networks and topologies - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"1.3.2 Wired and wireless networks, protocols and layers"," Modes of connection:",{"$nulls":4},"Modes of connection - Wired and wireless networks, protocols and layers - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o    Wired"]
[{"$nulls":3},"              •          Ethernet "]
[{"$nulls":3},"    o    Wireless"]
[{"$nulls":3},"              •          Wi-Fi"]
[{"$nulls":3},"              •          Bluetooth"]
[{"$nulls":3}," Encryption",{"$nulls":4},"Encryption - Wired and wireless networks, protocols and layers - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," IP addressing and MAC addressing",{"$nulls":4},"Addressing and protocols - Wired and wireless networks, protocols and layers - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Standards"]
[{"$nulls":3}," Common protocols including:"]
[{"$nulls":3},"    o   TCP/IP (Transmission Control Protocol/Internet Protocol)"]
[{"$nulls":3},"    o   HTTP (Hyper Text Transfer Protocol)"]
[{"$nulls":3},"    o   HTTPS (Hyper Text Transfer Protocol Secure)"]
[{"$nulls":3},"    o   FTP (File Transfer Protocol)"]
[{"$nulls":3},"    o   POP (Post Office Protocol)"]
[{"$nulls":3},"    o   IMAP (Internet Message Access Protocol)"]
[{"$nulls":3},"    o   SMTP (Simple Mail Transfer Protocol)"]
[{"$nulls":3}," The concept of layers",{"$nulls":4},"The concept of layers - Wired and wireless networks, protocols and layers - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"1.4.1 Threats to computer systems and networks"," Forms of attack",{"$nulls":4},"Forms of attack - Network security - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Malware",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zj89dxs/revision/2"]
[{"$nulls":3},"    o   Social engineering, e.g. phishing, people as the ‘weak point’ ",{"$nulls":4},"Other threats - Network security - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Brute-force attacks"]
[{"$nulls":3},"    o   Denial of service attacks"]
[{"$nulls":3},"    o   Data interception and theft"]
[{"$nulls":3},"    o   The concept of SQL injection"]
[null,null,"1.4.2 Identifying and preventing vulnerabilities"," Common prevention methods:",{"$nulls":4},"Identifying and preventing vulnerabilities - Network security - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Penetration Testing"]
[{"$nulls":3},"    o   Anti-malware software"]
[{"$nulls":3},"    o   Firewalls"]
[{"$nulls":3},"    o   User access levels"]
[{"$nulls":3},"    o   Passwords",{"$nulls":4},"Passwords, encryption, physical security, anti-malware and firewalls - Network security - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Encryption"]
[{"$nulls":3},"    o   Physical Security"]
[null,null,"1.5.1 Operating systems"," The purpose and functionality of operating systems:",{"$nulls":4},"Systems software - Systems software - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   User interface"]
[{"$nulls":3},"    o   Memory management and multitasking"]
[{"$nulls":3},"    o   Peripheral management and drivers"]
[{"$nulls":3},"    o   User management"]
[{"$nulls":3},"    o   File management"]
[null,null,"1.5.2 Utility software"," The purpose and functionality of utility software",{"$nulls":4},"Utility software - Systems software - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Utility system software:"]
[{"$nulls":3},"    o   Encryption software"]
[{"$nulls":3},"    o   Defragmentation"]
[{"$nulls":3},"    o   Data Compression"]
[null,null,"1.6.1 Ethical, legal, cultural and environmental impact"," Impacts of digital technology on wider society including:",{"$nulls":4},"Impacts of digital technology on wider society - Ethical, legal and environmental impacts of digital technology - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Ethical issues"]
[{"$nulls":3},"    o   Legal issues"]
[{"$nulls":3},"    o   Cultural issues"]
[{"$nulls":3},"    o   Environmental issues"]
[{"$nulls":3},"    o   Privacy issues"]
[{"$nulls":3}," Legislation relevant to Computer Science:",{"$nulls":4},"Legislation relevant to Computer Science - Ethical, legal and environmental impacts of digital technology - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   The Data Protection Act 2018"]
[{"$nulls":3},"    o   Computer Misuse Act 1990"]
[{"$nulls":3},"    o   Copyright Designs and Patents Act 1988"]
[{"$nulls":3},"    o   Software licences (i.e. open source and proprietary)"]
[{"$nulls":3},"    "]

{"sheet":"Component 02","index":2,"n_rows":87,"n_cols":9,"rows_kept":87,"merged":[[2,1,2,3],[3,1,3,3],[4,1,8,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[10,1,13,1],[10,2,13,2],[14,1,21,1],[14,2,21,2],[22,1,28,1],[22,2,28,2],[29,1,35,1],[29,2,35,2],[36,1,41,1],[36,2,41,2],[42,1,52,1],[42,2,52,2],[53,1,61,1],[53,2,61,2],[62,1,72,1],[62,2,72,2],[73,1,76,1],[73,2,76,2],[77,1,81,1],[77,2,81,2],[82,1,86,1],[82,2,86,2]]}
[]
[]
[null,"J277 - Specification Component 02: Computational thinking, algorithms and programming"]
[null,"Student Guidance"]
[null,"Use this Study Record to help track and review your GCSE Computer Science learning over the teaching of the course.\n\nYou can use this information to review your progress and help to plan your revision. It will help you to focus on:\n- What have you been taught? Have you reviewed or revised it? How confidently do you think you know the topic?\n\nPractical Programming forms an essential part of learning.\nYou are encouraged to balance your academic studies with practical programming tasks using Python."]
[]
[]
[]
[{"$nulls":4},"Taught","Revised","Not confident","Confident"]
[null,"Date introduced:","Specification Topic","Sub topic",{"$nulls":4},"Notes and Comments"]
[null,null,"2.1.1 Computational thinking"," Principles of computational thinking",{"$nulls":4},"Principles of computational thinking - Computational thinking - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Abstraction",{"$nulls":4},"Abstraction - Computational thinking - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Decomposition",{"$nulls":4},"Decomposition - Computational thinking - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Algorithmic Thinking.",{"$nulls":4},"Algorithmic thinking - Computational thinking - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"2.1.2 Designing, creating and refining algorithms"," Identify the inputs, processes, and outputs for a problem",{"$nulls":4},"Algorithm production - Designing, creating and refining algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Structure diagrams"]
[{"$nulls":3}," Create, interpret, correct, complete, and refine algorithms using:"]
[{"$nulls":3},"    o   Pseudocode",{"$nulls":4},"Pseudocode - Designing, creating and refining algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Flowcharts",{"$nulls":4},"Flowcharts - Designing, creating and refining algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Reference language/high-level programming language",{"$nulls":4},"GCSE (9-1) Computer Science J277 Specification"]
[{"$nulls":3}," Identify common errors",{"$nulls":4},"Identify common errors - Designing, creating and refining algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Trace tables",{"$nulls":4},"Trace tables - Designing, creating and refining algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"2.1.3 Searching and sorting algorithms"," Standard searching algorithms:",{"$nulls":4},"Standard search algorithms - Searching and sorting algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Binary search",{"$nulls":4},"Standard search algorithms - Searching and sorting algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Linear search",{"$nulls":4},"Standard search algorithms - Searching and sorting algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Standard sorting algorithms:",{"$nulls":4},"Standard sorting algorithms - Searching and sorting algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Bubble sort",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zjdkw6f/revision/4"]
[{"$nulls":3},"    o   Merge sort",{"$nulls":4},"Merge sort - Searching and sorting algorithms - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Insertion sort",{"$nulls":4},"https://www.bbc.co.uk/bitesize/guides/zjdkw6f/revision/5"]
[null,null,"2.2.1 Programming fundamentals"," The use of variables, constants, operators, inputs, outputs and assignments",{"$nulls":4},"Variables and constants - Programming fundamentals - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The use of the three basic programming constructs used to control the flow of a program:",{"$nulls":4},"The three basic programming constructs - Programming fundamentals - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Sequence"]
[{"$nulls":3},"    o   Selection"]
[{"$nulls":3},"    o   Iteration (count- and condition- controlled loops)"]
[{"$nulls":3}," The common arithmetic operators",{"$nulls":4},"Common arithmetic operators - Programming fundamentals - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The common Boolean operators AND, OR, NOT"]
[null,null,"2.2.2 Data types"," The use of data types:",{"$nulls":4},"Data types - Programming fundamentals - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Integer"]
[{"$nulls":3},"    o   Real"]
[{"$nulls":3},"    o   Boolean"]
[{"$nulls":3},"    o   Character and string"]
[{"$nulls":3},"    o   Casting"]
[null,null,"2.2.3 Additional programming techniques"," The use of basic string manipulation",{"$nulls":4},"The use of basic string manipulation - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The use of basic file handling operations:",{"$nulls":4},"The use of basic file handling operations - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Open"]
[{"$nulls":3},"    o   Read"]
[{"$nulls":3},"    o   Write"]
[{"$nulls":3},"    o   Close"]
[{"$nulls":3}," The use of records to store data",{"$nulls":4},"The use of records to store data - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The use of SQL to search for data",{"$nulls":4},"The use of SQL to search for data - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The use of arrays (or equivalent) when solving problems, including both one-dimensional (1D) and two-dimensional (2D) arrays",{"$nulls":4},"The use of arrays - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," How to use sub programs (functions and procedures) to produce structured code",{"$nulls":4},"How to use subprograms to produce structured code - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Random number generation",{"$nulls":4},"Random number generation - Programming techniques - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[null,null,"2.3.1 Defensive design"," Defensive design considerations:",{"$nulls":4},"Defensive design considerations - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Anticipating misuse"]
[{"$nulls":3},"    o   Authentication",{"$nulls":4},"Authentication - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Input validation",{"$nulls":4},"Input validation - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Maintainability:",{"$nulls":4},"Maintainability - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"        o   Use of sub programs",{"$nulls":4},"Use of sub programs - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"        o   Naming conventions"]
[{"$nulls":3},"    o  Indentation"]
[{"$nulls":3},"    o   Commenting"]
[null,null,"2.3.2 Testing"," The purpose of testing",{"$nulls":4},"The purpose and types of testing - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Types of testing:"]
[{"$nulls":3},"    o   Iterative"]
[{"$nulls":3},"    o   Final/terminal"]
[{"$nulls":3}," Identify syntax and logic errors",{"$nulls":4},"Identify syntax and logic errors - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Selecting and using suitable test data:",{"$nulls":4},"Selecting and using suitable test data - Producing robust programs - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Normal"]
[{"$nulls":3},"    o   Boundary"]
[{"$nulls":3},"    o   Invalid"]
[{"$nulls":3},"    o   Erroneous"]
[{"$nulls":3}," Refining algorithms"]
[null,null,"2.4.1 Boolean logic"," Simple logic diagrams using the operations AND, OR and NOT",{"$nulls":4},"AND gates - Boolean logic - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Truth tables"]
[{"$nulls":3}," Combining Boolean operators using AND, OR and NOT",{"$nulls":4},"Combining Boolean operators using AND, OR and NOT gates - Boolean logic - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," Applying logical operators in truth tables to solve problems"]
[null,null,"2.5.1 Languages"," Characteristics and purpose of different levels of programming language:",{"$nulls":4},"What are high-level and low-level languages? - Programming languages and Integrated Development Environments - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   High-level languages",{"$nulls":4},"High-level languages - Programming languages and Integrated Development Environments - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Low-level languages",{"$nulls":4},"Low-level languages – machine code - Programming languages and Integrated Development Environments - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The purpose of translators",{"$nulls":4},"The purpose of translators - Programming languages and Integrated Development Environments - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3}," The characteristics of a compiler and an interpreter",{"$nulls":4},"Compilers, interpreters and assemblers - Software development - Eduqas - GCSE Computer Science Revision - Eduqas - BBC Bitesize"]
[null,null,"2.5.2 The Integrated Development Environment (IDE)"," Common tools and facilities available in an integrated development environment (IDE):",{"$nulls":4},"Integrated Development Environment (IDE) - Programming languages and Integrated Development Environments - OCR - GCSE Computer Science Revision - OCR - BBC Bitesize"]
[{"$nulls":3},"    o   Editors"]
[{"$nulls":3},"    o   Error diagnostics"]
[{"$nulls":3},"    o   Run-time environment"]
[{"$nulls":3},"    o   Translators"]

{"sheet":"General revision","index":3,"n_rows":9,"n_cols":3,"rows_kept":9}
[]
[null,"PMT revision guides (Component 1) Past question papers, Revision guides, Flash cards","OCR GCSE Computer Science Topic 1: Computer systems - PMT"]
[null,"PMT revision guides (Component 2) Past question papers, Revision guides, Flash cards","OCR GCSE Computer Science Topic 2: Computational thinking, algorithms and programming - PMT"]
[]
[null,"Zig zag resources","ZigZag Resorces"]
[]
[null,"Save my exams","Save my Exam notes"]
[]
[null,"OCR GCSE specification","GCSE (9-1) Computer Science J277 Specification"]