Computer Science 0478/21 Oct Nov 2024 | Cambridge IGCSE Past Papers With Mark Scheme

1. Data Validation & Verification | Identifying Input Checks and Boolean Expressions – Choosing verification techniques, constructing truth tables, and classifying operators.

2. Algorithm Development & Pseudocode | Completing Code for Array Processing – Writing missing pseudocode, displaying results, and using meaningful variable names.

3. Logic Circuits & Boolean Algebra | Creating Logic Expressions and Truth Tables – Deriving Boolean expressions, completing truth tables, and analyzing logic circuit outputs.

4. Password Security & File Handling | Implementing Validation & Storage – Designing flowcharts for password validation, writing pseudocode for file storage, and explaining secure storage reasons.

5. Error Detection & Debugging | Identifying and Correcting Pseudocode Errors – Debugging temperature-checking pseudocode, completing trace tables, and refining condition checks.

6. Database Queries & SQL | Filtering & Retrieving Data – Identifying primary keys, executing SQL queries, and modifying SQL statements for alternative outputs.

7. Sorting & Searching Algorithms | Processing Competition Results – Implementing sorting for ranking, verifying user input, and awarding certificates based on performance.