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

“

”

Having used your resources at KS3, these are well received by the students and teachers alike. They are well structured and resourced with answers.

Mr Myles Coulson. Teacher of Computer Science, Tabor Academy

“

”

The feedback I have had from my staff are all positive. We use your material and adapt each to suit our students. It has certainly made our life easier, especially as there are so many other factors that take up our time. It’s actually the first time I have bought in resources in the last 6 years. What we like is the quality of the resources, the activities are engaging for our students and the assessment material is varied (tests as well as tick sheet) and easy for students to understand.

Mukul Choudhury. Lode Heath School

Relevant Textbooks

• 

  KS3 ClearRevise Workbook
  Complete course workbook
  ISBN: 9781916518155