BooksBusinessComputingDesign & TechnologyEnglishHumanitiesLanguagesMathsPEScienceClearReviseAI TutorAbout
Back to All Units

A Level OCR

£140.00 + VAT Discounted rate from £112.00

+

Unit 4: Exchanging data

Component 01

Unplugged Unit
Perfect for lessons away from computers or workshops.
4

Inside the Unit...

Download Free Sample 4.2mb

Areas Covered

This unit consists of six topics, each more substantial than a single lesson and intended to be covered over the course of a week.

  • Topic 1: Compression, encryption and hashing
  • Topic 2: Database concepts
  • Download sample lesson above
  • Topic 3: Relational databases and normalisation
  • Topic 4: Introduction to SQL
  • Topic 5: Defining and updating tables using SQL
  • Topic 6: Transaction processing
  • End of unit assessment

There are six worksheets, six homework tasks, and an examination-style assessment test, each with answers included in this unit.

Summary

This unit covers Sections 1.3.1 and 1.3.2 of the 2015 H446 specification. The first lesson covers the topics of compression and encryption. This is followed by four lessons on databases and SQL, with a final lesson on transaction processing. Each of the six topics may be spread over more than one lesson, especially if time is spent in the lessons going over homework tasks. Practical database examples are based around Microsoft Access.

What's included in the toolkit?

Toolkit

The A Level units have been written to satisfy the specification for Component 1 and Component 2 of the OCR H046/H446 Computer Science AS/A Level. Each unit contains:

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

What people say...

“
”

The A level units that we have purchased from PG Online are the first resources I have purchased that do what they say on the box. A complete scheme of work, nothing else required! At a time when the ICT/computing curriculum is in complete flux, these resources have been the rock we needed to hang on to. They have saved us many hours of work and have helped students (and staff) understand the curriculum. Thank you.

Steve Casey. Head of Computing, The Burgate School and Sixth Form

“
”

We just received your AS text books, they look great, nice and easy to follow and pitched at a level that makes them accessible for the students.

Gavin Donaghy. Head of Computing, Graveney School

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 4.2mb

    Areas Covered

    This unit consists of six topics, each more substantial than a single lesson and intended to be covered over the course of a week.

    • Topic 1: Compression, encryption and hashing
    • Topic 2: Database concepts
    • Download sample lesson above
    • Topic 3: Relational databases and normalisation
    • Topic 4: Introduction to SQL
    • Topic 5: Defining and updating tables using SQL
    • Topic 6: Transaction processing
    • End of unit assessment

    There are six worksheets, six homework tasks, and an examination-style 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