Year 9 Functional Skills - see also database practice at Year 9 Databases
The Functional Skills exam will consist of
Two Year 9 groups will take the exam on the morning of Weds 14th May, one session after another in Room 34.
Lesson 1 - Notes on Databases
Key Points
A database has records (eg for each person) with fields for the data.
You need a unique primary key to identify individual records.
You add data using a data-entry form into a table; Search with queries and show results with reports.
Questions for homework
1. Average height Au is bigger than UK (girls / boys)
2. Average time to get to school NZ / Au / Ca
3. Sort the favourite subjects in UK and Ca and NZ to see any differences.
Lesson 2
Go through answers
Look at example test.
(Show search wildcards/Show adding to a table).
| Sample Exam | Resources |
[return to schoolwebsites.htm]