OCR Nationals (2010)
Unit 7: Databases – Design and Use
Student Name: / Self/Peer Assessment / Teacher Assessment
Target Grade: / Pass o / Merit o / Distinction o
AO1 - Design a relational database to meet the needs of an organisation
P1.1 / Explain the user requirements for the database
P1.2 / Describe its purpose and explain who will be using it
P1.3 / Give details of table names, primary keys, field names, data types, field lengths
M1.4 / Give details of combo boxes, validation rules
D1.5 / Give details of input masks
P1.6 / Sketch diagram showing the relationships
P1.7 / Sketch diagram for a form to be used
M1.8 / Sketch diagram for three different forms to be used
D1.9 / Sketch diagram for three different customised forms to be used
AO1 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
AO2 - Construct the database according to the design
P2.1 / Screenshots showing you have created the structure for each table
P2.2 / Screenshot showing you have created the relationships
P2.3 / Printouts showing you have entered 20 records into each of the three tables
P2.4 / Screenshots showing the use of forms to enter records into one table
M2.5 / Screenshots showing the use of customised forms to enter records into each table
D2.6 / At least one form includes a close button
AO2 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
AO3 - Interrogate the database
P3.1 / Annotated screenshot showing a simple query using the criteria given
P3.2 / Annotated screenshot showing a simple sorted query
P3.3 / Annotated screenshot showing a sorted query with multiple criteria
M3.4 / Annotated screenshot showing a query sorted on two fields
M3.5 / Annotated screenshot showing a complex query on linked tables
D3.6 / Annotated screenshot showing a second complex query on linked tables
AO3 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
Student Name: / Self/Peer Assessment / Teacher Assessment
Target Grade: / Pass o / Merit o / Distinction o
AO4 - Create reports
P4.1 / Produce a report for the sorted table from P3.1
P4.2 / Produce a report for one of your queries
M4.3 / Customise at least one of your reports with colours, title and logo
D4.4 / Produce a third report, and customise all three with a title and logo
AO4 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
AO5 - Create a user interface
P5.1 / Create a switchboard for the database
M5.2 / Make your switchboard well structured with links to forms and tables
D5.3 / Fully customise your switchboard with a logo, title, and instructions
AO5 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
AO6 - Test the database
P6.1 / Create a test table testing some areas of the database
M6.2 / Create a test table testing most areas of the database
D6.3 / Create a test table testing all areas of the database
P6.4 / Carry out the tests and record the results in the test table
P6.5 / Provide screenshots to show you have corrected any errors found during testing
AO5 Assessed Grade: / Pass o / Merit o / Distinction o / Comment:
OCR 2010 ICT U7 Tick Sheet