KS3

£120.00 + VAT

+

Database development

Build and interrogate your own software system

 
K

Inside the Unit...

Areas Covered

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

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

Very helpful assessments, easy to assess and the resources are perfect for teaching. Thanks.

Seeven Soobaroyen. Springwood High School

A fantastic set of resources to support both teachers and students in the delivery of the new computing curriculum. We would be lost without it.

Catherine Williams. Head of Department, St Bede's Inter-Church School

Inside the Unit...

  • Areas Covered

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

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

    Download Free Sample 6.0mb

  • 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

  • Pricing and Discounts

    • Lifetime site licence for:
    • 1 KS3 unit £120 + VAT
    • GCSE & IGCSE units are individually priced
    • A Level units are individually priced
    • Discount for 2-5 units 10%
    • Discount for 6-11 units 15%
    • Discount for 12 or more units 20%
    • Budget plans are available. There are no annual renewal fees.