Chapter 9- Databases Candidates should be able to: 1 Define a single-table database from given data storage requirements 2 Suggest suitable basic data types 3 Understand the purpose of a primary key and identify a suitable primary key for a given database table 4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table Notes and guidance • Including: – fields – records – validation • Including: – text/alphanumeric – character – Boolean – integer – real – date/time • Limited to: – SELECT – FROM – WHERE – ORDER BY – SUM – COUNT • Identifying the output given by an SQL statement that will query the given contents of a database table

Paper 2: Algorithms, programming and logic Chapter 8: Programming 8.1 Programming concepts 8.2 Arrays 8.3 File handling

Year 7/8/9 Test 1- Excel Spreadsheet

IB DP Year 12/13- Test 5- Topic 3- Networks with Question and Answers

** IGCSE Computer Science -Year 10/11 ** 2023/2024 updated version Chapter 7-Algorithm design and problem-solving: ** Learning Objectives: ** 1 Understand the program development life cycle, limited to: analysis, design, coding and testing. 2 (a) Understand that every computer system is made up of sub-systems, which are made up of further sub-systems (b) Understand how a problem can be decomposed into its component parts © Use different methods to design and construct a solution to a problem 3 Explain the purpose of a given algorithm 4 Understand standard methods of solution 5 (a) Understand the need for validation checks to be made on input data and the different types of validation check (b) Understand the need for verification checks to be made on input data and the different types of verification check. 6 Suggest and apply suitable test data 7 Complete a trace table to document a dry-run of an algorithm. 8 Identify errors in given algorithms and suggest ways of correcting these errors. 9 Write and amend algorithms for given problems or scenarios, using: pseudocode, program code and flowcharts

IGCSE Cambridge Computer Science Approved Pseudocode and logical gate

IB DP Computer Science -Y12/13- Internal Assessment (IA) The Internal Assessment for Computer Science is an opportunity for you to showcase your algorithmic and technical prowess at developing software intended to solve a legitimate, real world problem for someone.

Paper 2 : Option 4—Database (SL -30 hours) A.1 Basic concepts (5 hours) A.2 The relational database model (15 hours) A.3 Further aspects of database management (10 hours) HL Extension A.4 Further database models and database analysis (15 hours)- In Progress

IB DP Computer Science - Year 12/13 - Test 2- V2 - Topic 2

Topic 4—Computational thinking, problem-solving and programming (45 hours) 4.1 General principles (10 hours) 4.2 Connecting computational thinking and program design (22 hours) 4.3 introduction to programming (13 hours)

IB DP Computer Science Past Paper 1 and 2 (Year 2023)

IGCSE Computer Science for Year 10 and 11- Term 1-Test 2 from chapter 2 /3 and 4 Questions and Answers

IB DP Year 12/13-Test 4-Topic 2 and 3 with Question and Answers

IB DP Year 12/13-Test 3 - Topic 2 with Question and Answers

IB DP - Approved notation for developing pseudocode

Network fundamentals Data transmission Wireless networking

STEAM Project for Year 7/8 and 09 Sustainability City Development Project

2.1 Computer organization Computer architecture Secondary memory Binary representation Simple logic gates

Diploma Programme Computer science guide and curriculum

Test 2 - Topic 1—System fundamentals: 1.1 Systems in organizations