New to PG?
Start here
BooksBusinessComputingDesign & TechnologyEnglishHumanitiesLanguagesMathsPEScienceClearReviseAI TutorAbout
Back to All Units

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 3.5mb

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...

“
”

The key strengths of the materials are in their simplicity - you have the content pupils need to know, simply, attractively presented and then a well designed worksheet to test it. The worksheets look excellent and very effective as a tool to cement the learning.

Dr Bruce Geddes. Head of Curriculum, British School Kuala Lumpur

“
”

I am pleased to have used so many resources created by PG Online. They are the best companion in the life of a teacher!

J Kulandairaj. Computer Science Teacher, Brimsham Green School

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 3.5mb

    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