10.1 Data Types and Records 10.2 Arrays 10.3 Files 10.4 Introduction to Abstract Data Types (ADT)

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

Show understanding of computer ethics, including copyright issues and plagiarism Distinguish between free software, freeware and shareware Show understanding of the ethical issues raised by the spread of electronic communication and computer systems, including hacking, cracking and production of malware

Show understanding of the need for input, output, primary memory and secondary (including removable) storage.Describe the principal operations of hardware devices Show understanding of the use of buffersExplain the differences between Random Access Memory (RAM) and Read Only Memory (ROM)Explain the differences between Static RAM (SRAM) and Dynamic RAM (DRAM)Explain the difference between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM)Show an understanding of monitoring and control systems Candidates should be able to:Use the following logic gate symbols: Understand and define the functions of: NOT, AND, OR, NAND, NOR and XOR (EOR) gatesConstruct a logic circuitConstruct a truth tableConstruct a logic expression

** 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 Computer Science Tracing Table past paper 2 Questions and Answers

IGCSE Revision: RECAP: Paper 2: Algorithms, programming and logic with 29 Questions and Answers

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

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

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

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

Diploma Programme Computer science guide and curriculum

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

Practical Exam for Year 10 and 11 ( Python programming /JavaScript and MySQL database) with answers

3.1 Computers and their components 3.2 Logic Gates and Logic Circuits

5.1 The internet and the world wide web 5.2 Digital currency 5.3 Cyber security

13.1 User-defined data types 13.2 File organisation and access 13.3 Floating-point numbers, representation and manipulation

14.1 Protocols 14.2 Circuit switching, packet switching

This practical activities using Python programming will teach student how to Encrypt and Decrypt