KS3

Summary 

This unit covers essential theory of databases in order to prepare pupils for Computer Science GCSE or IT qualifications. Supporting the basic theory, this unit has a practical focus, covering the creation and use of a database with one or two tables 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 database of their own. They will create a table using suitable field data types and adding appropriate validation. Pupils will gain more experience of creating queries and create and customise an input form and report. More able pupils will also be able to create a menu system.

What's included in the 10th Anniversary toolkit?

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

The 10th Anniversary Upgrade includes:

1. Revised content based on teacher feedback that fully meets the national curriculum requirements 
2. Full HD 16:9 widescreen presentations with enriched illustrations 
3. New starters and plenaries with every lesson 
4. Full answer slides for all questions asked in presentations 
5. Worksheets with answers for every lesson 
6. Homework sheets with answers for every lesson 
7. Updated learning objectives and unit assessments 
8. Updated lesson plans for new and non-specialist teachers 
9. Pointer slides to worksheet activities in all presentations 
10. An improved foundation and progression for the latest GCSE and vocational qualifications 

What people say...

“

”

Our year 8 girls really enjoyed the Python Unit and even complained when we moved on to another topic.

Don Smith. Head of ICT, Greenford High School

“

”

We have been using PG Online KS3 materials for well over a year now. PG Online materials have significantly reduced our worries, because the units are extremely well organised and make it much easier to teach the new curriculum.

Suki Chima. Computer Science Teacher, Sion-Manning RC Girls School

Relevant Textbooks

• 

  KS3 ClearRevise Workbook
  Complete course workbook
  ISBN: 9781916518155