SHSubjectHub

Searching & Sorting Data

KS3Lesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 11 questions
  • 29 marks
  • about 45 minutes
  • marked instantly

Question types: multiple choice, multi-part, fill the gap, ordering, matching.

Try it with a class, freeHow it works

Try one from this worksheet

Once data is stored in a table, we ask it questions. What is a query?

Pick an answer: it's marked straight away, just as your pupils would see it.

About this resource

Put a database to work. Learn that a query is a question you ask the data, filter records using criteria, sort results into ascending or descending order, and combine simple criteria with AND and OR. Includes a hands-on SQL query using the platform's SQL tool.

16 slides.

Lesson outline

  1. Hook — Fast Enough?
  2. Do Now — Recall from Lessons 1 & 2
  3. A Query Is Just a Question
  4. Quick Check — Search or Sort?
  5. I Do — Filter With a Criterion (HousePoints > 40)
  6. We Do — Which Records Match?
  7. I Do — Sort by HousePoints, Descending
  8. Hinge Check — What Happens When You Sort?
  9. We Do — Filter Then Sort, Together
  10. Combining Criteria: AND / OR
  11. Quick Check — AND or OR?
  12. Main Task — Write a Query in SQL
Unit bundleDatabases
Part of: Databases: the whole unitEvery resource in the unit in one zip.

More from Databases