IGCSE Computer Science
This course aims to give you a thorough understanding not only of what computers can do, but how they work, how all the bits and pieces fit together, and give you an introduction into concepts of programming and program design.
Topic 7 - Algorithm design and problem-solving
7.1 Development life cycle, limited to: analysis, design, coding and testing
7.2 (a) Understand that every computer system is made up of sub-systems
(b) Understand how a problem can be decomposed into its component parts
(c) Use different methods to design and construct a solution to a problem
7.3 Explain the purpose of a given algorithm
7.4 Understand standard methods of solution
7.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
7.6 Suggest and apply suitable test data
7.7 Complete a trace table to document a dry-run of an algorithm
7.8 Identify errors in given algorithms and suggest ways of correcting these errors
7.9 Write and amend algorithms for given problems or scenarios, using: pseudocode, program code and flowcharts
Topic 9 - Databases
9.1 Define a single-table database from given data storage requirements
9.2 Suggest suitable basic data types
9.3 Understand the purpose of a primary key and identify a suitable primary key for a given database table
9.4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table
