New to PG?
Start here

IGCSE

£100.00 + VAT Discounted rate from £80.00

+

0478 Unit 10: Advanced programming and databases

Paper 2: Algorithms, Programming and Logic

 
10

Inside the Unit...

Download Free Sample 4.3mb

Areas Covered

  • Lesson 1: Procedures and functions
  • Lesson 2: File handling
  • Lesson 3: Boolean logic
  • Lesson 4: Maintainable programs
  • Download sample lesson above
  • Lesson 5: Databases and SQL
  • Assessment

There are 5 worksheets, 5 homework tasks, and an assessment test, each with answers included in this unit.

Summary - New 2023-2025 Exam Specification

This second programming unit covers a selection of more advanced topics. The first lesson begins by looking at procedures and functions. Students are then introduced to file handling techniques. Boolean logic is considered in lesson 3. This lesson covers all the common gates and the more advanced NAND, NOR and XOR gates. Lesson 4 covers maintainable programs. The last lesson concludes the programming unit with a look at both databases and SQL. SELECT queries are covered in depth, including the use of ORDER BY, SUM and COUNT. Many practical examples and tasks are given for students to solve throughout the unit. The final assessment gives students the opportunity to demonstrate their understand of programming concepts in a written form.

What's included in the toolkit?

Toolkit

These units have been written to satisfy the specification for the theoretical Section 1 of the Cambridge IGCSE® 0478, 0984 and O Level 2210 Computer Science courses. Each unit contains:

  • PowerPoint slides for each lesson
  • Detailed lesson plans
  • Learning objectives and outcomes
  • Worksheets and homework activities with answers
  • End-of-unit Assessment test with answers
  • Other material and links to online resources

What people say...

I purchased your Cambridge IGCSE resources a year ago, and I want you to know that they really are top-notch resources - they get a huge thumbs-up from me!

Stephen Trask. Head of Computing, The British International School, Abu Dhabi

Fantastic resources! An excellent time saving strategy for lesson preparation and marking. Concepts are comprehensive and structured appropriately for pupils and teachers.

Neferti Rolluqui. Head of Computer Science, Dhahran British Grammar School, Saudi Arabia

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 4.3mb

    Areas Covered

    • Lesson 1: Procedures and functions
    • Lesson 2: File handling
    • Lesson 3: Boolean logic
    • Lesson 4: Maintainable programs
    • Download sample lesson above
    • Lesson 5: Databases and SQL
    • Assessment

    There are 5 worksheets, 5 homework tasks, and an assessment test, each with answers included in this unit.

  • How to order

    1. Add individual units to a draft order or download a blank order form below to complete manually

    2. Using a draft order you can either:

    1. Save your order online
      (registration or log in required)
    2. Email us your complete order
      (registration or log in required)
    3. Create a PDF
      (to fax or email at a later date)

    Download blank order form

    PDF

    Word

  • Unit Pricing and Discounts

    Each unit is individually priced for LIFE. Please view each unit for detail. 

    Discounts are cumulative based on the total number of units licenced to your department.

    All prices subject to further discounts and VAT.

    There are no annual renewal fees.

    2-5 units 10% discount
    6-11 units 15% discount
    12+ units 20% discount