New to PG?
Start here

KS3

£120.00 + VAT Discounted rate from £96.00

+

Database development

Build and interrogate your own software system

 
K

Inside the Unit...

Download Free Sample 6.0mb

Areas Covered

  • Lesson 1 Introduction to databases
  • Lesson 2 Creating a database table
  • Lesson 3 Queries
    Download free sample above
  • Lesson 4 Input forms
  • Lesson 5 Creating a report
  • Lesson 6 Finishing and testing
  • Unit assessment

There are 3 worksheets in this unit and 3 pre-populated sample databases.

Summary - New: 3rd Edition

This unit covers essential theory of databases in order to prepare pupils for GCSEs in either Computing or ICT. Supporting the basic theory, this unit has a practical focus, covering the creation and use of a single-table database and/or a simple relational database involving two tables in a one- to-many relationship using MS Access.

The first lesson is designed to engage pupils in the concept of databases using a number of “Unsolved Crimes” and a database of suspects, from which pupils must use queries to find the culprit for each of the cases they have been allocated.

In subsequent lessons pupils will create a flat-file or two-table relational database of their own, using suitable field types and adding in appropriate validations. They will create an input form, queries, a report and a front end menu for their own application. Two populated database have been included for demonstration of these skills by the teacher.

What's included in the toolkit?

Toolkit

The currently available units have been written to satisfy the new National Curriculum for Computing, they are designed for teaching at KS3 but individual lessons in some units may also be appropriate for teaching Key Stages 2 or 4, particularly where Year 10 students may not previously have been exposed to certain topics.

  • PowerPoint slides for each lesson
  • Detailed lesson plans
  • Learning objectives and outcomes
  • Statement of which of the Government Guidelines are covered in the unit
  • Worksheets and activities
  • End-of-unit Assessment material
  • Other material and links to online resources

What people say...

I am stunned at the PG Online resources – really professional and high quality for teachers to save time and brilliant to immediately engage pupils. A must-try for NQT's, non-specialist and qualified teachers. Thank so much PG Online for your helpful service as well.

Rachel Shelton. Department of Design Technology, Staffordshire

Many thanks for continuing to improve and expand your excellent resources. I can’t begin to add up the time it has saved us.

Jules Hazzledine. Head of ICT & Business Studies, William Farr School

Inside the Unit...

  • Download Free Sample 6.0mb

    Areas Covered

    • Lesson 1 Introduction to databases
    • Lesson 2 Creating a database table
    • Lesson 3 Queries
      Download free sample above
    • Lesson 4 Input forms
    • Lesson 5 Creating a report
    • Lesson 6 Finishing and testing
    • Unit assessment

    There are 3 worksheets in this unit and 3 pre-populated sample databases.

  • 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