IGCSE Computer Science 0478 (CIE) - Everything for Paper 2 (Programming and Problem Solving)

1
Introduction
- Introduction to the course
- Coursebooks
- 0478Exams
2
Algorithms
- What is an algorithm?
- Computational Thinking
- Algorithm creation - example
- What to look for when creating an algorithm
- How do we write down algorithms?
3
Algorithm Practice
- Algorithm Practice 1 (Temperature in a room)
- Algorithm Practice 1 (Converting Algorithm to code)
- Algorithm Practice 2 (Finding the Smallest Value)
- Algorithms 2 Min in Python Code
- Algorithm Practice 2 Finding the Maximum value
- Coursebook Work
4
Pseudo Code
- Introduction
- What is Pseudo Code and why do we use it?
- Variable assignment and data types
- Conditionals (IF/ELSE/CASE)
- Loops
- For Loop
- While Loop
- Repeat Until Loop
- Input/Output
- Comments
- Coursebook Work
- Pseudo Code Question
- Pseudo Code Answer
- Pseudo Code Quiz
5
Flow Charts
- What are flowcharts?
- Flowchart Example
- Flowchart Exam example
- Coursebook Work
- Flow chart Question
- Flow Chart Answer
6
Trace Tables
- Trace Tables - Flow Chart Example
- Trace Tables - Pseudo Code Example
- Coursebook Work
- Exam Question: Trace Tables
- Exam Question: (Answer) Trace Tables
7
Errors in Code
- Correcting Errors in PseudoCode 1
- Correcting Errors in PseudoCode 2
- Correcting Errors in PseudoCode 3
- Correcting Errors in PseudoCode 4
- Errors in Code (Summary)
- Errors in Code: Practice
- Errors in Code Practice: Answers
8
Databases
- What are databases?
- Why use Databases?
- Examples of Database use
- Different Database Packages available
- Tables
- Field Data Types
- Validation and Verification
- A look at OpenOffice Database
- Exam Questions
- Coursebook work
- Practical Work - Databases
- Exam Questions: Databases
- Exam Questions: (Answers) Databases